RCU schema creation utility fails with error java.sql.SQLException: ORA-39006: internal error ORA-06

2773333

Hi

While creating the DW, BIACOMP and ODIREPO schemas using BIAPPS_RCU I am getting error with data pump utility. Below is the log file for the same. Any help would be greatly appreciated.

2017-08-31 15:51:55.287 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed

oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6135:Error while trying to execute Java action.

at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:302)

at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)

at java.lang.Thread.run(Thread.java:662)

Caused by: oracle.sysman.assistants.common.task.ActionFailedException: RCU-6135:Error while trying to execute Java action.

at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:537)

... 1 more

Caused by: java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:510)

... 1 more

Caused by: java.sql.SQLException: ORA-39006: internal error

ORA-06512: at "SYS.DBMS_DATAPUMP", line 7143

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

ORA-06512: at "SYS.DBMS_DATAPUMP", line 4932

ORA-06512: at "SYS.DBMS_DATAPUMP", line 7137

ORA-06512: at line 1

2017-08-31 15:51:55.293 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: Executing Task: Oracle Business Intelligence Applications Components Repository

2017-08-31 15:51:55.294 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction command=C:\Users\vpalanisamy\Desktop\19_OBIA_RCU\/rcu/integration/biapps/lib/biappsrcudbinstall.jar:oracle.biapps.rcu.dbinstall.DataPumpUtils:cancel

2017-08-31 15:51:55.295 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: jarPath=C:\Users\vpalanisamy\Desktop\19_OBIA_RCU\/rcu/integration/biapps/lib/biappsrcudbinstall.jar

2017-08-31 15:51:55.298 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction method=cancel

2017-08-31 15:51:55.299 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Connect As Owner: false

2017-08-31 15:51:55.299 NOTIFICATION rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::connect: Connecting to database: user:SYS, role:SYSDBA, connectString:(description=(address=(host=172.17.25.26)(protocol=tcp)(port=1521))(connect_data=(service_name=DWAPICORP)(server=dedicated)))

2017-08-31 15:51:56.526 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.task.TaskRunner::suspendExecution: Suspending the execution

2017-08-31 15:51:57.955 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.task.TaskRunner::notifyIfSuspended: Resuming the execution

2017-08-31 15:51:57.956 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.task.TaskRunner::cancelExecution: Canceling the execution

2017-08-31 15:51:58.296 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: m_bean.getResetSession() = false

2017-08-31 15:51:58.296 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: m_bean.getConnectAsOwner() = false

2017-08-31 15:51:58.296 NOTIFICATION rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::connect: Connecting to database: user:SYS, role:SYSDBA, connectString:(description=(address=(host=172.17.25.26)(protocol=tcp)(port=1521))(connect_data=(service_name=DWAPICORP)(server=dedicated)))

2017-08-31 15:51:58.343 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: current user=SYS

2017-08-31 15:51:58.343 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: Performing JDBCScript Action Command: C:\Users\vpalanisamy\Desktop\19_OBIA_RCU\/rcu/integration//biapps/sql/biapps_cleanup.sql CMDLINE Parameters Length: 2

2017-08-31 15:51:58.343 NOTIFICATION rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::parseNexecuteScript: ParseNexecute Script: C:\Users\vpalanisamy\Desktop\19_OBIA_RCU\/rcu/integration//biapps/sql/biapps_cleanup.sql

2017-08-31 15:51:58.356 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: **** Sql script DONE****

2017-08-31 15:51:58.356 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: m_bean.getResetSession() = false

2017-08-31 15:51:58.357 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: m_bean.getConnectAsOwner() = false

2017-08-31 15:51:58.358 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: current user=SYS

2017-08-31 15:51:58.358 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: Performing JDBCScript Action Command: C:\Users\vpalanisamy\Desktop\19_OBIA_RCU\/rcu/integration//biapps/sql/biapps_cleanup.sql CMDLINE Parameters Length: 2

2017-08-31 15:51:58.358 NOTIFICATION rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::parseNexecuteScript: ParseNexecute Script: C:\Users\vpalanisamy\Desktop\19_OBIA_RCU\/rcu/integration//biapps/sql/biapps_cleanup.sql

2017-08-31 15:51:58.370 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: **** Sql script DONE****

2017-08-31 15:51:58.370 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JavaAction::perform: User clicked stop. Stopping execution of the method.

2017-08-31 15:51:58.370 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction command=oracle.ias.version.SchemaVersionUtil:utilCreateRegistryEntry

2017-08-31 15:51:58.371 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: JavaAction method=utilCreateRegistryEntry

2017-08-31 15:51:58.371 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Connecting as Owner:false

2017-08-31 15:51:58.373 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.ActionThread::run: Failed to execute method:  Excepton:

java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:510)

at java.lang.Thread.run(Thread.java:662)

Caused by: java.sql.SQLException: Closed Connection

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)

at oracle.jdbc.driver.PhysicalConnection.getMetaData(PhysicalConnection.java:3974)

at oracle.ias.version.SchemaVersion.<init>(SchemaVersion.java:304)

at oracle.ias.version.SchemaVersionUtil.initialize(SchemaVersionUtil.java:143)

at oracle.ias.version.SchemaVersionUtil.utilCreateRegistryEntry(SchemaVersionUtil.java:271)

... 6 more

Regards

Vyshak P

2773333

Anyone ?

Regards

Vyshak

Sherry George

Hi Vyshak,

You haven't provided any version numbers for your application or DB. But for a start confirm that you are performing installation on a certified system.