Troubleshooting
Problem
Sterling Integrator 5.1 upgrade from GIS 4.3 fails - Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
Symptom
Upgrade : Gentran Integration Suite 4.3 to Sterling Integrator 5.1
SQL Server 2008
The upgrade fails and the PreInstallSI log shows errors pertaining to the SI_VERSION table date/time field format.
Old date/time format - May 27 2010 3:00PM
New date/time format - 2010-05-27 15:00:00
Error MessageDEBUG:getNamedSQL():getNamedSQL=upgrade.selectAllFromSI_VERSION
DEBUG:getNamedSQL():query is:select * from SI_VERSION
DEBUG:UpgradeHelper.getIsOldSchema()false
DEBUG:4.3+ schema for SI_VERSION table
GISUpgradeHelper.buildMapSIVersions start
DEBUG:[GISUpgradeHelper].getNamedSQL():getNamedSQL=upgrade.selectAllFromSI_VERSION
DEBUG:[GISUpgradeHelper].getNamedSQL():query is:select * from SI_VERSION
java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
at java.sql.Timestamp.valueOf(Timestamp.java:194)
at com.microsoft.sqlserver.jdbc.DDC.convertStringToObject(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.readUnicodeString(Unknown Source)
at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.Column.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.Column.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getTimestamp(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getTimestamp(Unknown Source)
at com.sterlingcommerce.woodstock.install.utils.GISUpgradeHelper.buildMapSIVersions(GISUpgradeHelper.java:92)
at upgrade.scripts.PreServiceInstall.doPreInstallTasks(PreServiceInstall.java:182)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sterlingcommerce.woodstock.install.utils.ClassUtils.runAllOfTypeInPackage(ClassUtils.java:125)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.doPreInstallTasks(ServiceInstall.java:3156)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.installService(ServiceInstall.java:756)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.install(ServiceInstall.java:522)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.install(ServiceInstall.java:243)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.install(ServiceInstall.java:352)
at com.sterlingcommerce.woodstock.install.InstallSI.ModuleLoader(InstallSI.java:1470)
at com.sterlingcommerce.woodstock.install.InstallSI.PerformInstall(InstallSI.java:771)
at com.sterlingcommerce.woodstock.install.InstallSI.main(InstallSI.java:133)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.instanciateAndRun(InstallSIBootstrapper.java:355)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.instanciateAndRun(InstallSIBootstrapper.java:359)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.doIt(InstallSIBootstrapper.java:188)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.main(InstallSIBootstrapper.java:81)
com.sterlingcommerce.woodstock.install.module_loader.ServiceInstallException
at com.sterlingcommerce.woodstock.install.utils.ClassUtils.runAllOfTypeInPackage(ClassUtils.java:134)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.doPreInstallTasks(ServiceInstall.java:3156)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.installService(ServiceInstall.java:756)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.install(ServiceInstall.java:522)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.install(ServiceInstall.java:243)
at com.sterlingcommerce.woodstock.install.module_loader.ServiceInstall.install(ServiceInstall.java:352)
at com.sterlingcommerce.woodstock.install.InstallSI.ModuleLoader(InstallSI.java:1470)
at com.sterlingcommerce.woodstock.install.InstallSI.PerformInstall(InstallSI.java:771)
at com.sterlingcommerce.woodstock.install.InstallSI.main(InstallSI.java:133)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.instanciateAndRun(InstallSIBootstrapper.java:355)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.instanciateAndRun(InstallSIBootstrapper.java:359)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.doIt(InstallSIBootstrapper.java:188)
at com.sterlingcommerce.woodstock.install.InstallSIBootstrapper.main(InstallSIBootstrapper.java:81)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sterlingcommerce.woodstock.install.utils.ClassUtils.runAllOfTypeInPackage(ClassUtils.java:125)
... 16 more
Caused by: com.sterlingcommerce.woodstock.install.module_loader.ServiceInstallException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
at upgrade.scripts.PreServiceInstall.doPreInstallTasks(PreServiceInstall.java:310)
... 21 more
Resolving The Problem
Manually edit the data from the SI_INSTALL_DATE column within the SI_VERSION table to match the expected date/time format and rerun the upgrade.
Historical Number
NFX10594
Product Synonym
[<p><b>]Severity[</b><p>];Normal
Was this topic helpful?
Document Information
Modified date:
20 November 2019
UID
swg21557975