/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
When function based indices are present, the update system process crashes with the following exception:
|
INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | ERROR [hybrisHTTP24] [10.6.34.219] [DefaultInitUpdateFacade] Failed to initialize INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | java.lang.IllegalStateException: Cannot determine function name and column name from function expression: 'P_FIRSTNAME' INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.bootstrap.ddl.HybrisOraclePlatform$HybrisOracleModelReader.getIndexColumn(HybrisOraclePlatform.java:485) ~[ybootstrap.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.bootstrap.ddl.HybrisOraclePlatform$HybrisOracleModelReader.readIndex(HybrisOraclePlatform.java:462) ~[ybootstrap.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.bootstrap.ddl.HybrisOraclePlatform$HybrisOracleModelReader.fillIndicesCacheIfNeeded(HybrisOraclePlatform.java:365) ~[ybootstrap.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.bootstrap.ddl.HybrisOraclePlatform$HybrisOracleModelReader.readIndices(HybrisOraclePlatform.java:312) ~[ybootstrap.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at org.apache.ddlutils.platform.JdbcModelReader.readTable(JdbcModelReader.java:567) ~[ddlutils-1.0.jar:1.0] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at org.apache.ddlutils.platform.oracle.Oracle8ModelReader.readTable(Oracle8ModelReader.java:102) ~[ddlutils-1.0.jar:1.0] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at org.apache.ddlutils.platform.oracle.Oracle10ModelReader.readTable(Oracle10ModelReader.java:80) ~[ddlutils-1.0.jar:1.0] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at org.apache.ddlutils.platform.JdbcModelReader.readTables(JdbcModelReader.java:516) ~[ddlutils-1.0.jar:1.0] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:472) ~[ddlutils-1.0.jar:1.0] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1920) ~[ddlutils-1.0.jar:1.0] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1904) ~[ddlutils-1.0.jar:1.0] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.bootstrap.ddl.HybrisOraclePlatform.readModelFromDatabase(HybrisOraclePlatform.java:90) ~[ybootstrap.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.bootstrap.ddl.HybrisSchemaGenerator.update(HybrisSchemaGenerator.java:220) ~[ybootstrap.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization.initializeSchemaAndTypeSystemFullyNewStyle(Initialization.java:1228) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization.initialize(Initialization.java:1097) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization.createEmptySystemOrUpdate(Initialization.java:768) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization.access$4(Initialization.java:748) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization$4.call(Initialization.java:555) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization$4.call(Initialization.java:1) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization$SessionRecoveryAfterRegistryStartupAwareExecutor.execute(Initialization.java:690) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization.doInitializeImpl(Initialization.java:558) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization.access$5(Initialization.java:475) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization$5.call(Initialization.java:801) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization$5.call(Initialization.java:1) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.system.InitializationLockHandler.performLocked(InitializationLockHandler.java:81) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.core.Initialization.doInitialize(Initialization.java:833) ~[coreserver.jar:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.hac.facade.impl.DefaultInitUpdateFacade.executeInitUpdate(DefaultInitUpdateFacade.java:70) [DefaultInitUpdateFacade.class:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at de.hybris.platform.hac.controller.platform.InitUpdateController.initExecuteWrap(InitUpdateController.java:107) [InitUpdateController.class:?] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_112] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_112] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_112] INFO | jvm 1 | main | 2017/06/23 16:02:16.610 | at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_112] ... ... |
Read more...
Environment
Hybris 6.0, 6.1, 6.2, 6.3
ORACLE-XE 11.2.0
Oracle 12c
Product
Keywords
System update Failed to initialize Oracle Cannot determine function name and column name from function expression , KBA , CEC-COM-CPS , SAP Commerce , Problem
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.