High Availability problems with Data Sourcer

[victor]

Hi,

I am in a process of reviewing the logs from a problem we just had at one of our sites, and I was wondering if it is something that is inherent to Datasourcer or not.

We have the latest datasourcer version available running on Windows connected to Oracle DB. The two datasourcers are in HA and it seems like from time to time there is a racing condition that causes datasourcers to re-write data into ODS. Again and again and again.

Has anyone encountered a problem like this?

Thanks,
Vic

P.S. I know it is a very generic question, I just figured I ask first and see where it gets me

[cmcshane]

Hi Vic,

I have a HA deployment of data sourcers, but haven't come across this problem.

The ODS database grants a DB lock to one data_sourcer only, generally whichever one is started first. Both data_sourcers in the HA config collect the data from stat_server. The one with the ODS_Lock writes it, whereas the other one periodically checks the ODS to ensure the data it has collected is already there.

You can check your ODS database to see the configuration. The OL_DB_LOCK table shows which data-sourcer has the lock, whereas the OL_DB_PROPERTIES shows the connection to config server as well as the primary and backup data_sourcer DBID's.

Hope this makes sense.

If you want to send the log entries for the errors I'd be glad to assist.

Colin

[victor]

Hi, Colin,

thanks for the reply. I will check this right away!

Vic