Copying 'DEFAULT' typesystem to 'new_ts1' typesystem... not coping the ydeployments table entry.

[former_member631232]

Hi Experts,

I create a new typesystem from "DEFAULT" typesystem by ant createtypesystem -DtypeSystemName=new_ts1 cmd. the build success with message "TypeSystemHelper - Copying 'DEFAULT' typesystem to 'new_ts1' typesystem...". But this cmd did not coping the ydeployments table entry and at the time of system update the update fail as the new ydeployments is not available with typesystemname as "new_ts1".

Thanks in Advance.

Regards,

Sachi

[former_member631232]

Hi Arvind,

Thanks for your support. It is working fine now as expected, I faced the issue due to HSQL DB, now moved to MySql 5.7V and new type system is copied successfully.

Regards,

Sachi

[arvind-kumar_avinash]

Hello Sachidananda Manadhata - Please check hybris/data/hsqldb/mydb.log and let me know if you do not see new_ts1 in the INSERT statements. Also, before you perform the system update, you need to add the following in the local.properties:

db.type.system.name=new_ts1

Please check https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/1905/en-US/06f15aada9b148279f5c50fc70aa... for more details.

[former_member631232]

Thank you Arvind for your response.

I Follow the same procedure as per the wiki, Below are the mydb.log and mydb.script contents.

mydb.log: /*C3*/SET SCHEMA PUBLIC DISCONNECT (only this much content)

mydb.script: INSERT INTO TYPESYSTEMPROPS9 VALUES(NULL,8796871098455,8796093120594,'hmcindexfield',0,'hmcIndexField',1,'thefield',NULL).

There is no INSERT statement for "ydeployments" table and also no "new_ts1" typesystemname data.

Thanks,

Sachi

[arvind-kumar_avinash]

I just checked it in v1811 and I didn't face any issue. I am attaching my hybris/data/hsqldb/mydb.log file. Which version are you using?

mydblog.txt

[former_member631232]

Hi Arvind, If you don't mind would you please create one more type system from "new_type_system" to "new_type_system2". Some times its creating first time but fail in second time. I tested this with 6.7 and 1811 Version.

Regards,

Sachi