Question
[1,018] Data store unknown error: [Error occurred while accessing the model provider. ?
Hi ,
When creating DataTable with service dynamically, I sometimes get the error "[1,018] Data store unknown error: [Error occurred while accessing the model provider." .
var params = {
name: dataTableName,
description: "",
thingTemplateName: "DataTable",
};
Resources["EntityServices"].CreateThing(params);
Things[dataTableName].SetDataShape({ name: shapeName });
//Things[dataTableName].SetProjectName({ projectName: "ABCD" });
Things[dataTableName].EnableThing();
Things[dataTableName].RestartThing();
Things[dataTableName].SetPersistenceProvider({
name: persistentProvider
});
Resources["EntityServices"].AddShapeToThing({
name: dataTableName /* THINGNAME */,
thingShapeName: "LockableThing" /* THINGSHAPENAME */
});
Things[dataTableName].EnableThing();
Things[dataTableName].RestartThing();
And, if error occurs, I have the following exception handling to rollback:
var params = {
name: dataTableName /* THINGNAME */
};
try{
Resources["EntityServices"].DeleteThing(params);
logger.debug("Rollback data table "+dataTableName + "finished");
}catch(error2){
logger.debug("fail to rollback data table "+dataTableName + ". Error: " + error2 ); // result: INFOTABLE dataShape: "EntityReference"
var existingGhostEntities =
Resources["GhostEntitiesResource"].GetGhostEntities({
deleteGhosts: true /* BOOLEAN */
});
}
Even though, if the error "Data store unknown error" occurs then it will always occur unless restart tomcat . Any suggestion ?
Thingworx 8.4.2 + Postgresql 10.x
Regards,
Sean

