I am installing BO XI R2 and want to use a sybase server to store the CMS database.
However, in the install wizard for BO, when I get ot he screen to specify which database server I wan to to use for the CMS db, it only gives moptions to enter the server name, username and password. The field to enter the CMS db name is greyed out, so I cannot type anyhting into it.
I left it, and carried on with the install, but now the install says it cannot connect to the CMS, and the CMS server is always stopped in the CCM.
I have a feeling this is because I couldn’t enter a db name for the CMS db. Does anyone know why this field would be greyed out in the install wizard?
i had the same problem. I entered the server name, username and password and go on. Then i had problem with the CMS too, but i don’t think they were related to this.
The problems were rights problems in the DB config. You can launch event viewer (run : eventvwr) and check the error message in Application log.
if I check the actual database I created for the CMS, there are 3 tables created in there - so the install is creating the tables required for the CMS database.
however, I cannot start the CMS server!
Looking at busobj knowledge base, it looks like it may be to dowith unicode utf-8 support required on my sybase server, and I dont think my sybase server has this.
CMS_InfoObjects5
CMS_Aliases5
CMS_IdNumbers5
are the tables created. can anyone confirm these are the only tables created when a new install is carried out?
Once the install is complete, I get a screen saying
“The install could not log onto the CMS. Please enter username and password for the CMS”.
The CMS itself is on the local host. The databse is on a sybase server.
The username is Administartor. The password is blank.
The authentication is ‘secEnterprise’.
I have just checked the event viewer log and there are a number of errors:
The root server reported an error Initialization Failure. (Reason: Database access error. Reason The ‘select into’ database option is not enabled for database ‘BO_CMS’. ALTER TABLE with data copy cannot be done. Set the ‘select into’ database option and re-run.
.).
(BO_CMS is my cms database on the sybase server)
Cannot connect to name server ELONW084661(Transport error: unable to retrieve the CMS factory.)
Its now created 5 tables, but I still get that message about it not being able to log on to the CMS. I think it may be to do with the unicode utf-8 support (but not sure).
I got something to add about this. I’ve made a complete new install of XI R2 with SP1 on a new server. I still can’t enter the database name i want to use for CMS and for audit, only server, username and password. But this time, there was 4 databases on same server with same username/password, two empty i wanted to use and two with data, which serve for BO6 installed on another server. I had no problem during the install (just have to reboot to make the CMS start) but when i checked the contents of my DB, i discovered BO has created all new tables in a non-empty DB.
I checked the install guide, and it’s clearly mention : “Enter the database name in the Database field for the CMS database”. But how to do this since the field is grey out? I was thinking it will ask for more info if several db match the username/password couple but it’s not the case.
We have similier issue… Does any one has solution for this??
We have installed XI R2 in different server but connected to the same database with different schema. Now our XI server is down and complaining about can’t access database in event log.
Quoting Patman "I am installing BO XI R2 and want to use a sybase server to store the CMS database.
However, in the install wizard for BO, when I get ot he screen to specify which database server I wan to to use for the CMS db, it only gives moptions to enter the server name, username and password. The field to enter the CMS db name is greyed out, so I cannot type anyhting into it.
I left it, and carried on with the install, but now the install says it cannot connect to the CMS, and the CMS server is always stopped in the CCM. "
Does anyone have a working installation? please share it…XI on Sybase seems to be a nightmare…
for my part, I haven’t tried to use sybase for CMS database, used SQL server 2000 with no problem but each time I try to access to a sybase univers based, it crashes. I have reinstalled Sybase 12.5 on server but same issue…
I worked with praksb31 to install XI R2 using Sybase 12.5.3 as the CMS database… Here are some of the issues we ran into during the install, and their resolutions.
The user that the CMS logs on as must have SELECT INTO / ALTER TABLE privilege on the CMS database during install, at the very least (I’m not sure if they continue to require that for operation, but in our case that user still has that privilege)
The Sybase server that houses the CMS database must use a unicode character set. We used utf8. Our initial install attempts were against a server using iso8859 and the CMS would not start. I was able to make a test install work against a server using the character set cp850, but I’m told by BOBJ support that this will fail at some point.
The Sybase server that houses the CMS database must have a logical page size larger than 2k. When we attempted to install to a server using utf8 but with 2k logical page size, we got an error message that composite indexes could not be created b/c they were greater than the maximum index size. We increased logical page size to 8k to resolve the problem.
Finally, the reason the database field is greyed out is because the install will use the default database for the given user on the given server, as specified in the master database for that Sybase server.
(BOB member since 2006-02-13)
) and this is the right problem i was talking about. Ask your dba to turn on the option.
(BOB member since 2006-02-13)
)
(BOB member since 2004-01-09)
(BOB member since 2006-05-03)