IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Back to discussions
Expand all | Collapse all

PROCESS_ARCHIVE.START_PROCESSARCHIVE Package Exception

  • 1.  PROCESS_ARCHIVE.START_PROCESSARCHIVE Package Exception

    Posted 11/30/17 08:10 AM

    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.WMCUSTOMFIELDDEFINITION

    Just 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


    #Integration-Server-and-ESB
    #webMethods


Related Content