2025-09-25 09:57:46.949 +05:30 6410ee50-163f-432e-a8c1-57f927d9b86f ERR  Error occurred while excecuting procedure:ssp_t_Quotation_GS: System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@channnelid".
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location ---
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
ClientConnectionId:e29412ac-ad8e-47ee-b9ac-fd50d67b2206
Error Number:137,State:2,Class:15
2025-09-25 09:57:46.964 +05:30 6410ee50-163f-432e-a8c1-57f927d9b86f ERR  Must declare the scalar variable "@channnelid".
2025-09-25 09:57:46.971 +05:30 6410ee50-163f-432e-a8c1-57f927d9b86f ERR  Error Getting TransactionListQuotation from database System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@channnelid".
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location ---
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Quantum.Api.Repositories.TransactionRepository.GetTransactionSummary(DocType docType, Int32 be, Nullable`1 type)
   at Sang.Quantum.Api.Services.TransactionService.<>c__DisplayClass12_0.<<GetTransactionSummary>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String searchString)
ClientConnectionId:e29412ac-ad8e-47ee-b9ac-fd50d67b2206
Error Number:137,State:2,Class:15
2025-09-25 09:57:46.974 +05:30 6410ee50-163f-432e-a8c1-57f927d9b86f ERR  SQL Exception occurred System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@channnelid".
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location ---
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Quantum.Api.Repositories.TransactionRepository.GetTransactionSummary(DocType docType, Int32 be, Nullable`1 type)
   at Sang.Quantum.Api.Services.TransactionService.<>c__DisplayClass12_0.<<GetTransactionSummary>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String searchString)
   at Sang.Quantum.Api.Services.TransactionService.GetTransactionSummary(SummaryRequest summaryRequest)
   at Sang.Quantum.Api.Controllers.TransactionController.GetTransactionSummary(SummaryRequest summaryRequest)
ClientConnectionId:e29412ac-ad8e-47ee-b9ac-fd50d67b2206
Error Number:137,State:2,Class:15
2025-09-25 09:59:46.238 +05:30 d3a4a24b-7abe-4755-bef9-c86e79abbcde ERR  Error occurred while excecuting procedure:ssp_t_Quotation_GS: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'AS'.
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location ---
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
ClientConnectionId:5ed2d32e-b208-4529-8c26-e789fc32c58d
Error Number:156,State:1,Class:15
2025-09-25 09:59:46.238 +05:30 d3a4a24b-7abe-4755-bef9-c86e79abbcde ERR  Incorrect syntax near the keyword 'AS'.
2025-09-25 09:59:46.240 +05:30 d3a4a24b-7abe-4755-bef9-c86e79abbcde ERR  Error Getting TransactionListQuotation from database System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'AS'.
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location ---
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Quantum.Api.Repositories.TransactionRepository.GetTransactionSummary(DocType docType, Int32 be, Nullable`1 type)
   at Sang.Quantum.Api.Services.TransactionService.<>c__DisplayClass12_0.<<GetTransactionSummary>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String searchString)
ClientConnectionId:5ed2d32e-b208-4529-8c26-e789fc32c58d
Error Number:156,State:1,Class:15
2025-09-25 09:59:46.242 +05:30 d3a4a24b-7abe-4755-bef9-c86e79abbcde ERR  SQL Exception occurred System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'AS'.
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader()
   at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location ---
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters)
   at Sang.Quantum.Api.Repositories.TransactionRepository.GetTransactionSummary(DocType docType, Int32 be, Nullable`1 type)
   at Sang.Quantum.Api.Services.TransactionService.<>c__DisplayClass12_0.<<GetTransactionSummary>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, String searchString)
   at Sang.Quantum.Api.Services.TransactionService.GetTransactionSummary(SummaryRequest summaryRequest)
   at Sang.Quantum.Api.Controllers.TransactionController.GetTransactionSummary(SummaryRequest summaryRequest)
ClientConnectionId:5ed2d32e-b208-4529-8c26-e789fc32c58d
Error Number:156,State:1,Class:15
2025-09-25 10:01:45.260 +05:30 7e74fc60-8db4-4146-bce1-9bfe26682c7b ERR  Token Regeneration failed Microsoft.IdentityModel.Tokens.SecurityTokenMalformedException: IDX12741: JWT must have three segments (JWS) or five segments (JWE).
   at Sang.Service.Common.Validators.TokenValidator.ValidateToken(String token, String TokenKey)
   at Sang.Service.Common.Authentication.TokenService.RegenerateTokens(String refershToken)
   at Sang.Quantum.Api.Controllers.LoginController.RegenerateTokens(String refreshToken)
2025-09-25 13:49:49.096 +05:30 c09de270-b0a0-4bdf-a11b-e3518398a121 ERR  {
  "ProxyApiError": {
    "ErrorMessage": "{\"status\":\"Failure\",\"statusCode\":4000,\"message\":\"Api Validation error\",\"result\":\"[{\\\"PropertyName\\\":\\\"SendMail[0].Subject\\\",\\\"ErrorMessage\\\":\\\"Subject required.\\\"}]\"}",
    "StatusCode": 400,
    "RequestMethod": {
      "Method": "POST"
    },
    "RequestUri": "http://localhost:5501/Mail/SendMail",
    "CorrelationId": null
  }
}
2025-09-25 14:14:13.939 +05:30 331375cc-632d-4834-9a2d-60fba7b25420 ERR  {
  "ProxyApiError": {
    "ErrorMessage": "{\"status\":\"Failure\",\"statusCode\":4000,\"message\":\"Api Validation error\",\"result\":\"[{\\\"PropertyName\\\":\\\"SendMail[0].Subject\\\",\\\"ErrorMessage\\\":\\\"Subject required.\\\"}]\"}",
    "StatusCode": 400,
    "RequestMethod": {
      "Method": "POST"
    },
    "RequestUri": "http://localhost:5501/Mail/SendMail",
    "CorrelationId": null
  }
}
2025-09-25 14:33:42.450 +05:30 411b4ae3-cf1e-43ca-8e52-f87db8d61398 ERR  {
  "ProxyApiError": {
    "ErrorMessage": "{\"status\":\"Failure\",\"statusCode\":4000,\"message\":\"Api Validation error\",\"result\":\"[{\\\"PropertyName\\\":\\\"SendMail[0].Subject\\\",\\\"ErrorMessage\\\":\\\"Subject required.\\\"}]\"}",
    "StatusCode": 400,
    "RequestMethod": {
      "Method": "POST"
    },
    "RequestUri": "http://localhost:5501/Mail/SendMail",
    "CorrelationId": null
  }
}
2025-09-25 14:41:28.159 +05:30 4e10bc51-716e-49d9-9c7e-a4eb4266c5f5 ERR  {
  "ProxyApiError": {
    "ErrorMessage": "{\"status\":\"Failure\",\"statusCode\":4000,\"message\":\"Api Validation error\",\"result\":\"[{\\\"PropertyName\\\":\\\"SendMail[0].Subject\\\",\\\"ErrorMessage\\\":\\\"Subject required.\\\"}]\"}",
    "StatusCode": 400,
    "RequestMethod": {
      "Method": "POST"
    },
    "RequestUri": "http://localhost:5501/Mail/SendMail",
    "CorrelationId": null
  }
}
2025-09-25 14:53:38.335 +05:30 8772ad35-b1c7-46df-be8d-b5e0e6de4bcf ERR  {
  "ProxyApiError": {
    "ErrorMessage": "{\"status\":\"Failure\",\"statusCode\":4000,\"message\":\"Api Validation error\",\"result\":\"[{\\\"PropertyName\\\":\\\"SendMail[0].Subject\\\",\\\"ErrorMessage\\\":\\\"Subject required.\\\"}]\"}",
    "StatusCode": 400,
    "RequestMethod": {
      "Method": "POST"
    },
    "RequestUri": "http://localhost:5501/Mail/SendMail",
    "CorrelationId": null
  }
}