The CMS.exe is not working.

[Former Member]

Hi all,

The CMS.exe is not working.

SIA is running and using port 6410.

CMS is not running, even that is using port 6400.

In the last log file of the CMS is see the following:

(err.m_IDSError == IDS_ERR_CMSSYSTEMDB_NODATABASECONNECTIONSAVAILABLE : Error refreshing CMS listeners: ).

The database look ok, so i guess there is somthing i can not see.

How can i find the issue with teh DB? or maybe it relates to somthing else....?

Thanks,

Doron

[Former Member]

You can simple write a simple sql statement through SQL+ to your CMS database and see if it is responding.

Also check on your CMS> Properties>configuration, it will give you some clue.

Not to forget, you can see the windows event viewer logs too.

[Former Member]

The DB is alive and working just fine.

Do you have a clue how can I solve this issue?

-Doron

[Former Member]

Issue is solved.

[Former Member]

Would you explain me how this issue has been resolved - please?

I have been experiencing the same issue and I used to restart DB as a temporary work around.

The error I can see in logs are given below:-

2010/02/26 05:49:57.659|>>|A| |31049|1162353568| |||||||||||||||assert failure: (apsfactory.cpp:1530). (err.m_IDSError == IDS_ERR_CMSSYSTEMDB_NODATABASECONNECTIONSAVAILABLE : Error collecting resources: CMS system database is overloaded, please try again. If the problem persists, please contact the system administrator(FWB 00027) Writing to the database.

Please shed some light on this please.

Thanks very much.

[denis_konovalov]

This error message indicates that the Database which host CMS DB for your BOE environment is overloaded, has no more connections left to serve requests from CMS server.

You need to work with your DBA to increase resources available to CMS DB from the database.

You can also try to reduce number of connections CMS uses to connect to database, if you're on XI3.1 - you can do it in CMC>Servers>CMS server properties.

However, lovering that number will have performance impact on your env.

[Former Member]

Hi Doron,

Can you please elaborate on how you resolved the error/behavior?

Thanks.

Kevin

[Former Member]

Hi,

I am facing the same issue. and I can see this error in Event log.  I verified with DBA then DB is fine. but I am getting it multiple times in a day. but DB is okay. what can be solution for the same? Even when I am trying to recreate database, it does not finish. I am getting issue about license also but if I cannot login then I cannot provide license information right? I did provide once when I was installing it.

The root server reported an error Initialization Failure. (Reason: CMS system database is overloaded, please try again. If the problem persists, please contact the system administrator(FWB 00027)CMS system database is overloaded, please try again. If the problem persists, please contact the system administrator(FWB 00027) CacheObjectIDs

).

The root server reported an error Initialization Failure. (Reason: Missing critical system object type. Kind: LicenseRestriction.  (FWB 00037)Missing critical system object type. Kind: LicenseRestriction.  (FWB 00037) Unable to find LicenseRestriction kind.

).

[Former Member]

Hi Mandar,

The error you had reported is usually because of communication blockage within BO server.

Please check the ports connectivity for CMS and other servers, is it opened bi-directional from Firewall side (if it exists).

As mentioned DB connectivity is fine and DB server is up and working then this could be the only root cause, please share your findings....

Thanks,

Arun

[Former Member]

@Arun,

Thank you for response. But when i redirect my repository to SQL Server it works. That's why I am confused if it is application issue or Database issue.

I will check ports and get back.

Regards,

Mandar

[Former Member]

Here is Update to issue.

oracle client connectivity is good but when used throught CCM (for CMS) it is taking long time to start CMS. (7-8 minutes). After that I can login.

but when we work through oracle client (From server) it does not show any delay as such. can I add trace to ccm to see what is going wrong Or why it is delaying?

Any one have seen issue where it is slow through Business Objects

[Former Member]

Hi Mandar,

What is the system repository on which the CMS is pointing to? (which is not working, as with SQL server it works)

Any changes done to the DB or BO side after which the issue started occuring or is the issue while install itself?

Thanks,

Arun

[Former Member]

It is Oracle 10 G R2. This issue right from when we installed BO.

Also one more observation, for Oracle when I tried to re-create database, it gives me error

"Failed to recreate the database. Reason: Internal Error: An unknown exception has occurred"

There is no more information on this. (Of course with SQL Server works). As work around, I re-create SQL server data and copy from that to Oracle. which is time consuming.

Regards,

Mandar

[Former Member]

Hi Mandar,

Please check this:

Error:

The root server reported an error Initialization Failure. (Reason: CMS system database is overloaded, please try again. If the problem persists, please contact the system administrator(FWB 00027)CMS system database is overloaded, please try again. If the problem persists, please contact the system administrator(FWB 00027)

Cause

Timeout while waiting for database resources.

Resolution

1. On the server machine, navigate to Central Configuration Manager (CCM). 
2. Stop the Server Intelligence Agent (SIA). 
3. Go to the properties of the SIA. 
4. Navigate to 'Startup' tab. 
5. In the 'Local CMS' section, double click on the Central Management Server, a 'Server Properties' dialog box would appear. 
6. Add the switch -ndbqthreads 10 -maxobjectsincache 100000 at the end of the command line. 
7. Start the SIA.

Please try the above steps and share your feedback.

Thanks,

Arun