on 02-04-2009 7:20 AM
Hi,
The BOMM 3.0 always fail and will crash the CMS to restart
anyone has idea?
Besides, anyone knows what is CMS Remote Process Handler?
CMSMetaIntegrator log
[I-3026762] 2009-02-04 00:55:45.109 Crystal report collection progress: 10 of 209 completed
[E-3026103] 2009-02-04 00:56:09.453 Unable to retrieve list of reports from CMS. Unable to retrieve list of reports from CMS. CMS query failed. All the servers with CMS midwuat.EDB.LOCAL:6400, cluster @midwuat.EDB.LOCAL, kind cms which host service null, are down or disabled
.
SELECT TOP 1179 SI_ID, SI_CUID, SI_NAME, SI_DESCRIPTION, SI_KEYWORD, SI_PARENT_CUID, SI_UPDATE_TS,SI_CREATION_TIME, SI_PARENTID FROM CI_INFOOBJECTS WHERE SI_KIND = 'Webi' AND SI_INSTANCE = 0
[C-0000000] 2009-02-04 00:56:09.468 com.bobj.mm.integrator.cms.collector.exception.CollectorException: Unable to retrieve list of reports from CMS. Unable to retrieve list of reports from CMS. CMS query failed. All the servers with CMS midwuat.EDB.LOCAL:6400, cluster @midwuat.EDB.LOCAL, kind cms which host service null, are down or disabled
.
SELECT TOP 1179 SI_ID, SI_CUID, SI_NAME, SI_DESCRIPTION, SI_KEYWORD, SI_PARENT_CUID, SI_UPDATE_TS,SI_CREATION_TIME, SI_PARENTID FROM CI_INFOOBJECTS WHERE SI_KIND = 'Webi' AND SI_INSTANCE = 0
at com.bobj.mm.integrator.cms.collector.ReportCollector.run(ReportCollector.java:138)
at com.bobj.mm.integrator.cms.collector.CMSCollectorController.collectWebIReports(CMSCollectorController.java:451)
at com.bobj.mm.integrator.cms.collector.CMSCollectorController.collectAllReportTypes(CMSCollectorController.java:202)
at com.bobj.mm.integrator.cms.collector.CMSCollectorController.run(CMSCollectorController.java:175)
at com.bobj.mm.integrator.cms.CMSMetadataIntegrator.integrate(CMSMetadataIntegrator.java:403)
at com.bobj.mm.integrator.Integrator.execute(Integrator.java:165)
at com.bobj.mm.utility.Utility.runExecute(Utility.java:441)
at com.bobj.mm.core.Main.run(Main.java:1166)
at com.bobj.mm.core.Main.main(Main.java:230)
CMSRemoteProcessHandler log
[I-3026013] 2009-02-04 00:51:17.671 Started execution on 2009-02-04 00:51:17.
[I-3027156] 2009-02-04 00:51:17.687 Remote process handler received start request: 6828
[W-3027157] 2009-02-04 00:56:34.046 Remote process handler error processing work request: Connection reset
[W-3027157] 2009-02-04 00:56:34.046 Remote process handler error processing work request: Connection reset
[W-3027157] 2009-02-04 00:56:34.046 Remote process handler error processing work request: Connection reset
[W-3027157] 2009-02-04 00:56:34.046 Remote process handler error processing work request: Connection reset
[W-3027157] 2009-02-04 00:56:34.046 Remote process handler error processing work request: Connection reset
[W-3027157] 2009-02-04 00:56:34.046 Remote process handler error processing work request: Connection reset
[W-3027157] 2009-02-04 00:56:34.046 Remote process handler error processing work request: Connection reset
[W-3027157] 2009-02-04 00:56:34.046 Remote process handler error processing work request: Connection reset
[W-3027157] 2009-02-04 00:56:34.046 Remote process handler error processing work request: Connection reset
[W-3027157] 2009-02-04 00:56:34.046 Remote process handler error processing work request: Connection reset
[E-3026103] 2009-02-04 00:56:34.046 Remote process handler shutting down the remote handler after 10 consecutive exceptions
[C-0000000] 2009-02-04 00:56:34.046 com.bobj.mm.sdk.SDKException: Remote process handler shutting down the remote handler after 10 consecutive exceptions
at com.bobj.mm.sdk.processmanager.RemoteProcessHandler.execute(RemoteProcessHandler.java:128)
at com.bobj.mm.core.Main.runExecute(Main.java:1113)
at com.bobj.mm.core.Main.run(Main.java:1166)
at com.bobj.mm.core.Main.main(Main.java:230)
[E-3026022] 2009-02-04 00:56:34.046 Utility failed with code 4.
[I-3026014] 2009-02-04 00:56:34.046 Completed execution on 2009-02-04 00:56:34.
[I-3026105] 2009-02-04 00:56:34.046 Elapsed time is 5:16.421 [min:sec.millisec].
The BOMM job hangs at
[C-3026002] 2009-02-04 21:27:25.419 Acquiring batch lock.
anyone knows what is the batch lock?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manoj,
I did not get SQL-911 if I run the two Integrator sources separately.
But it is weird if BOMM does not support to schedule more than one source at the same time. and I cannot find any document about it.
besides, it all failed for BusinessObjects Enterprise integrator source even though i run it alone.
Is it because the loading for RAS is too heavy during BOMM job running?
It seems that the RAS will die and the CMS is restarted by the SIA
I got the following message from the Windows Event Viewer.
Event Type: Information
Event Source: Server Intelligence Agent
Event Category: (20001)
Event ID: 4096
Date: 2009-02-08
Time: 10:44:58 PM
User: N/A
Computer: MIDWUAT
Description:
[Node Name: MIDWUAT]
[User Name: midw_uat_adm]
Server Intelligence Agent: server MIDWUAT.ReportApplicationServer stopped with exit code = 0 (0x0).
Event Type: Information
Event Source: BusinessObjects_crystalras
Event Category: (14)
Event ID: 34200
Date: 2009-02-08
Time: 10:46:40 PM
User: N/A
Computer: MIDWUAT
Description:
The description for Event ID ( 34200 ) in Source ( BusinessObjects_crystalras ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Successfully registered with name rptappserver."midwuat.EDB.LOCAL"-MIDWUAT.ReportApplicationServer with name server.
there is no restriction on number of integrators running at the same time, as long as they are different configuration, and your system is capable of handling the load, for example you can run CMS Integrator and DI/DS integrator at the same time
the issue looks more like of BOE configuration and setup, is everything else working fine in BOE ? running reports etc
what do you see in the MM CMS Integrator log file ?
is it failing at the same Query
SELECT TOP 1179 SI_ID, SI_CUID, SI_NAME, SI_DESCRIPTION, SI_KEYWORD, SI_PARENT_CUID, SI_UPDATE_TS,SI_CREATION_TIME, SI_PARENTID FROM CI_INFOOBJECTS WHERE SI_KIND = 'Webi' AND SI_INSTANCE = 0
can you run this Query from Query Builder and see if it run successfully from there
what is the exact version of BOE and MM that you are using ? like which Fix Packs ?
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.