IBM Support

FileNet Content Engine Incorrect syntax error during AddOn installation

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.

[{"Product":{"code":"SSNW2F","label":"FileNet P8 Platform"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Content Engine","Platform":[{"code":"PF033","label":"Windows"}],"Version":"5.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg21653858