Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Publication Schedule fails every night - Error User account getting locked

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

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question