Usage Note 21025: ERROR [ListenerMeasureValueChanged]
com.ibatis.common.jdbc.exception.NestedSQLException
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
SAS System | SAS Financial Management | Microsoft Windows XP Professional | 4.4 | | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Standard Edition | 4.4 | | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.4 | | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.4 | | 9.1 TS1M3 | |
Microsoft Windows 2000 Server | 4.4 | | 9.1 TS1M3 | |
Microsoft Windows 2000 Professional | 4.4 | | 9.1 TS1M3 | |
Microsoft Windows 2000 Datacenter Server | 4.4 | | 9.1 TS1M3 | |
Microsoft Windows 2000 Advanced Server | 4.4 | | 9.1 TS1M3 | |
AIX | 4.4 | | 9.1 TS1M3 | |
64-bit Enabled AIX | 4.4 | | 9.1 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | low |
Date Modified: | 2009-06-29 13:24:30 |
Date Created: | 2007-09-26 15:37:02 |