DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=InstanceName.FILEPROCREL;TABLE, DRIVER=4.14.113

ERROR : When Enable The Foundation 


RunSQLFile:
SET SCHEMA InstanceName
Executing file: /opt/IBM/WebSphere/CommerceServer70/components/foundation/schema/fep1/db2/wcs.schema.foundation.sql
Failed to execute:   CREATE TABLE fileprocrel ( uploadfile_id        BIGINT NOT NULL, processfile_id       BIGINT NOT NULL, optcounter           SMALLINT NOT NULL DEFAULT 0 ) IN USERSPACE1 INDEX IN USERSPACE1

BUILD FAILED


/opt/IBM/WebSphere/CommerceServer70/components/common/xml/enableFeature.xml:89: The following error occurred while executing this line:
/opt/IBM/WebSphere/CommerceServer70/components/common/xml/enableFeature.xml:165: The following error occurred while executing this line:
/opt/IBM/WebSphere/CommerceServer70/components/common/xml/databaseTasks.xml:20: The following error occurred while executing this line:
/opt/IBM/WebSphere/CommerceServer70/components/common/xml/databaseTasks.xml:97: The following error occurred while executing this line:
/opt/IBM/WebSphere/CommerceServer70/components/common/xml/commonEnablementTasks.xml:43: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=InstanceName.FILEPROCREL;TABLE, DRIVER=4.14.113
at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:539)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:384)
at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:107)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)


Problem : fileprocrel table has data (This is occured when we run Foundation Enable Command Second Time)
SQLCODE=-601 means the table already exists in your DB and the script is trying to create it and DB2 did not allow that

Solution : 1. Drop the FILEPROCREL table  OR
  2. Restore the DB backup Before start the Feature Enable Process Then Start the Feature Enable Process.

Refference : 

https://www-01.ibm.com/support/knowledgecenter/SSZLC2_7.0.0/com.ibm.commerce.component-services.doc/tasks/twvenablefoundation.htm