[2024-09-29 07:32:23] local.INFO: array ( 'sppd_laporan_id' => '4044', 'latitude' => '-7.7936862', 'longitude' => '110.3613451', 'uraian' => 'penerapan K3 pada perpipaan', 'logtime' => '2024-09-29 07:32:23', 'foto' => 'sppd/202409/1.06.01432_20240929073223_4044.JPG', ) [2024-09-29 09:00:09] local.INFO: notif error : {"error":{"code":404,"message":"Requested entity was not found.","status":"NOT_FOUND","details":[{"@type":"type.googleapis.com\/google.firebase.fcm.v1.FcmError","errorCode":"UNREGISTERED"}]}} [2024-09-29 09:00:11] local.INFO: notif error : {"error":{"code":404,"message":"Requested entity was not found.","status":"NOT_FOUND","details":[{"@type":"type.googleapis.com\/google.firebase.fcm.v1.FcmError","errorCode":"UNREGISTERED"}]}} [2024-09-29 09:00:17] local.INFO: notif error : {"error":{"code":404,"message":"Requested entity was not found.","status":"NOT_FOUND","details":[{"@type":"type.googleapis.com\/google.firebase.fcm.v1.FcmError","errorCode":"UNREGISTERED"}]}} [2024-09-29 09:00:53] local.INFO: notif error : {"error":{"code":404,"message":"Requested entity was not found.","status":"NOT_FOUND","details":[{"@type":"type.googleapis.com\/google.firebase.fcm.v1.FcmError","errorCode":"UNREGISTERED"}]}} [2024-09-29 19:40:01] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1013): Illuminate\Database\DatabaseManager->connection('oracle') #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(979): Illuminate\Database\Eloquent\Model::resolveConnection(NULL) #9 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(843): Illuminate\Database\Eloquent\Model->getConnection() #10 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(804): Illuminate\Database\Eloquent\Model->newBaseQueryBuilder() #11 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(788): Illuminate\Database\Eloquent\Model->newQueryWithoutScopes() #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1316): Illuminate\Database\Eloquent\Model->newQuery() #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1328): Illuminate\Database\Eloquent\Model->__call('whereNull', Array) #14 /var/www/apps/hris/app/Console/Commands/InsertLocationSppd.php(43): Illuminate\Database\Eloquent\Model::__callStatic('whereNull', Array) #15 [internal function]: App\Console\Commands\InsertLocationSppd->handle() #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(28): call_user_func_array(Array, Array) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/helpers.php(912): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(86): value(Object(Closure)) #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(30): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure)) #20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Container/Container.php(524): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Illuminate\Container\Container->call(Array) #22 /var/www/apps/hris/vendor/symfony/console/Command/Command.php(262): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Console/Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #24 /var/www/apps/hris/vendor/symfony/console/Application.php(826): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #25 /var/www/apps/hris/vendor/symfony/console/Application.php(189): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\InsertLocationSppd), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #26 /var/www/apps/hris/vendor/symfony/console/Application.php(120): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(123): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #28 /var/www/apps/hris/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #29 {main} [2024-09-29 19:40:47] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:40:47] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:41:39] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:41:54] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:41:54] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:42:51] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:42:52] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:50:00] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:50:00] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:50:01] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1013): Illuminate\Database\DatabaseManager->connection('oracle') #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(979): Illuminate\Database\Eloquent\Model::resolveConnection(NULL) #9 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(843): Illuminate\Database\Eloquent\Model->getConnection() #10 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(804): Illuminate\Database\Eloquent\Model->newBaseQueryBuilder() #11 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(788): Illuminate\Database\Eloquent\Model->newQueryWithoutScopes() #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1316): Illuminate\Database\Eloquent\Model->newQuery() #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1328): Illuminate\Database\Eloquent\Model->__call('whereNull', Array) #14 /var/www/apps/hris/app/Console/Commands/InsertLocationSppd.php(43): Illuminate\Database\Eloquent\Model::__callStatic('whereNull', Array) #15 [internal function]: App\Console\Commands\InsertLocationSppd->handle() #16 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(28): call_user_func_array(Array, Array) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/helpers.php(912): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(86): value(Object(Closure)) #19 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(30): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure)) #20 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Container/Container.php(524): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL) #21 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Illuminate\Container\Container->call(Array) #22 /var/www/apps/hris/vendor/symfony/console/Command/Command.php(262): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #23 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Console/Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #24 /var/www/apps/hris/vendor/symfony/console/Application.php(826): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #25 /var/www/apps/hris/vendor/symfony/console/Application.php(189): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\InsertLocationSppd), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #26 /var/www/apps/hris/vendor/symfony/console/Application.php(120): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #27 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(123): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #28 /var/www/apps/hris/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #29 {main} [2024-09-29 19:50:22] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:50:22] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:51:07] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:51:25] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 19:51:25] local.ERROR: Yajra\Pdo\Oci8\Exceptions\Oci8Exception: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved. in /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php:460 Stack trace: #0 /var/www/apps/hris/vendor/yajra/laravel-pdo-via-oci8/src/Pdo/Oci8.php(78): Yajra\Pdo\Oci8->connect('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array, 'WE8MSWIN1252') #1 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(204): Yajra\Pdo\Oci8->__construct('(DESCRIPTION = ...', 'hrisdb', 'pass4hrisdb', Array) #2 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Connectors/OracleConnector.php(35): Yajra\Oci8\Connectors\OracleConnector->createConnection('(DESCRIPTION = ...', Array, Array) #3 /var/www/apps/hris/vendor/yajra/laravel-oci8/src/Oci8/Oci8ServiceProvider.php(48): Yajra\Oci8\Connectors\OracleConnector->connect(Array) #4 [internal function]: Yajra\Oci8\Oci8ServiceProvider->Yajra\Oci8\{closure}(Array, 'oracle') #5 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(106): call_user_func(Object(Closure), Array, 'oracle') #6 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(71): Illuminate\Database\DatabaseManager->makeConnection('oracle') #7 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(322): Illuminate\Database\DatabaseManager->connection() #8 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(221): Illuminate\Database\DatabaseManager->__call('table', Array) #9 /var/www/apps/hris/app/Models/MY_Model.php(20): Illuminate\Support\Facades\Facade::__callStatic('table', Array) #10 /var/www/apps/hris/app/Modules/Api/Entities/Mdl_api.php(11): App\Models\MY_Model->get('hris_user') #11 /var/www/apps/hris/app/Http/Middleware/checkHeader.php(23): Modules\Api\Entities\Mdl_api->key_check('rL6IHNupVcZUgij...') #12 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(148): App\Http\Middleware\checkHeader->handle(Object(Illuminate\Http\Request), Object(Closure)) #13 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #14 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #15 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(561): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #16 /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)) #17 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Routing/Router.php(498): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #18 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(174): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #19 /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)) #20 /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)) #21 /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)) #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/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(102): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #24 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(149): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #25 /var/www/apps/hris/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #26 /var/www/apps/hris/public/index.php(53): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #27 {main} [2024-09-29 23:19:02] 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%] 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(330): 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%,%a%] (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."CHECKBOX") LIKE %a% or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %a% or LOWER("PEG"."NIP") LIKE %a% or LOWER("PER"."NAMA") LIKE %a% or LOWER("U"."NAMA") LIKE %a% or LOWER("PEG"."AKTIF") LIKE %a% or LOWER("PEG"."TMT_MASUK") LIKE %a% or LOWER("PEG"."TMT_BERHENTI") LIKE %a% or LOWER("PER"."NO_REKENING") LIKE %a% or LOWER("PER"."NIK") LIKE %a% or LOWER("PER"."GENDER") LIKE %a% or LOWER("PER"."TEMPAT_LAHIR") LIKE %a% or LOWER("PER"."TGL_LAHIR") LIKE %a% or LOWER("PER"."TELEPON") LIKE %a% or LOWER("PER"."AGAMA_ID") LIKE %a% or LOWER("PER"."GOL_DARAH") LIKE %a% or LOWER("PER"."STATUS_KAWIN") LIKE %a% or LOWER("PER"."ALAMAT") LIKE %a% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %a% or LOWER("PER"."TELP_KERABAT") LIKE %a% or LOWER("PER"."IBU_KANDUNG") LIKE %a% or LOWER("PER"."NPWP") LIKE %a% or LOWER("PEG"."ID") LIKE %a% or LOWER("PEG"."PERSONAL_ID") LIKE %a% or LOWER("PEG"."KODE_FINGER") LIKE %a% or LOWER("PEG"."STATUS_KERJA") LIKE %a% or LOWER("SAT"."UNIT_ID") LIKE %a% or LOWER("PEG"."AKTIF") LIKE %a% or LOWER("SAT"."NO_SK") LIKE %a% or LOWER("SAT"."TGL_SK") LIKE %a%)) 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(330): 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-09-29 23:19:02] 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%] 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(330): 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%,%ador%] (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."CHECKBOX") LIKE %ador% or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %ador% or LOWER("PEG"."NIP") LIKE %ador% or LOWER("PER"."NAMA") LIKE %ador% or LOWER("U"."NAMA") LIKE %ador% or LOWER("PEG"."AKTIF") LIKE %ador% or LOWER("PEG"."TMT_MASUK") LIKE %ador% or LOWER("PEG"."TMT_BERHENTI") LIKE %ador% or LOWER("PER"."NO_REKENING") LIKE %ador% or LOWER("PER"."NIK") LIKE %ador% or LOWER("PER"."GENDER") LIKE %ador% or LOWER("PER"."TEMPAT_LAHIR") LIKE %ador% or LOWER("PER"."TGL_LAHIR") LIKE %ador% or LOWER("PER"."TELEPON") LIKE %ador% or LOWER("PER"."AGAMA_ID") LIKE %ador% or LOWER("PER"."GOL_DARAH") LIKE %ador% or LOWER("PER"."STATUS_KAWIN") LIKE %ador% or LOWER("PER"."ALAMAT") LIKE %ador% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %ador% or LOWER("PER"."TELP_KERABAT") LIKE %ador% or LOWER("PER"."IBU_KANDUNG") LIKE %ador% or LOWER("PER"."NPWP") LIKE %ador% or LOWER("PEG"."ID") LIKE %ador% or LOWER("PEG"."PERSONAL_ID") LIKE %ador% or LOWER("PEG"."KODE_FINGER") LIKE %ador% or LOWER("PEG"."STATUS_KERJA") LIKE %ador% or LOWER("SAT"."UNIT_ID") LIKE %ador% or LOWER("PEG"."AKTIF") LIKE %ador% or LOWER("SAT"."NO_SK") LIKE %ador% or LOWER("SAT"."TGL_SK") LIKE %ador%)) 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(330): 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-09-29 23:19:07] 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%] 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(330): 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%,%adora%] (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."CHECKBOX") LIKE %adora% or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %adora% or LOWER("PEG"."NIP") LIKE %adora% or LOWER("PER"."NAMA") LIKE %adora% or LOWER("U"."NAMA") LIKE %adora% or LOWER("PEG"."AKTIF") LIKE %adora% or LOWER("PEG"."TMT_MASUK") LIKE %adora% or LOWER("PEG"."TMT_BERHENTI") LIKE %adora% or LOWER("PER"."NO_REKENING") LIKE %adora% or LOWER("PER"."NIK") LIKE %adora% or LOWER("PER"."GENDER") LIKE %adora% or LOWER("PER"."TEMPAT_LAHIR") LIKE %adora% or LOWER("PER"."TGL_LAHIR") LIKE %adora% or LOWER("PER"."TELEPON") LIKE %adora% or LOWER("PER"."AGAMA_ID") LIKE %adora% or LOWER("PER"."GOL_DARAH") LIKE %adora% or LOWER("PER"."STATUS_KAWIN") LIKE %adora% or LOWER("PER"."ALAMAT") LIKE %adora% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %adora% or LOWER("PER"."TELP_KERABAT") LIKE %adora% or LOWER("PER"."IBU_KANDUNG") LIKE %adora% or LOWER("PER"."NPWP") LIKE %adora% or LOWER("PEG"."ID") LIKE %adora% or LOWER("PEG"."PERSONAL_ID") LIKE %adora% or LOWER("PEG"."KODE_FINGER") LIKE %adora% or LOWER("PEG"."STATUS_KERJA") LIKE %adora% or LOWER("SAT"."UNIT_ID") LIKE %adora% or LOWER("PEG"."AKTIF") LIKE %adora% or LOWER("SAT"."NO_SK") LIKE %adora% or LOWER("SAT"."TGL_SK") LIKE %adora%)) 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(330): 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-09-29 23:19:08] 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%] 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(330): 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%] (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."CHECKBOX") LIKE %adorada% or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %adorada% or LOWER("PEG"."NIP") LIKE %adorada% or LOWER("PER"."NAMA") LIKE %adorada% or LOWER("U"."NAMA") LIKE %adorada% or LOWER("PEG"."AKTIF") LIKE %adorada% or LOWER("PEG"."TMT_MASUK") LIKE %adorada% or LOWER("PEG"."TMT_BERHENTI") LIKE %adorada% or LOWER("PER"."NO_REKENING") LIKE %adorada% or LOWER("PER"."NIK") LIKE %adorada% or LOWER("PER"."GENDER") LIKE %adorada% or LOWER("PER"."TEMPAT_LAHIR") LIKE %adorada% or LOWER("PER"."TGL_LAHIR") LIKE %adorada% or LOWER("PER"."TELEPON") LIKE %adorada% or LOWER("PER"."AGAMA_ID") LIKE %adorada% or LOWER("PER"."GOL_DARAH") LIKE %adorada% or LOWER("PER"."STATUS_KAWIN") LIKE %adorada% or LOWER("PER"."ALAMAT") LIKE %adorada% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %adorada% or LOWER("PER"."TELP_KERABAT") LIKE %adorada% or LOWER("PER"."IBU_KANDUNG") LIKE %adorada% or LOWER("PER"."NPWP") LIKE %adorada% or LOWER("PEG"."ID") LIKE %adorada% or LOWER("PEG"."PERSONAL_ID") LIKE %adorada% or LOWER("PEG"."KODE_FINGER") LIKE %adorada% or LOWER("PEG"."STATUS_KERJA") LIKE %adorada% or LOWER("SAT"."UNIT_ID") LIKE %adorada% or LOWER("PEG"."AKTIF") LIKE %adorada% or LOWER("SAT"."NO_SK") LIKE %adorada% or LOWER("SAT"."TGL_SK") LIKE %adorada%)) 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(330): 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-09-29 23:19: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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%] 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(330): 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%] (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."CHECKBOX") LIKE %adorada% or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %adorada% or LOWER("PEG"."NIP") LIKE %adorada% or LOWER("PER"."NAMA") LIKE %adorada% or LOWER("U"."NAMA") LIKE %adorada% or LOWER("PEG"."AKTIF") LIKE %adorada% or LOWER("PEG"."TMT_MASUK") LIKE %adorada% or LOWER("PEG"."TMT_BERHENTI") LIKE %adorada% or LOWER("PER"."NO_REKENING") LIKE %adorada% or LOWER("PER"."NIK") LIKE %adorada% or LOWER("PER"."GENDER") LIKE %adorada% or LOWER("PER"."TEMPAT_LAHIR") LIKE %adorada% or LOWER("PER"."TGL_LAHIR") LIKE %adorada% or LOWER("PER"."TELEPON") LIKE %adorada% or LOWER("PER"."AGAMA_ID") LIKE %adorada% or LOWER("PER"."GOL_DARAH") LIKE %adorada% or LOWER("PER"."STATUS_KAWIN") LIKE %adorada% or LOWER("PER"."ALAMAT") LIKE %adorada% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %adorada% or LOWER("PER"."TELP_KERABAT") LIKE %adorada% or LOWER("PER"."IBU_KANDUNG") LIKE %adorada% or LOWER("PER"."NPWP") LIKE %adorada% or LOWER("PEG"."ID") LIKE %adorada% or LOWER("PEG"."PERSONAL_ID") LIKE %adorada% or LOWER("PEG"."KODE_FINGER") LIKE %adorada% or LOWER("PEG"."STATUS_KERJA") LIKE %adorada% or LOWER("SAT"."UNIT_ID") LIKE %adorada% or LOWER("PEG"."AKTIF") LIKE %adorada% or LOWER("SAT"."NO_SK") LIKE %adorada% or LOWER("SAT"."TGL_SK") LIKE %adorada%)) 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(330): 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-09-29 23:19:48] 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%] 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(330): 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%,%adorada%] (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."CHECKBOX") LIKE %adorada% or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %adorada% or LOWER("PEG"."NIP") LIKE %adorada% or LOWER("PER"."NAMA") LIKE %adorada% or LOWER("U"."NAMA") LIKE %adorada% or LOWER("PEG"."AKTIF") LIKE %adorada% or LOWER("PEG"."TMT_MASUK") LIKE %adorada% or LOWER("PEG"."TMT_BERHENTI") LIKE %adorada% or LOWER("PER"."NO_REKENING") LIKE %adorada% or LOWER("PER"."NIK") LIKE %adorada% or LOWER("PER"."GENDER") LIKE %adorada% or LOWER("PER"."TEMPAT_LAHIR") LIKE %adorada% or LOWER("PER"."TGL_LAHIR") LIKE %adorada% or LOWER("PER"."TELEPON") LIKE %adorada% or LOWER("PER"."AGAMA_ID") LIKE %adorada% or LOWER("PER"."GOL_DARAH") LIKE %adorada% or LOWER("PER"."STATUS_KAWIN") LIKE %adorada% or LOWER("PER"."ALAMAT") LIKE %adorada% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %adorada% or LOWER("PER"."TELP_KERABAT") LIKE %adorada% or LOWER("PER"."IBU_KANDUNG") LIKE %adorada% or LOWER("PER"."NPWP") LIKE %adorada% or LOWER("PEG"."ID") LIKE %adorada% or LOWER("PEG"."PERSONAL_ID") LIKE %adorada% or LOWER("PEG"."KODE_FINGER") LIKE %adorada% or LOWER("PEG"."STATUS_KERJA") LIKE %adorada% or LOWER("SAT"."UNIT_ID") LIKE %adorada% or LOWER("PEG"."AKTIF") LIKE %adorada% or LOWER("SAT"."NO_SK") LIKE %adorada% or LOWER("SAT"."TGL_SK") LIKE %adorada%)) 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(330): 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-09-29 23:19:53] 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%] 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(330): 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."CHECKBOX") LIKE :p2 or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE :p3 or LOWER("PEG"."NIP") LIKE :p4 or LOWER("PER"."NAMA") LIKE :p5 or LOWER("U"."NAMA") LIKE :p6 or LOWER("PEG"."AKTIF") LIKE :p7 or LOWER("PEG"."TMT_MASUK") LIKE :p8 or LOWER("PEG"."TMT_BERHENTI") LIKE :p9 or LOWER("PER"."NO_REKENING") LIKE :p10 or LOWER("PER"."NIK") LIKE :p11 or LOWER("PER"."GENDER") LIKE :p12 or LOWER("PER"."TEMPAT_LAHIR") LIKE :p13 or LOWER("PER"."TGL_LAHIR") LIKE :p14 or LOWER("PER"."TELEPON") LIKE :p15 or LOWER("PER"."AGAMA_ID") LIKE :p16 or LOWER("PER"."GOL_DARAH") LIKE :p17 or LOWER("PER"."STATUS_KAWIN") LIKE :p18 or LOWER("PER"."ALAMAT") LIKE :p19 or LOWER("PER"."ALAMAT_TINGGAL") LIKE :p20 or LOWER("PER"."TELP_KERABAT") LIKE :p21 or LOWER("PER"."IBU_KANDUNG") LIKE :p22 or LOWER("PER"."NPWP") LIKE :p23 or LOWER("PEG"."ID") LIKE :p24 or LOWER("PEG"."PERSONAL_ID") LIKE :p25 or LOWER("PEG"."KODE_FINGER") LIKE :p26 or LOWER("PEG"."STATUS_KERJA") LIKE :p27 or LOWER("SAT"."UNIT_ID") LIKE :p28 or LOWER("PEG"."AKTIF") LIKE :p29 or LOWER("SAT"."NO_SK") LIKE :p30 or LOWER("SAT"."TGL_SK") LIKE :p31)) count_row_table Bindings : [1,SG,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%,%adorad%] (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."CHECKBOX") LIKE %adorad% or LOWER("HRIS_PEGAWAI" peg."AKSI") LIKE %adorad% or LOWER("PEG"."NIP") LIKE %adorad% or LOWER("PER"."NAMA") LIKE %adorad% or LOWER("U"."NAMA") LIKE %adorad% or LOWER("PEG"."AKTIF") LIKE %adorad% or LOWER("PEG"."TMT_MASUK") LIKE %adorad% or LOWER("PEG"."TMT_BERHENTI") LIKE %adorad% or LOWER("PER"."NO_REKENING") LIKE %adorad% or LOWER("PER"."NIK") LIKE %adorad% or LOWER("PER"."GENDER") LIKE %adorad% or LOWER("PER"."TEMPAT_LAHIR") LIKE %adorad% or LOWER("PER"."TGL_LAHIR") LIKE %adorad% or LOWER("PER"."TELEPON") LIKE %adorad% or LOWER("PER"."AGAMA_ID") LIKE %adorad% or LOWER("PER"."GOL_DARAH") LIKE %adorad% or LOWER("PER"."STATUS_KAWIN") LIKE %adorad% or LOWER("PER"."ALAMAT") LIKE %adorad% or LOWER("PER"."ALAMAT_TINGGAL") LIKE %adorad% or LOWER("PER"."TELP_KERABAT") LIKE %adorad% or LOWER("PER"."IBU_KANDUNG") LIKE %adorad% or LOWER("PER"."NPWP") LIKE %adorad% or LOWER("PEG"."ID") LIKE %adorad% or LOWER("PEG"."PERSONAL_ID") LIKE %adorad% or LOWER("PEG"."KODE_FINGER") LIKE %adorad% or LOWER("PEG"."STATUS_KERJA") LIKE %adorad% or LOWER("SAT"."UNIT_ID") LIKE %adorad% or LOWER("PEG"."AKTIF") LIKE %adorad% or LOWER("SAT"."NO_SK") LIKE %adorad% or LOWER("SAT"."TGL_SK") LIKE %adorad%)) 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(330): 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}