[2024-08-18 11:35:00] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30) and LOWER("PEG"."AKTIF") LIKE :p31) count_row_table Bindings : [1,SG,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%%1%%] in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:177 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): Yajra\Pdo\Oci8\Statement->execute() #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array) #2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #4 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #10 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #11 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #12 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #13 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #20 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #61 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #62 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #63 {main} Next Illuminate\Database\QueryException: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30) and LOWER("PEG"."AKTIF") LIKE :p31) count_row_table Bindings : [1,SG,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%%1%%] (SQL: select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = 1 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = SG and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %k% or LOWER("PEG"."NIP") LIKE %k% or LOWER("PER"."NAMA") LIKE %k% or LOWER("U"."NAMA") LIKE %k% or LOWER("PEG"."AKTIF") LIKE %k% or LOWER("PEG"."TMT_MASUK") LIKE %k% or LOWER("PEG"."TMT_BERHENTI") LIKE %k% or LOWER("PER"."NO_REKENING") LIKE %k% or LOWER("PER"."NIK") LIKE %k% or LOWER("PER"."GENDER") LIKE %k% or LOWER("PER"."TEMPAT_LAHIR") LIKE %k% or LOWER("PER"."TGL_LAHIR") LIKE %k% or LOWER("PER"."TELEPON") LIKE %k% or LOWER("PER"."AGAMA_ID") LIKE %k% or LOWER("PER"."GOL_DARAH") LIKE %k% or LOWER("PER"."STATUS_KAWIN") LIKE %k% or LOWER("PER"."ALAMAT") LIKE %k% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %k% or LOWER("PER"."TELP_KERABAT") LIKE %k% or LOWER("PER"."IBU_KANDUNG") LIKE %k% or LOWER("PER"."NPWP") LIKE %k% or LOWER("PEG"."ID") LIKE %k% or LOWER("PEG"."PERSONAL_ID") LIKE %k% or LOWER("PEG"."KODE_FINGER") LIKE %k% or LOWER("PEG"."STATUS_KERJA") LIKE %k% or LOWER("SAT"."UNIT_ID") LIKE %k% or LOWER("PEG"."AKTIF") LIKE %k% or LOWER("SAT"."NO_SK") LIKE %k% or LOWER("SAT"."TGL_SK") LIKE %k%) and LOWER("PEG"."AKTIF") LIKE %%1%%) count_row_table) in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #10 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #11 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #61 {main} [2024-08-18 11:35:01] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30) and LOWER("PEG"."AKTIF") LIKE :p31) count_row_table Bindings : [1,SG,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%%1%%] in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:177 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): Yajra\Pdo\Oci8\Statement->execute() #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array) #2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #4 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #10 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #11 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #12 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #13 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #20 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #61 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #62 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #63 {main} Next Illuminate\Database\QueryException: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30) and LOWER("PEG"."AKTIF") LIKE :p31) count_row_table Bindings : [1,SG,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%kela%,%%1%%] (SQL: select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = 1 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = SG and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %kela% or LOWER("PEG"."NIP") LIKE %kela% or LOWER("PER"."NAMA") LIKE %kela% or LOWER("U"."NAMA") LIKE %kela% or LOWER("PEG"."AKTIF") LIKE %kela% or LOWER("PEG"."TMT_MASUK") LIKE %kela% or LOWER("PEG"."TMT_BERHENTI") LIKE %kela% or LOWER("PER"."NO_REKENING") LIKE %kela% or LOWER("PER"."NIK") LIKE %kela% or LOWER("PER"."GENDER") LIKE %kela% or LOWER("PER"."TEMPAT_LAHIR") LIKE %kela% or LOWER("PER"."TGL_LAHIR") LIKE %kela% or LOWER("PER"."TELEPON") LIKE %kela% or LOWER("PER"."AGAMA_ID") LIKE %kela% or LOWER("PER"."GOL_DARAH") LIKE %kela% or LOWER("PER"."STATUS_KAWIN") LIKE %kela% or LOWER("PER"."ALAMAT") LIKE %kela% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %kela% or LOWER("PER"."TELP_KERABAT") LIKE %kela% or LOWER("PER"."IBU_KANDUNG") LIKE %kela% or LOWER("PER"."NPWP") LIKE %kela% or LOWER("PEG"."ID") LIKE %kela% or LOWER("PEG"."PERSONAL_ID") LIKE %kela% or LOWER("PEG"."KODE_FINGER") LIKE %kela% or LOWER("PEG"."STATUS_KERJA") LIKE %kela% or LOWER("SAT"."UNIT_ID") LIKE %kela% or LOWER("PEG"."AKTIF") LIKE %kela% or LOWER("SAT"."NO_SK") LIKE %kela% or LOWER("SAT"."TGL_SK") LIKE %kela%) and LOWER("PEG"."AKTIF") LIKE %%1%%) count_row_table) in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #10 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #11 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #61 {main} [2024-08-18 11:40:25] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30)) count_row_table Bindings : [1,SG,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%] in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:177 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): Yajra\Pdo\Oci8\Statement->execute() #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array) #2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #4 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #10 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #11 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #12 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #13 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #20 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #61 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #62 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #63 {main} Next Illuminate\Database\QueryException: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30)) count_row_table Bindings : [1,SG,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%] (SQL: select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = 1 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = SG and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %k% or LOWER("PEG"."NIP") LIKE %k% or LOWER("PER"."NAMA") LIKE %k% or LOWER("U"."NAMA") LIKE %k% or LOWER("PEG"."AKTIF") LIKE %k% or LOWER("PEG"."TMT_MASUK") LIKE %k% or LOWER("PEG"."TMT_BERHENTI") LIKE %k% or LOWER("PER"."NO_REKENING") LIKE %k% or LOWER("PER"."NIK") LIKE %k% or LOWER("PER"."GENDER") LIKE %k% or LOWER("PER"."TEMPAT_LAHIR") LIKE %k% or LOWER("PER"."TGL_LAHIR") LIKE %k% or LOWER("PER"."TELEPON") LIKE %k% or LOWER("PER"."AGAMA_ID") LIKE %k% or LOWER("PER"."GOL_DARAH") LIKE %k% or LOWER("PER"."STATUS_KAWIN") LIKE %k% or LOWER("PER"."ALAMAT") LIKE %k% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %k% or LOWER("PER"."TELP_KERABAT") LIKE %k% or LOWER("PER"."IBU_KANDUNG") LIKE %k% or LOWER("PER"."NPWP") LIKE %k% or LOWER("PEG"."ID") LIKE %k% or LOWER("PEG"."PERSONAL_ID") LIKE %k% or LOWER("PEG"."KODE_FINGER") LIKE %k% or LOWER("PEG"."STATUS_KERJA") LIKE %k% or LOWER("SAT"."UNIT_ID") LIKE %k% or LOWER("PEG"."AKTIF") LIKE %k% or LOWER("SAT"."NO_SK") LIKE %k% or LOWER("SAT"."TGL_SK") LIKE %k%)) count_row_table) in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #10 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #11 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #61 {main} [2024-08-18 11:40:28] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30)) count_row_table Bindings : [1,SG,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%] in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:177 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): Yajra\Pdo\Oci8\Statement->execute() #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array) #2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #4 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #10 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #11 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #12 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #13 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #20 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #61 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #62 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #63 {main} Next Illuminate\Database\QueryException: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30)) count_row_table Bindings : [1,SG,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%,%ke%] (SQL: select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = 1 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = SG and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %ke% or LOWER("PEG"."NIP") LIKE %ke% or LOWER("PER"."NAMA") LIKE %ke% or LOWER("U"."NAMA") LIKE %ke% or LOWER("PEG"."AKTIF") LIKE %ke% or LOWER("PEG"."TMT_MASUK") LIKE %ke% or LOWER("PEG"."TMT_BERHENTI") LIKE %ke% or LOWER("PER"."NO_REKENING") LIKE %ke% or LOWER("PER"."NIK") LIKE %ke% or LOWER("PER"."GENDER") LIKE %ke% or LOWER("PER"."TEMPAT_LAHIR") LIKE %ke% or LOWER("PER"."TGL_LAHIR") LIKE %ke% or LOWER("PER"."TELEPON") LIKE %ke% or LOWER("PER"."AGAMA_ID") LIKE %ke% or LOWER("PER"."GOL_DARAH") LIKE %ke% or LOWER("PER"."STATUS_KAWIN") LIKE %ke% or LOWER("PER"."ALAMAT") LIKE %ke% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %ke% or LOWER("PER"."TELP_KERABAT") LIKE %ke% or LOWER("PER"."IBU_KANDUNG") LIKE %ke% or LOWER("PER"."NPWP") LIKE %ke% or LOWER("PEG"."ID") LIKE %ke% or LOWER("PEG"."PERSONAL_ID") LIKE %ke% or LOWER("PEG"."KODE_FINGER") LIKE %ke% or LOWER("PEG"."STATUS_KERJA") LIKE %ke% or LOWER("SAT"."UNIT_ID") LIKE %ke% or LOWER("PEG"."AKTIF") LIKE %ke% or LOWER("SAT"."NO_SK") LIKE %ke% or LOWER("SAT"."TGL_SK") LIKE %ke%)) count_row_table) in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #10 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #11 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #61 {main} [2024-08-18 11:40:37] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30)) count_row_table Bindings : [1,SG,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%] in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:177 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): Yajra\Pdo\Oci8\Statement->execute() #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array) #2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #4 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #10 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #11 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #12 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #13 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #20 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #61 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #62 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #63 {main} Next Illuminate\Database\QueryException: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30)) count_row_table Bindings : [1,SG,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%,%k%] (SQL: select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = 1 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = SG and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %k% or LOWER("PEG"."NIP") LIKE %k% or LOWER("PER"."NAMA") LIKE %k% or LOWER("U"."NAMA") LIKE %k% or LOWER("PEG"."AKTIF") LIKE %k% or LOWER("PEG"."TMT_MASUK") LIKE %k% or LOWER("PEG"."TMT_BERHENTI") LIKE %k% or LOWER("PER"."NO_REKENING") LIKE %k% or LOWER("PER"."NIK") LIKE %k% or LOWER("PER"."GENDER") LIKE %k% or LOWER("PER"."TEMPAT_LAHIR") LIKE %k% or LOWER("PER"."TGL_LAHIR") LIKE %k% or LOWER("PER"."TELEPON") LIKE %k% or LOWER("PER"."AGAMA_ID") LIKE %k% or LOWER("PER"."GOL_DARAH") LIKE %k% or LOWER("PER"."STATUS_KAWIN") LIKE %k% or LOWER("PER"."ALAMAT") LIKE %k% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %k% or LOWER("PER"."TELP_KERABAT") LIKE %k% or LOWER("PER"."IBU_KANDUNG") LIKE %k% or LOWER("PER"."NPWP") LIKE %k% or LOWER("PEG"."ID") LIKE %k% or LOWER("PEG"."PERSONAL_ID") LIKE %k% or LOWER("PEG"."KODE_FINGER") LIKE %k% or LOWER("PEG"."STATUS_KERJA") LIKE %k% or LOWER("SAT"."UNIT_ID") LIKE %k% or LOWER("PEG"."AKTIF") LIKE %k% or LOWER("SAT"."NO_SK") LIKE %k% or LOWER("SAT"."TGL_SK") LIKE %k%)) count_row_table) in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #10 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #11 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #61 {main} [2024-08-18 11:40:37] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30)) count_row_table Bindings : [1,SG,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%] in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:177 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): Yajra\Pdo\Oci8\Statement->execute() #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array) #2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #4 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #10 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #11 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #12 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #13 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #20 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #61 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #62 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #63 {main} Next Illuminate\Database\QueryException: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30)) count_row_table Bindings : [1,SG,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%,%l%] (SQL: select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = 1 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = SG and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %l% or LOWER("PEG"."NIP") LIKE %l% or LOWER("PER"."NAMA") LIKE %l% or LOWER("U"."NAMA") LIKE %l% or LOWER("PEG"."AKTIF") LIKE %l% or LOWER("PEG"."TMT_MASUK") LIKE %l% or LOWER("PEG"."TMT_BERHENTI") LIKE %l% or LOWER("PER"."NO_REKENING") LIKE %l% or LOWER("PER"."NIK") LIKE %l% or LOWER("PER"."GENDER") LIKE %l% or LOWER("PER"."TEMPAT_LAHIR") LIKE %l% or LOWER("PER"."TGL_LAHIR") LIKE %l% or LOWER("PER"."TELEPON") LIKE %l% or LOWER("PER"."AGAMA_ID") LIKE %l% or LOWER("PER"."GOL_DARAH") LIKE %l% or LOWER("PER"."STATUS_KAWIN") LIKE %l% or LOWER("PER"."ALAMAT") LIKE %l% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %l% or LOWER("PER"."TELP_KERABAT") LIKE %l% or LOWER("PER"."IBU_KANDUNG") LIKE %l% or LOWER("PER"."NPWP") LIKE %l% or LOWER("PEG"."ID") LIKE %l% or LOWER("PEG"."PERSONAL_ID") LIKE %l% or LOWER("PEG"."KODE_FINGER") LIKE %l% or LOWER("PEG"."STATUS_KERJA") LIKE %l% or LOWER("SAT"."UNIT_ID") LIKE %l% or LOWER("PEG"."AKTIF") LIKE %l% or LOWER("SAT"."NO_SK") LIKE %l% or LOWER("SAT"."TGL_SK") LIKE %l%)) count_row_table) in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #10 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #11 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #61 {main} [2024-08-18 11:40:37] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30)) count_row_table Bindings : [1,SG,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%] in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:177 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): Yajra\Pdo\Oci8\Statement->execute() #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array) #2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #4 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #10 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #11 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #12 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #13 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #20 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #61 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #62 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #63 {main} Next Illuminate\Database\QueryException: Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 426 Statement : select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p2 or LOWER("PEG"."NIP") LIKE :p3 or LOWER("PER"."NAMA") LIKE :p4 or LOWER("U"."NAMA") LIKE :p5 or LOWER("PEG"."AKTIF") LIKE :p6 or LOWER("PEG"."TMT_MASUK") LIKE :p7 or LOWER("PEG"."TMT_BERHENTI") LIKE :p8 or LOWER("PER"."NO_REKENING") LIKE :p9 or LOWER("PER"."NIK") LIKE :p10 or LOWER("PER"."GENDER") LIKE :p11 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p12 or LOWER("PER"."TGL_LAHIR") LIKE :p13 or LOWER("PER"."TELEPON") LIKE :p14 or LOWER("PER"."AGAMA_ID") LIKE :p15 or LOWER("PER"."GOL_DARAH") LIKE :p16 or LOWER("PER"."STATUS_KAWIN") LIKE :p17 or LOWER("PER"."ALAMAT") LIKE :p18 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p19 or LOWER("PER"."TELP_KERABAT") LIKE :p20 or LOWER("PER"."IBU_KANDUNG") LIKE :p21 or LOWER("PER"."NPWP") LIKE :p22 or LOWER("PEG"."ID") LIKE :p23 or LOWER("PEG"."PERSONAL_ID") LIKE :p24 or LOWER("PEG"."KODE_FINGER") LIKE :p25 or LOWER("PEG"."STATUS_KERJA") LIKE :p26 or LOWER("SAT"."UNIT_ID") LIKE :p27 or LOWER("PEG"."AKTIF") LIKE :p28 or LOWER("SAT"."NO_SK") LIKE :p29 or LOWER("SAT"."TGL_SK") LIKE :p30)) count_row_table Bindings : [1,SG,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%,%lak%] (SQL: select count(*) as aggregate from (select '1' as "ROW_COUNT" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = 1 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = SG and (LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %lak% or LOWER("PEG"."NIP") LIKE %lak% or LOWER("PER"."NAMA") LIKE %lak% or LOWER("U"."NAMA") LIKE %lak% or LOWER("PEG"."AKTIF") LIKE %lak% or LOWER("PEG"."TMT_MASUK") LIKE %lak% or LOWER("PEG"."TMT_BERHENTI") LIKE %lak% or LOWER("PER"."NO_REKENING") LIKE %lak% or LOWER("PER"."NIK") LIKE %lak% or LOWER("PER"."GENDER") LIKE %lak% or LOWER("PER"."TEMPAT_LAHIR") LIKE %lak% or LOWER("PER"."TGL_LAHIR") LIKE %lak% or LOWER("PER"."TELEPON") LIKE %lak% or LOWER("PER"."AGAMA_ID") LIKE %lak% or LOWER("PER"."GOL_DARAH") LIKE %lak% or LOWER("PER"."STATUS_KAWIN") LIKE %lak% or LOWER("PER"."ALAMAT") LIKE %lak% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %lak% or LOWER("PER"."TELP_KERABAT") LIKE %lak% or LOWER("PER"."IBU_KANDUNG") LIKE %lak% or LOWER("PER"."NPWP") LIKE %lak% or LOWER("PEG"."ID") LIKE %lak% or LOWER("PEG"."PERSONAL_ID") LIKE %lak% or LOWER("PEG"."KODE_FINGER") LIKE %lak% or LOWER("PEG"."STATUS_KERJA") LIKE %lak% or LOWER("SAT"."UNIT_ID") LIKE %lak% or LOWER("PEG"."AKTIF") LIKE %lak% or LOWER("SAT"."NO_SK") LIKE %lak% or LOWER("SAT"."TGL_SK") LIKE %lak%)) count_row_table) in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure)) #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select count(*)...', Array, Object(Closure)) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select count(*)...', Array, true) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2094): Illuminate\Database\Query\Builder->get(Array) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2022): Illuminate\Database\Query\Builder->aggregate('count', Array) #6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(108): Illuminate\Database\Query\Builder->count() #7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(540): Yajra\Datatables\Engines\QueryBuilderEngine->count() #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(503): Yajra\Datatables\Engines\BaseEngine->filterRecords() #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #10 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/DataController.php(317): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #11 [internal function]: Modules\Satgas\Http\Controllers\DataController->data_satgas(Object(Illuminate\Http\Request)) #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\DataController), 'data_satgas') #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.data.ind...') #20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #60 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #61 {main} [2024-08-18 11:44:32] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: Error Code : 904 Error Message : ORA-00904: "AKSI": invalid identifier Position : 964 Statement : select t2.* from ( select rownum AS "rn", t1.* from (select "PEG"."ID", "PEG"."NIP", "PER"."NAMA", "PER"."NO_REKENING", "U"."NAMA" as "UNIT", "PEG"."TMT_MASUK", "PEG"."TMT_BERHENTI", "PER"."NIK", "PER"."GENDER", "PER"."TEMPAT_LAHIR", "PER"."TGL_LAHIR", "PER"."TELEPON", "PER"."AGAMA_ID", "PER"."GOL_DARAH", "PER"."STATUS_KAWIN", "PER"."ALAMAT", "PER"."ALAMAT_TINGGAL", "PER"."TELP_KERABAT", "PER"."IBU_KANDUNG", "PER"."NPWP", "PEG"."PERSONAL_ID", "PEG"."KODE_FINGER", "PEG"."STATUS_KERJA", "SAT"."UNIT_ID", "PEG"."AKTIF", "SAT"."NO_SK", "SAT"."TGL_SK", "SAT"."KEGIATAN" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 order by "PEG"."AKTIF" desc, "PEG"."TMT_BERHENTI" asc, "AKSI" asc) t1 ) t2 where t2."rn" between 1 and 15 Bindings : [1,SG] in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8/Statement.php:177 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(323): Yajra\Pdo\Oci8\Statement->execute() #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select t2.* fro...', Array) #2 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select t2.* fro...', Array, Object(Closure)) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select t2.* fro...', Array, Object(Closure)) #4 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select t2.* fro...', Array, true) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(725): Illuminate\Database\Query\Builder->get() #7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(642): Yajra\Datatables\Engines\QueryBuilderEngine->results() #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(595): Yajra\Datatables\Engines\BaseEngine->getProcessedData(true) #9 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(508): Yajra\Datatables\Engines\BaseEngine->render(true) #10 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #11 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/PemberhentianController.php(79): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #12 [internal function]: Modules\Satgas\Http\Controllers\PemberhentianController->data_satgas(Object(Illuminate\Http\Request)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\PemberhentianController), 'data_satgas') #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #19 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.pemberhe...') #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #22 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #25 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #59 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #60 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #61 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #62 {main} Next Illuminate\Database\QueryException: Error Code : 904 Error Message : ORA-00904: "AKSI": invalid identifier Position : 964 Statement : select t2.* from ( select rownum AS "rn", t1.* from (select "PEG"."ID", "PEG"."NIP", "PER"."NAMA", "PER"."NO_REKENING", "U"."NAMA" as "UNIT", "PEG"."TMT_MASUK", "PEG"."TMT_BERHENTI", "PER"."NIK", "PER"."GENDER", "PER"."TEMPAT_LAHIR", "PER"."TGL_LAHIR", "PER"."TELEPON", "PER"."AGAMA_ID", "PER"."GOL_DARAH", "PER"."STATUS_KAWIN", "PER"."ALAMAT", "PER"."ALAMAT_TINGGAL", "PER"."TELP_KERABAT", "PER"."IBU_KANDUNG", "PER"."NPWP", "PEG"."PERSONAL_ID", "PEG"."KODE_FINGER", "PEG"."STATUS_KERJA", "SAT"."UNIT_ID", "PEG"."AKTIF", "SAT"."NO_SK", "SAT"."TGL_SK", "SAT"."KEGIATAN" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = :p0 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = :p1 order by "PEG"."AKTIF" desc, "PEG"."TMT_BERHENTI" asc, "AKSI" asc) t1 ) t2 where t2."rn" between 1 and 15 Bindings : [1,SG] (SQL: select t2.* from ( select rownum AS "rn", t1.* from (select "PEG"."ID", "PEG"."NIP", "PER"."NAMA", "PER"."NO_REKENING", "U"."NAMA" as "UNIT", "PEG"."TMT_MASUK", "PEG"."TMT_BERHENTI", "PER"."NIK", "PER"."GENDER", "PER"."TEMPAT_LAHIR", "PER"."TGL_LAHIR", "PER"."TELEPON", "PER"."AGAMA_ID", "PER"."GOL_DARAH", "PER"."STATUS_KAWIN", "PER"."ALAMAT", "PER"."ALAMAT_TINGGAL", "PER"."TELP_KERABAT", "PER"."IBU_KANDUNG", "PER"."NPWP", "PEG"."PERSONAL_ID", "PEG"."KODE_FINGER", "PEG"."STATUS_KERJA", "SAT"."UNIT_ID", "PEG"."AKTIF", "SAT"."NO_SK", "SAT"."TGL_SK", "SAT"."KEGIATAN" from "HRIS_PEGAWAI" peg left join "HRIS_PERSONAL" per on "PER"."ID" = "PEG"."PERSONAL_ID" left join "HRIS_KELENGKAPAN_SATGAS" sat on "SAT"."PEGAWAI_ID" = "PEG"."ID" and "SAT"."AKTIF" = 1 left join "HRIS_UNIT" u on "U"."ID" = "SAT"."UNIT_ID" left join "HRIS_STATUS_KERJA" hsk on "HSK"."ID" = "PEG"."STATUS_KERJA" where "HSK"."KODE" = SG order by "PEG"."AKTIF" desc, "PEG"."TMT_BERHENTI" asc, "AKSI" asc) t1 ) t2 where t2."rn" between 1 and 15) in /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php:647 Stack trace: #0 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select t2.* fro...', Array, Object(Closure)) #1 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select t2.* fro...', Array, Object(Closure)) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php(103): Illuminate\Database\Connection->select('select t2.* fro...', Array, true) #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1703): Yajra\Oci8\Query\OracleBuilder->runSelect() #4 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(725): Illuminate\Database\Query\Builder->get() #5 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(642): Yajra\Datatables\Engines\QueryBuilderEngine->results() #6 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(595): Yajra\Datatables\Engines\BaseEngine->getProcessedData(true) #7 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/BaseEngine.php(508): Yajra\Datatables\Engines\BaseEngine->render(true) #8 /var/www/apps/hris/vendor/yajra/laravel-datatables-oracle/src/Engines/QueryBuilderEngine.php(79): Yajra\Datatables\Engines\BaseEngine->make(true, false) #9 /var/www/apps/hris/app/Modules/Satgas/Http/Controllers/PemberhentianController.php(79): Yajra\Datatables\Engines\QueryBuilderEngine->make(true) #10 [internal function]: Modules\Satgas\Http\Controllers\PemberhentianController->data_satgas(Object(Illuminate\Http\Request)) #11 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('data_satgas', Array) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Satgas\Http\Controllers\PemberhentianController), 'data_satgas') #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #17 /var/www/apps/hris/vendor/caffeinated/shinobi/src/Middleware/UserHasPermission.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Caffeinated\Shinobi\Middleware\UserHasPermission->handle(Object(Illuminate\Http\Request), Object(Closure), 'satgas.pemberhe...') #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #20 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #56 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #57 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #58 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #59 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #60 {main} [2024-08-18 14:41:33] local.ERROR: ErrorException: Connection closed by server in /var/www/apps/hris/vendor/phpseclib/phpseclib/phpseclib/Net/SSH2.php:1228 Stack trace: #0 [internal function]: Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(1024, 'Connection clos...', '/var/www/apps/h...', 1228, Array) #1 /var/www/apps/hris/vendor/phpseclib/phpseclib/phpseclib/Net/SSH2.php(1228): user_error('Connection clos...') #2 /var/www/apps/hris/vendor/phpseclib/phpseclib/phpseclib/Net/SSH2.php(2101): phpseclib\Net\SSH2->_connect() #3 [internal function]: phpseclib\Net\SSH2->_login('webadmin', 'webadminpass') #4 /var/www/apps/hris/vendor/phpseclib/phpseclib/phpseclib/Net/SFTP.php(414): call_user_func_array(Array, Array) #5 /var/www/apps/hris/vendor/league/flysystem-sftp/src/SftpAdapter.php(223): phpseclib\Net\SFTP->login('webadmin', 'webadminpass') #6 /var/www/apps/hris/vendor/league/flysystem-sftp/src/SftpAdapter.php(195): League\Flysystem\Sftp\SftpAdapter->login() #7 /var/www/apps/hris/vendor/league/flysystem/src/Adapter/AbstractFtpAdapter.php(643): League\Flysystem\Sftp\SftpAdapter->connect() #8 /var/www/apps/hris/vendor/league/flysystem-sftp/src/SftpAdapter.php(547): League\Flysystem\Adapter\AbstractFtpAdapter->getConnection() #9 /var/www/apps/hris/vendor/league/flysystem-sftp/src/SftpAdapter.php(539): League\Flysystem\Sftp\SftpAdapter->getMetadata('foto/Satgas.200...') #10 /var/www/apps/hris/vendor/league/flysystem/src/Filesystem.php(57): League\Flysystem\Sftp\SftpAdapter->has('foto/Satgas.200...') #11 [internal function]: League\Flysystem\Filesystem->has('foto/Satgas.200...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Filesystem/FilesystemAdapter.php(475): call_user_func_array(Array, Array) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Filesystem/FilesystemManager.php(328): Illuminate\Filesystem\FilesystemAdapter->__call('has', Array) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Filesystem\FilesystemManager->__call('has', Array) #15 /var/www/apps/hris/routes/web.php(90): Illuminate\Support\Facades\Facade::__callStatic('has', Array) #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(189): App\Providers\RouteServiceProvider->{closure}('Satgas.20058.JP...') #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(163): Illuminate\Routing\Route->runCallable() #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #20 /var/www/apps/hris/app/Http/Middleware/LogAccessRoute.php(22): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\LogAccessRoute->handle(Object(Illuminate\Http\Request), Object(Closure)) #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #23 /var/www/apps/hris/app/Http/Middleware/Maintenance.php(33): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\Maintenance->handle(Object(Illuminate\Http\Request), Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #28 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #29 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(65): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #30 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure)) #31 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #32 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #33 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #34 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #35 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #36 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure)) #37 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #38 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #39 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure)) #40 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #41 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #42 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure)) #43 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #44 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #45 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #46 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #47 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #48 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #49 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #50 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #51 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #52 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #53 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #54 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #55 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #56 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #57 {main} [2024-08-18 21:15:54] local.ERROR: ErrorException: Trying to get property 'kode' of non-object in /var/www/apps/hris/app/Modules/Api/Entities/Mdl_absen.php:355 Stack trace: #0 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_absen.php(355): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(8, 'Trying to get p...', '/var/www/apps/h...', 355, Array) #1 /var/www/apps/hris/app/Modules/Api/Http/Controllers/AbsenController.php(76): Modules\Api\Entities\Mdl_absen->cuti('M.23.006', '2024') #2 [internal function]: Modules\Api\Http\Controllers\AbsenController->cuti(Object(Illuminate\Http\Request), 'M.23.006', '2024') #3 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(55): call_user_func_array(Array, Array) #4 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(44): Illuminate\Routing\Controller->callAction('cuti', Array) #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(203): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Modules\Api\Http\Controllers\AbsenController), 'cuti') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Route.php(160): Illuminate\Routing\Route->runController() #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(559): Illuminate\Routing\Route->run() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #9 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #10 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #11 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(520): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(46): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #22 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #25 {main}