10 Replies Latest reply: Feb 16, 2009 5:19 PM by Kelvin Ngai RSS

BOMM 3.0 Faild: utility failed with code 4

Kelvin Ngai
Currently Being Moderated

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

  • Re: BOMM 3.0 Faild: utility failed with code 4
    Kelvin Ngai
    Currently Being Moderated

    The BOMM job hangs at

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

     

    anyone knows what is  the batch lock?

    • Re: BOMM 3.0 Faild: utility failed with code 4
      Kelvin Ngai
      Currently Being Moderated

      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?

      • Re: BOMM 3.0 Faild: utility failed with code 4
        Manoj Dhyani
        Currently Being Moderated

        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 ?

        • Re: BOMM 3.0 Faild: utility failed with code 4
          Kelvin Ngai
          Currently Being Moderated

          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.

Actions