SAP Knowledge Base Article - Preview

3681923 - Deployment failure on “Running type system upgrade” due to Unknown JDBC type code -155

Symptom

During the deployment, an error occurred: `Unknown JDBC type code -155`, deployment failed at "Running type system upgrade" step, and the issue was identified as related to the `DATETIMEOFFSET` type in custom table `QueryXXXX_test`.

The error logs provided further details, including stack traces and unsupported database column types.

{"exception":{"exception_class":"org.apache.ddlutils.model.ModelException","exception_message":"Unknown JDBC type code -155","stacktrace":"org.apache.ddlutils.model.ModelException: Unknown JDBC type code -155\n\tat org.apache.ddlutils.model.Column.setTypeCode(Column.java:215)\n\tat org.apache.ddlutils.platform.JdbcModelReader.readColumn(JdbcModelReader.java:781)\n\tat org.apache.ddlutils.platform.mssql.MSSqlModelReader.readColumn(MSSqlModelReader.java:177)\n\tat org.apache.ddlutils.platform.JdbcModelReader.readColumns(JdbcModelReader.java:755)\n\tat org.apache.ddlutils.platform.JdbcModelReader.readTable(JdbcModelReader.java:565)\n\tat org.apache.ddlutils.platform.mssql.MSSqlModelReader.readTable(MSSqlModelReader.java:100)\n\tat de.hybris.bootstrap.ddl.HybrisMSSqlPlatform$HybrisMSSqlModelReader.readTable(HybrisMSSqlPlatform.java:168)\n\tat org.apache.ddlutils.platform.JdbcModelReader.readTables(JdbcModelReader.java:516)\n\tat org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:472)\n\tat org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1920)\n\tat org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1904)\n\tat de.hybris.bootstrap.ddl.HybrisMSSqlPlatform.readModelFromDatabase(HybrisMSSqlPlatform.java:61)\n\tat de.hybris.bootstrap.ddl.HybrisSchemaGenerator.update(HybrisSchemaGenerator.java:268)\n\tat de.hybris.platform.core.Initialization.initializeSchemaAndTypeSystemFullyNewStyle(Initialization.java:1360)\n\tat de.hybris.platform.core.Initialization.initialize(Initialization.java:1234)\n\tat de.hybris.platform.core.Initialization.createEmptySystemOrUpdate(Initialization.java:874)\n\tat de.hybris.platform.core.Initialization$4.call(Initialization.java:618)\n\tat de.hybris.platform.core.Initialization$4.call(Initialization.java:613)\n\tat de.hybris.platform.core.Initialization$SessionRecoveryAfterRegistryStartupAwareExecutor.execute(Initialization.java:796)\n\tat de.hybris.platform.core.Initialization.doInitializeImpl(Initialization.java:621)\n\tat de.hybris.platform.core.Initialization$5.call(Initialization.java:918)\n\tat de.hybris.platform.core.Initialization$5.call(Initialization.java:909)\n\tat de.hybris.platform.core.system.InitializationLockHandler.performLocked(InitializationLockHandler.java:68)\n\tat de.hybris.platform.core.Initialization.doInitialize(Initialization.java:950)\n\tat de.hybris.ant.taskdefs.InitPlatformAntPerformableImpl.performImpl(InitPlatformAntPerformableImpl.java:107)\n\tat de.hybris.ant.taskdefs.AbstractAntPerformable.doPerform(AbstractAntPerformable.java:84)\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)\n\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.base/java.lang.reflect.Method.invoke(Method.java:569)\n\tat bsh.Reflect.invokeMethod(Reflect.java:131)\n\tat bsh.Reflect.invokeObjectMethod(Reflect.java:77)\n\tat bsh.Name.invokeMethod(Name.java:852)\n\tat 

***Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.***


Read more...

Environment

SAP Commerce Cloud

Product

SAP Commerce Cloud all versions

Keywords

deployment failure, unsupported database column type, DATETIMEOFFSET, Unknown JDBC type code -155 , KBA , CEC-SCC-CLA-DEP , Deployments , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.