Skip to main content
A
aziliotto12-Amethyst
12-Amethyst
February 27, 2017
Question

Unknown error occurred. Contact the administrator if this re-occurs.

  • February 27, 2017
  • 1 reply
  • 3476 views

Hi i have this system error when trying to retrieve data from datatable or datastream:

com.thingworx.common.exceptions.DataAccessException: [2.006] Unknown error occurred. Contact the administrator if this re-occurs.

twerr.jpg

The problem is this error occurred also when navigate system menu for search things and other things.

Server spec: Dual core 2.39ghz 8gb RAM windows server 2012 r2 , THINGWORX 7.1.3 with postgressql. I noticed the cpu of my server is most of the time 99 %.

At the beginning i think it was because i used a DataTable for storage large amout of data so i changed to datastream but the datatable still exist but i don't read and write data from that datatable. Should i delete this big datatable (containing about 130k rows)? I think it is a postgres issue, can i reindex all thingworx database ?

Thanks

1 reply

S
supandey5-Regular Member
5-Regular Member
February 27, 2017

Alberto, data in PostgreSQL is indexed automatically. The error above kind of looks more like permission issue (i'm not 100% on this though), are you logged in as admin user when you get this particular error?

Since you have mentioned CPU is 99% most of the time, how many cores do you have on that machine? Is that a VM? Did you check which process is utilizing that much CPU? You might also want to check the catalina.out and the application log for ThingWorx for more detail on this.

A
aziliotto12-AmethystAuthor
12-Amethyst
February 27, 2017

Yes i am logged in as administrator i'm working with this user since 6 monhts so i don't think is permission issue.

I installed postgres and thingworx on the same Virtual Machine in a server with 2 virtual cores. Now i restarted the VM and seems to be ok but i did it some days ago so i think in a few days i will have the same issue. The process was postgressql

Terms & ConditionsAccessibility statement