2025-07-03 16:35:42: ERROR DETAILSarray(4) {
["type"]=>
int(1)
["message"]=>
string(1024) "Uncaught Exception: PDOException: SQLSTATE[07002]: [Microsoft][ODBC Driver 17 for SQL Server]COUNT field incorrect or syntax error in D:\Apps\AIPM-CP2\BN\_base\PhpHelpers\DBSSP2.php:632
Stack trace:
#0 D:\Apps\AIPM-CP2\BN\_base\PhpHelpers\DBSSP2.php(632): PDOStatement->execute()
#1 D:\Apps\AIPM-CP2\BN\_base\PhpHelpers\DBSSP2.php(337): Helpers\DB::simple2(Array, Object(PDO), '(SELECT IC_ID A...', 'IC_ID', Array, Array)
#2 D:\Apps\AIPM-CP2\BN\Screens\Admin\EnergyYields\InverterConsumptionAdjustment.pxp(38): Helpers\DB::selectGridSSP2(Array, Array, 'IC_ID', 'SELECT\r\n\tIC_ID,...')
#3 [internal function]: DataService\getGridData(Array)
#4 D:\Apps\AIPM-CP2\BN\_base\ServiceBase\DataService.php(66): call_user_func('DataService\\get...', 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\InverterConsumptionAdjustment.pxp(108): require_once('D:\\Apps\\AIPM-CP...')
#8 [internal function]: "
["file"]=>
string(47) "D:\Apps\AIPM-CP2\BN\_base\PhpHelpers\DBSSP2.php"
["line"]=>
int(357)
}
REQUEST
array(14) {
["draw"]=>
string(1) "1"
["columns"]=>
array(12) {
[0]=>
array(0) {
}
[1]=>
array(5) {
["data"]=>
string(0) ""
["name"]=>
string(11) "!responsive"
["searchable"]=>
string(5) "false"
["orderable"]=>
string(5) "false"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
}
[2]=>
array(5) {
["data"]=>
string(1) "1"
["name"]=>
string(2) "ID"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
}
[3]=>
array(5) {
["data"]=>
string(1) "2"
["name"]=>
string(5) "SI_ID"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
}
[4]=>
array(5) {
["data"]=>
string(1) "3"
["name"]=>
string(13) "Inverter Name"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
}
[5]=>
array(5) {
["data"]=>
string(1) "4"
["name"]=>
string(10) "Start Date"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
}
[6]=>
array(5) {
["data"]=>
string(1) "5"
["name"]=>
string(8) "End Date"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
}
[7]=>
array(5) {
["data"]=>
string(1) "6"
["name"]=>
string(6) "Recent"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
}
[8]=>
array(5) {
["data"]=>
string(1) "7"
["name"]=>
string(8) "Previous"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
}
[9]=>
array(5) {
["data"]=>
string(1) "8"
["name"]=>
string(10) "Actual kWh"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
}
[10]=>
array(5) {
["data"]=>
string(1) "9"
["name"]=>
string(12) "Override kWh"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
}
[11]=>
array(5) {
["data"]=>
string(2) "10"
["name"]=>
string(7) "Remarks"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
}
}
["order"]=>
array(1) {
[0]=>
array(2) {
["column"]=>
int(4)
["dir"]=>
string(3) "ASC"
}
}
["start"]=>
string(1) "0"
["length"]=>
string(2) "50"
["search"]=>
array(2) {
["value"]=>
string(0) ""
["regex"]=>
string(5) "false"
}
["bShowInfoCol"]=>
string(5) "false"
["bShowIDCol"]=>
string(5) "false"
["sFunctionName"]=>
string(11) "getGridData"
["oConditionalParams"]=>
array(1) {
["IC_StartDate"]=>
string(10) "2025-06-01"
}
["aFinalColumns"]=>
array(11) {
[0]=>
array(11) {
["name"]=>
string(11) "!responsive"
["width"]=>
string(4) "25px"
["orderable"]=>
string(5) "false"
["visible"]=>
string(4) "true"
["searchable"]=>
string(5) "false"
["index"]=>
string(1) "0"
["bSortable"]=>
string(5) "false"
["sName"]=>
string(11) "!responsive"
["sWidth"]=>
string(4) "25px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(5) "false"
}
[1]=>
array(11) {
["name"]=>
string(2) "ID"
["format"]=>
string(0) ""
["visible"]=>
string(5) "false"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "1"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(2) "ID"
["bVisible"]=>
string(5) "false"
["bSearchable"]=>
string(4) "true"
}
[2]=>
array(11) {
["name"]=>
string(5) "SI_ID"
["format"]=>
string(0) ""
["visible"]=>
string(5) "false"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "2"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(5) "SI_ID"
["bVisible"]=>
string(5) "false"
["bSearchable"]=>
string(4) "true"
}
[3]=>
array(13) {
["name"]=>
string(13) "Inverter Name"
["width"]=>
string(5) "150px"
["format"]=>
string(0) ""
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "3"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(13) "Inverter Name"
["sWidth"]=>
string(5) "150px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
[4]=>
array(13) {
["name"]=>
string(10) "Start Date"
["width"]=>
string(5) "100px"
["format"]=>
string(4) "date"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "4"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(10) "Start Date"
["sWidth"]=>
string(5) "100px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
[5]=>
array(13) {
["name"]=>
string(8) "End Date"
["width"]=>
string(5) "100px"
["format"]=>
string(4) "date"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "5"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(8) "End Date"
["sWidth"]=>
string(5) "100px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
[6]=>
array(13) {
["name"]=>
string(6) "Recent"
["width"]=>
string(5) "100px"
["format"]=>
string(9) "decimal_2"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "6"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(6) "Recent"
["sWidth"]=>
string(5) "100px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
[7]=>
array(13) {
["name"]=>
string(8) "Previous"
["width"]=>
string(5) "100px"
["format"]=>
string(9) "decimal_2"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "7"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(8) "Previous"
["sWidth"]=>
string(5) "100px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
[8]=>
array(13) {
["name"]=>
string(10) "Actual kWh"
["width"]=>
string(4) "80px"
["format"]=>
string(9) "decimal_2"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "8"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(10) "Actual kWh"
["sWidth"]=>
string(4) "80px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
[9]=>
array(13) {
["name"]=>
string(12) "Override kWh"
["width"]=>
string(4) "80px"
["format"]=>
string(9) "decimal_2"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "9"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(12) "Override kWh"
["sWidth"]=>
string(4) "80px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
[10]=>
array(11) {
["name"]=>
string(7) "Remarks"
["format"]=>
string(0) ""
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(2) "10"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(7) "Remarks"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
}
["oColumnsDict"]=>
array(11) {
["!responsive"]=>
array(11) {
["name"]=>
string(11) "!responsive"
["width"]=>
string(4) "25px"
["orderable"]=>
string(5) "false"
["visible"]=>
string(4) "true"
["searchable"]=>
string(5) "false"
["index"]=>
string(1) "0"
["bSortable"]=>
string(5) "false"
["sName"]=>
string(11) "!responsive"
["sWidth"]=>
string(4) "25px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(5) "false"
}
["ID"]=>
array(11) {
["name"]=>
string(2) "ID"
["format"]=>
string(0) ""
["visible"]=>
string(5) "false"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "1"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(2) "ID"
["bVisible"]=>
string(5) "false"
["bSearchable"]=>
string(4) "true"
}
["SI_ID"]=>
array(11) {
["name"]=>
string(5) "SI_ID"
["format"]=>
string(0) ""
["visible"]=>
string(5) "false"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "2"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(5) "SI_ID"
["bVisible"]=>
string(5) "false"
["bSearchable"]=>
string(4) "true"
}
["Inverter Name"]=>
array(13) {
["name"]=>
string(13) "Inverter Name"
["width"]=>
string(5) "150px"
["format"]=>
string(0) ""
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "3"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(13) "Inverter Name"
["sWidth"]=>
string(5) "150px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
["Start Date"]=>
array(13) {
["name"]=>
string(10) "Start Date"
["width"]=>
string(5) "100px"
["format"]=>
string(4) "date"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "4"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(10) "Start Date"
["sWidth"]=>
string(5) "100px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
["End Date"]=>
array(13) {
["name"]=>
string(8) "End Date"
["width"]=>
string(5) "100px"
["format"]=>
string(4) "date"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "5"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(8) "End Date"
["sWidth"]=>
string(5) "100px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
["Recent"]=>
array(13) {
["name"]=>
string(6) "Recent"
["width"]=>
string(5) "100px"
["format"]=>
string(9) "decimal_2"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "6"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(6) "Recent"
["sWidth"]=>
string(5) "100px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
["Previous"]=>
array(13) {
["name"]=>
string(8) "Previous"
["width"]=>
string(5) "100px"
["format"]=>
string(9) "decimal_2"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "7"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(8) "Previous"
["sWidth"]=>
string(5) "100px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
["Actual kWh"]=>
array(13) {
["name"]=>
string(10) "Actual kWh"
["width"]=>
string(4) "80px"
["format"]=>
string(9) "decimal_2"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "8"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(10) "Actual kWh"
["sWidth"]=>
string(4) "80px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
["Override kWh"]=>
array(13) {
["name"]=>
string(12) "Override kWh"
["width"]=>
string(4) "80px"
["format"]=>
string(9) "decimal_2"
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(1) "9"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(12) "Override kWh"
["sWidth"]=>
string(4) "80px"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
["Remarks"]=>
array(11) {
["name"]=>
string(7) "Remarks"
["format"]=>
string(0) ""
["visible"]=>
string(4) "true"
["searchable"]=>
string(4) "true"
["orderable"]=>
string(4) "true"
["search"]=>
array(1) {
["regex"]=>
string(5) "false"
}
["index"]=>
string(2) "10"
["bSortable"]=>
string(4) "true"
["sName"]=>
string(7) "Remarks"
["bVisible"]=>
string(4) "true"
["bSearchable"]=>
string(4) "true"
}
}
["sGroupByColumnTitle"]=>
string(0) ""
["iSystemColumnCount"]=>
string(1) "1"
}
COOKIES
array(6) {
["PHPSESSID"]=>
string(26) "05an7krhjqj3v54h2fl6b13gtp"
["SU_ID"]=>
string(2) "17"
["sLang"]=>
string(2) "en"
["sAppVersion"]=>
string(17) "2025.04.02.110028"
["iSiteSelected"]=>
string(3) "451"
["sFullUrl"]=>
string(84) "https://aipm-cpall2-bn.enmax.co.th/#/Screens/AnalysisReports/Devices/Inverters.phtml"
}