Hi
I have set up an oracle job to run this archiving package which worked well until recently when I get this exception in the OPERATION_LOG table
OTHER EXCEPTIONS OCCURRED!-1422ORA-01422: exact fetch returns more than requested number of rows
END ARCHIVETABLE SAGLIVE.WMCUSTOMFIELDDEFINITIONJust before these is the row below
SQLSTMT:: INSERT INTO SAGARC.WMCUSTOMFIELDDEFINITION( PROCESSKEY,DEPLOYMENTVERSION,MODELVERSION,STEPID,FIELDALIAS,DOCUMENTTYPE,DOCUMENTNAME,FIELDNAME,FIELDTYPE,TYPE )(SELECT SD.PROCESSKEY,SD.DEPLOYMENTVERSION,SD.MODELVERSION,SD.STEPID,SD.FIELDALIAS,SD.DOCUMENTTYPE,SD.DOCUMENTNAME,SD.FIELDNAME,SD.FIELDTYPE,SD.TYPE FROM SAGLIVE.WMCUSTOMFIELDDEFINITION SD,SAGLIVE.WMPROCESSDEFINITION PD WHERE SD.DEPLOYMENTVERSION=PD.DEPLOYMENTVERSION AND SD.PROCESSKEY=PD.PROCESSKEY AND PD.DEPLOYMENTTIME > which doesn’t seem to be correct but I can’t find where this error is
Anybody help
Thanks