• Print |
• E-mail  |
• Bookmark

When using the SAS provided jobs to load the tables into the DDS
library you may encounter errors in the log that may look like:

   ERROR [ListenerMeasureValueChanged]
   com.ibatis.common.jdbc.exception.NestedSQLEx
   ception:
   --- The error occurred while applying a parameter map.
   --- Check the getMeasureValueChanges-InlineParameterMap.
   --- Check the statement (query failed).
   --- Cause: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
   You have an error in your SQL syntax; check the manual that
   corresponds to your MySQL server version for the right syntax
   to use near  'from DDS.TABLE_XXX at line 1
   Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
   You have an error in your SQL syntax; check the manual that
   corresponds to your MySQL server version for the right syntax
   to use near  'from DDS.TABLE_XXX' at line 1


This can occur because the Measure functionality in SAS Strategic
Performance Management has incorrectly determined that the table update
is a metric table update. This is not true in the case of the DDS table
updates. However this incorrect detection has no side-effect except the
errors shown in the log. Thus the errors can be ignored. Any metric
table updates will be handled correctly.

Operating System and Release Information