Valence Portal Errors Search Crash

[gzambrano]

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

[robert.swanson]

Hi Gloria,

Thanks for the heads-up, that is a bug in the VVERRORS app. We'll definitely have this corrected on the next 4.1 build, which is tentatively scheduled for release next week. If you need an immediate fix you can go into the source for VVERRORS and adjust lines 265.00 through 269.00 to look as follows:

' upper(char(VVMSGTXT)) like '+SQ+'%'+ 
%trim(post_Search)+'%'+SQ+' or '+      
' upper(char(VVHLPTXT)) like '+SQ+'%'+ 
%trim(post_Search)+'%'+SQ+' or '+      
' upper(char(VVLOGINID)) like '+SQ+'%'+

Then recompile the program and it should work.

-Rob

[gzambrano]

Hi Rob,

Thank you very much for your prompt reply. I applied the fix and it worked fine.

Regards,

Gloria