Search This Blog

Wednesday, September 24, 2014

Error when Applying RTOC in Data Map

Symptom:
Using the RTOC capability in the Data Map, the following error appears:

"Failed! Incorrect syntax near keyword 'into'.

Here is an example of the complete error:



This error usually occurs when upgrading to DBObjects 3.2.0 or higher.

Solution:
This can be solved by applying the following hot fix.  Download the file p_ETL_MAP_v7.7.sql, and execute via SSMS on BPM Connect database exhibiting the issue.  This fix will be included as a part of DBobjects 3.3.1.

No comments:

Post a Comment