system.data.SQLite.SQLiteException(0x800007BF) SQL logic error

Question

system.data.SQLite.SQLiteException(0x800007BF) SQL logic error

Dineshkumar.S 456

IN my windows application developed in C# having an issue with some of the users with that error as below

so after this error i found that one of the table in the users db is missing from the actual live db so because of this it is showing the error so how can we find the issue why the table is not getting synced to the user's db and how to dix it can anyone suggest me any ideas ??

Jack J Jun 25,306 Reputation points

2023-02-06T07:12:00.6166667+00:00

@Dineshkumar.S, Welcome to Microsoft Q&A, could you provide some steps or some code about your problem? It will be better for me to analyze your problem.
Dineshkumar.S 456 Reputation points

2023-02-06T07:19:02.8566667+00:00

I am checking the data schema sync now so I am not sure about the code so I will tell you the steps in syncing
Db contains the list of table in that when the user opens the app and sync it with the live server it should sync the newly added data and tables from the live to their local but in some of the user cases it is not syncing the newly created table and because of that it is showing that particular error.

Once I am sure about the code I will share the code samples. Thanks in advance
Jack J Jun 25,306 Reputation points

2023-02-06T07:34:46.68+00:00

@Dineshkumar.S , you could add try-catch sentence to check if which row throws the exception or you could set the breakpoint in your app. After checking it, maybe you will find the related code and provide it. BTW, based on my search, the error often occurs when you use the sql query in c#.

Dineshkumar.S 456

Hey hi as you said i checked the issue it is because my schema is not updating i will provide the code and let me know any issue why it is not updating the latest schema

 static void CheckDbCompat()
        {
            EYE.Client.EyeApiAdapter api = new EYE.Client.EyeApiAdapter();
            string mainPath = Path.Combine(api.GetSqliteDataDir(), EYE.Model.DbCM.GetSqliteEyeMainFileName());

            if (File.Exists(mainPath))
            {
                string strSchemaVersion = DbCM.GetVar("dbSchemaVersion", "");
                if (!Int32.TryParse(strSchemaVersion, out int nSchemaVersion))
                {
                    nSchemaVersion = 106;
                }
                if (nSchemaVersion < 107)  //major change so Start Over
                {
                    BaseUtil.WriteToAppConfig("BootstrapState", "");
                }
            }
            
        }

Jack J Jun 25,306 Reputation points

2023-02-10T07:54:43.8733333+00:00

@Dineshkumar.S, thanks for the feedback, just with the above code, it is hard to know where the problem is. It seems that there are many custom classes, and I could not use them. Based on your error, I suggest that you could try to find the related code about your sql query. According to my search, it is often related to sql query.