DefaultValue="sysdate"
DefaultValue="'2500-12-31'"
DefaultValue="'2500-12-31'"
DefaultValue="timestamp('2500-12-31 00:00:00.0')"
For all others - it seems like deployer.sh -t entitydeployer just
ignores the default value passed and tries ''
[java] Reorg statement executed successfully for table :
YFS_CUSTOMER
[java] [saneSqlExec] Failed to execute: ALTER TABLE YFS_CUSTOMER
ADD EXTN_PURGE_DATE TIMESTAMP DEFAULT TIMESTAMP('') NOT
NULL ADD EXTN_DELETE_DATE TIMESTAMP DEFAULT TIMESTAMP('') NOT NULL
[java] /opt/IBM/oms/SMCFS93/properties/entityDeployer.xml:873: The
following error occurred while executing this line:
[java] /opt/IBM/oms/SMCFS93/properties/entityDeployer.xml:853: com.
ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-574,
SQLSTATE=42894, SQLERRMC=EXTN_PURGE_DATE;SSFS93DEV.YFS_CUSTOMER;-180,
DRIVER=4.15.82
[java] at org.apache.tools.ant.ProjectHelper.
addLocationToBuildException(ProjectHelper.java:497)
[java] at org.apache.tools.ant.taskdefs.MacroInstance.execute
(MacroInstance.java:401)
[java] at org.apache.tools.ant.UnknownElement.execute
(UnknownElement.java:291)
[java] at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown
Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:37)
[java] at java.lang.reflect.Method.invoke(Method.java:611)
[java] at org.apache.tools.ant.dispatch.DispatchUtils.execute
(DispatchUtils.java:106)
[java] at org.apache.tools.ant.Task.perform(Task.java:348)
[java] at org.apache.tools.ant.Target.execute(Target.java:390)
[java] at org.apache.tools.ant.Target.performTasks(Target.java:
411)
[java] at org.apache.tools.ant.Project.executeSortedTargets
(Project.java:1397)
[java] at org.apache.tools.ant.Project.executeTarget(Project.
java:1366)
[java] at com.sterlingcommerce.woodstock.install.deployer.
AntDeployer.executeScript(AntDeployer.java:256)
[java] at com.sterlingcommerce.woodstock.install.deployer.
AntDeployer.deploy(AntDeployer.java:200)
[java] at com.sterlingcommerce.woodstock.install.deployer.
AntDeployer.execute(AntDeployer.java:195)
[java] at com.sterlingcommerce.woodstock.install.deployer.
AntDeployer.main(AntDeployer.java:174)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:60)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:37)
[java] at java.lang.reflect.Method.invoke(Method.java:611)
[java] at com.sterlingcommerce.woodstock.noapp.NoAppLoader.main
(NoAppLoader.java:90)
[java] Caused by: /opt/IBM/oms/SMCFS93/properties/entityDeployer.
xml:853: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
SQLCODE=-574, SQLSTATE=42894, SQLERRMC=EXTN_PURGE_DATE;SSFS93DEV.
YFS_CUSTOMER;-180, DRIVER=4.15.82
[java] at org.apache.tools.ant.taskdefs.SQLExec.execute
(SQLExec.java:672)
[java] at com.sterlingcommerce.woodstock.install.SaneSQLExec.
execute(SaneSQLExec.java:108)
[java] at org.apache.tools.ant.UnknownElement.execute
(UnknownElement.java:291)
[java] at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown
Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:37)
[java] at java.lang.reflect.Method.invoke(Method.java:611)
[java] at org.apache.tools.ant.dispatch.DispatchUtils.execute
(DispatchUtils.java:106)
[java] at org.apache.tools.ant.Task.perform(Task.java:348)
[java] at org.apache.tools.ant.taskdefs.Sequential.execute
(Sequential.java:68)
[java] at org.apache.tools.ant.UnknownElement.execute
(UnknownElement.java:291)
[java] at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown
Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:37)
[java] at java.lang.reflect.Method.invoke(Method.java:611)
[java] at org.apache.tools.ant.dispatch.DispatchUtils.execute
(DispatchUtils.java:106)
[java] at org.apache.tools.ant.Task.perform(Task.java:348)
[java] at org.apache.tools.ant.taskdefs.MacroInstance.execute
(MacroInstance.java:398)
|