I wonder if anyone can help with the problem I am experiencing.
I installed BO XI 3.1 SP2 onto a Windows 2003 server (no clustering - only one machine) using the default MySQL database for the CMS and Audit databases.
I now want to change the CMS database to be Oracle. I migrated the DB using SQL Developer which complained of two indexes SI_CUID and SI_GUID not being able to be created uniquely. The solution presented was to remove the unique statement from the script which I did and then ran the script successfully.
I’m now having difficulty in changing the configuration of the SIA properties.
There is a fix ‘ADAPT01299996’ in Service pack 3 which deals with the following:
“When Installing or re-initializing on a Unix or Linux system, the installation will sometimes fail because the Central Management
Server (CMS) displays an error message about duplicate Global Unique Identifiers (GUID), and then it terminates unexpectedly” Whilst the fix refers to Linux and Unix operating systems there are windows components on this fix?
I’m wondering if applying SP3 will resolve the issue?
Start CCM
Stop CMS Server process and SIA.
Create necessary ODBC Datasource for your Oracle Database to connect. (if not exist already).
Right click SIA
-> Properties -> Configuration
As part of the CMS Database Configuration - Click Specify
You can choose to copy the datasource from MySQL to Oracle 10g …
The BOE will automatically copy the datasource (create tables, indexes) to Oracle based on the username/schema you have provided as part of credentials.
Restart SIA
Verify all the tables created under Oracle 10g env.
This sounds straight forward. I just have a couple of questions:
when specifying the properties on the SIA which option do you refer to? There are 3?
Will this take the content over or do I need to create a BIAR file before hand and then import it after repointing the CMS?
Thanks
Karen
Subsequently, I have solved this problem and it was relatively simple in the end. I had an empty oracle db, I then stopped the CMS and the SIA. Through the properties of the SIA I ‘copied’ (option 2) the CMS from the MySQL db to the new Oracle DB. Migration would appear to be successful.
(BOB member since 2002-08-29)