Changing universes name

[Yanndewael]

Hello,

I want to change the name of all my universes, by SQL query instead of manual change in BO.

I then made the following queries:

-- TO CHANGE universe name --> Change UNI_FILENAME of UNV_UNIVERSE

UPDATE UNV_UNIVERSE SET UNI_FILENAME='NEWNAME' WHERE UNI_FILENAME='OLDNAME'


--> Change M_UNI_C_FILENAME of OBJ_M_UNIVERSE

UPDATE OBJ_M_UNIVERSES SET m_uni_c_filename='NEWNAME' WHERE m_uni_c_filename='OLDNAME'


-- TO CHANGE the rep-unv links --> Change M_SRC_C_NAME of OBJ_M_DOCATVAR

UPDATE OBJ_M_DOCATVAR SET m_src_c_name='NEWNAME' WHERE m_doc_n_id='xxx'


I have a problem with the last query: even if NEWNAME is in the DB, when I try to retrieve a report from Corporate Documents, the queries of this report have still the link to the old universe name.
Is there something to do in addition? Since I have about 500 reports, I don't want to change all the links manually.

Thank you in advance,

Yannick

 

[suj2000]

Hi,

If you cant achieve this, why dont you copy the change of the new universe into the old universe,

This way you need not change the name of the universe through SQL.


Thanks,
Suj

 

[skrandel]

What happens if you just change the name of the universe. Not the file name, but the name. Then it has the same universe id and file name. That's what the reports really want anyway.

Don't do a Save As. Just change it and export.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[lilianbrun]

Well, i've got the same problem.

Yannick : have you find a solution on this issue ?

But I'm afraid it it store in the BLOB field (OBJ_X_DOCUMENTS.X_DOC_B_CONTENT), cause i log database acces of BO while i import a report it and there's never an universe name in SQL querys.

Regards.