Archiving Error message in the ODSGenealogyETL.ksh
We are setting up the archiving functionality and having some problems with this. In a test environment it was OK.
The error message is that specified field is not found (see the attached file). I checked all the fields and all of them are available. When i execute the error query which is in the error message manually, it succeeds.
Anybody an idea what is going wrong?
Wed Nov 04 15:18:40 CET 2015 ODSBOMExtract: Started ODSBOM Extract
Wed Nov 04 15:18:52 CET 2015 ODSBOMExtract: [SQL][BaseDataSource].....The following fatal SQL exception has occurred:
insert into ods_bom
(HANDLE,
SITE,
BOM,
BOM_TYPE,
DESCRIPTION,
ERP_BILL_OF_MATERIAL,
STATUS_BO,
TMP_BOM,
COPIED_FROM_BOM,
COPIED_FROM_BOM_REVISION,
BOM_REVISION,
bom_template,
HAS_BEEN_RELEASED,
EFF_START_DATE,
EFF_END_DATE,
PREV_SITE,
ORIGINAL_TRANSFER_KEY,
ODS_CREATED_DATE_TIME,
ODS_MODIFIED_DATE_TIME)
select
bom.HANDLE,
bom.SITE,
bom.BOM,
bom.BOM_TYPE,
bom.DESCRIPTION,
bom.ERP_BILL_OF_MATERIAL,
bom.STATUS_BO,
bom.TMP_BOM,
copy_from_bom.BOM,
copy_from_bom.REVISION,
bom.REVISION,
bom.bom_template,
bom.HAS_BEEN_RELEASED,
bom.EFF_START_DATE,
bom.EFF_END_DATE,
bom.PREV_SITE,
bom.ORIGINAL_TRANSFER_KEY
,sysdate, sysdate from bom, bom copy_from_bom
where
bom.copied_from_bom_bo=copy_from_bom.handle(+)
and
((bom.MODIFIED_DATE_TIME > TO_DATE( '2013-09-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and bom.MODIFIED_DATE_TIMETO_DATE( '2013-09-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND bom.PARTITION_DATE
java.sql.SQLDataException: ORA-01878: specified field not found in datetime or interval
ORA-02063: preceding line from WIP
ORA-02063: preceding 2 lines from ODS
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)
at com.sap.me.ods.database.ODSBaseDataSource$StatementWrapper.executeUpdate(ODSBaseDataSource.java:1112)
at com.sap.me.frame.jdbc.DynamicQuery.executeUpdate(DynamicQuery.java:859)
at com.sap.me.frame.AbstractSqlImplementation.executeUpdate(AbstractSqlImplementation.java:71)
at com.sap.me.frame.AbstractDataSource.executeUpdate(AbstractDataSource.java:301)
at com.sap.me.ods.olap.ODSBOMRollupProcess.ODSExtract(ODSBOMRollupProcess.java:175)
at com.sap.me.ods.ODSBOMExtract.main(ODSBOMExtract.java:39)
Wed Nov 04 15:18:52 CET 2015 ODSBOMExtract: Exception Occurred.
javax.ejb.EJBException: nested exception is: java.sql.SQLDataException: ORA-01878: specified field not found in datetime or interval
ORA-02063: preceding line from WIP
ORA-02063: preceding 2 lines from ODS