cancel
Showing results for 
Search instead for 
Did you mean: 

Composedtypes table not created after system update in MYSQL Database

former_member821495
Discoverer
0 Kudos

Hi Team,

I installed mysql dump on one of the newly created schema and after that I tried to build and update the system from command prompt. I am getting below error:

   [java] ERROR [DeploymentMigrationUtil] Error while migrating deployments of extension basecommerce
     [java] de.hybris.platform.jalo.JaloSystemException: Table 'hybrisship.composedtypes' doesn't exist
     [java]     at de.hybris.platform.persistence.type.TypeManagerEJB.findByCodeExact(TypeManagerEJB.java:285) ~[coreserver.jar:?]
     [java]     at de.hybris.platform.persistence.type.TypeManagerEJB.getComposedType(TypeManagerEJB.java:457) ~[coreserver.jar:?]
     [java]     at de.hybris.platform.jalo.type.TypeManager.getComposedType(TypeManager.java:362) ~[coreserver.jar:?]
     [java]     at de.hybris.platform.util.migration.DeploymentMigrationUtil.migrateGeneralizedDuplicatedDeployments(DeploymentMigrationUtil.java:151) [coreserver.jar:?]
     [java]     at de.hybris.platform.cms2.jalo.Cms2Manager.notifyInitializationStart(Cms2Manager.java:69) [cms2server.jar:?]
     [java]     at de.hybris.platform.core.Initialization.doInitializeImpl(Initialization.java:541) [coreserver.jar:?]
     [java]     at de.hybris.platform.core.Initialization$5.call(Initialization.java:867) [coreserver.jar:?]
     [java]     at de.hybris.platform.core.Initialization$5.call(Initialization.java:1) [coreserver.jar:?]
     [java]     at de.hybris.platform.core.system.InitializationLockHandler.performLocked(InitializationLockHandler.java:68) [coreserver.jar:?]
     [java]     at de.hybris.platform.core.Initialization.doInitialize(Initialization.java:899) [coreserver.jar:?]
     [java]     at de.hybris.ant.taskdefs.InitPlatformAntPerformableImpl.performImpl(InitPlatformAntPerformableImpl.java:107) [coreserver.jar:?]
     [java]     at de.hybris.ant.taskdefs.AbstractAntPerformable.doPerform(AbstractAntPerformable.java:84) [coreserver.jar:?]
     [java]     at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
     [java]     at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
     [java]     at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
     [java]     at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
     [java]     at bsh.Reflect.invokeMethod(Reflect.java:131) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.Reflect.invokeObjectMethod(Reflect.java:77) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.Name.invokeMethod(Name.java:852) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:69) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:96) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:41) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.BSHBlock.evalBlock(BSHBlock.java:125) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.BSHBlock.eval(BSHBlock.java:75) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.BSHBlock.eval(BSHBlock.java:41) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.BSHTryStatement.eval(BSHTryStatement.java:80) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.Interpreter.eval(Interpreter.java:659) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.Interpreter.eval(Interpreter.java:750) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at bsh.Interpreter.eval(Interpreter.java:739) [bsh-2.0b6.jar:2.0b6 2016-02-05 05:16:19]
     [java]     at de.hybris.platform.util.ClientExecuter.execute(ClientExecuter.java:42) [coreserver.jar:?]
     [java]     at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
     [java]     at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
     [java]     at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
     [java]     at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
     [java]     at de.hybris.bootstrap.loader.Loader.execute(Loader.java:136) [ybootstrap.jar:?]
     [java]     at de.hybris.bootstrap.loader.Loader.main(Loader.java:110) [ybootstrap.jar:?]
     [java] Caused by: de.hybris.platform.persistence.hjmp.HJMPFinderException: Table 'hybrisship.composedtypes' doesn't exist
     [java]     at de.hybris.platform.persistence.type.ComposedType_HJMPWrapper.ejbFindByCodeExact(ComposedType_HJMPWrapper.java:1387) ~[coreserver.jar:?]
     [java]     at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
     [java]     at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
     [java]     at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
     [java]     at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
     [java]     at de.hybris.platform.util.Utilities.callMethod(Utilities.java:1017) ~[coreserver.jar:?]
     [java]     at de.hybris.platform.util.Utilities.callMethod(Utilities.java:1007) ~[coreserver.jar:?]
     [java]     at de.hybris.platform.persistence.framework.HomeInvocationHandler.invokeMethod(HomeInvocationHandler.java:105) ~[coreserver.jar:?]
     [java]     at de.hybris.platform.persistence.framework.HomeInvocationHandler.invoke(HomeInvocationHandler.java:55) ~[coreserver.jar:?]
     [java]     at com.sun.proxy.$Proxy176.findByCodeExact(Unknown Source) ~[?:?]
     [java]     at de.hybris.platform.persistence.type.TypeManagerEJB.findByCodeExact(TypeManagerEJB.java:272) ~[coreserver.jar:?]
     [java]     ... 35 more
     [java]  INFO [DeploymentMigrationUtil] * Finished migrating duplicated deployments of extension basecommerce
     [java]  INFO [DeploymentMigrationUtil] *****************************************************
     [java]  INFO [DeploymentMigrationUtil]
     [java]  INFO [Initialization] ###############################################################
     [java]  INFO [Initialization] Updating system ...
     [java]  INFO [Initialization] ###############################################################
     [java]  INFO [Initialization] Please wait. This step can take some minutes to complete.
     [java]  INFO [Initialization] If you do not receive any feedback on this page in this time, consult the applicationserver logs for possible errors.
     [java]  INFO [Initialization] Updating system...
     [java]  INFO [Initialization] ### Starting type system update
     [java]  INFO [Initialization] >>> Updating schema (and type system) ...
     [java]  INFO [DbTypeSystemImpl] Fetching type system related entities
     [java]  INFO [DbTypeSystemImpl] 0 deployments have been fetched in 1.236 ms
     [java] ERROR [HybrisSchemaGenerator] Make sure you are trying to update already initialized type system. Cannot read existing DbTypeSystem properly due to : StatementCallback; bad SQL grammar [select * from null]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null' at line 1
     [java] shutting down hybris registry..
     [java]  INFO [DefaultTaskService] Task engine already stopped.
     [java]  INFO [DefaultSolrClientPool] Stopping Solr clients clean-up thread for tenant master
     [java]  INFO [TenantStartupNotifier] Using default implementation of TenantStartupNotifier for tenant <<junit>>[58511186]
     [java]  INFO [TenantStartupNotifier] Instantiating de.hybris.platform.core.BlockingTenantStartupNotifier for tenant <<junit>>[58511186].
     [java]  INFO [DefaultAfterSaveListenerRegistry] AfterSaveEventPublisher-master has been interrupted - stopping now: sleep interrupted
     [java]  INFO [DefaultAfterSaveListenerRegistry] AfterSaveEventPublisher-master has been interrupted/terminated but without InterruptedException - stopping now.
     [java]  INFO [RcclTenantAwareEhCacheManagerFactoryBean] Shutting down EhCache CacheManager 'rccl_master'
     [java]  INFO [DefaultCacheController] Removed listener from cache controller. Currently registered 1
     [java] Stopping Solr process 4684 running on port 6983
     [java] ERROR: Input redirection is not supported, exiting the process immediately.
     [java]  INFO [DefaultClusterNodeManagementService] Unregistering assigned cluster node id 0...

Accepted Solutions (0)

Answers (3)

Answers (3)

samuelyang
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Hemanth,

Now I see the issue, running Commerce on top of an existing mysql dump file is not recommended at all, it's better to start over again from initializing the whole system against mysql.

samuelyang
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Hemanth,

So did you mean the system initialization against mysql succeeded, but the update system failed with the above error messages?

And What is the mysql version are you using? Is it a supported version?

former_member821495
Discoverer
0 Kudos

I am using hybris 2005 , mysql 8.0.29 and existing database dump. After building code using ant clean all command, I did ant updatesystem and seeing the above error.

samuelyang
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Hemanth,

Did you just change the underlying database from HSQLDB to MySQL?

If this is the case, you will need to re-initialize the whole system.

former_member821495
Discoverer
0 Kudos

No, I started using mysql from the beginning.