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

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

Incorrect data displaying when working ADO Service

Mr_Henry_M
14-Alexandrite

Incorrect data displaying when working ADO Service

Hello everybody!

 

Testing ADO Service, I suddenly ran into a strange problem. Even with two problems.

 

1. The first is that the mashup, which receives data from the service, which, in turn, receives data from the Excel database, for some reason stopped displaying all the changes that I make in Excel. The work of the service for obtaining data is presented below.

 

4.png

 

So, changing the value in the first line in my database, I see that the service sees this change as well (circled value 13). But in the Grid, after page updating, in the same line the value is still 15, as it was. And after reconnecting to the database and restarting the mashup too. Moreover, when replacing dates in other lines, these lines just disappear from the Grid.

 

2. I don’t know if the second problem is related to the first, but in that case the data from the Excel database isn't displayed at all. Neither in the mashup

 

3.png

 

or when testing the service (it tries to Execute for a long time, after which it reports a timeout).

 

2.png

 

Although the column headers are visible on the page for service creating, which means that a connection to the database has been established.

 

1.png

 

The difference with the first case is that the data is not written into a spreadsheet, but copied from another Excel file - where the data, in turn, was imported from several csv files. Yes, a little bit confuddling )

 

Maybe there are some special nuances of receiving data when using ADO Service, which I don't know - or it's not related to ADO at all. And, maybe, someone knows how to solve at least one of the problems )

2 REPLIES 2
slangley
23-Emerald II
(To:Mr_Henry_M)

Hi @Mr_Henry_M.

 

Have you checked the logs for errors?  Which version of ThingWorx are you running?

 

Can you provide the config file so we can review your settings?  When you run the service, how many rows of data are you expecting?

 

Is this happening with other Excel files or just this one?  This could indicate that the problem started as a result of an environmental change such as an upgrade or o/s patch, requiring you to make updates to your configuration.

 

Regards.

 

--Sharon

 

 

slangley
23-Emerald II
(To:slangley)

Hi @Mr_Henry_M.

 

Have you found a solution to your problem?  If so, please feel free to post and update on community with your solution.  If you are still having issues, please provide the config file and logs and answers to the previous questions so we can investigate.

 

Regards.

 

--Sharon

Top Tags