ERROR RELATED TO AUTHOR FIELD WHILE IMPORTING DATA INTO BPM 10G USING ANT TASK (Doc ID 1339434.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Management Suite - Version: 6.0.0 to 10.3
Information in this document applies to any platform.

Symptoms


During migration, while importing instances  into 10g from a lower version e.g. 6.0 using ANT tasks, following error is seen in ANT task output. As a result, some of the instances are failed to be imported into 10g environment.


Error:
[fuego:instancesmanager] ORA-01400: cannot insert NULL into ("BPMENGINEDB"."PPROCINSTANCE"."AUTHOR")
[fuego:instancesmanager] java.sql.SQLException: ORA-01400: cannot insert NULL into ("BPMENGINEDB"."PPROCINSTANCE"."AUTHOR")
[fuego:instancesmanager] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
[fuego:instancesmanager] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
[fuego:instancesmanager] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
[fuego:instancesmanager] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
[fuego:instancesmanager] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
[fuego:instancesmanager] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
[fuego:instancesmanager] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
[fuego:instancesmanager] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
[fuego:instancesmanager] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
[fuego:instancesmanager] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
[fuego:instancesmanager] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
[fuego:instancesmanager] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
[fuego:instancesmanager] at fuego.jdbc.FaultTolerantPreparedStatement.executeUpdate(FaultTolerantPreparedStatement.java:625)
[fuego:instancesmanager] at fuego.migration.engine.migration.PPROCINSTANCETableContainer.insert(PPROCINSTANCETableContainer.java:200)
[fuego:instancesmanager] at fuego.migration.engine.migration.SymbolicInstancesImport.insertRecord(SymbolicInstancesImport.java:804)
[fuego:instancesmanager] at fuego.migration.engine.migration.SymbolicInstancesImport.endElement(SymbolicInstancesImport.java:285)
[fuego:instancesmanager] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
[fuego:instancesmanager] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
[fuego:instancesmanager] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
[fuego:instancesmanager] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
[fuego:instancesmanager] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[fuego:instancesmanager] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
[fuego:instancesmanager] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
[fuego:instancesmanager] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
[fuego:instancesmanager] at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
[fuego:instancesmanager] at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
[fuego:instancesmanager] at fuego.migration.engine.migration.SymbolicInstancesImport.parseImpl(SymbolicInstancesImport.java:1151)
[fuego:instancesmanager] at fuego.migration.engine.migration.SymbolicInstancesImport.parse(SymbolicInstancesImport.java:883)
[fuego:instancesmanager] at fuego.migration.engine.migration.SymbolicInstancesImport.execute(SymbolicInstancesImport.java:787)
[fuego:instancesmanager] at fuego.tools.ant.enterprise.impl.EngineInstancesManagerTaskImpl.execute(Unknown Source)
[fuego:instancesmanager] at fuego.tools.ant.enterprise.impl.EngineInstancesManagerTaskImpl.execute(Unknown Source)
[fuego:instancesmanager] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[fuego:instancesmanager] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[fuego:instancesmanager] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[fuego:instancesmanager] at java.lang.reflect.Method.invoke(Method.java:597)
[fuego:instancesmanager] at fuego.tools.ant.enterprise.taskdefs.Utils.executeTask(Unknown Source)
[fuego:instancesmanager] at fuego.tools.ant.enterprise.taskdefs.Utils.executeTask(Unknown Source)
[fuego:instancesmanager] at fuego.tools.ant.enterprise.taskdefs.EngineInstancesManagerTask.execute(Unknown Source)
[fuego:instancesmanager] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[fuego:instancesmanager] at org.apache.tools.ant.Task.perform(Task.java:364)
[fuego:instancesmanager] at fuego.tools.ant.enterprise.taskdefs.DirectorySessionTask.processTasks(Unknown Source)
[fuego:instancesmanager] at fuego.tools.ant.enterprise.taskdefs.DirectorySessionTask.executeImpl(Unknown Source)
[fuego:instancesmanager] at fuego.tools.ant.BaseFuegoTask.execute(Unknown Source)
[fuego:instancesmanager] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
[fuego:instancesmanager] at org.apache.tools.ant.Task.perform(Task.java:364)
[fuego:instancesmanager] at org.apache.tools.ant.Target.execute(Target.java:341)
[fuego:instancesmanager] at org.apache.tools.ant.Target.performTasks(Target.java:369)
[fuego:instancesmanager] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
[fuego:instancesmanager] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
[fuego:instancesmanager] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
[fuego:instancesmanager] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
[fuego:instancesmanager] at org.apache.tools.ant.Main.runBuild(Main.java:668)
[fuego:instancesmanager] at org.apache.tools.ant.Main.startAnt(Main.java:187)
[fuego:instancesmanager] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
[fuego:instancesmanager] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms