Skip to Content
author's profile photo Former Member
Former Member

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2015 at 04:40 AM
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.