SQL and Citect SCADA indexing Problem

Hey guys,

I have been trying to store and retrieve data to an from SQL database using Citect SCADA 2018. Pushing data and retrieving worked fine for a while and suddenly the project wont compile saying the file italian.dbf file in the source directory is not indexed. if we delete the file then the compilation error would read korean.dbf not indexed. since not compiling i cant run the project anymore and stuck at this point. i have a single table in sql with single primary key and 4 columns.

attaching the error schreenshot. Please look into and provide viable solutions.

P.S. the attached sql database diag originally had the marked column as primary key and automatically generated clustered index before i dropped them.
 

Attachments

Hey guys,

I have been trying to store and retrieve data to an from SQL database using Citect SCADA 2018. Pushing data and retrieving worked fine for a while and suddenly the project wont compile saying the file italian.dbf file in the source directory is not indexed. if we delete the file then the compilation error would read korean.dbf not indexed. since not compiling i cant run the project anymore and stuck at this point. i have a single table in sql with single primary key and 4 columns.

attaching the error schreenshot. Please look into and provide viable solutions.

P.S. the attached sql database diag originally had the marked column as primary key and automatically generated clustered index before i dropped them.
Hey ClinKv

Ther description of the error message that you shared is following:

[TD]F4019[/TD]

[TD]File not indexed[/TD]

[TD]The database needs to be indexed, but the index file associated with the database cannot be found. Pack the database.[/TD]​

You should " pack the database"
So let check on Schneider citect application how to " pack the database".

Hope this can help
Controls Guy25.
 
Top