2023-11-10 11:35:36 [::1][18967][8g1ohct18acn5go3s27dh0f0tb][error][yii\db\Exception] PDOException: SQLSTATE[22018]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'H2' to data type int. in D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\db\Command.php:1320 Stack trace: #0 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\db\Command.php(1320): PDOStatement->execute() #1 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 D:\xampp\htdocs\YASASVI\frontend\modules\Answersheet\controllers\AnswersheetController.php(69): yii\db\Command->queryAll() #4 [internal function]: app\modules\Answersheet\controllers\AnswersheetController->actionCandidateChallenge() #5 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #6 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #7 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('candidate-chall...', Array) #8 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('Answersheet/ans...', Array) #9 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #10 D:\xampp\htdocs\YASASVI\frontend\web\index.php(18): yii\base\Application->run() #11 {main} Next yii\db\Exception: SQLSTATE[22018]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'H2' to data type int. The SQL being executed was: exec getCommonDataSP '*', 'WHERE IsActive=1 and QuestionSet=2', 'QuestionChallangesMst', 'order by QuestionNumber asc' in D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\db\Schema.php:676 Stack trace: #0 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\db\Command.php(1325): yii\db\Schema->convertException(Object(PDOException), 'exec getCommonD...') #1 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\db\Command.php(1186): yii\db\Command->internalExecute('exec getCommonD...') #2 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\db\Command.php(417): yii\db\Command->queryInternal('fetchAll', NULL) #3 D:\xampp\htdocs\YASASVI\frontend\modules\Answersheet\controllers\AnswersheetController.php(69): yii\db\Command->queryAll() #4 [internal function]: app\modules\Answersheet\controllers\AnswersheetController->actionCandidateChallenge() #5 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #6 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #7 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('candidate-chall...', Array) #8 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('Answersheet/ans...', Array) #9 D:\xampp\htdocs\YASASVI\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #10 D:\xampp\htdocs\YASASVI\frontend\web\index.php(18): yii\base\Application->run() #11 {main} Additional Information: Array ( [0] => 22018 [1] => 245 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'H2' to data type int. )