cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Thingworx Analytics: Send Data From Dataconnect To Analytics Server

SOLVED

Re: Thingworx Analytics: Send Data From Dataconnect To Analytics Server

Hi Christophe,

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:

  1. A message "I'm Alive" from http://localhost:8080/1.0 url;
  2. A message "{"implementationVersion":"52.2.0"}" from http://localhost:8080/1.0/about/versioninfo url;
  3. Under /ThingworxStorage/repository/SystemRepository we have Tractor_DAD folder:
    1.   inside it we've Tractor_DAD1489746987677.zip and 1489746987677 folder with skinny csv and payload.json;

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.

Luigi Dell'Aversano

Re: Thingworx Analytics: Send Data From Dataconnect To Analytics Server

Hi Luigi

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

- output of http://localhost:8080/twxml-connect/about/versioninfo

- output of http://localhost:8080/twxml-connect/1.0/about/versioninfo

Thank you

Kind regards

Christophe

Re: Thingworx Analytics: Send Data From Dataconnect To Analytics Server

Hi Christophe,

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!

Luigi Dell'Aversano

Re: Thingworx Analytics: Send Data From Dataconnect To Analytics Server

Hi Luigi

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.

Kind regards

Christophe

Re: Thingworx Analytics: Send Data From Dataconnect To Analytics Server

Hi Christophe,

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.


Luigi Dell'Aversano


Re: Thingworx Analytics: Send Data From Dataconnect To Analytics Server

Hi Luigi

It is complaining abut the database access.

I did notice that you have got

dataconnect.database.username=

dataconnect.database.password=

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 ?

Regards

Christophe

Re: Thingworx Analytics: Send Data From Dataconnect To Analytics Server

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

Luigi Dell'Aversano

Re: Thingworx Analytics: Send Data From Dataconnect To Analytics Server

Hi Luigi

Brilliant, I am happy it works for you

Regards

Christophe

Re: Thingworx Analytics: Send Data From Dataconnect To Analytics Server

Hi,Christophe Morfin!

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!


Kind regards

Juanjuan

Re: Thingworx Analytics: Send Data From Dataconnect To Analytics Server

Hi JuanJuan

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.

Thank you

Kind regards

Christophe