Message SQL0803 Received from QYIVRIPS during Electronic Service Agent Transmission Attempt

Message SQL0803 Received from QYIVRIPS during Electronic Service Agent Transmission Attempt

The following message can be received in the Electronic Service Agent Audit log, the QYPSJSVR joblog, the QYIVRIPS joblog, or a combination of all joblogs: SQL0803 - Duplicate key value specified.


Example of Audit log entry without the message ID:

InventoryManager: com.ibm.as400.sa.svcsndr.ProcessException:

com.ibm.db2.jdbc.app.DB2SQLIntegrityConstraintViolationException: Duplicate key value specified.    

    • Related Articles

    • How to add a New Form and attach to a Service Category

      Admins can now create multiple forms within the Form Builder, then attach one or multiple forms to any service category, and make it required! Note: At least one form question must be marked required. Adding a New Form Go to the left sidebar of your ...

    • Setting up Service Categories

      Add service categories to differentiate your work orders based on the type of work to be accomplished, as well as assigning the right group of vendors to the work order. For example, if a pipe bursts in your wall you can signify that it is a PLUMBING ...

    • Microsoft® ODBC Driver 13.1 for SQL Server® - Windows

      Microsoft® ODBC Driver 13.1 for SQL Server® - Windows, Linux, & macOS https://www.microsoft.com/en-us/download/details.aspx?id=53339 If your PC is Windows 10 download the 64 bit driver 

    • V7R1 IBM iAccess for Windows Service Pack instructions

      See attached document Note: The latest service pack of Client Access does not need the 2 MS service packs. https://www.ibm.com/support/pages/ibm-i-access-windows-service-packs

    • Changing Service Tools User id

      Changing Service Tools Userid STRSST   Option 8   Option 1   Change the password by the one needed.   Also check this: Change IBM Service Tools Pwd (CHGDSTPWD) This will reset QSECOFR back to the system supplied default (read the help text on this).