2025-05-07 18:07:50: ERROR DETAILSarray(4) { ["type"]=> int(1) ["message"]=> string(1024) "Uncaught PDOException: SQLSTATE[23000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'S_ID', table 'AIPM_CPABN.dbo.DailyYieldAdjustment'; column does not allow nulls. INSERT fails. in D:\Apps\AIPM-CP2\BN\_base\PhpHelpers\DB.php:646 Stack trace: #0 D:\Apps\AIPM-CP2\BN\_base\PhpHelpers\DB.php(646): PDOStatement->execute() #1 D:\Apps\AIPM-CP2\BN\_base\PhpHelpers\DB.php(471): Helpers\DB::insert('DailyYieldAdjus...', 'DYA_ID', Array, NULL, NULL, NULL, true, '') #2 D:\Apps\AIPM-CP2\BN\Screens\Admin\EnergyYields\DailyYieldAdjustment_Edit.pxp(28): Helpers\DB::insertUpdate('DailyYieldAdjus...', 'DYA_ID', Array) #3 [internal function]: DataService\insertUpdateOverrideAdjustment(Array) #4 D:\Apps\AIPM-CP2\BN\_base\ServiceBase\DataService.php(66): call_user_func('DataService\\ins...', Array) #5 [internal function]: unknown() #6 D:\Apps\AIPM-CP2\BN\_base\ServiceBase\DataService.php(2): sg_load('639086E74756B02...') #7 D:\Apps\AIPM-CP2\BN\Screens\Admin\EnergyYields\DailyYie" ["file"]=> string(43) "D:\Apps\AIPM-CP2\BN\_base\PhpHelpers\DB.php" ["line"]=> int(668) }


REQUEST
array(2) { ["sFunctionName"]=> string(30) "insertUpdateOverrideAdjustment" ["oData"]=> string(169) "{"DYA_ID":null,"S_ID":null,"DYA_Date":null,"DYA_kWhTotal":65.61,"DYA_kWhOffPeak":0,"DYA_kWhHoliday":65.61,"DYA_IsDim":false,"DYA_RecordedOn":null,"SU_IDRecordedBY":null}" }
COOKIES
array(6) { ["PHPSESSID"]=> string(26) "h6ui8mgrnp799e65k62u8trvrp" ["SU_ID"]=> string(2) "28" ["sLang"]=> string(2) "en" ["sAppVersion"]=> string(17) "2025.04.02.110028" ["iSiteSelected"]=> string(3) "513" ["sFullUrl"]=> string(85) "http://aipm-cpall2-bn.enmax.co.th/#/Screens/AnalysisReports/Devices/PowerMeters.phtml" }

################################################################################################################