[2025-06-07 00:40:04] Production.INFO: next invoice date [2025-06-07 00:40:04] Production.INFO: 2025-07-07 [2025-06-07 00:40:04] Production.INFO: getdaysdiff [2025-06-07 00:40:04] Production.INFO: +30 [2025-06-07 00:40:04] Production.INFO: call prc_setAccountDiscountPlan (155,11,1,30,30,'RMScheduler',2025-06-07 00:40:04,1,0,,,0) [2025-06-07 00:40:05] Production.INFO: next invoice date [2025-06-07 00:40:05] Production.INFO: 2025-07-07 [2025-06-07 00:40:05] Production.INFO: getdaysdiff [2025-06-07 00:40:05] Production.INFO: +30 [2025-06-07 00:40:05] Production.INFO: call prc_setAccountDiscountPlan (232,16,1,30,30,'RMScheduler',2025-06-07 00:40:04,1,0,,,0) [2025-06-07 00:40:05] Production.INFO: next invoice date [2025-06-07 00:40:05] Production.INFO: 2025-07-07 [2025-06-07 00:40:05] Production.INFO: getdaysdiff [2025-06-07 00:40:05] Production.INFO: +30 [2025-06-07 00:40:05] Production.INFO: call prc_setAccountDiscountPlan (232,13,2,30,30,'RMScheduler',2025-06-07 00:40:04,1,0,,,0) [2025-06-07 00:40:05] Production.INFO: next invoice date [2025-06-07 00:40:05] Production.INFO: 2025-07-07 [2025-06-07 00:40:05] Production.INFO: getdaysdiff [2025-06-07 00:40:05] Production.INFO: +30 [2025-06-07 00:40:05] Production.INFO: call prc_setAccountDiscountPlan (232,11,1,30,30,'RMScheduler',2025-06-07 00:40:04,0,0,,,0) [2025-06-07 00:40:05] Production.INFO: next invoice date [2025-06-07 00:40:05] Production.INFO: 2025-07-07 [2025-06-07 00:40:05] Production.INFO: getdaysdiff [2025-06-07 00:40:05] Production.INFO: +30 [2025-06-07 00:40:05] Production.INFO: call prc_setAccountDiscountPlan (232,13,2,30,30,'RMScheduler',2025-06-07 00:40:04,0,0,,,0) [2025-06-07 00:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 00:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 00:40:18] Production.INFO: count ==3705 [2025-06-07 00:40:20] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 00:40:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 00:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15248659', 'tblTempUsageDetail_20' ) start [2025-06-07 00:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15248659', 'tblTempUsageDetail_20' ) end [2025-06-07 00:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15248659', 'tblTempVendorCDR_20' ) start [2025-06-07 00:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15248659', 'tblTempVendorCDR_20' ) end [2025-06-07 00:40:20] Production.INFO: ProcessCDR(1,15248659,1,1,2) [2025-06-07 00:40:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15248659,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 00:40:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15248659,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 00:40:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15248659,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 00:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15248659,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 00:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15248659', 'tblTempUsageDetail_20' ) start [2025-06-07 00:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15248659', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 00:40:30] Production.INFO: ==15952== Releasing lock... [2025-06-07 00:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 00:40:30] Production.INFO: 56.25 MB #Memory Used# [2025-06-07 01:40:04] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 01:40:04] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 01:40:17] Production.INFO: count ==3705 [2025-06-07 01:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 01:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 01:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15248906', 'tblTempUsageDetail_20' ) start [2025-06-07 01:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15248906', 'tblTempUsageDetail_20' ) end [2025-06-07 01:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15248906', 'tblTempVendorCDR_20' ) start [2025-06-07 01:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15248906', 'tblTempVendorCDR_20' ) end [2025-06-07 01:40:19] Production.INFO: ProcessCDR(1,15248906,1,1,2) [2025-06-07 01:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15248906,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 01:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15248906,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 01:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15248906,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 01:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15248906,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 01:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15248906', 'tblTempUsageDetail_20' ) start [2025-06-07 01:40:29] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15248906', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 01:40:29] Production.INFO: ==20968== Releasing lock... [2025-06-07 01:40:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 01:40:29] Production.INFO: 56 MB #Memory Used# [2025-06-07 02:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 02:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 02:40:18] Production.INFO: count ==3705 [2025-06-07 02:40:20] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 02:40:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 02:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15249153', 'tblTempUsageDetail_20' ) start [2025-06-07 02:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15249153', 'tblTempUsageDetail_20' ) end [2025-06-07 02:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15249153', 'tblTempVendorCDR_20' ) start [2025-06-07 02:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15249153', 'tblTempVendorCDR_20' ) end [2025-06-07 02:40:20] Production.INFO: ProcessCDR(1,15249153,1,1,2) [2025-06-07 02:40:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15249153,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 02:40:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15249153,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 02:40:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15249153,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 02:40:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15249153,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 02:40:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15249153', 'tblTempUsageDetail_20' ) start [2025-06-07 02:40:31] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15249153', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 02:40:31] Production.INFO: ==26196== Releasing lock... [2025-06-07 02:40:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 02:40:31] Production.INFO: 56 MB #Memory Used# [2025-06-07 03:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 03:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 03:40:17] Production.INFO: count ==3705 [2025-06-07 03:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 03:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 03:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15249399', 'tblTempUsageDetail_20' ) start [2025-06-07 03:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15249399', 'tblTempUsageDetail_20' ) end [2025-06-07 03:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15249399', 'tblTempVendorCDR_20' ) start [2025-06-07 03:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15249399', 'tblTempVendorCDR_20' ) end [2025-06-07 03:40:19] Production.INFO: ProcessCDR(1,15249399,1,1,2) [2025-06-07 03:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15249399,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 03:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15249399,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 03:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15249399,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 03:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15249399,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 03:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15249399', 'tblTempUsageDetail_20' ) start [2025-06-07 03:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15249399', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 03:40:30] Production.INFO: ==31069== Releasing lock... [2025-06-07 03:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 03:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 04:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 04:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 04:40:17] Production.INFO: count ==3705 [2025-06-07 04:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 04:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 04:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15249649', 'tblTempUsageDetail_20' ) start [2025-06-07 04:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15249649', 'tblTempUsageDetail_20' ) end [2025-06-07 04:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15249649', 'tblTempVendorCDR_20' ) start [2025-06-07 04:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15249649', 'tblTempVendorCDR_20' ) end [2025-06-07 04:40:19] Production.INFO: ProcessCDR(1,15249649,1,1,2) [2025-06-07 04:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15249649,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 04:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15249649,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 04:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15249649,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 04:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15249649,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 04:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15249649', 'tblTempUsageDetail_20' ) start [2025-06-07 04:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15249649', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 04:40:30] Production.INFO: ==3311== Releasing lock... [2025-06-07 04:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 04:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 05:40:04] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 05:40:04] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 05:40:18] Production.INFO: count ==3705 [2025-06-07 05:40:20] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 05:40:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 05:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15249895', 'tblTempUsageDetail_20' ) start [2025-06-07 05:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15249895', 'tblTempUsageDetail_20' ) end [2025-06-07 05:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15249895', 'tblTempVendorCDR_20' ) start [2025-06-07 05:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15249895', 'tblTempVendorCDR_20' ) end [2025-06-07 05:40:20] Production.INFO: ProcessCDR(1,15249895,1,1,2) [2025-06-07 05:40:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15249895,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 05:40:24] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15249895,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 05:40:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15249895,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 05:40:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15249895,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 05:40:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15249895', 'tblTempUsageDetail_20' ) start [2025-06-07 05:40:31] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15249895', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 05:40:31] Production.INFO: ==7692== Releasing lock... [2025-06-07 05:40:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 05:40:31] Production.INFO: 56 MB #Memory Used# [2025-06-07 06:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 06:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 06:40:17] Production.INFO: count ==3705 [2025-06-07 06:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 06:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 06:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15250142', 'tblTempUsageDetail_20' ) start [2025-06-07 06:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15250142', 'tblTempUsageDetail_20' ) end [2025-06-07 06:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15250142', 'tblTempVendorCDR_20' ) start [2025-06-07 06:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15250142', 'tblTempVendorCDR_20' ) end [2025-06-07 06:40:19] Production.INFO: ProcessCDR(1,15250142,1,1,2) [2025-06-07 06:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15250142,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 06:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15250142,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 06:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15250142,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 06:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15250142,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 06:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15250142', 'tblTempUsageDetail_20' ) start [2025-06-07 06:40:29] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15250142', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 06:40:29] Production.INFO: ==12009== Releasing lock... [2025-06-07 06:40:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 06:40:29] Production.INFO: 56 MB #Memory Used# [2025-06-07 07:40:04] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 07:40:04] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 07:40:17] Production.INFO: count ==3705 [2025-06-07 07:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 07:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 07:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15250390', 'tblTempUsageDetail_20' ) start [2025-06-07 07:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15250390', 'tblTempUsageDetail_20' ) end [2025-06-07 07:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15250390', 'tblTempVendorCDR_20' ) start [2025-06-07 07:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15250390', 'tblTempVendorCDR_20' ) end [2025-06-07 07:40:19] Production.INFO: ProcessCDR(1,15250390,1,1,2) [2025-06-07 07:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15250390,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 07:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15250390,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 07:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15250390,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 07:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15250390,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 07:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15250390', 'tblTempUsageDetail_20' ) start [2025-06-07 07:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15250390', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 07:40:30] Production.INFO: ==16310== Releasing lock... [2025-06-07 07:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 07:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 08:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 08:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 08:40:17] Production.INFO: count ==3705 [2025-06-07 08:40:20] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 08:40:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 08:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15250636', 'tblTempUsageDetail_20' ) start [2025-06-07 08:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15250636', 'tblTempUsageDetail_20' ) end [2025-06-07 08:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15250636', 'tblTempVendorCDR_20' ) start [2025-06-07 08:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15250636', 'tblTempVendorCDR_20' ) end [2025-06-07 08:40:20] Production.INFO: ProcessCDR(1,15250636,1,1,2) [2025-06-07 08:40:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15250636,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 08:40:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15250636,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 08:40:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15250636,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 08:40:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15250636,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 08:40:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15250636', 'tblTempUsageDetail_20' ) start [2025-06-07 08:40:31] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15250636', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 08:40:31] Production.INFO: ==20632== Releasing lock... [2025-06-07 08:40:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 08:40:31] Production.INFO: 56 MB #Memory Used# [2025-06-07 09:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 09:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 09:40:17] Production.INFO: count ==3705 [2025-06-07 09:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 09:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 09:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15250884', 'tblTempUsageDetail_20' ) start [2025-06-07 09:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15250884', 'tblTempUsageDetail_20' ) end [2025-06-07 09:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15250884', 'tblTempVendorCDR_20' ) start [2025-06-07 09:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15250884', 'tblTempVendorCDR_20' ) end [2025-06-07 09:40:19] Production.INFO: ProcessCDR(1,15250884,1,1,2) [2025-06-07 09:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15250884,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 09:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15250884,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 09:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15250884,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 09:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15250884,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 09:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15250884', 'tblTempUsageDetail_20' ) start [2025-06-07 09:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15250884', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 09:40:30] Production.INFO: ==24889== Releasing lock... [2025-06-07 09:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 09:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 10:40:04] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 10:40:04] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 10:40:17] Production.INFO: count ==3705 [2025-06-07 10:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 10:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 10:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15251131', 'tblTempUsageDetail_20' ) start [2025-06-07 10:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15251131', 'tblTempUsageDetail_20' ) end [2025-06-07 10:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15251131', 'tblTempVendorCDR_20' ) start [2025-06-07 10:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15251131', 'tblTempVendorCDR_20' ) end [2025-06-07 10:40:19] Production.INFO: ProcessCDR(1,15251131,1,1,2) [2025-06-07 10:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15251131,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 10:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15251131,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 10:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15251131,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 10:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15251131,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 10:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15251131', 'tblTempUsageDetail_20' ) start [2025-06-07 10:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15251131', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 10:40:30] Production.INFO: ==29173== Releasing lock... [2025-06-07 10:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 10:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 11:40:04] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 11:40:04] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 11:40:17] Production.INFO: count ==3705 [2025-06-07 11:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 11:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 11:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15251377', 'tblTempUsageDetail_20' ) start [2025-06-07 11:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15251377', 'tblTempUsageDetail_20' ) end [2025-06-07 11:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15251377', 'tblTempVendorCDR_20' ) start [2025-06-07 11:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15251377', 'tblTempVendorCDR_20' ) end [2025-06-07 11:40:19] Production.INFO: ProcessCDR(1,15251377,1,1,2) [2025-06-07 11:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15251377,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 11:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15251377,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 11:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15251377,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 11:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15251377,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 11:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15251377', 'tblTempUsageDetail_20' ) start [2025-06-07 11:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15251377', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 11:40:30] Production.INFO: ==966== Releasing lock... [2025-06-07 11:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 11:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 12:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 12:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 12:40:17] Production.INFO: count ==3705 [2025-06-07 12:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 12:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 12:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15251624', 'tblTempUsageDetail_20' ) start [2025-06-07 12:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15251624', 'tblTempUsageDetail_20' ) end [2025-06-07 12:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15251624', 'tblTempVendorCDR_20' ) start [2025-06-07 12:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15251624', 'tblTempVendorCDR_20' ) end [2025-06-07 12:40:19] Production.INFO: ProcessCDR(1,15251624,1,1,2) [2025-06-07 12:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15251624,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 12:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15251624,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 12:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15251624,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 12:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15251624,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 12:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15251624', 'tblTempUsageDetail_20' ) start [2025-06-07 12:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15251624', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 12:40:30] Production.INFO: ==5377== Releasing lock... [2025-06-07 12:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 12:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 13:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 13:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 13:40:17] Production.INFO: count ==3705 [2025-06-07 13:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 13:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 13:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15251872', 'tblTempUsageDetail_20' ) start [2025-06-07 13:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15251872', 'tblTempUsageDetail_20' ) end [2025-06-07 13:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15251872', 'tblTempVendorCDR_20' ) start [2025-06-07 13:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15251872', 'tblTempVendorCDR_20' ) end [2025-06-07 13:40:19] Production.INFO: ProcessCDR(1,15251872,1,1,2) [2025-06-07 13:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15251872,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 13:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15251872,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 13:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15251872,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 13:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15251872,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 13:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15251872', 'tblTempUsageDetail_20' ) start [2025-06-07 13:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15251872', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 13:40:30] Production.INFO: ==10013== Releasing lock... [2025-06-07 13:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 13:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 14:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 14:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 14:40:18] Production.INFO: count ==3705 [2025-06-07 14:40:20] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 14:40:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 14:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15252119', 'tblTempUsageDetail_20' ) start [2025-06-07 14:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15252119', 'tblTempUsageDetail_20' ) end [2025-06-07 14:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15252119', 'tblTempVendorCDR_20' ) start [2025-06-07 14:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15252119', 'tblTempVendorCDR_20' ) end [2025-06-07 14:40:20] Production.INFO: ProcessCDR(1,15252119,1,1,2) [2025-06-07 14:40:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15252119,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 14:40:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15252119,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 14:40:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15252119,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 14:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15252119,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 14:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15252119', 'tblTempUsageDetail_20' ) start [2025-06-07 14:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15252119', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 14:40:30] Production.INFO: ==14709== Releasing lock... [2025-06-07 14:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 14:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 15:40:04] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 15:40:04] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 15:40:17] Production.INFO: count ==3705 [2025-06-07 15:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 15:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 15:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15252365', 'tblTempUsageDetail_20' ) start [2025-06-07 15:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15252365', 'tblTempUsageDetail_20' ) end [2025-06-07 15:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15252365', 'tblTempVendorCDR_20' ) start [2025-06-07 15:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15252365', 'tblTempVendorCDR_20' ) end [2025-06-07 15:40:19] Production.INFO: ProcessCDR(1,15252365,1,1,2) [2025-06-07 15:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15252365,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 15:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15252365,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 15:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15252365,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 15:40:28] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15252365,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 15:40:28] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15252365', 'tblTempUsageDetail_20' ) start [2025-06-07 15:40:29] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15252365', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 15:40:29] Production.INFO: ==19526== Releasing lock... [2025-06-07 15:40:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 15:40:29] Production.INFO: 56 MB #Memory Used# [2025-06-07 16:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 16:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 16:40:17] Production.INFO: count ==3705 [2025-06-07 16:40:20] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 16:40:20] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 16:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15252613', 'tblTempUsageDetail_20' ) start [2025-06-07 16:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15252613', 'tblTempUsageDetail_20' ) end [2025-06-07 16:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15252613', 'tblTempVendorCDR_20' ) start [2025-06-07 16:40:20] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15252613', 'tblTempVendorCDR_20' ) end [2025-06-07 16:40:20] Production.INFO: ProcessCDR(1,15252613,1,1,2) [2025-06-07 16:40:20] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15252613,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 16:40:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15252613,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 16:40:23] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15252613,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 16:40:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15252613,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 16:40:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15252613', 'tblTempUsageDetail_20' ) start [2025-06-07 16:40:31] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15252613', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 16:40:31] Production.INFO: ==23899== Releasing lock... [2025-06-07 16:40:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 16:40:31] Production.INFO: 56 MB #Memory Used# [2025-06-07 17:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 17:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 17:40:17] Production.INFO: count ==3705 [2025-06-07 17:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 17:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 17:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15252860', 'tblTempUsageDetail_20' ) start [2025-06-07 17:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15252860', 'tblTempUsageDetail_20' ) end [2025-06-07 17:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15252860', 'tblTempVendorCDR_20' ) start [2025-06-07 17:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15252860', 'tblTempVendorCDR_20' ) end [2025-06-07 17:40:19] Production.INFO: ProcessCDR(1,15252860,1,1,2) [2025-06-07 17:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15252860,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 17:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15252860,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 17:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15252860,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 17:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15252860,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 17:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15252860', 'tblTempUsageDetail_20' ) start [2025-06-07 17:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15252860', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 17:40:30] Production.INFO: ==28780== Releasing lock... [2025-06-07 17:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 17:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 18:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 18:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 18:40:17] Production.INFO: count ==3705 [2025-06-07 18:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 18:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 18:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15253105', 'tblTempUsageDetail_20' ) start [2025-06-07 18:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15253105', 'tblTempUsageDetail_20' ) end [2025-06-07 18:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15253105', 'tblTempVendorCDR_20' ) start [2025-06-07 18:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15253105', 'tblTempVendorCDR_20' ) end [2025-06-07 18:40:19] Production.INFO: ProcessCDR(1,15253105,1,1,2) [2025-06-07 18:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15253105,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 18:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15253105,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 18:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15253105,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 18:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15253105,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 18:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15253105', 'tblTempUsageDetail_20' ) start [2025-06-07 18:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15253105', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 18:40:30] Production.INFO: ==1210== Releasing lock... [2025-06-07 18:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 18:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 19:40:04] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 19:40:04] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 19:40:16] Production.INFO: count ==3705 [2025-06-07 19:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 19:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 19:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15253352', 'tblTempUsageDetail_20' ) start [2025-06-07 19:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15253352', 'tblTempUsageDetail_20' ) end [2025-06-07 19:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15253352', 'tblTempVendorCDR_20' ) start [2025-06-07 19:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15253352', 'tblTempVendorCDR_20' ) end [2025-06-07 19:40:19] Production.INFO: ProcessCDR(1,15253352,1,1,2) [2025-06-07 19:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15253352,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 19:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15253352,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 19:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15253352,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 19:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15253352,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 19:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15253352', 'tblTempUsageDetail_20' ) start [2025-06-07 19:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15253352', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 19:40:30] Production.INFO: ==5914== Releasing lock... [2025-06-07 19:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 19:40:30] Production.INFO: 56 MB #Memory Used# [2025-06-07 20:40:04] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 20:40:04] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 20:40:17] Production.INFO: count ==3705 [2025-06-07 20:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 20:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 20:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15253598', 'tblTempUsageDetail_20' ) start [2025-06-07 20:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15253598', 'tblTempUsageDetail_20' ) end [2025-06-07 20:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15253598', 'tblTempVendorCDR_20' ) start [2025-06-07 20:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15253598', 'tblTempVendorCDR_20' ) end [2025-06-07 20:40:19] Production.INFO: ProcessCDR(1,15253598,1,1,2) [2025-06-07 20:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15253598,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 20:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15253598,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 20:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15253598,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 20:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15253598,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 20:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15253598', 'tblTempUsageDetail_20' ) start [2025-06-07 20:40:29] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15253598', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 20:40:29] Production.INFO: ==10338== Releasing lock... [2025-06-07 20:40:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 20:40:29] Production.INFO: 56 MB #Memory Used# [2025-06-07 21:40:04] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 21:40:04] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 21:40:17] Production.INFO: count ==3705 [2025-06-07 21:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 21:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 21:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15253845', 'tblTempUsageDetail_20' ) start [2025-06-07 21:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15253845', 'tblTempUsageDetail_20' ) end [2025-06-07 21:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15253845', 'tblTempVendorCDR_20' ) start [2025-06-07 21:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15253845', 'tblTempVendorCDR_20' ) end [2025-06-07 21:40:19] Production.INFO: ProcessCDR(1,15253845,1,1,2) [2025-06-07 21:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15253845,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 21:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15253845,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 21:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15253845,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 21:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15253845,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 21:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15253845', 'tblTempUsageDetail_20' ) start [2025-06-07 21:40:29] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15253845', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 21:40:29] Production.INFO: ==15546== Releasing lock... [2025-06-07 21:40:29] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 21:40:29] Production.INFO: 56 MB #Memory Used# [2025-06-07 22:40:05] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 22:40:05] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 22:40:18] Production.INFO: count ==3705 [2025-06-07 22:40:21] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 22:40:21] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 22:40:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15254093', 'tblTempUsageDetail_20' ) start [2025-06-07 22:40:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15254093', 'tblTempUsageDetail_20' ) end [2025-06-07 22:40:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15254093', 'tblTempVendorCDR_20' ) start [2025-06-07 22:40:21] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15254093', 'tblTempVendorCDR_20' ) end [2025-06-07 22:40:21] Production.INFO: ProcessCDR(1,15254093,1,1,2) [2025-06-07 22:40:21] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15254093,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 22:40:23] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15254093,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 22:40:24] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15254093,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 22:40:30] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15254093,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 22:40:30] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15254093', 'tblTempUsageDetail_20' ) start [2025-06-07 22:40:31] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15254093', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 22:40:31] Production.INFO: ==20842== Releasing lock... [2025-06-07 22:40:31] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 22:40:31] Production.INFO: 56 MB #Memory Used# [2025-06-07 23:40:04] Production.ERROR: Array ( [start_date_ymd] => 2025-06-01 09:40:05 [end_date_ymd] => 2025-06-02 09:40:05 [RateCDR] => 1 ) [2025-06-07 23:40:04] Production.INFO: select c.src, c.ID,c.`start`,c.`end`,c.duration,c.billsec,c.realsrc as extension,c.accountcode, c.firstdst,c.lastdst,coalesce(sum(cc_cost)) as cc_cost,c.pincode, c.userfield,IFNULL(cc_type ,'') as cc_type, disposition,IFNULL(p.pr_name,'') as cc_peername,IFNULL(cc.cc_buy,'') as cc_buy, ex.ex_name,ex.ex_description, pin.pc_description as pincode_name from asteriskcdrdb.cdr c left outer join asterisk.cc_callcosts cc on c.uniqueid=cc.cc_uniqueid and ( c.sequence=cc.cc_cdr_sequence or (c.sequence is null and cc.cc_cdr_sequence=0 ) ) /*-- Given by mirta same as in their front end.*/ left outer join asterisk.pr_providers p on cc_pr_id = pr_id left outer join asterisk.te_tenants te ON te.te_code = c.accountcode left outer join asterisk.ex_extensions ex ON CONCAT(ex.ex_number, '-', te.te_code) = c.realsrc and ex.ex_te_id = te.te_id left outer join asterisk.pc_pincodes pin ON pin.pc_pin = c.pincode where `end` >= '2025-06-01 09:40:05' and `end` < '2025-06-02 09:40:05' AND ( userfield like '%outbound%' or userfield like '%inbound%' or ( userfield = '' AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' ) /*-- Ignore Internal call*/ ) AND ( dst<>'h' or duration <> 0 ) /*-- given by mirta*/ AND IFNULL(cc_type ,'') <> 'OUTNOCHARGE' and prevuniqueid='' group by ID,c.`start`,c.`end`,realsrc,firstdst,duration,billsec,userfield,uniqueid,prevuniqueid,lastdst,dst,pincode,IFNULL(cc_type ,'') [2025-06-07 23:40:17] Production.INFO: count ==3705 [2025-06-07 23:40:19] Production.ERROR: pbx CDR StartTime 2025-06-01 09:40:05 - End Time 2025-06-02 09:40:05 [2025-06-07 23:40:19] Production.ERROR: ========================== pbx transaction end ============================= [2025-06-07 23:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15254340', 'tblTempUsageDetail_20' ) start [2025-06-07 23:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID ('1','1' , '15254340', 'tblTempUsageDetail_20' ) end [2025-06-07 23:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15254340', 'tblTempVendorCDR_20' ) start [2025-06-07 23:40:19] Production.INFO: CALL prc_DeleteDuplicateUniqueID2 ('1','1' , '15254340', 'tblTempVendorCDR_20' ) end [2025-06-07 23:40:19] Production.INFO: ProcessCDR(1,15254340,1,1,2) [2025-06-07 23:40:19] Production.ERROR: start CALL prc_ProcesssVCDR( 1,1,15254340,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 23:40:22] Production.ERROR: end CALL prc_ProcesssVCDR( 1,1,15254340,'tblTempVendorCDR_20',1,2,'','CurrentRate','0','0') [2025-06-07 23:40:22] Production.ERROR: start CALL prc_ProcesssCDR( 1,1,15254340,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 23:40:29] Production.ERROR: end CALL prc_ProcesssCDR( 1,1,15254340,'tblTempUsageDetail_20',1,2,'','CurrentRate','0','0','0','0') [2025-06-07 23:40:29] Production.ERROR: PBX CALL prc_ProcessDiscountPlan ('15254340', 'tblTempUsageDetail_20' ) start [2025-06-07 23:40:30] Production.ERROR: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:362 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(362): PDOStatement->execute(Array) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(616): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'CALL prc_Proce...', Array) #2 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #4 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #6 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #7 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #8 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #9 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #10 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 {main} Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1 (SQL: CALL prc_ProcessDiscountPlan ('15254340', 'tblTempUsageDetail_20' ))' in /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624 Stack trace: #0 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(580): Illuminate\Database\Connection->runQueryCallback('CALL prc_Proce...', Array, Object(Closure)) #1 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/Connection.php(363): Illuminate\Database\Connection->run('CALL prc_Proce...', Array, Object(Closure)) #2 [internal function]: Illuminate\Database\Connection->statement('CALL prc_Proce...') #3 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(304): call_user_func_array(Array, Array) #4 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->__call('statement', Array) #5 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(210): Illuminate\Database\DatabaseManager->statement('CALL prc_Proce...') #6 /var/www/html/onswitch.neon.service/app/Console/Commands/PBXAccountUsage.php(0): Illuminate\Support\Facades\Facade::__callStatic('statement', Array) #7 [internal function]: App\Console\Commands\PBXAccountUsage->fire() #8 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Container/Container.php(526): call_user_func_array(Array, Array) #9 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(115): Illuminate\Container\Container->call(Array) #10 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Console/Command.php(101): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\PBXAccountUsage), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/html/onswitch.neon.service/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/onswitch.neon.service/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(94): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/onswitch.neon.service/artisan(36): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 {main} [2025-06-07 23:40:30] Production.INFO: ==27537== Releasing lock... [2025-06-07 23:40:30] Production.INFO: pbxaccountusage-command-pbxaccountusage-companyid-1-cronjobid-16 #Stops# [2025-06-07 23:40:30] Production.INFO: 56 MB #Memory Used#