PureEngage On-Premises

 View Only

Sign Up

  • 1.  Can I see SQL statements in ICON logs? causing DB errors

    Posted 08-04-2016 15:06
    Hi I am getting Arithmetic overflow error for data type smallint, value = 69729 error in ICON logs.

    Can I see the SQL statement causing these errors?

    Thanks,
    Dilipa


  • 2.  RE: Can I see SQL statements in ICON logs? causing DB errors

    Posted 08-08-2016 06:18
    Hello,

    you can see it within DBServer logs which is used by the ICON for CRUD operations. According to this error, strongly recommend to follow KB article below:

    https://genesyspartner.force.com/customercare/pkb_Home?id=kA4U00000008drfKAA&l=en_US&fs=Search&pn=1

    The above error can be bypassed by configuring an error reaction using the following settings in CME:
    In the ICON application -> on the Options tab-> dbw-error-reactions-> add:
    Option name: error_smallint
    Option Value: error=Arithmetic overflow error;reaction=ignore
     
    Please delete this reaction after the issue is resolved.
     
    We recommend to find out what exactly data is caused the overflow and correct it in order to avoid such issue occurances in future.

    HTH!

    Regards,
    --Jakub--