Troubleshooting
Problem
When configuring Process Engine virtual server and database silently, an error may occur.
Symptom
Running the configuration silently may see the following error:
C:\Program Files\ibm\FileNet\ProcessEngine\data>peinit -V PEInitV.properties
Trace log options file 'C:\Program Files\IBM\FileNet\ProcessEngine\data\pesvr.default\traceOptions' does not exist
Configuring virtual server default on host machine <servername>...
Virtual server configuration updated
PEInit finished successfully
C:\Program Files\ibm\FileNet\ProcessEngine\data>peinit -D PEInitD.properties
Trace log options file 'C:\Program Files\IBM\FileNet\ProcessEngine\data\pesvr.default\traceOptions' does not exist
Configuring database...
PEInit terminated by error: [FNRPE1210001000E]Database error. See chained exception;
Cannot execute statement, SQL: "CREATE TABLE VWRDBObject (F_ObjectRootNVARCHAR(128) NOT NULL, F_RegionNum INT NULL, F_SubName1 NVARCHAR(128) NULL, F_SubName2 NVARCHAR(128) NULL, F_SubName3 NVARCHAR(128) NULL, F_Location NVARCHAR(128) NOT NULL, F_MarkedAsDeleted SMALLINT NULL) ON primary"
at filenet.jpe.database.DbDesc.MapMSSQLError(DbDesc.java:720)
at filenet.jpe.database.DbDesc.ConvertError(DbDesc.java:665)
...
Caused by:
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'primary'.
...
at filenet.jpe.database.DbStatement.execute(DbStatement.java:78)
... 8 more
Cause
The issue can occur if using the Primary file group during the configuration phase instead of a specially created non-Primary file group.
Environment
Windows 2008, SQL 2008
Resolving The Problem
Steps to resolve:
- Open file PEInitD.properties with a text editor, such as Notepad.
- Update the value of pe_data with the correct file group.
- Re-run the silent installation.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21503084