I'm Ilona from Hungary and i'm working with ThingWorx for 1 year.
I have a big problem with TWX. The cenrtal IT has upgraded the system to 8.4.4 version, and from it the included database went wrong. The upgrade was at 2019.08.27.
I tried to explain the error:
The Datashape is (attached). In the DataTable is an important field, named "TableIndex" is a #NUMBER field.
I have 145 rows.
When i run QeryDataTableEntries service I get the all 145 line. ---> OK
When i run QeryDataTableEntries service with a condition: ID=145, I get this line. ---> OK
When i run QeryDataTableEntries service with a condition: DatumBe=2019.09.09. --> I get 4 lines -->OK
When i run QeryDataTableEntries service with a condition: TableIndex=4, I get just the older lines, before the upgrade, and the new lines not.
What could be this problem? What is different between version 8.2.2 and 8.4.4??
Maybe the caracter coding? Can I set it somewhere?
Has anybody else the same problem?
I've tried the followings:
- I Used the ows AddDataTableEntries service-->same result
- I tried to change #NUMBER to #NUMBER -->nothing changed
The datashape was not changed before.
Thank You in advanced!
I'd suggest you open a support case for this. If you're unable to do so, just let me know and I'l open one for you.
-- Craig A.