Time Stamp: 08/01/2023 05:35:27 PM
Exception Type: Error
Message: SQLite error
table tblAssetType has no column named AssetType
Source: System.Data.SQLite
Target Site: System.Data.SQLite.SQLiteStatement Prepare(System.Data.SQLite.SQLiteConnection, System.String, System.Data.SQLite.SQLiteStatement, UInt32, System.String ByRef)
Stack Trace:    at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at SFAServices.CreateSqliteDatabase.InsertDataRow(String CommandText, SQLiteConnection connection) in f:\WebSites\Arla-Dev-Vansales\Site\App_Code\CreateSqliteDatabase.cs:line 16092
   at SFAServices.CreateSqliteDatabase.InsertAssetTypes(IList`1 AssetTypes, SQLiteConnection connection) in f:\WebSites\Arla-Dev-Vansales\Site\App_Code\CreateSqliteDatabase.cs:line 9463
=======================================================================


Time Stamp: 08/01/2023 05:35:27 PM
Exception Type: Error
Message: SQLite error
near "the": syntax error
Source: System.Data.SQLite
Target Site: System.Data.SQLite.SQLiteStatement Prepare(System.Data.SQLite.SQLiteConnection, System.String, System.Data.SQLite.SQLiteStatement, UInt32, System.String ByRef)
Stack Trace:    at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at SFAServices.CreateSqliteDatabase.InsertDataRow(String CommandText, SQLiteConnection connection) in f:\WebSites\Arla-Dev-Vansales\Site\App_Code\CreateSqliteDatabase.cs:line 16092
   at SFAServices.CreateSqliteDatabase.InsertCompetitor(IList`1 Competitors, SQLiteConnection connection) in f:\WebSites\Arla-Dev-Vansales\Site\App_Code\CreateSqliteDatabase.cs:line 14118
=======================================================================


Time Stamp: 08/01/2023 05:35:29 PM
Exception Type: Error
Message: SQLite error
no such table: tblPaymentTerm
Source: System.Data.SQLite
Target Site: System.Data.SQLite.SQLiteStatement Prepare(System.Data.SQLite.SQLiteConnection, System.String, System.Data.SQLite.SQLiteStatement, UInt32, System.String ByRef)
Stack Trace:    at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at SFAServices.CreateSqliteDatabase.InsertDataRow(String CommandText, SQLiteConnection connection) in f:\WebSites\Arla-Dev-Vansales\Site\App_Code\CreateSqliteDatabase.cs:line 16092
   at SFAServices.CreateSqliteDatabase.InsertPaymentTerms(IList`1 lstPaymentTerms, SQLiteConnection connection) in f:\WebSites\Arla-Dev-Vansales\Site\App_Code\CreateSqliteDatabase.cs:line 19557
=======================================================================


Time Stamp: 08/01/2023 05:35:29 PM
Exception Type: Error
Message: SQLite error
no such table: tblClearTaxConfig
Source: System.Data.SQLite
Target Site: System.Data.SQLite.SQLiteStatement Prepare(System.Data.SQLite.SQLiteConnection, System.String, System.Data.SQLite.SQLiteStatement, UInt32, System.String ByRef)
Stack Trace:    at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at SFAServices.CreateSqliteDatabase.InsertDataRow(String CommandText, SQLiteConnection connection) in f:\WebSites\Arla-Dev-Vansales\Site\App_Code\CreateSqliteDatabase.cs:line 16092
   at SFAServices.CreateSqliteDatabase.InsertClearTaxConfig(IList`1 lstClearTaxConfigs, SQLiteConnection connection) in f:\WebSites\Arla-Dev-Vansales\Site\App_Code\CreateSqliteDatabase.cs:line 19823
=======================================================================