REF_EXECUTE_NON_QUERY
|
Procedure or function 'RECORD_LINKER_RESULT' expects parameter '@PARAM_REC_LINKER_CODE_INTERNAL', which was not supplied.
|
18:03:16.4678640
|
0.000
Path
|
F:\VB Projects\NETLibrary\Modules\References\SQL\MSSQL\Server\REF_SQL_EXECUTES.vb [Line : 97]
|
18:03:16.4795679
|
0.012
VAR_REPORT_ERROR
|
STACK TRACE (2) : CUS_TRANSACTION_RESULT
|
18:03:16.4795679
|
0.001
VAR_REPORT_ERROR
|
STACK TRACE (3) : CUS_TRANSACTION_RESULT
|
18:03:16.4805707
|
0.001
VAR_REPORT_ERROR
|
STACK TRACE (4) : _Lambda$__1
|
18:03:16.4805707
|
0.000
VAR_REPORT_ERROR
|
STACK TRACE (5) : _Lambda$__15
|
18:03:16.4805707
|
0.000
VAR_REPORT_ERROR
|
FULL DETAILS:
System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'RECORD_LINKER_RESULT' expects parameter '@PARAM_REC_LINKER_CODE_INTERNAL', which was not supplied.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at NETLIB.NETCLASS.NETRC._SQL.REF_EXECUTE_NON_QUERY(SqlCommand SQL_COMMAND, SqlParameterCollection SQL_PARAM, Int32 RETRY_ATTEMPT, Boolean AUTO_RETRY, Boolean ALLOW_RETRY, Boolean RAISE_ERROR) in F:\VB Projects\NETLibrary\Modules\References\SQL\MSSQL\Server\REF_SQL_EXECUTES.vb:line 57
ClientConnectionId:8296af38-1558-4c88-b149-1dc8c893c0cb
Error Number:201,State:4,Class:16
|
18:03:16.4829756
|
0.002

SQLCommand Details
|
Properties
|
18:03:16.4839744
|
0.000
SQL_COMMAND.CommandType
|
CommandType.StoredProcedure : StoredProcedure
|
18:03:16.4839744
|
0.001
SQL_COMMAND.CommandText
|
RECORD_LINKER_RESULT
|
18:03:16.4839744
|
0.000
SQL_COMMAND.Connection.ConnectionString
|
Data Source=192.168.1.200\PeakSQL;Initial Catalog=Peak;Integrated Security=False;User Id=sa;encrypt=true;trustServerCertificate=true;
|
18:03:16.4839744
|
0.000
SQL_COMMAND.ConnectionState
|
ConnectionState.Open : 1
|
18:03:16.4849715
|
0.001
SQL_COMMAND.Connection.ServerVersion
|
12.00.2000
|
18:03:16.4849715
|
0.000
SQL_COMMAND.Transaction
|
OFF
|
18:03:16.4849715
|
0.000

SQLCommand Details
|
Parameters [Total: 6]
|
18:03:16.4859689
|
0.001
@PARAM_REC_LINKER_ID
|
Value : [ 1 ]
DbType : [SqlDbType.BigInt : 0], Direction : [ParameterDirection.Input : Input]
Size : [-1], Precision: [0], Scale : [0]
|
18:03:16.4879636
|
0.001
@PARAM_REC_LINKER_JSON_RES
|
Value : [ {"data":{"order":{"referenceId":"TXN55XDGYH1PPYHSPSGP","orderId":"2208000028","traceNo":"REF-TXN55XDGYH1PPYHSPSGP","source":"dsa","paymentMethod":"cash","status":"FULFILLED","totalPrice":9.5,"productSku":"GLOBE10","transactionId":"TXN55XDGYH1PPYHSPSGP","epin":null,"expiry":null,"debitedAmount":9.5},"product":{"sku":"GLOBE10","name":"Globe AutoloadMax 10","type":"LOAD","fulfillmentType":{"id":"533dac40-9d8e-484f-a6de-3317ac0b6518","name":"FULFILLMENT","description":null},"price":10,"discountedPrice":9.5,"sellingPrice":10},"balance":{"availableBalance":9798.5,"endBalance":9798.5,"autorefund":true}},"message":"Success!"} ]
DbType : [SqlDbType.NVarChar : 12], Direction : [ParameterDirection.Input : Input]
Size : [2000], Precision: [0], Scale : [0]
|
18:03:16.4879636
|
0.001
@PARAM_REC_LINKER_SYNC_RES
|
Value : [ ]
DbType : [SqlDbType.NVarChar : 12], Direction : [ParameterDirection.Input : Input]
Size : [2000], Precision: [0], Scale : [0]
|
18:03:16.4879636
|
0.000
@PARAM_REC_LINKER_PRICE_TOTAL
|
Value : [ 10 ]
DbType : [SqlDbType.Decimal : 5], Direction : [ParameterDirection.Input : Input]
Size : [-1], Precision: [18], Scale : [2]
|
18:03:16.4879636
|
0.000
@PARAM_REC_LINKER_PRICE_DEBIT
|
Value : [ 9.9 ]
DbType : [SqlDbType.Decimal : 5], Direction : [ParameterDirection.Input : Input]
Size : [-1], Precision: [18], Scale : [2]
|
18:03:16.4889614
|
0.001
@PARAM_REC_LINKER_WALLET_BALANCE
|
Value : [ 901 ]
DbType : [SqlDbType.Decimal : 5], Direction : [ParameterDirection.Input : Input]
Size : [-1], Precision: [18], Scale : [2]
|
18:03:16.4889614
|
0.000