4 Replies Latest reply on Feb 27, 2017 11:20 AM by albertoz RSS
    albertoz Explorer

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

    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