topic Re: [resolved] Having trouble creating data container in Talend Data Catalog

[resolved] Having trouble creating data container

Anonymous — Wed, 28 Aug 2013 02:36:29 GMT

When I create a new data container called 'CHCSDataContainer' and try to deploy it to my MDM server, I get this error:
"Unable to physically create the data cluster CHCSDataContainer: Could not create storage 'CHCSDataContainer' with data model 'CHCSDataContainer'."
The odd things is, I never told it to use CHCSDataContainer as the data model, as I already have a data model defined that uses another name. Is this a permission issue?

Re: [resolved] Having trouble creating data container

Anonymous — Wed, 28 Aug 2013 09:19:25 GMT

Hi mlefbvre,
To help you, we need to have more details with the server log.
You can display it by right-clicking on your server in the Server Explorer tab if you're using a 5.3.x version, or open the file that is located here : <JBOSS>/server/default/log/server.log
Regards,
Cyril.

Re: [resolved] Having trouble creating data container

Anonymous — Wed, 28 Aug 2013 18:52:03 GMT

2013-08-28 07:51:16,569 INFO Container 'CHCSDataContainer' does not exist in revision 'null', creating it.
2013-08-28 07:51:16,569 INFO Reading from datasource file at 'C:\mdm\TOS_MDM-Server-r104014-V5.3.1\jboss-4.2.2.GA\bin\datasources.xml'.
2013-08-28 07:51:16,589 INFO Reading from datasource file at 'C:\mdm\TOS_MDM-Server-r104014-V5.3.1\jboss-4.2.2.GA\bin\datasources.xml'.
2013-08-28 07:51:16,601 INFO Reading from datasource file at 'C:\mdm\TOS_MDM-Server-r104014-V5.3.1\jboss-4.2.2.GA\bin\datasources.xml'.
2013-08-28 07:51:16,613 INFO Reading from datasource file at 'C:\mdm\TOS_MDM-Server-r104014-V5.3.1\jboss-4.2.2.GA\bin\datasources.xml'.
2013-08-28 07:51:16,627 ERROR TransactionRolledbackLocalException in method: public abstract boolean com.amalto.core.server.XmlServer.existCluster(java.lang.String,java.lang.String) throws com.amalto.core.util.XtentisException, causedBy: java.lang.RuntimeException: Could not create storage 'CHCSDataContain

To see the whole post, download it here
OriginalPost.pdf

Re: [resolved] Having trouble creating data container

Anonymous — Wed, 28 Aug 2013 19:52:05 GMT

Is it a requirement that the Data Container and the Data Model have the same name? If not, where do you specify which data model should be used in the container?
If I make my Data Container and my Data Model the same name, it works. I am pretty sure that was not the intention as I have seen examples where they are different. Is this an Open Studio vs Enterprise Studio difference?

Re: [resolved] Having trouble creating data container

Anonymous — Thu, 29 Aug 2013 08:34:45 GMT

Hello
I think that post will help you: https://jira.talendforge.org/browse/TMDM-5107
Regards

Re: [resolved] Having trouble creating data container

Anonymous — Thu, 29 Aug 2013 09:00:11 GMT

Is it a requirement that the Data Container and the Data Model have the same name?

Yes, it is.
Regards,
Cyril.

Re: [resolved] Having trouble creating data container

Anonymous — Thu, 29 Aug 2013 20:15:21 GMT

Is it a requirement that the Data Container and the Data Model have the same name?

Yes, it is.
Regards,
Cyril.

So, then in the Talend MDM book, by Diethard Steiner, that is recommended in the sticky, "Talend Open Studio For MDM: A Practical Starter Guide ", it is an error when they call the Data Container: "SecondHandLenses", and the Data Model: "Lenses"?
Can you have multiple Data Models within a Data Container?
o If not, then why are they defined separately? Why not have the Data Container define what the model is, instead of a separate convention?
o If so, how do you associate a Data Model to a Data Container of a different name?

Re: [resolved] Having trouble creating data container

Anonymous — Sun, 20 Oct 2013 14:47:05 GMT

Please note that my book was based on version 5.0 (as mentioned at the beginning of the book). At that time, it was possible to name the data container differently from the data model. I will try to update my book over the next to months to reflect the changes in 5.2 and 5.3.

Re: [resolved] Having trouble creating data container

Anonymous — Wed, 05 Feb 2014 18:22:23 GMT

I am having a similar issue... If anybody can advise it would be much appreciated. See below error log:
I have tried to recreate the DM and DC from scratch and still the same issue. When deploying to MDM Server.

2014-02-05 10:16:24,194 ERROR SOAP request exception
java.rmi.RemoteException: Unable to physically create the data cluster TestAruba: javax.ejb.TransactionRolledbackLocalException: Could not create storage 'TestAruba' with data model 'TestAruba'.;
: Could not create storage 'TestAruba' with data model 'TestAruba'.
: Could not create storage 'TestAruba' with data model 'TestAruba'.
: Can not use view 'Browse_items_PartyModel' with data model 'TestAruba': Field 'ID' is not a FK field.
: Field 'ID' is not a FK field.; nested exception is: com.amalto.core.util.XtentisException: Unable to physically create the data cluster TestAruba: javax.ejb.TransactionRolledbackLocalException: Could not create storage '

To see the whole post, download it here
OriginalPost.pdf

Re: [resolved] Having trouble creating data container

Anonymous — Wed, 05 Feb 2014 19:52:21 GMT

I think the following error:

: Can not use view 'Browse_items_PartyModel' with data model 'TestAruba': Field 'ID' is not a FK field.

Is the cause of your issue. Take a look at the view you defined for entity PartyModel. If you have a Join clause to another entity, please make sure you picked a FK as left part of the join.

Re: [resolved] Having trouble creating data container

Anonymous — Wed, 04 Jun 2014 16:00:50 GMT

Hello,
I was trying to create a data model, a data container and a data view, and while trying to deploy them on server, I had the same error "unable to physically create the date cluster <PRODUCT>: could not create storage".
A reply to a similar post ( https://jira.talendforge.org/browse/TMDM-4484) gave me an idea, and IT WORKED!
Although it may seem absurd, but to avoid error, you have to follow this order:
1-right-click Data Model, and create a category, example: Product
2-under category Product, create the data model Product. add some elements to it.
3-go to Data Container and do the same thing: create a category Product, then inside it, a new data container with same name
4-creating a view: go to Data Model Entity, right-click on Product ---> "Generate default browse items view"
DEPLOYING ON SERVER:
Now, we will deploy each element on server, in the following order:
5-right-click the newly created view -->deploy to server
6-now deploy the Data Model: Product
7-finally, deploy the Data Container : Product
This is how the 3 deployments worked error-free for me!
Best regards,
Amin ELMASRI

Re: [resolved] Having trouble creating data container

Anonymous — Mon, 09 Jun 2014 06:58:18 GMT

Thanks Amin. However, if:
1- in the MDM repository view you select both data model(s) *and* data container(s) (hold the ctrl key).
2- right click
3- click on "deploy to server..."
4- select your MDM server
... the MDM studio will deploy all the selected items in the correct order.
A quick (but rather technical) explanation on why data model needs to be present before the data container can be created: the database schema is created based on the data model's content (i.e. a entity "Address" leads to a table named "ADDRESS"), thus data model needs to be present server-side before the container can be created.
But since this is a bit too technical (and not very user friendly), the MDM studio (starting from 5.2) deploys selected items in the correct order.