---------------------------------------------------------------

Log Entry : 4/27/2024 10:15:06 AM - 
-------------------------------------------------------------
obj={"sName":"test2704","sCode":"","sAltName":"tt27","sBarcode":"","sRegNo":"2704","sInvNo":"777","iAssetType":34,"iAssetSubCategory":5,"iCompany":5,"iLocation":28,"iSupplier":422,"iProject":0,"iWarehouse":0,"iPurchaseDate":"2024-04-27","fPurchaseValue":0,"fCumDeprValue":0,"fInsuredValue":0,"fScrapValue":0,"fITDeprRate":0,"fITAccr":0,"fQty":1,"sImagePath":"","image":null,"bDepreciable":true,"iDepreciation":1,"iUnitOfUsage":1,"fLifePeriod":1,"iDateOfCommencement":"2024-04-28","iWriteOfPeriodYr":1,"iWriteOfPeriodMonth":12,"iAssetAc":0,"iAccumDeprAc":0,"iDeprPLAc":0,"iDisposalGain":0,"iDisposalLoss":0,"sModel":" ","sMake":" ","sDateYear":" ","sSection":" ","iId":0,"iUser":11}

---------------------------------------------------------------

Log Entry : 4/27/2024 1:31:09 PM - 
-------------------------------------------------------------
TransactionController
Method:PostTransIssue 
System.Data.SqlClient.SqlException (0x80131904): Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more)
   at System.Data.SqlClient.SqlDataReader.NextResult()
   at System.Data.ProviderBase.DataReaderContainer.NextResult()
   at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Sang.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters)
   at Sang.Asset.WebAPI.Controllers.TransactionController.PostTransIssue(TransIssueViewModel obj)
ClientConnectionId:4ddb5b0f-fdef-46e4-ae7c-f73c25c35967
Error Number:217,State:1,Class:16

---------------------------------------------------------------

Log Entry : 4/27/2024 1:35:09 PM - 
-------------------------------------------------------------
TransactionController
Method:PostTransIssue 
System.Data.SqlClient.SqlException (0x80131904): Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more)
   at System.Data.SqlClient.SqlDataReader.NextResult()
   at System.Data.ProviderBase.DataReaderContainer.NextResult()
   at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Sang.Asset.WebAPI.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters)
   at Sang.Asset.WebAPI.Controllers.TransactionController.PostTransIssue(TransIssueViewModel obj)
ClientConnectionId:49f76b2d-55c2-4a99-9a06-d48fdb25e182
Error Number:217,State:1,Class:16