2024-02-01 12:59:37 [::1][-][1mdp03jbg4091o6vhd05im08ge][error][yii\db\Exception] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Procedure or function 'sPupdateCandidateStatusAfterPayment' expects parameter '@tranasactionID', which was not supplied. in D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\db\Command.php:1320
Stack trace:
#0 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute()
#1 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\db\Command.php(1120): yii\db\Command->internalExecute('exec sPupdateCa...')
#2 D:\xampp\htdocs\AnswerKeyChallange\frontend\modules\Payment\controllers\HdfcResponseController.php(98): yii\db\Command->execute()
#3 [internal function]: app\modules\Payment\controllers\HdfcResponseController->actionPaymentResponseHdfc()
#4 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array)
#5 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array)
#6 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('payment-respons...', Array)
#7 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('Payment/hdfc-re...', Array)
#8 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request))
#9 D:\xampp\htdocs\AnswerKeyChallange\frontend\web\index.php(18): yii\base\Application->run()
#10 {main}

Next yii\db\Exception: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Procedure or function 'sPupdateCandidateStatusAfterPayment' expects parameter '@tranasactionID', which was not supplied.
The SQL being executed was: exec sPupdateCandidateStatusAfterPayment 1,'200.00'   in D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\db\Schema.php:676
Stack trace:
#0 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec sPupdateCa...')
#1 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\db\Command.php(1120): yii\db\Command->internalExecute('exec sPupdateCa...')
#2 D:\xampp\htdocs\AnswerKeyChallange\frontend\modules\Payment\controllers\HdfcResponseController.php(98): yii\db\Command->execute()
#3 [internal function]: app\modules\Payment\controllers\HdfcResponseController->actionPaymentResponseHdfc()
#4 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array)
#5 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array)
#6 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('payment-respons...', Array)
#7 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('Payment/hdfc-re...', Array)
#8 D:\xampp\htdocs\AnswerKeyChallange\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request))
#9 D:\xampp\htdocs\AnswerKeyChallange\frontend\web\index.php(18): yii\base\Application->run()
#10 {main}
Additional Information:
Array
(
    [0] => 42000
    [1] => 201
    [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Procedure or function 'sPupdateCandidateStatusAfterPayment' expects parameter '@tranasactionID', which was not supplied.
)