Wiki

Options

New Case Case Status
Log In

Wiki

Options

 
KB100027 - Incorrect Syntax Ne…
  • RSS Feed

Last modified on 8/8/2019 4:21 PM by User.

Tags:

KB100027 - Incorrect Syntax Near UNPIVOT

Error Message When Using Map Tool: Incorrect Syntax Near UNPIVOT...

This error message may appear when trying to use the EtaPRO Data Point "Map" tool following an EtaPRO upgrade on a database that originated in SQL 2000 (80) or SQL 2005 (90):

Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.

Incorrect syntax near 'UNPIVOT'. You may need to set the compatiblity level of the current database to a higher value to enable the feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.

Incorrect syntax near ')'.

Incorrect syntax near 'UNPIVOT'. You may need to set the compatiblity level of the current database to a higher value to enable the feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.

EtaPRO systems originally configured with SQL 2000 (80) or SQL 2005 (90) include EtaPRO Version 7.4 through Version 9.0.30.

 

Database Compatibility Level Verification

After an upgrade, you should verify that the EtaPRO database compatibility level is up to date. This is most easily tested by attempting to Reverse Map and EtaPRO Data Point. If the following message appears, you will need to manually update the compatibility level using SQL Management Studio.
 

NOTE: SQL Server database manipulation is discouraged by EtaPRO Support. If you need guidance to complete this task, please contact us!

To update the database compatibility level:

  1. Launch SQL Management Studio
  2. Connect to the SQL instance to which your EtaPRO databases are attached using an db_owner account
  3. Expand the Databases branch in the Object Explorer
  4. Right-click each EtaPRO database and select Properties
  5. In the Select a page area, choose Options
  6. Select SQL Server 2008 (100) from the Compatibiltiy level drop-down menu:


     
  7. On the same form, make sure the Auto Close property is set to False


     
  8. Click OK
  9. After all databases have been updated, test the Reverse Map tool again. If the error message persists, please contact EtaPRO Support.

This task can also be accomplished by running a query as described here:  https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-server-2017

These instructions are also included in the Upgrading to EtaPRO 10.4 document.