Now we are having troubles with the LOV’s not getting exported with Universe.
The universe can be imported (and comes with LOV’s) but when we try to re-export the imported universe…it again gives error with LOV’s (I have attached a document showing the error with document domain name)
The only way we have been able to run the full-client reports is by exporting the universe without LOV’s and then manually exporting the LOV’s separately. (Copy-Paste)
But this causes problem with the WEBi reports and the formatting of LOV’s in Webi is lost in this process.
did you try doing the following
open/import the universe in designer and while exporting universe check the options Associate a List of Values and Export with Universe on properties tab.
Yes, this is done for all the LOV’s.
This would not have given an error at all even if we had missed checking those boxes in the properties of LOV’s objects.
the error message you have is very clear.
in order to use lov, you must have your univers and document domain in the same database. Is it the case for you ? this message seems to say not.
If your error message is “UX0040: the universe and document domain are not on the same data account” then look at Knowledge Base 6122. In Supervisor you have to bring the connection definitions for Universe and Document Repositories Network Layers into line. Upgrading to 6.5.1 seemed to screw mine up. Use Tools > Repository select ‘Universe’ and it to be the same as Document.
I have a similar problem with LOV’s. I create the universe in local repository and send the universe without LOV files though i have many List of Values to development team. They will publish universe to their repository and it was working fine for almost 1 year. Now the user want LOV in date prompt should be in sorted order and i changed in universe\Object Properties\Edit settings to ascending. And send both LOV files and universe. Now when they try to publish the universe it says
‘Document Domain does not exist in the same data account. You can not export your list of values’. Why it is happening now? LOV was there before also but this error has never come. And before this sorting issue i sent only the universe and no LOV files. But without LOV files not getting sorted values in prompt. With LOV file it showing error. Can anybody pleasee explain me why this happend and is there any solutions for this?
To avoid this error message, export only one LOV of the universe (i.e. refresh the
LOV before the export to create the .lov file). The universe’s ID is then present in
the document domain (with the LOV), and the domain is recognized as the right
one.
Of course, you must export all other LOVs assigned to objects with the option
checked Export with universe if you want them to be imported with the universe.
Thank you so much for the reply. But still i have issues. Univere is to be published to another repository and schema. It usually works fine. I have no access to production repository.i just copy and send the universe and production will publish to webi with their schema connection. Though i could export to local repository could not find any document domain. How do i create a document domain? can i send the same to production? if yes how they can use it?
This is what i am getting from BO error documentation.Hope that it would help you…
The document domain does not exist on the same data account. You cannot
export your lists of values. (UX0040)
Cause
Although your document domain and universe domain are defined in the same data account, there is a problem with the List of Values (LOV) table. An LOV is a file which contains the data values associated with an object. LOVs are stored in the document domain as a table called OBJ_X_DOCUMENTS. However, in order for a document export to succeed, thissame table must also exist in the universe domain. This is not the case in yourdata account.
Action
You can create the LOV table manually, or (if you are a supervisor) use the wizard available in Supervisor to create it in the same database as the universe domain.
Example
You have a development, testing and production repository as well as development, testing and production domains. You have created a universe with a few objects having files that are LOVs. All of the objects refresh before use and export with the universe. The LOVs display with no problem in Designer, but the above error message is displayed when you try to export the universe
(BOB member since 2005-09-21)
(BOB member since 2005-07-28)
(BOB member since 2005-09-21)
(BOB member since 2003-05-26)
(BOB member since 2002-09-19)