Publication Schedule fails every night - Error User account getting locked

[Former Member]

Gurus,

We have an issue where in a WEBI publication we have was running fine from an year but from last 3 days its failing every night saying "Account is Locked". We asked the DBA to unlock the user but then it fails every night. I checked the schedule property and it looks like setting was to only run once. The DBA mentioned that the account gets locked after 10 unsuccessful attempts. But the publication is run only once.(either its a success or failure). They assured there is no other application using this account and password.

Below is the Error :

2015-10-09 03:30:13,432 INFO  [PublishingService:RunInstancePool-25] BusinessObjects_PublicationAdminLog_Instance_9825130 - [Publication ID # 9825130] - Running publication instance.

2015-10-09 03:30:13,463 INFO  [PublishingService:RunInstancePool-25] BusinessObjects_PublicationAdminLog_Instance_9825130 - [Publication ID # 9825130] - The global delivery rule for this publication was met; publication processing will now begin.

2015-10-09 03:30:36,506 ERROR [PublishingService:HandlerPool-6] BusinessObjects_PublicationAdminLog_Instance_9825130 - [Publication ID # 9825130] - Scheduling document job "XXX_yyyy" (ID: 9,825,138) failed:

Database error: ORA-28000: the account is locked

. (IES 10901)

Scheduling document 'XXX_yyyy' (ID: 9,825,138) failed for the following users:

  555555 (ID: 622203)

These users had the following profile values:

  [No profile values]

(FBE60502)

2015-10-09 03:30:36,712 INFO  [PublishingService:RunInstancePool-25] BusinessObjects_PublicationAdminLog_Instance_9825130 - [Publication ID # 9825130] - Publication scheduling complete.

Any insights into what can be the problem scenarios here? Would appreciate your insight.

Env: BOBJ 4.1 SP4 on LINUX REDHAT / CMS DB Oracle 11G

Thanks,

Tsar

[Former Member · Accepted solution]

Hi Tsar,

Hope below links help you in some ways

https://websmp230.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F...

Redirecting...

[Former Member · Accepted solution]

Regina,

Thanks for your response. But I get a 400 Access denied error when I access it.

-TI

[Former Member · Accepted solution]

updated Oracle database credentials in IDT for connection .

Note 951167 - ORA-28000: the account is locked

ote 951167 - ORA-28000: the account is locked

Read this Note's

It will help you ..Hope so

[Former Member · Accepted solution]

Thanks for your response Regina. Looks like its an issue at the database layer which was fixed. We are still trying to communicate with them about the exact fix which is sometimes hard to get quickly. i will update this thread as soon as I get an answer on this from our DBA.

Thanks,

Tsar