Project and Portfolio Management Practitioners Forum
cancel

DB error(ORA-01722: invalid number) while migrating a workflow

Highlighted
KChauhan
Valued Contributor.

DB error(ORA-01722: invalid number) while migrating a workflow

Hi,
We are facing some DB related issues while migrating a workflow to our test instance.The workflow uses some DB functions at the execution steps.The functions are compiled successfully in the database and also we are able to complete the request successfully.We are also not able to determine as to which code is throwing the error -ORA-01722: invalid number.We also tried to implement the resolution of the error as given online.Attached is the execution log and the code.We also verified the workflow and it's working fine.We are in PPM 7.1 SP10.
2 REPLIES
Mahen M
Acclaimed Contributor.

Re: DB error(ORA-01722: invalid number) while migrating a workflow

Can you try this migration from "Admin User" account whose User_id=1?

Regards,
Mahendran M
KChauhan
Valued Contributor.

Re: DB error(ORA-01722: invalid number) while migrating a workflow

Hi,
I tried the same but it didnt work again.Same error as below -
An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)
Java stack trace:
An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)
nested detail:ORA-01722: invalid number

java.sql.SQLException: ORA-01722: invalid number

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1072)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
at com.kintana.core.db.pool.PooledPreparedStatement.executeQuery(PooledPreparedStatement.java:133)
at com.kintana.core.util.AgentUtils.runQuery(AgentUtils.java:600)
at com.kintana.core.util.AgentUtils.runQuery(AgentUtils.java:513)
at com.kintana.core.util.AgentUtils.runQuery(AgentUtils.java:499)
at com.kintana.mig.server.ExtractionUtils.loadChildren(ExtractionUtils.java:588)
at com.kintana.mig.server.ExtractionUtils.loadChildren(ExtractionUtils.java:524)
at com.kintana.mig.server.BaseKintanaObjectAgent.loadChildren(BaseKintanaObjectAgent.java:221)
at com.kintana.mig.server.ExtractTransactionImpl.addKintanaObject(ExtractTransactionImpl.java:179)
at sun.reflect.GeneratedMethodAccessor468.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kintana.rmi.MethodInvoker.run(MethodInvoker.java:77)
at com.kintana.rmi.util.ThreadPool$WorkerThread.run(ThreadPool.java:276)




An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)
at com.kintana.core.util.AgentUtils.runQuery(AgentUtils.java:661)
at com.kintana.core.util.AgentUtils.runQuery(AgentUtils.java:513)
at com.kintana.core.util.AgentUtils.runQuery(AgentUtils.java:499)
at com.kintana.mig.server.ExtractionUtils.loadChildren(ExtractionUtils.java:588)
at com.kintana.mig.server.ExtractionUtils.loadChildren(ExtractionUtils.java:524)
at com.kintana.mig.server.BaseKintanaObjectAgent.loadChildren(BaseKintanaObjectAgent.java:221)
at com.kintana.mig.server.ExtractTransactionImpl.addKintanaObject(ExtractTransactionImpl.java:179)
at sun.reflect.GeneratedMethodAccessor468.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.kintana.rmi.MethodInvoker.run(MethodInvoker.java:77)
at com.kintana.rmi.util.ThreadPool$WorkerThread.run(ThreadPool.java:276)
Extraction failed
exit code = 2
Errors occurred during command execution.


When I click the Verify button on the workflow then its not showing any errors but only warnings.I had tried to verify the old workflow and then it was showing the same error and then i copied it and now its not showing.But the migration is failing.