MDM data model is not deploying to mdm server Talend 7

Four Stars

MDM data model is not deploying to mdm server Talend 7

MDM data model is not deploying to mdm server Talend 7

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

Employee

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

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.

Four Stars

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

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 .