CA Single Sign-On Tech Tip by Sau Lai Wong, Principal Support Engineer for 23rd August 2016

Issue:

Following error is logged in smps.log:

“Timestamp parameters with a scale, must have a scale less than ten and a precision equal to 20 plus the scale. You specified a precision of 32 and scale of 12. Error in parameter 1."

Environment:

Policy Store: IBM DB2 10.x

Policy Server: R12.52 SP1 CR1

Cause:

This is a known issue with Data Direct driver v07.12 against IBM DB2 10.x. R12.52 SP1 CR1 Policy Server is using Data Direct driver v07.12.0056 (B0067, U0042).

The connection option "WorkArounds2=2" is not functioning properly against DB2 LUW 10.x with the ODBC 7.1 DB2 driver.  This option causes the driver to ignore the ColumnSize and DecimalDigits specified in SQLBindParameter.  When executing a parameterized UPDATE statement against a timestamp, an error occurs due to the option "WorkArounds2=2" is not functioning correctly.  This only occurs against DB2 LUW 10.x.

Timestamps for DB2 10.x have a precision and scale of 32 and 12. The connection option "WorkArounds2=2" was not handling the precision of greater than 30 correctly.

Resolution:

The issue is addressed with Data Direct driver v07.13.0105 (B0111, U0073).

R12.52 SP1 CR2 Policy Server uses Data Direct driver v07.15.

Additional Information:

http://knowledgebase.progress.com/articles/Article/000049211