Time Stamp: 08/07/2023 04:08:14 PM
Exception Type: Error
Message: Input string was not in a correct format.
Source: mscorlib
Target Site: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)
Stack Trace:    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at System.String.System.IConvertible.ToInt32(IFormatProvider provider)
   at System.Convert.ToInt32(Object value)
   at CommonFunctions.getIntValue(Object objTest) in e:\WebSites\PanaSonicDev\Site\App_Code\CommonFunctions.cs:line 1667
=======================================================================


Time Stamp: 08/07/2023 04:10:36 PM
Exception Type: Error
Message: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Source: mscorlib
Target Site: Void ThrowArgumentOutOfRangeException(System.ExceptionArgument, System.ExceptionResource)
Stack Trace:    at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at pages_AssignSurveyNewV2.BindUserSurveyDetails(Int32 SurveyId) in e:\WebSites\PanaSonicDev\Site\Pages\AssignSurveyNewV2.aspx.cs:line 290
=======================================================================


Time Stamp: 08/07/2023 04:17:56 PM
Exception Type: Error
Message: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Source: mscorlib
Target Site: Void ThrowArgumentOutOfRangeException(System.ExceptionArgument, System.ExceptionResource)
Stack Trace:    at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at pages_AssignSurveyNewV2.BindUserSurveyDetails(Int32 SurveyId) in e:\WebSites\PanaSonicDev\Site\Pages\AssignSurveyNewV2.aspx.cs:line 290
=======================================================================


Time Stamp: 08/07/2023 06:29:27 PM
Exception Type: Error
Message: SQLite error
table tblRoute has no column named EInvoice_DeviceId
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 e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 16127
   at SFAServices.CreateSqliteDatabase.InsertRoute(IList`1 Routes, SQLiteConnection connection) in e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 3515
=======================================================================


Time Stamp: 08/07/2023 06:29:27 PM
Exception Type: Error
Message: SQLite error
table tblCustomer has no column named Address_AdditionalStreet_Arabic
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 e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 16127
   at SFAServices.CreateSqliteDatabase.InsertCustomers(IList`1 objCustomerSiteMasters, SQLiteConnection connection) in e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 7282
=======================================================================


Time Stamp: 08/07/2023 06:29:27 PM
Exception Type: Error
Message: SQLite error
near "a": 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 e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 16127
   at SFAServices.CreateSqliteDatabase.InsertAssets(IList`1 Assets, SQLiteConnection connection) in e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 9411
=======================================================================


Time Stamp: 08/07/2023 06:29: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 e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 16127
   at SFAServices.CreateSqliteDatabase.InsertAssetTypes(IList`1 AssetTypes, SQLiteConnection connection) in e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 9498
=======================================================================


Time Stamp: 08/07/2023 06:29:27 PM
Exception Type: Error
Message: SQLite error
table tblCustomerPlanogramParentSKUShare has no column named Id
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 e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 16127
   at SFAServices.CreateSqliteDatabase.InsertCustomerPlanogramParentSKUShare(IList`1 lstCustomerPlanogramParentSKUShare, SQLiteConnection connection) in e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 11203
=======================================================================


Time Stamp: 08/07/2023 06:29: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 e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 16127
   at SFAServices.CreateSqliteDatabase.InsertCompetitor(IList`1 Competitors, SQLiteConnection connection) in e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 14153
=======================================================================


Time Stamp: 08/07/2023 06:29:27 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 e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 16127
   at SFAServices.CreateSqliteDatabase.InsertClearTaxConfig(IList`1 lstClearTaxConfigs, SQLiteConnection connection) in e:\WebSites\PanaSonicDev\Site\App_Code\CreateSqliteDatabase.cs:line 19867
=======================================================================