[2025-03-10 11:56:18] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%h%,%h%,%h%,%h%,%h%,%h%,%h%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %h% or LOWER("DATA"."TGL_BUAT") LIKE %h% or LOWER("DATA"."TGL_SELESAI") LIKE %h% or LOWER("DATA"."JUDUL") LIKE %h% or LOWER("DATA"."URAIAN") LIKE %h% or LOWER("DATA"."KET") LIKE %h% or LOWER("DATA"."JENIS") LIKE %h%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%h%,%h%,%h%,%h%,%h%,%h%,%h%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %h% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %h% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %h% or LOWER(\"DATA\".\"JUDUL\") LIKE %h% or LOWER(\"DATA\".\"URAIAN\") LIKE %h% or LOWER(\"DATA\".\"KET\") LIKE %h% or LOWER(\"DATA\".\"JENIS\") LIKE %h%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%h%,%h%,%h%,%h%,%h%,%h%,%h%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %h% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %h% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %h% or LOWER(\"DATA\".\"JUDUL\") LIKE %h% or LOWER(\"DATA\".\"URAIAN\") LIKE %h% or LOWER(\"DATA\".\"KET\") LIKE %h% or LOWER(\"DATA\".\"JENIS\") LIKE %h%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%h%,%h%,%h%,%h%,%h%,%h%,%h%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "} [2025-03-10 11:56:18] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %huk% or LOWER("DATA"."TGL_BUAT") LIKE %huk% or LOWER("DATA"."TGL_SELESAI") LIKE %huk% or LOWER("DATA"."JUDUL") LIKE %huk% or LOWER("DATA"."URAIAN") LIKE %huk% or LOWER("DATA"."KET") LIKE %huk% or LOWER("DATA"."JENIS") LIKE %huk%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %huk% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %huk% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %huk% or LOWER(\"DATA\".\"JUDUL\") LIKE %huk% or LOWER(\"DATA\".\"URAIAN\") LIKE %huk% or LOWER(\"DATA\".\"KET\") LIKE %huk% or LOWER(\"DATA\".\"JENIS\") LIKE %huk%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %huk% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %huk% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %huk% or LOWER(\"DATA\".\"JUDUL\") LIKE %huk% or LOWER(\"DATA\".\"URAIAN\") LIKE %huk% or LOWER(\"DATA\".\"KET\") LIKE %huk% or LOWER(\"DATA\".\"JENIS\") LIKE %huk%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "} [2025-03-10 11:56:20] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %huku% or LOWER("DATA"."TGL_BUAT") LIKE %huku% or LOWER("DATA"."TGL_SELESAI") LIKE %huku% or LOWER("DATA"."JUDUL") LIKE %huku% or LOWER("DATA"."URAIAN") LIKE %huku% or LOWER("DATA"."KET") LIKE %huku% or LOWER("DATA"."JENIS") LIKE %huku%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %huku% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %huku% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %huku% or LOWER(\"DATA\".\"JUDUL\") LIKE %huku% or LOWER(\"DATA\".\"URAIAN\") LIKE %huku% or LOWER(\"DATA\".\"KET\") LIKE %huku% or LOWER(\"DATA\".\"JENIS\") LIKE %huku%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %huku% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %huku% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %huku% or LOWER(\"DATA\".\"JUDUL\") LIKE %huku% or LOWER(\"DATA\".\"URAIAN\") LIKE %huku% or LOWER(\"DATA\".\"KET\") LIKE %huku% or LOWER(\"DATA\".\"JENIS\") LIKE %huku%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "} [2025-03-10 11:56:23] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %huku% or LOWER("DATA"."TGL_BUAT") LIKE %huku% or LOWER("DATA"."TGL_SELESAI") LIKE %huku% or LOWER("DATA"."JUDUL") LIKE %huku% or LOWER("DATA"."URAIAN") LIKE %huku% or LOWER("DATA"."KET") LIKE %huku% or LOWER("DATA"."JENIS") LIKE %huku%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %huku% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %huku% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %huku% or LOWER(\"DATA\".\"JUDUL\") LIKE %huku% or LOWER(\"DATA\".\"URAIAN\") LIKE %huku% or LOWER(\"DATA\".\"KET\") LIKE %huku% or LOWER(\"DATA\".\"JENIS\") LIKE %huku%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %huku% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %huku% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %huku% or LOWER(\"DATA\".\"JUDUL\") LIKE %huku% or LOWER(\"DATA\".\"URAIAN\") LIKE %huku% or LOWER(\"DATA\".\"KET\") LIKE %huku% or LOWER(\"DATA\".\"JENIS\") LIKE %huku%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "} [2025-03-10 11:56:26] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %hukum% or LOWER("DATA"."TGL_BUAT") LIKE %hukum% or LOWER("DATA"."TGL_SELESAI") LIKE %hukum% or LOWER("DATA"."JUDUL") LIKE %hukum% or LOWER("DATA"."URAIAN") LIKE %hukum% or LOWER("DATA"."KET") LIKE %hukum% or LOWER("DATA"."JENIS") LIKE %hukum%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hukum% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hukum% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hukum% or LOWER(\"DATA\".\"JUDUL\") LIKE %hukum% or LOWER(\"DATA\".\"URAIAN\") LIKE %hukum% or LOWER(\"DATA\".\"KET\") LIKE %hukum% or LOWER(\"DATA\".\"JENIS\") LIKE %hukum%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hukum% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hukum% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hukum% or LOWER(\"DATA\".\"JUDUL\") LIKE %hukum% or LOWER(\"DATA\".\"URAIAN\") LIKE %hukum% or LOWER(\"DATA\".\"KET\") LIKE %hukum% or LOWER(\"DATA\".\"JENIS\") LIKE %hukum%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "} [2025-03-10 11:56:29] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %hukum% or LOWER("DATA"."TGL_BUAT") LIKE %hukum% or LOWER("DATA"."TGL_SELESAI") LIKE %hukum% or LOWER("DATA"."JUDUL") LIKE %hukum% or LOWER("DATA"."URAIAN") LIKE %hukum% or LOWER("DATA"."KET") LIKE %hukum% or LOWER("DATA"."JENIS") LIKE %hukum%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hukum% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hukum% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hukum% or LOWER(\"DATA\".\"JUDUL\") LIKE %hukum% or LOWER(\"DATA\".\"URAIAN\") LIKE %hukum% or LOWER(\"DATA\".\"KET\") LIKE %hukum% or LOWER(\"DATA\".\"JENIS\") LIKE %hukum%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hukum% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hukum% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hukum% or LOWER(\"DATA\".\"JUDUL\") LIKE %hukum% or LOWER(\"DATA\".\"URAIAN\") LIKE %hukum% or LOWER(\"DATA\".\"KET\") LIKE %hukum% or LOWER(\"DATA\".\"JENIS\") LIKE %hukum%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%,%hukum%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "} [2025-03-10 11:56:31] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %huku% or LOWER("DATA"."TGL_BUAT") LIKE %huku% or LOWER("DATA"."TGL_SELESAI") LIKE %huku% or LOWER("DATA"."JUDUL") LIKE %huku% or LOWER("DATA"."URAIAN") LIKE %huku% or LOWER("DATA"."KET") LIKE %huku% or LOWER("DATA"."JENIS") LIKE %huku%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %huku% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %huku% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %huku% or LOWER(\"DATA\".\"JUDUL\") LIKE %huku% or LOWER(\"DATA\".\"URAIAN\") LIKE %huku% or LOWER(\"DATA\".\"KET\") LIKE %huku% or LOWER(\"DATA\".\"JENIS\") LIKE %huku%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %huku% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %huku% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %huku% or LOWER(\"DATA\".\"JUDUL\") LIKE %huku% or LOWER(\"DATA\".\"URAIAN\") LIKE %huku% or LOWER(\"DATA\".\"KET\") LIKE %huku% or LOWER(\"DATA\".\"JENIS\") LIKE %huku%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%,%huku%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "} [2025-03-10 11:56:32] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %huk% or LOWER("DATA"."TGL_BUAT") LIKE %huk% or LOWER("DATA"."TGL_SELESAI") LIKE %huk% or LOWER("DATA"."JUDUL") LIKE %huk% or LOWER("DATA"."URAIAN") LIKE %huk% or LOWER("DATA"."KET") LIKE %huk% or LOWER("DATA"."JENIS") LIKE %huk%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %huk% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %huk% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %huk% or LOWER(\"DATA\".\"JUDUL\") LIKE %huk% or LOWER(\"DATA\".\"URAIAN\") LIKE %huk% or LOWER(\"DATA\".\"KET\") LIKE %huk% or LOWER(\"DATA\".\"JENIS\") LIKE %huk%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %huk% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %huk% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %huk% or LOWER(\"DATA\".\"JUDUL\") LIKE %huk% or LOWER(\"DATA\".\"URAIAN\") LIKE %huk% or LOWER(\"DATA\".\"KET\") LIKE %huk% or LOWER(\"DATA\".\"JENIS\") LIKE %huk%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%,%huk%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "} [2025-03-10 11:56:34] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %hu% or LOWER("DATA"."TGL_BUAT") LIKE %hu% or LOWER("DATA"."TGL_SELESAI") LIKE %hu% or LOWER("DATA"."JUDUL") LIKE %hu% or LOWER("DATA"."URAIAN") LIKE %hu% or LOWER("DATA"."KET") LIKE %hu% or LOWER("DATA"."JENIS") LIKE %hu%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hu% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hu% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hu% or LOWER(\"DATA\".\"JUDUL\") LIKE %hu% or LOWER(\"DATA\".\"URAIAN\") LIKE %hu% or LOWER(\"DATA\".\"KET\") LIKE %hu% or LOWER(\"DATA\".\"JENIS\") LIKE %hu%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hu% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hu% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hu% or LOWER(\"DATA\".\"JUDUL\") LIKE %hu% or LOWER(\"DATA\".\"URAIAN\") LIKE %hu% or LOWER(\"DATA\".\"KET\") LIKE %hu% or LOWER(\"DATA\".\"JENIS\") LIKE %hu%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "} [2025-03-10 11:56:35] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %hu% or LOWER("DATA"."TGL_BUAT") LIKE %hu% or LOWER("DATA"."TGL_SELESAI") LIKE %hu% or LOWER("DATA"."JUDUL") LIKE %hu% or LOWER("DATA"."URAIAN") LIKE %hu% or LOWER("DATA"."KET") LIKE %hu% or LOWER("DATA"."JENIS") LIKE %hu%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hu% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hu% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hu% or LOWER(\"DATA\".\"JUDUL\") LIKE %hu% or LOWER(\"DATA\".\"URAIAN\") LIKE %hu% or LOWER(\"DATA\".\"KET\") LIKE %hu% or LOWER(\"DATA\".\"JENIS\") LIKE %hu%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hu% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hu% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hu% or LOWER(\"DATA\".\"JUDUL\") LIKE %hu% or LOWER(\"DATA\".\"URAIAN\") LIKE %hu% or LOWER(\"DATA\".\"KET\") LIKE %hu% or LOWER(\"DATA\".\"JENIS\") LIKE %hu%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "} [2025-03-10 11:56:56] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %hu% or LOWER("DATA"."TGL_BUAT") LIKE %hu% or LOWER("DATA"."TGL_SELESAI") LIKE %hu% or LOWER("DATA"."JUDUL") LIKE %hu% or LOWER("DATA"."URAIAN") LIKE %hu% or LOWER("DATA"."KET") LIKE %hu% or LOWER("DATA"."JENIS") LIKE %hu%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hu% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hu% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hu% or LOWER(\"DATA\".\"JUDUL\") LIKE %hu% or LOWER(\"DATA\".\"URAIAN\") LIKE %hu% or LOWER(\"DATA\".\"KET\") LIKE %hu% or LOWER(\"DATA\".\"JENIS\") LIKE %hu%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hu% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hu% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hu% or LOWER(\"DATA\".\"JUDUL\") LIKE %hu% or LOWER(\"DATA\".\"URAIAN\") LIKE %hu% or LOWER(\"DATA\".\"KET\") LIKE %hu% or LOWER(\"DATA\".\"JENIS\") LIKE %hu%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "} [2025-03-10 11:57:06] local.ERROR: Error Code : 904 Error Message : ORA-00904: "DATA"."JENIS": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = :p0 and (LOWER("DATA"."PEMOHON") LIKE :p1 or LOWER("DATA"."TGL_BUAT") LIKE :p2 or LOWER("DATA"."TGL_SELESAI") LIKE :p3 or LOWER("DATA"."JUDUL") LIKE :p4 or LOWER("DATA"."URAIAN") LIKE :p5 or LOWER("DATA"."KET") LIKE :p6 or LOWER("DATA"."JENIS") LIKE :p7) order by "DATA"."TGL_ENTRI" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select "DATA"."U_PEMOHON" as "PEMOHON", "DATA"."TGL_ENTRI" as "TGL_BUAT", "DATA"."TGL_SELESAI" as "TGL_SELESAI", "DATA"."JUDUL", "DATA"."URAIAN", "C"."KET", "J"."JENIS" from "DATA" left join "DATA_JENIS" j on "J"."RECID" = "DATA"."JENIS_ID" left join "MASTER_CODE" c on "C"."KODE" = "DATA"."STATUS" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and "DATA"."BAGIAN_PEMOHON" = 22 and (LOWER("DATA"."PEMOHON") LIKE %hu% or LOWER("DATA"."TGL_BUAT") LIKE %hu% or LOWER("DATA"."TGL_SELESAI") LIKE %hu% or LOWER("DATA"."JUDUL") LIKE %hu% or LOWER("DATA"."URAIAN") LIKE %hu% or LOWER("DATA"."KET") LIKE %hu% or LOWER("DATA"."JENIS") LIKE %hu%) order by "DATA"."TGL_ENTRI" desc) count_row_table) {"userId":"10601401 ","exception":"[object] (Yajra\\DataTables\\Exceptions\\Exception(code: 0): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hu% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hu% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hu% or LOWER(\"DATA\".\"JUDUL\") LIKE %hu% or LOWER(\"DATA\".\"URAIAN\") LIKE %hu% or LOWER(\"DATA\".\"KET\") LIKE %hu% or LOWER(\"DATA\".\"JENIS\") LIKE %hu%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/DataTableAbstract.php:778, Illuminate\\Database\\QueryException(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] (SQL: select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = 22 and (LOWER(\"DATA\".\"PEMOHON\") LIKE %hu% or LOWER(\"DATA\".\"TGL_BUAT\") LIKE %hu% or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE %hu% or LOWER(\"DATA\".\"JUDUL\") LIKE %hu% or LOWER(\"DATA\".\"URAIAN\") LIKE %hu% or LOWER(\"DATA\".\"KET\") LIKE %hu% or LOWER(\"DATA\".\"JENIS\") LIKE %hu%) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table) at /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, Yajra\\Pdo\\Oci8\\Exceptions\\Oci8Exception(code: 904): Error Code : 904 Error Message : ORA-00904: \"DATA\".\"JENIS\": invalid identifier Position : 738 Statement : select count(*) as aggregate from (select \"DATA\".\"U_PEMOHON\" as \"PEMOHON\", \"DATA\".\"TGL_ENTRI\" as \"TGL_BUAT\", \"DATA\".\"TGL_SELESAI\" as \"TGL_SELESAI\", \"DATA\".\"JUDUL\", \"DATA\".\"URAIAN\", \"C\".\"KET\", \"J\".\"JENIS\" from \"DATA\" left join \"DATA_JENIS\" j on \"J\".\"RECID\" = \"DATA\".\"JENIS_ID\" left join \"MASTER_CODE\" c on \"C\".\"KODE\" = \"DATA\".\"STATUS\" where data.tgl_entri BETWEEN TO_DATE('01/01/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND TO_DATE('28/02/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') and \"DATA\".\"BAGIAN_PEMOHON\" = :p0 and (LOWER(\"DATA\".\"PEMOHON\") LIKE :p1 or LOWER(\"DATA\".\"TGL_BUAT\") LIKE :p2 or LOWER(\"DATA\".\"TGL_SELESAI\") LIKE :p3 or LOWER(\"DATA\".\"JUDUL\") LIKE :p4 or LOWER(\"DATA\".\"URAIAN\") LIKE :p5 or LOWER(\"DATA\".\"KET\") LIKE :p6 or LOWER(\"DATA\".\"JENIS\") LIKE :p7) order by \"DATA\".\"TGL_ENTRI\" desc) count_row_table Bindings : [22,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%,%hu%] at /var/www/apps/elit/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:183) [stacktrace] #0 /var/www/apps/elit/vendor/yajra/laravel-datatables-oracle/src/QueryDataTable.php(106): Yajra\\DataTables\\DataTableAbstract->errorResponse(Object(Illuminate\\Database\\QueryException)) #1 /var/www/apps/elit/app/Http/Controllers/LayananController.php(832): Yajra\\DataTables\\QueryDataTable->make(true) #2 [internal function]: App\\Http\\Controllers\\LayananController->report_pengajuan(Object(Illuminate\\Http\\Request)) #3 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #4 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('report_pengajua...', Array) #5 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\LayananController), 'report_pengajua...') #6 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController() #7 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(682): Illuminate\\Routing\\Route->run() #8 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #9 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #10 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #11 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #12 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #13 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Auth\\Middleware\\Authenticate->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #14 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #15 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(75): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #17 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #18 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #19 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #22 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #23 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #24 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #25 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #26 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #28 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #29 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #30 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #31 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(684): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #32 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(659): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #33 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #34 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Router.php(614): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #35 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #36 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #37 /var/www/apps/elit/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #38 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #41 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #42 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #43 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #44 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #47 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #48 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #49 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #50 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(163): Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #51 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #52 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #53 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #54 /var/www/apps/elit/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #55 /var/www/apps/elit/public/index.php(55): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #56 {main} "}