BRCONNECT Error......lock file delete

[Former Member]

Hi experts,

we are facing problem with BRCONNCT ,

I am running FULL update stats with extenal command in Background job..

it is failing with error

Please delete file /oracle/SID/sapcheck/.lock_sta.brc if BRCONNECT was killed..

wen i delete , next run comes succesfulll..

and i am running Optimizer statss in DB13 it fails with same error ....

wen i delete the .lock , next run successfull...

every time ineed to delete this filee...

i heard if BRCONNECT already running , shows this error .. i am sure no BRcoonect runs other than tis jobs..

please suggest in priority..

Regards,

Siva.

[Former Member · Accepted solution]

You need to check on the OS level or in the DB13 calendar whether another brconnect job is already running. In that case the file /oracle/SID/sapcheck/.lock_sta.brc is used as a blocker to prevent multiple jobs running parallel.

If you are using a Unix/Linux OS try this as the sidadm user:

ps -ef | grep brconnect

If another brconnect job runs you should get the a corresponding output.

And please note that collecting statistics can take quite a long time depending on the size and hardware capabilitites of your machine. So please make sure that the stats jobs is definitely completed.

Kind regards,

[Former Member · Accepted solution]

Hi Sven,

     Thank you so much. Your information resolved my issue. Yes, there are 2 brconnect process are running currently. So that we have stopped both / killed (kill -2 <pid>) and started fresh stats which worked for us.

     Thanks a lot...

Regards

Santosh K

[Former Member]

I am not sure about the root cause and exact solution for this error.

try to upgrade the brtools to latest version and check. hope it helps you to resolve your issue.