Data table LineFlag_PNP not found SQLite Error

Data table LineFlag_PNP not found SQLite Error

Matej_Grabnar
Explorer Explorer
197 Views
1 Reply
Message 1 of 2

Data table LineFlag_PNP not found SQLite Error

Matej_Grabnar
Explorer
Explorer

I'm getting this exception from Autodesk Plant 3D, when updating DataManager (for each DataGridViewRow) to cell.Value = DBNull.Value; 

 

System.Data.SQLite (Log): SQLite error (1): no such table: LineFlag_PNP in "select "PnPID","PnPGuid","PnPTimestamp","Flag","Line" from "LineFlag_PNP" where "Line"=@p1"

 

So the Autodesk is selecting something from LineFlag_PNP table that does not exist for each row. 

There is no Class "LineFlag" in Project Setup.

If the solution is that the LineFlag must exist, where in the P&ID Class Definitions must I put it? 

 

Matej_Grabnar_0-1762257973072.png

 

Thank you for any suggestions! 

MG

 

 

 

0 Likes
198 Views
1 Reply
Reply (1)
Message 2 of 2

Matej_Grabnar
Explorer
Explorer

Follow up: 

I added this table into SQLite in ProcessPower.dcf 

CREATE TABLE IF NOT EXISTS "LineFlag_PNP" (
    "PnPID"        INTEGER PRIMARY KEY AUTOINCREMENT,
    "PnPGuid"      TEXT NOT NULL,
    "PnPTimestamp" DATETIME DEFAULT (datetime('now')),
    "Flag"         TEXT,
    "Line"         INTEGER
);

The error stopped appearing in output window. 

 

The question still remains where in project is this "LineFlag" defined? It's not in Classes. 

0 Likes