IBM Support

Sterling Integrator 5.1 upgrade from GIS 4.3 fails - Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

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 Message

DEBUG: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.

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

NFX10594

Product Synonym

[<p><b>]Severity[</b><p>];Normal

Document Information

Modified date:
20 November 2019

UID

swg21557975

Page Feedback