Topic
1 reply Latest Post - ‏2012-10-11T22:30:46Z by Yossarian42
SystemAdmin
SystemAdmin
5837 Posts
ACCEPTED ANSWER

Pinned topic Exception during feature enablement in WCS 7, Feature pack 3

‏2012-02-13T17:25:07Z |
Hi

While enalbing foundation feature for server environment. I am getting following error.

RunSQLFile:
SET SCHEMA DB2INST1
Executing file: <WC_Commerce_Install_dir>/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

<WC_Commerce_Install_dir>/components/common/xml/enableFeature.xml:82: The following error occurred while executing this line:
<WC_Commerce_Install_dir>components/common/xml/enableFeature.xml:138: The following error occurred while executing this line:
<WC_Commerce_Install_dir>/components/common/xml/databaseTasks.xml:20: The following error occurred while executing this line:
<WC_Commerce_Install_dir>/components/common/xml/databaseTasks.xml:89: The following error occurred while executing this line:
<WC_Commerce_Install_dir>/components/common/xml/commonEnablementTasks.xml:43: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=DB2INST1.FILEPROCREL;TABLE, DRIVER=4.13.80
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)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:64)
at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:217)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:599)
at org.apache.tools.ant.TaskAdapter.execute(TaskAdapter.java:123)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
at org.apache.tools.ant.Task.perform(Task.java:364)
at org.apache.tools.ant.Target.execute(Target.java:341)
at org.apache.tools.ant.Target.performTasks(Target.java:369)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
at org.apache.tools.ant.Main.runBuild(Main.java:668)
at org.apache.tools.ant.Main.startAnt(Main.java:187)
at org.apache.tools.ant.Main.start(Main.java:150)
at com.ibm.commerce.config.ant.server.AntLauncher.main(AntLauncher.java:280)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:599)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:267)
Caused by: /sitwcs/IBM/WebSphere/CommerceServer70/components/common/xml/enableFeature.xml:138: The following error occurred while executing this line:
/sitwcs/IBM/WebSphere/CommerceServer70/components/common/xml/databaseTasks.xml:20: The following error occurred while executing this line:
/sitwcs/IBM/WebSphere/CommerceServer70/components/common/xml/databaseTasks.xml:89: The following error occurred while executing this line:
/sitwcs/IBM/WebSphere/CommerceServer70/components/common/xml/commonEnablementTasks.xml:43: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=DB2INST1.FILEPROCREL;TABLE, DRIVER=4.13.80

Can someone please help me in how to resolve this issue
Thanks
Updated on 2012-10-11T22:30:46Z at 2012-10-11T22:30:46Z by Yossarian42
  • Yossarian42
    Yossarian42
    1 Post
    ACCEPTED ANSWER

    Re: Exception during feature enablement in WCS 7, Feature pack 3

    ‏2012-10-11T22:30:46Z  in response to SystemAdmin
    Not sure if this has been resolved for you since it's been a while. Make sure that either the table FILEPROCREL is empty or is backed up and drop the table and try to enable the feature again. SQLCODE=-601 means the table already exists in your DB and the script is trying to create it and DB2 did not allow that.