Can someone explain this table to me? It keeps filling up and doesn’t seem to clear itself out at all.
Thanks,
Julie
Listserv Archives (BOB member since 2002-06-25)
Julie Moran wrote:
Can someone explain this table to me? It keeps filling up and doesn’t seem to clear itself out at all.
This is a really good question: This table is THE (a) “Document Repository”, it’s documented in the repository documentation on the BusinessObjects CD in directory “freeware”, as far as I remember.
All Doc you send to the repository or to the DAS or to another BusinessObjects user is stored in this table.
Hope this helps…
–
Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna, Austria Tel. +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at
Listserv Archives (BOB member since 2002-06-25)
Does it ever clear itself out? Ours just keeps filling up and we’re constantly adding more space.
Can someone explain this table to me? It keeps filling up and doesn’t
seem
to clear itself out at all.
This is a really good question: This table is THE (a) “Document Repository”, it’s
documented in the repository documentation on the BusinessObjects CD in directory
“freeware”, as far as I remember.
All Doc you send to the repository or to the DAS or to another BusinessObjects
user is stored in this table.
Listserv Archives (BOB member since 2002-06-25)
OBJ_X_DOCUMENTS is a table like any other, and would only be cleared out if there were records on it that you no longer wanted to maintain, and therefore deleted. The way to do this in BusinessObjects is to go to TOOLS, DELETE DOCUMENT in supervisor. This will allow you to delete the various types of documents on the table…repository docs, user docs (sent from one user to another), and processed docs (doc agent). Do not attempt to delete records directly from the obj_x_documents, as you might compromise the relational integrity of the doc domain.
If the table is filling up constantly, perhaps you need to look at who is doing what in your user community…is DAS posting unclaimed docs to various user id’s? Are users sending docs to the repository for storage? One other thing can can affect the size of obj_x_documents: Lists of Values. If you export your universes with LOV’s, those queries also get stored on obj_x_documents. As these lists can sometimes be quite large, this may contribute to your problem.
Jason Beard
Listserv Archives (BOB member since 2002-06-25)
I have another question regarding the Document repository. Just
as Jason I have the feeling that this table is not cleaned up. When I
try to Link a document to a group I get a list of available documents.
Some of them bear the same name and I see no way of distinguishing
between those. Apperently it is possible to have multiple documents in
the repository.
hans
Listserv Archives (BOB member since 2002-06-25)
Julie Moran wrote:
Does it ever clear itself out? Ours just keeps filling up and we’re
constantly adding more space.
It does not clean itself up very well, but you can clear obj_X_document by
using the Supervisor module (Tools, Delete Documents) and deleting reports
from the document domain. There is some descriptive information in the
delete panel that helps distinguish a “standard” (i.e. persistent) report
from other types of reports. For DAS documents, I don’t think
obj_x_documents is cleared until all users have retrieved the processed
reports.
Jay Clise
Sandia National Labs
Albuquerque, New Mexico
Listserv Archives (BOB member since 2002-06-25)
For DAS documents, I believe obj_x_documents is not cleared until the
log entry is purged from the DAS.
That’s a little tidbit you should know about when configuring the DAS.
Larry Rosenblum
Saama Technologies, Inc.
Clise, Jay wrote:
Julie Moran wrote:
Does it ever clear itself out? Ours just keeps filling up and we’re
constantly adding more space.It does not clean itself up very well, but you can clear obj_X_document by
using the Supervisor module (Tools, Delete Documents) and deleting reports
from the document domain. There is some descriptive information in the
delete panel that helps distinguish a “standard” (i.e. persistent) report
from other types of reports. For DAS documents, I don’t think
obj_x_documents is cleared until all users have retrieved the processed
reports.Jay Clise
Sandia National Labs
Albuquerque, New Mexico
Listserv Archives (BOB member since 2002-06-25)
The sure way to have the obj_x_document table cleared is to do a “compact”
from the Supervisor. But it might be a good idea to do it at a time when
your users is off the system, because you do not want any activity on the
document domain when you do it.
-Sai
For DAS documents, I believe obj_x_documents is not cleared until the
log entry is purged from the DAS.
That’s a little tidbit you should know about when configuring the DAS.
Larry Rosenblum
Saama Technologies, Inc.
Clise, Jay wrote:
Julie Moran wrote:
Does it ever clear itself out? Ours just keeps filling up and we’re
constantly adding more space.It does not clean itself up very well, but you can clear obj_X_document
by
using the Supervisor module (Tools, Delete Documents) and deleting
reports
from the document domain. There is some descriptive information in the
delete panel that helps distinguish a “standard” (i.e. persistent) report
from other types of reports. For DAS documents, I don’t think
obj_x_documents is cleared until all users have retrieved the processed
reports.Jay Clise
Sandia National Labs
Albuquerque, New Mexico
Listserv Archives (BOB member since 2002-06-25)