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

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Database fail after upgrade system ftom 8.2.2 to 8.4.4

_Lya_1986
10-Marble

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.

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


Top Tags