Hi,
I am facing an issue while publishing report through BCA server where the database is MSSQL Server 2000. While I am publishing the report I am getting the BCA error BCA0018
The details of the error says that
STATUS: S1T00
ORA 00054 Resource busy and acquire with NOWAIT specified
DB ERROR -54
STATUS: 22934
ORA 00001 Unique constraint (BOADMIN.PKX_BATCH) Violated
DB ERROR -9
The error doesnot come back if I try some times later.I check the resource utilization of server.It is well below the machine limits.Is this a networking problem ? Please advise
Hari
haribalakrishnan (BOB member since 2003-04-10)
I think your repository databse is Oracle and message suggest some primary key violation is happening.
Could you please give us the complate scenerio. When u get this error?
JaiGupta (BOB member since 2002-09-12)
Jai,
Infact I am facing this problem recently.We have not done any thing to server or BO server components.It is happening when the user tries to publish the report at the BCA.After getting the error,the same user can publish the same report with the same variables if he tries after some time/or repetetive attempts.If it was Oracle issue,it could have started from the beginning,I feel.
Hari
haribalakrishnan (BOB member since 2003-04-10)
"ORA 00054 Resource busy and acquire with NOWAIT specified "
This is definatelya problem from Oracle End only. It points to some lock on the resources( database tables) by same user or some diffrent user.
- Insure that all previous transactions are complete i.e. COMMIT or ROLLBACK.
- If you still have the problem, restart the RDBMS instance.
JaiGupta (BOB member since 2002-09-12)
Ji Jai,
I rebooted the Oracle server,No luck.Any other ideas…
Hari
haribalakrishnan (BOB member since 2003-04-10)
Do a scan and repair on the BO repository
JaiGupta (BOB member since 2002-09-12)
Get an Oracle DBA to look at this. Also, have a search both on here and tech support - I remember reading about this occuring in a very specific set of circumstances…I think the fix was the addition of a registry key.
Nick Daniels 
(BOB member since 2002-08-15)
Nick. Do you know any more details of this registry key? Where to look etc… cheers
I am also getting this problem intermittently using Oracle 9i database on Linux.
My experienced DBA adds that this error is caused by one transaction locking a table in the repository for write. The lock is still in place when the next transaction occurs. My BO key file has the settings: “Disconnect after each transaction”.
Does anyone have any suggestions please regarding key file settings in general?
Also does anyone know what tables would be locked (for write) by BCA/BO in the repository whilst processing BCA jobs?
JonK (BOB member since 2004-07-07)
If you have access to BO’s own technical support website (http://www.techsupport.businessobjects.com/app/ocs_HomePage.asp) you could search for NO WAIT I think that might get you there…
Nick Daniels (BOB member since 2002-08-15)