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

Database fail after upgrade system ftom 8.2.2 to 8.4.4

_Lya_1986
5-Regular Member

Database fail after upgrade system ftom 8.2.2 to 8.4.4

Hi all,

 

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

BUT

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!

 

Ilona

 

 

2 REPLIES 2
CRArko
17-Peridot
(To:_Lya_1986)

Hello, Ilona.

 

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.

 

Thanks,

 

-- Craig A.

_Lya_1986
5-Regular Member
(To:CRArko)

Hello Creig,

 

Thanks for the answer, would you open a support case for me please?

I don't know where is it.

 

Thank you,

Ilona

Announcements