Which repository table has info abt BCA being online/offline

system · August 5, 2009, 10:15am

In BO6.1, which repository table has information about a BCA being online/offline?

We have a huge shared repository in which there 7 BCA agents defined on 3 different servers. I have created a VB application to check the status of scheduled reports on these servers. But DS_PENDING_JOB table has nothing for a BCA which goes offline. I need to identify which BCA has gone offline by polling the relevant table.

I have already checked OBJ_M_ACTOR and OBJ_M_ACTORLINK.

Table OBJ_M_ACTOR has a field named STATUS, but the column contains a value 1 for both online and offline BCAs.

Similarly table OBJ_M_ACTORLINK also has a STATUS column, but this column has a value 0 for both online and offline BCA.

Any help would be appreciated.

regards
Kapil.

mkkapil (BOB member since 2009-08-03)

system · August 5, 2009, 2:10pm

Welcome to B:bob:B!

Regarding your question:

I don’t think there is a BO repository table that holds this information.

Marek Chladny (BOB member since 2003-11-27)

system · August 6, 2009, 7:00am

Thanks Marek.

Is there a way I can get this information so that my VB application can identify offline BCAs?

Though I am yet to explore this option but how about the BCA config files?

Cheers!

mkkapil (BOB member since 2009-08-03)

system · August 6, 2009, 2:58pm

I am sorry but I can’t help here. I don’t know how to identify offline BCAs.

Marek Chladny (BOB member since 2003-11-27)

system · August 13, 2009, 7:07am

Though I could not find a place in repository for this information, but I have found a work around.

The information can be captured from the bca config file on BCA server. The file is created in the following location:

\<installation-directory>\Program Files\Business Objects\BusinessObjects Enterprise 6\nodes<server>\mycluster\config\servers\

The config file has a name like “BcaScdul_@BCASchedulersGroup_BCA_0.cfg”. There will be a separate file for each agent.

This file has a parameter named “nOnOff”. Value 1 stands for online and 0 for offline.

Regards
Kapil.

mkkapil (BOB member since 2009-08-03)