Valence Framework 4.1.20150211.0
Valence Portal
Errors app
Entered my user id in the search field
App crashed with the following error:
Program VVSRVPGM
Module VVOUT
Procedure VVOUT_EXECSQLTOJSON
Message ID VV00007
Statement Number
Message Text SQL statement prep failure (SQLSTT=57017) - SQL0332 - Character conversion between CCSID 1200 and CCSID 65535 not valid.
Help Text The value of the statement is: select VVERRLOG.*, char(date(VVSTAMP),iso) as VVDATE, char(time(VVSTAMP),jis) as VVTIME from VVERRLOG where char(VVID) like '%C801097%' or upper(VVPGM) like '%C801097%' or upper(VVMODULE) like '%C801097%' or upper(VVPROC) like '%C801097%' or upper(VVMSGID) like '%C801097%' or upper(VVSTMT) like '%C801097%' or upper(VVMSGTXT) like '%C801097%' or upper(VVHLPTXT) like '%C801097%' or upper(VVLOGINID) like '%C801097%' or upper(VVIBMIUSER) like '%C801097%' or upper(char(VVSTAMP)) like '%C801097%' or upper(VVJOB) like '%C801097%' or upper(VVCALPGM) like '%C801097%' or upper(VVCALSTK) like '%C801097%' order by VVID desc
Valence Login ID C801097
IBM i User C801097
Timestamp 2015-03-06-12.34.53.359000
Job Number 393244
Calling Program VVERRORS
Call Stack VVCALL[VVCALL]-->VVERRORS[VVERRORS]-->VVERRORS[SENDBACKERRORRECORDS]-->VVSRVPGM{VVOUT}[VVOUT_EXECSQLTOJSON]
Would appreciate any help to fix this issue.
Regards,
Gloria
Valence Portal
Errors app
Entered my user id in the search field
App crashed with the following error:
Program VVSRVPGM
Module VVOUT
Procedure VVOUT_EXECSQLTOJSON
Message ID VV00007
Statement Number
Message Text SQL statement prep failure (SQLSTT=57017) - SQL0332 - Character conversion between CCSID 1200 and CCSID 65535 not valid.
Help Text The value of the statement is: select VVERRLOG.*, char(date(VVSTAMP),iso) as VVDATE, char(time(VVSTAMP),jis) as VVTIME from VVERRLOG where char(VVID) like '%C801097%' or upper(VVPGM) like '%C801097%' or upper(VVMODULE) like '%C801097%' or upper(VVPROC) like '%C801097%' or upper(VVMSGID) like '%C801097%' or upper(VVSTMT) like '%C801097%' or upper(VVMSGTXT) like '%C801097%' or upper(VVHLPTXT) like '%C801097%' or upper(VVLOGINID) like '%C801097%' or upper(VVIBMIUSER) like '%C801097%' or upper(char(VVSTAMP)) like '%C801097%' or upper(VVJOB) like '%C801097%' or upper(VVCALPGM) like '%C801097%' or upper(VVCALSTK) like '%C801097%' order by VVID desc
Valence Login ID C801097
IBM i User C801097
Timestamp 2015-03-06-12.34.53.359000
Job Number 393244
Calling Program VVERRORS
Call Stack VVCALL[VVCALL]-->VVERRORS[VVERRORS]-->VVERRORS[SENDBACKERRORRECORDS]-->VVSRVPGM{VVOUT}[VVOUT_EXECSQLTOJSON]
Would appreciate any help to fix this issue.
Regards,
Gloria
Comment