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

    BBNA populate DB issue

    Shilpa NameToUpdate

      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>