Troubleshooting
Problem
During a creation of a new Object Store, the installation of two AddOns failed with a DB_ERROR indicating an Incorrect syntax for a sql statement.
Symptom
The p8_server_error.log file shows the following two errors during the installation of these two add-ons:
2013-10-21T13:28:09.581 22222998 ENG FNRCP0002E - ERROR method name: invokeImportScript principal name: epsvcgcdadm Global Transaction: true User Transaction: false Exception Info: The installation of the AddOn 5.2.0 Publishing Extensions into the object store p8os1 failed. The installation report follows: PostImportScriptMethod failed with exception: There was an error running the script. Message was: Wrapped com.filenet.api.exception.EngineRuntimeException: FNRCD0009E: DB_ERROR: The database access failed with the following error: ErrorCode 1,018, Message 'Incorrect syntax near 'Index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.' ObjectStore: "p8os1", SQL: ""CREATE INDEX UI_u2297_sourcedocument ON dbo.DocVersion (u2297_sourcedocument) ON Index "" failedBatchItem=0 (#47)
com.filenet.api.exception.EngineRuntimeException: FNRCP0002E: PERSIST_ADDON_INSTALLATION_FAILED: The installation of the AddOn 5.2.0 Publishing Extensions into the object store p8os1 failed. The installation report follows: PostImportScriptMethod failed with exception: There was an error running the script. Message was: Wrapped com.filenet.api.exception.EngineRuntimeException: FNRCD0009E: DB_ERROR: The database access failed with the following error: ErrorCode 1,018, Message 'Incorrect syntax near 'Index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.' ObjectStore: "p8os1", SQL: ""CREATE INDEX UI_u2297_sourcedocument ON dbo.DocVersion (u2297_sourcedocument) ON Index "" failedBatchItem=0 (#47) failedBatchItem=0
2013-10-21T13:28:18.785 22222998 ENG FNRCP0002E - ERROR method name: invokeImportScript principal name: epsvcgcdadm Global Transaction: true User Transaction: false Exception Info: The installation of the AddOn 5.2.0 Workplace Access Roles Extensions into the object store p8os1 failed. The installation report follows: PostImportScriptMethod failed with exception: There was an error running the script. Message was: Wrapped com.filenet.api.exception.EngineRuntimeException: FNRCD0009E: DB_ERROR: The database access failed with the following error: ErrorCode 1,018, Message 'Incorrect syntax near 'Index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.' ObjectStore: "p8os1", SQL: ""CREATE INDEX UI_u2988_applicationname ON dbo.Generic (u2988_applicationname) ON Index "" failedBatchItem=0 (#29)
com.filenet.api.exception.EngineRuntimeException: FNRCP0002E: PERSIST_ADDON_INSTALLATION_FAILED: The installation of the AddOn 5.2.0 Workplace Access Roles Extensions into the object store p8os1 failed. The installation report follows: PostImportScriptMethod failed with exception: There was an error running the script. Message was: Wrapped com.filenet.api.exception.EngineRuntimeException: FNRCD0009E: DB_ERROR: The database access failed with the following error: ErrorCode 1,018, Message 'Incorrect syntax near 'Index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.' ObjectStore: "p8os1", SQL: ""CREATE INDEX UI_u2988_applicationname ON dbo.Generic (u2988_applicationname) ON Index "" failedBatchItem=0 (#29) failedBatchItem=0
The following two sql statements cause the error:
CREATE INDEX UI_u2297_sourcedocument ON dbo.DocVersion (u2297_sourcedocument) ON Index
CREATE INDEX UI_u2988_applicationname ON dbo.Generic (u2988_applicationname) ON Index
The incorrect syntax is due to the "ON Index" part of the sql statement. The customer had created a filegroup in MS SQL called "Index" to be used for their indexes.
Cause
The filegroup name "Index" is a reserved word in MS SQL and resulted in the incorrect syntax error.
Environment
CPE 5.2.0.2
WAS 8.5.0.2
Windows 2008 R2
SQL Server 2008 R2
Resolving The Problem
Replaced the "Index" filegroup with one called "Indinfo" and the AddOns installed successfully.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21653858