Removing the documents from Database

security Supervisor (4.x - 6.x)
1

Hi,

Our database has many reports which ran last year and not retreived by the users. Some failed reports are also lying in the database. Any help on cleaning(removing) these reports from database is appreciated. We use oracle 7.3, sqlnet 2.3 and BO 4.1.

Thanks in advance,
Sanjay

Listserv Archives (BOB member since 2002-06-25)

2

If documents were run using Doc Agent you need to delete them from Doc Agent, then use Supervisor to delete unwanted documents.

This will remove the documents from DS_PENDING_JOB and OBJ_X_DOCUMENTS tables in the repository, there will also be an entry in OBJ_M_DOCUMETS, sometime the entry in this table is not deleted, (one of BO;s quirks). You can do a scan and repair in Supervisor on the Document domain. If this does not work you can delete this through SQLPlus.

Min :slight_smile:

Hi,

Our database has many reports which ran last year and not retreived by the
users. Some failed reports are also lying in the database. Any help on
cleaning(removing) these reports from database is appreciated. We use oracle
7.3, sqlnet 2.3 and BO 4.1.

Thanks in advance,
Sanjay

Listserv Archives (BOB member since 2002-06-25)