Skip to main content
H
htran-2115-Moonstone
15-Moonstone
August 5, 2019
Solved

Data store integrity violation error occurred when create a thing

  • August 5, 2019
  • 3 replies
  • 2328 views

Hi,

 

What is going on? Other things are created successfully, except THING_120573

 

JavaException: java.lang.Exception: Unable to create thing: THING_120573 : [1,002] Data store integrity violation error: [Error occurred while accessing the model provider.]

 

Any help would be greatly appreciated.

 

Remarks, SpotlightSearch returns nothing, GetGhostEntities returns an empty array, however thing_model table contains a row with that name.

 

My Bests,

Hung Tran

Best answer by cmorfin

Hi @htran-21 

 

Thank you for the details.

It appears then that you isolated why you are getting the persistence violation error.

There is trace of that Thing inside the database and so a new one with same name cannot be created.

 

It appears that they has been some kind of corruption here.

I would advise to open a case to Technical Support to ensure this is cleared in a safe way.

 

Kind regards

Christophe

 

3 replies

C
cmorfin19-TanzaniteAnswer
19-Tanzanite
August 6, 2019

Hi @htran-21 

 

Thank you for the details.

It appears then that you isolated why you are getting the persistence violation error.

There is trace of that Thing inside the database and so a new one with same name cannot be created.

 

It appears that they has been some kind of corruption here.

I would advise to open a case to Technical Support to ensure this is cleared in a safe way.

 

Kind regards

Christophe

 

Ascherer17
Ascherer1716-Pearl
16-Pearl
June 10, 2026

I’ve had this issue as well although today my issue was with a Thing Shape.  Usually restarting the platform seems to clear things up, but otherwise running “DeleteGhostEntities” in PlatformSubsystem and deleting the relevant row in the “<collection>_model” table (thing_model in your example) often helps.  It doesn’t hurt to back up the table first, especially if you’re dealing with a production system.

N
nmutter16-Pearl
16-Pearl
June 15, 2026

you have a zombie entity :) Restarting TWX will show you the thing in Composer.

  • Ghost Entity: The Entities exist in ThingWorx memory but not in the database
    • happens at exception in services which use Create<Entity>
  • Zombie Entity: The Entities are deleted from ThingWorx memory but still exist in the database
    • happens at exception in services which use Delete<Entity>

check article https://www.ptc.com/en/support/article/CS336004?&as=1 regarding Zombie Entities

 

edit: huh, this was an old topic :P but guess interesting anyway with the new ZombieEntity services :)

    Ascherer17
    Ascherer1716-Pearl
    16-Pearl
    June 15, 2026

    Yes, I just learned about zombie entities and the new services in Thingworx 10.1.1 per https://support.ptc.com/help/thingworx/platform/r10.1/en/index.html#page/ThingWorx/Help/Release_Notes/Whats_New_in_ThingWorx_Platform_10_1_1_0.html. 

    In my instance, I was dealing with Thingworx 10.1.0 rather than 10.1.1.  The ‘resolve’ service might have resolved my problem.

    Terms & ConditionsAccessibility statement