2 Replies Latest reply: Mar 9, 2012 11:22 AM by Shilpa_Jadhav RSS

BBNA populate DB issue

Shilpa_Jadhav

Hi All,

 

 

I hv uninstalled bbna and was trying to reinstall again, but facing issue with the installation, I was getting notification of populate_db failed.

 

see the logs, can anyone giv me the solution on dis?

 

 

 

D:\Program Files\BMC Software\BCA-Networks\tools>populate_db.bat

Creating BCA-Networks database tables ...

Mar 3, 2012 12:07:41 AMcom.bmc.bcan.tools.bootstrap.ApplicationLauncher launch

INFO: launching com.versant.core.jdo.tools.ant.CreateJdbcSchemaTask ...

Dropping tables in schema onjdbc:oracle:thin:@1.1.1.1:1521:BBNA1

javax.jdo.JDODataStoreException: java.sql.SQLException: ORA-00054:resource busy

and acquire with NOWAIT specified

 

Most recent SQL:

DROP TABLE BASE_JOB CASCADE CONSTRAINTS

        atcom.versant.core.common.BindingSupportImpl.datastore(VOA 4.0.2.17 ---

-------:236)

        atcom.versant.core.jdbc.sql.SqlDriver.defaultMapException(VOA 4.0.2.17

-:3375)

        atcom.versant.core.jdbc.sql.SqlDriver.mapException(VOA 4.0.2.17 -:3333)

 

        atcom.versant.core.jdbc.sql.SqlDriver.dropTable(VOA 4.0.2.17 -:1047)

        atcom.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.dropAllTables(VOA

4.0.2.17 ------------:149)

        atcom.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.execute(VOA 4.0.2

.17 ------------:131)

        atcom.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.main(VOA 4.0.2.17

------------:46)

        atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        atsun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        atsun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        atjava.lang.reflect.Method.invoke(Unknown Source)

        atcom.bmc.bcan.tools.bootstrap.ApplicationLauncher.launch(ApplicationLa

uncher.java:63)

        atcom.bmc.bcan.tools.bootstrap.ApplicationLauncher.main(ApplicationLaun

cher.java:96)

NestedThrowablesStackTrace:

java.sql.SQLException: ORA-00054: resource busy and acquire withNOWAIT specifie

d

 

        atoracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.ja

va:70)

        atoracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:1

33)

        atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java

:206)

        atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

        atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

        atoracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)

        atoracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)

        atoracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)

 

        atoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme

nt.java:1222)

        atoracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.ja

va:1770)

        atoracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)

 

        atoracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrap

per.java:299)

        atcom.versant.core.jdbc.conn.StatementWithLastSQL.execute(VOA 4.0.2.17

------------:131)

        atcom.versant.core.jdbc.sql.OracleSqlDriver.dropTable(VOA 4.0.2.17 ----

---:222)

        atcom.versant.core.jdbc.sql.SqlDriver.dropTable(VOA 4.0.2.17 -:1039)

        atcom.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.dropAllTables(VOA

4.0.2.17 ------------:149)

        atcom.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.execute(VOA 4.0.2

.17 ------------:131)

        atcom.versant.core.jdo.tools.ant.CreateJdbcSchemaTask.main(VOA 4.0.2.17

------------:46)

        atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        atsun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        atsun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        atjava.lang.reflect.Method.invoke(Unknown Source)

        atcom.bmc.bcan.tools.bootstrap.ApplicationLauncher.launch(ApplicationLa

uncher.java:63)

        atcom.bmc.bcan.tools.bootstrap.ApplicationLauncher.main(ApplicationLaun

cher.java:96)

Populating BCA-Networks database tables ...

Mar 3, 2012 12:07:58 AMcom.bmc.bcan.tools.bootstrap.ApplicationLauncher launch

INFO: launching com.bmc.bcan.engine.database.admin.BcanPopulator ...

Mar 3, 2012 12:08:06 AM com.bmc.bcan.engine.database.persistence.DBSessionFactor

y <init>

INFO: bumping up maxActive database property to 70

Mar 3, 2012 12:08:16 AM com.bmc.bcan.engine.database.admin.Populatorpopulate

SEVERE: database population error

java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAITspecifie

d

 

        atoracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.ja

va:70)

        atoracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:1

33)

        atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java

:206)

        atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

        atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)

        atoracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)

        atoracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)

 

        atoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme

nt.java:1222)

        atoracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatem

ent.java:1706)

        atoracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java

:1674)

        atoracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStateme

ntWrapper.java:275)

        atcom.bmc.bcan.engine.database.persistence.DBTools.executeUpdate(DBTool

s.java:281)

        atcom.bmc.bcan.engine.database.admin.BcanPopulator.modifyOracleStringCo

lumnTypes(BcanPopulator.java:508)

        atcom.bmc.bcan.engine.database.admin.BcanPopulator.work(BcanPopulator.j

ava:3076)

        atcom.bmc.bcan.engine.database.admin.Populator.populate(Populator.java:

45)

        atcom.bmc.bcan.engine.database.admin.BcanPopulator.main(BcanPopulator.j

ava:171)

        atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        atsun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        atsun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(UnknownSource)

        atcom.bmc.bcan.tools.bootstrap.ApplicationLauncher.launch(ApplicationLa

uncher.java:63)

        atcom.bmc.bcan.tools.bootstrap.ApplicationLauncher.main(ApplicationLaun

cher.java:96)

Mar 3, 2012 12:08:16 AMcom.bmc.bcan.engine.database.admin.BcanPopulator clearEv

ents

SEVERE: Deleting all events. This method should only be called by test code and

database populator classes.

Failure with exit code 1

 

D:\Program Files\BMC Software\BCA-Networks\tools>