Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

CMS crash with core files and multiple report output generation

Happy new year to everyone,

Our BOXIR3.1SP6FP2 env has recently started behaving weirdly by triggering multiple output to users inbox and email notification out of scheduled reports. Also we have noticed the CMS crash with core file (almost 4GB) generation at the time of multiple report output.

Most of the times, CMC crashes and recycles itself. At few times, CMS services alone went shut down.

OS details: RHEL 5.5, 32 GB RAM, 8 core processor on each of the clustered node, Oracle 10GR2.4 CMS DB server, 11GR2.4 oracle reporting DB server and oracle 11.1.0.6 client.

2015/01/21 23:54:37.946|>=| | |28123|1534131088|{|||||||||||||||DBQueue::Read

2015/01/21 23:54:37.946|==| | |28123|1496185744|
|||||||||||||||(OracleStatement.cpp:156) Prepare: SQL: SELECT ObjectID,
Version, LastModifyTime, CRC, Properties FROM CMS_InfoObjects6 WHERE ObjectID
IN (1004050) ORDER BY ObjectID

2015/01/21 23:54:37.946|==| | |28123|1496185744| ||||||||||||||(OracleStatement.cpp:183) Prepared statement Execute

2015/01/21 23:54:37.965|==| | |28123|1496451984| |||||||||||||||SResourceSource::LoadString 50293

2015/01/21 23:54:37.966|==| | |28123|1496451984| |||||||||||||||SResourceSource::LoadString Unknown exception in database thread

2015/01/21 23:54:37.967|==| | |28123|1496451984| |||||||||||||||SResourceSource::LoadString 33007

2015/01/21 23:54:37.967|==| | |28123|1496451984| |||||||||||||||SResourceSource::LoadString CMS is unstable and will shut down immediately. Reason: %1...

2015/01/21 23:54:38.506|==| | |28123|1496185744| |||||||||||||||(OracleStatement.cpp:156) Prepare: SQL: SELECT ObjectID,
Version, LastModifyTime, CRC, Properties FROM CMS_InfoObjects6 WHERE ObjectID IN (1009213) ORDER BY ObjectID

2015/01/21 23:54:38.506|==| | |28123|1496185744| |||||||||||||||(OracleStatement.cpp:183) Prepared statement Execute

2015/01/21 23:54:38.512|==| | |28123|1455592672| |||||||||||||||(sidaemon.cpp:549) SUNIXDaemon::run: server restart flag is 1..

2015/01/21 23:54:38.513|==| | |28123|1455592672| |||||||||||||||(sidaemon.cpp:552) SUNIXDaemon::run: in abort ...

2015/01/21 23:54:38.513|==| | |28123|1455592672| |||||||||||||||(sidaemon.cpp:555) SUNIXDaemon::run: doing the WithAbort case ...

2015/01/21 23:54:38.520|==| | |28123|1496185744| |||||||||||||||(dbq.cpp:1357) DBQ: Time required to read 1 objects: 20.000000 ms

Thank you,

Karthik

Former Member
Former Member replied

Hi All,

The issue got resolved few months ago and thought of updating the resolution here.

Cause: CMS crashed while reading a large or inflated string value for metadata property SI_WEBIDOCPROPERTIES saved with the physical report. As per SAP support engineer, this might have grown abnormally through the use of incompatible webi rich client version.

Resolution:

A. Appended the parameter "-maxobjectsincache 1000" at CMC-->Servers-->CMS command line section

B. Reduced the "SizeOfTheLargestObjectAllowedInTheCacheInBytes"="10000" at .registry file present at ../../bobje/data/.bobj/registry/software/business objects/suite 12.0/cms/instances/CMS_name.cms/

C. Also SAP provided a SDK LA fix code to clean or remove the large string value for the property SI_WEBIDOCPROPERTIES for all webi documents present in the system.

Preventive measure: As per SAP's recommendation, better to use the compatible BO client tool same as the server version.

Thanks,

Karthik

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question