Hi. I had a universe on a Sybase universe domain. I added an Oracle domain. I tried to export the universe to the Oracle domain (with a new name) and got a message like “Warning - Document domain exists on another account, cannot export list of values”. Well it wasn’t just a warning because the universe didn’t export. So I added a document domain to the Oracle account and it still didn’t work. The only way I could get it to work was to uncheck the export with universe option on the list of values. Anybody have any ideas on what is going on here?
Maybe you didn’t create the document domain on exactly the same middleware layer, and, database account as the universe domain?
W.
DI 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
Maybe you didn’t create the document domain on exactly the same middleware layer, and, database account as the universe domain?
Well actually I did (I am looking at the document and universe tables right now in the same account), but what difference does it make? What is BusinessObjects trying to do here?
In a message dated 98-07-22 10:51:08 EDT, you write:
Maybe you didn’t create the document domain on exactly
the same middleware layer, and, database account as the universe domain?
Well actually I did (I am looking at the document and universe tables right now in the same account), but what difference does it make? What is BusinessObjects trying to do here?
Thanks,
Greg Mills
Greg:
A list of values is actually stored as a document in the repository. To connect the list of values information to an object definition requires a join between the OBJ_X_DOCUMENTS table (in the document domain) and the UNV_OBJCONTENT table (in the universe domain). In order to process this join, they require that the Universe Domain and the Document Domain belong to the same owner (account, etc).
Note: this does not appear to be documented in my version of the HTML map to the repository. I have decided that this is the case after some detailed investigation on my own. It may or may not be correct but I think that it is.
That doesn’t explain why you were getting your error, but it is an explanation for why the two domains have to belong to the same account. Note that there is nothing to prevent you from creating a separate document domain (under a different account) for users to use for trading / storing documents. In fact, I suggest that this should be done to avoid a full database (from exporting 20 megabyte reports!) from taking down the rest of the repository.
Regards,
Dave Rathbun
Integra Solutions www.islink.com See you in Orlando in '98!
Maybe you didn’t create the document domain on exactly the same middleware layer, and, database account as the universe domain?
Well actually I did (I am looking at the document and universe tables right now in the same account), but what difference does it make? What is BusinessObjects trying to do here?
It uses the document domain with the same account for exporting LOVs into it…if you set the parameter to ‘eport with universe’
WM
DI 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
but I think that it is.