Wednesday, August 7, 2013

SQR issue

Issue: On some occasions when a value of a numeric variable in an SQR is masked to few digits and if the number of digits is more than the Masked format then the value that gets printed would be JUNK data and usually is printed as *****.
Below is a sample code snippet and output log for example.






Solution: The root cause is the Process Instance value is of 7 digits whereas the masking was being done for 6 digits resulting in resulting in moving a JUNK value to the String variable (i.e. $PrcsInstance as seen in the screenshot). As a solution we can either comment out the masking part from the code or else add few more digits to the masking value as shown in the below screenshot.

No comments: