topic Re: MDM data model is not deploying to mdm server Talend 7 in Talend Data Catalog

MDM data model is not deploying to mdm server Talend 7

Anonymous — Tue, 07 Aug 2018 07:51:25 GMT

Hello ,

I have created Data model , container and view .

Data model is not deploying to mdm server .

Please find the attached screenshot of error msg from studio and MDM log

Re: MDM data model is not deploying to mdm server Talend 7

Anonymous — Tue, 07 Aug 2018 10:33:37 GMT

Hi,

When deploying, you are getting the following error:

Caused by: java.lang.RuntimeException: Could not prepare 'final_cutomer'.
	at com.amalto.core.storage.hibernate.HibernateStorage.prepare(Unknown Source)
	at com.amalto.core.storage.SecuredStorage.prepare(Unknown Source)
	at com.amalto.core.storage.CacheStorage.prepare(Unknown Source)
	... 90 more
Caused by: java.lang.RuntimeException: Exception occurred during Hibernate initialization.
	... 93 more
Caused by: java.lang.IllegalStateException: Could not prepare database schema: Duplicate column name 'x_talend_staging_hastask'

Duplicate column name 'x_talend_staging_status'

Duplicate column name 'x_talend_staging_source'

Duplicate column name 'x_talend_staging_blockkey'

Duplicate column name 'x_talend_staging_error'

Duplicate column name 'x_talend_staging_values'

Duplicate key name 'cutomer_x_talend_task_id_index'

Duplicate key name 'cutomer_x_talend_staging_hastask_index'

Duplicate key name 'cutomer_x_talend_staging_status_index'

Duplicate key name 'cutomer_x_talend_staging_blockkey_index'

It looks like the Staging DB is already created.

Re: MDM data model is not deploying to mdm server Talend 7

Anonymous — Tue, 07 Aug 2018 11:23:21 GMT

Once we deploy data model to server ,it has to create table in staging schema .

But table is not creating in staging .

We created table in staging and tried redeploying data model then also we cant able to deploy .

we tried Undeploying data model ,data container and view and redeploy .

we are getting error and error is present in attachment .

ERROR.PNG