cancel
Showing results for 
Search instead for 
Did you mean: 

BOMM 3.0 Faild: utility failed with code 4

Former Member
0 Kudos

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].

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

The BOMM job hangs at

[C-3026002] 2009-02-04 21:27:25.419 Acquiring batch lock.

anyone knows what is the batch lock?

Former Member
0 Kudos

sometimes it returns SQL-911, which mean deadlock or lock timeout.

There are two integrator sources,

1. Business Objects Enterprise BOXI R3

2. Data Integrator 11.7.2.3

They are scheduled every day 11:00 pm

any problem for this setting?

Former Member
0 Kudos

let me check this, does it works if you run both the Integrator at different time ?

is it consistently reproduced if you run both the Integrator at the same time ?

what is the database type and version of the MM repository ?

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Manoj,

Everything else are working fine in BOE.

There are more information:

The Database server is DB2 and all repositories are in the same DB2 server

DB2 9.5.2

could you give some examples about the wrong configuration or setup which will lead to the BOMM problem

Thank you

Former Member
0 Kudos

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 ?

Former Member
0 Kudos

Hi Manoj ,

I call BO support and he found it is because the 64bit DB2 library is used for 32 bit BOE and BOMM.

The BOMM scheduled jobs are fine after changing to use 32 bit DB2 library.

Thank you very much for your replies

Kelvin

Former Member
0 Kudos

Hi Kelvin,

I am glad to hear it's OK after changing the library.

Cheers,

Henry

Former Member
0 Kudos

Hi Henry,

Happy to see you here.. Thank you so much.

Kelvin Ngai.