I've already created the link under "/" but it doesn't work yet.
Maybe there are some other errors, I've attached DataConnect logs that aren't empties, and DataConnect configuration file.
At the moment we've got:
We 've on the same VMware Centos 7 station Analytics server and Thingworx composer and DataConnect (MED-61147-CD-520_F000_ThingWorx-Machine-Learning-52-0-dataconnect.rpm).
Where are the mistakes?
Thank you for support.
Thank you for all the details, they are quite useful indeed.
The additional challenge that you have got here is that you have deployed ThingWorx Analytics and DataConnect on the same machine.
I will need some additional info to see if we can move forward with this setup.
Could you please send me:
- the output of ls -l <Tomcat>/webapps (possibly ls -l /usr/share/tomcat/webapps )
- a screenshot of SYSTEM > Subsystems > PlatformSubsystem: showing the ThingWorx DataConnect URL Path
Attached there are the additional information requests.
In the output of http://localhost:8080/twxml-connect/about/versioninfo there is a response error like you will see in the attach.
Thank you so much!
ok, so because you have deployed ThingWorx Analytics and DataConnect on the same machine, the URI to access DataConnect is not the default http://<host>:<port>/1.0 but http://<host>:<port>/twxml-connect/1.0 .
So you will need to update the URI pointing to DataConnect with this information under SYSTEM > Subsystems > PlatformSubsystem: ThingWorx DataConnect URL Path.
Also in dataconnect.conf, the property dataconnect.transfer.uri should point to a directory (that you can create somewhere on your disk), not the zip file as you have it now. See How to use DataConnect when sending property values from the ThingWorx platform to ThingWorx Analyti... for an example of a setting for this property. (under DataConnect configuration)
After those changes you will need to restart Tomcat.
I've changed configuration file and ThingWorx DataConnect URL Path.
Now dataconnect-rest.log file is populates too, I've attached it.
Inside it there is an error "
2017-03-20T11:55:36.720Z [ERROR] [http-bio-8080-exec-10] [com.coldlight.dataconnect.rest.exception.HttpExceptionResolver] - [[1596f8ed-4338-460d-8ce9-090add31090c] Unknown error: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection]
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection" and "Wrong user name or password [28000-190]".
At which username and password it refers to? H2 password or APP KEY?
Thank you for the fast support.
It is complaining abut the database access.
I did notice that you have got
I was assuming you remove the values for security purpose, but just want to make sure, you do need to have values here, the property should not be left without values. You can use any username and password, it will be created at runtime.
Can you please confirm you have got some values there ?
Hi Christophe ... IT WORKS !!!
Thank you for support and very precious informations!
I had deleted username and password from database credentials, this was a(nother) mistake.
Furthermore, I've select a correct day-hour-minutes like below
and I've got on Thingworx Analytics Builder
Thank's a lot
I have the same problem,my Thingworx and Dataconnect are not on the same machine, I have created a shared file. But the runtime still reported an error.
I added an attachment.
We look forward to your reply, thank you!
Could you please open a new thread ?
It will help dissociate the different issues and help others to find answers in the future.
This thread is already very long and did cover several issues so it is difficult to follow.
If the information in it do not help you to fix your issue, then please open a new thread and we will take it from there.