CDR is not logged in DB

Sometimes CDR is not written in a table so I have gone through the full logs and found that there is no hangup line present but as per dial plan it is there and the strange thing is out of 100s calls only few 2-3 calls have this issues so below are the logs.

Can anyone suggest why it happens only on a few calls if the dialplan is common for all calls?

[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:1] Ringing(“SIP/Common-00000317”, “”) in new stack
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:2] Set(“SIP/Common-00000317”, “CALLERID(name)=2XXXXXXXXXX”) in new stack
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:3] NoOp(“SIP/Common-00000317”, “<<<<<<<<<<<< Check Active Status static file 209>>>>>>>>>>>”) in new stack
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:4] AGI(“SIP/Common-00000317”, “agi://127.0.0.1:4761/ARA.php,1XXXXXXXXXX,2XXXXXXXXXX”) in new stack

[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] res_agi.c: – <SIP/Common-00000317>AGI Script agi://127.0.0.1:4761/ARA.php completed, returning 0
[Dec 4 20:17:31] ERROR[1763][C-000000bf] utils.c: write() returned error: Broken pipe
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:5] CELGenUserEvent(“SIP/Common-00000317”, “USER_DEFINED,cid:1001,dialcode:1855,region:Usa-North America 8xx Term.”) in new stack
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:6] Set(“SIP/Common-00000317”, “CDR(cid)=1001”) in new stack
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:7] Set(“SIP/Common-00000317”, “CDR(accountcode)=1001-1XXXXXXXXXX”) in new stack
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:8] Set(“SIP/Common-00000317”, “CDR(dial_code)=1855”) in new stack
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:9] Set(“SIP/Common-00000317”, “CDR(region)=Usa-North America 8xx Term.”) in new stack
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:10] GotoIf(“SIP/Common-00000317”, “0?MinutesExhaust,1XXXXXXXXXX,1”) in new stack
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:11] GotoIf(“SIP/Common-00000317”, “0?INACTIVE,1XXXXXXXXXX,1”) in new stack
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:12] NoOp(“SIP/Common-00000317”, “<<<<<<<<<<<< Client AND Number is ACTIVE >>>>>>>>>>>>>>”) in new stack
[Dec 4 20:17:31] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:13] AGI(“SIP/Common-00000317”, “agi://127.0.0.1:4761/CB.php,2XXXXXXXXXX,1XXXXXXXXXX”) in new stack

[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] res_agi.c: – <SIP/Common-00000317>AGI Script agi://127.0.0.1:4761/CB.php completed, returning 0
[Dec 4 20:17:32] ERROR[1763][C-000000bf] utils.c: write() returned error: Broken pipe
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:14] GotoIf(“SIP/Common-00000317”, “0?BLOCKED,1XXXXXXXXXX,1”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:15] Set(“SIP/Common-00000317”, “GROUP()=1001”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:16] NoOp(“SIP/Common-00000317”, “>>>>>>>>>>>>>>>>>>>>>>>> Total Channels : 4 AND CID: 1001 AND Current Call is: 1 AND INBOUND”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:17] GotoIf(“SIP/Common-00000317”, “0?CallLimitExceeded,1XXXXXXXXXX,1”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:18] NoOp(“SIP/Common-00000317”, “Data Inserted into CDR Table”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:19] NoOp(“SIP/Common-00000317”, “<<<<<<<<<<<< Blacklist Passed >>>>>>>>>>>”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:20] NoOp(“SIP/Common-00000317”, “<<<<<<<<<<<< Call is Allowed as per Call Limit >>>>>>>>>>>”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:21] NoOp(“SIP/Common-00000317”, “<<<<<<<<<<<< Start Call Flow >>>>>>>>>>>”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:22] GotoIf(“SIP/Common-00000317”, “1?NODTMF:DTMF”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Goto (MAINCONTEXT,1XXXXXXXXXX,24)
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:24] AGI(“SIP/Common-00000317”, “agi://127.0.0.1:4761/MYOD.php,1XXXXXXXXXX”) in new stack

[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] res_agi.c: – <SIP/Common-00000317>AGI Script agi://127.0.0.1:4761/MYOD.php completed, returning 0
[Dec 4 20:17:32] ERROR[1763][C-000000bf] utils.c: write() returned error: Broken pipe
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:25] GotoIfTime(“SIP/Common-00000317”, “00:00:00-23:59:59,mon,,,America/New_York?MYON,1XXXXXXXXXX,1”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:26] GotoIfTime(“SIP/Common-00000317”, “00:00:00-23:59:59,tue,,,America/New_York?MYON,1XXXXXXXXXX,1”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MAINCONTEXT:27] GotoIfTime(“SIP/Common-00000317”, “00:00:00-23:59:59,wed,,,America/New_York?MYON,1XXXXXXXXXX,1”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Goto (MYON,1XXXXXXXXXX,1)
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYON:1] AGI(“SIP/Common-00000317”, “agi://127.0.0.1:4761/MYRE.php,1XXXXXXXXXX”) in new stack

[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] res_agi.c: – <SIP/Common-00000317>AGI Script agi://127.0.0.1:4761/MYRE.php completed, returning 0
[Dec 4 20:17:32] ERROR[1763][C-000000bf] utils.c: write() returned error: Broken pipe
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYON:2] GotoIf(“SIP/Common-00000317”, “0?NOBackground,1XXXXXXXXXX,1”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYON:3] Playback(“SIP/Common-00000317”, “/var/www/html/realtime/useruploads/wave_ivr/blank”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] file.c: – <SIP/Common-00000317> Playing ‘/var/www/html/realtime/useruploads/wave_ivr/blank.slin’ (language ‘en’)
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYON:4] Gosub(“SIP/Common-00000317”, “MYRE,1XXXXXXXXXX,1”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYRE:1] Set(“SIP/Common-00000317”, “TIME=20:17:32”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYRE:2] Set(“SIP/Common-00000317”, “CALLERID2=2XXXXXXXXXX”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYRE:3] Set(“SIP/Common-00000317”, “DIRNAME=1XXXXXXXXXX/2019/12/04”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYRE:4] Set(“SIP/Common-00000317”, “FILENAME=1001/IN/1XXXXXXXXXX/2019/12/04/1575490651.791-201732-2XXXXXXXXXX”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYRE:5] Set(“SIP/Common-00000317”, “NEWFILENAME=1001/IN/1XXXXXXXXXX/2019/12/04/1575490651.791-201732-2XXXXXXXXXX”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYRE:6] System(“SIP/Common-00000317”, “/bin/mkdir -p 1001/IN/1XXXXXXXXXX/2019/12/04”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYRE:7] Set(“SIP/Common-00000317”, “FILE=1001/IN/1XXXXXXXXXX/2019/12/04/1575490651.791-201732-2XXXXXXXXXX.mp3”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYRE:8] AGI(“SIP/Common-00000317”, “agi://127.0.0.1:4761/Report.php,1001/IN/1XXXXXXXXXX/2019/12/04/1575490651.791-201732-2XXXXXXXXXX.mp3,1575490651.791,20:17:32”) in new stack

[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] res_agi.c: – <SIP/Common-00000317>AGI Script agi://127.0.0.1:4761/Report.php completed, returning 0
[Dec 4 20:17:32] ERROR[1763][C-000000bf] utils.c: write() returned error: Broken pipe
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYRE:9] MixMonitor(“SIP/Common-00000317”, “1001/IN/1XXXXXXXXXX/2019/12/04/1575490651.791-201732-2XXXXXXXXXX.wav,b”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYRE:10] Return(“SIP/Common-00000317”, “”) in new stack

[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] res_agi.c: – <SIP/Common-00000317>AGI Script agi://127.0.0.1:4761/MYON.php completed, returning 0
[Dec 4 20:17:32] ERROR[1763][C-000000bf] utils.c: write() returned error: Broken pipe
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@MYON:6] Goto(“SIP/Common-00000317”, “Queue,1XXXXXXXXXX,1”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Goto (Queue,1XXXXXXXXXX,1)
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@Queue:1] Set(“SIP/Common-00000317”, “CALLERID(all)=2XXXXXXXXXX”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] pbx.c: – Executing [1XXXXXXXXXX@Queue:2] Queue(“SIP/Common-00000317”, “1001-1XXXXXXXXXX,tT,90”) in new stack
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] res_musiconhold.c: – Started music on hold, class ‘1001-1XXXXXXXXXX’, on SIP/Common-00000317
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] netsock2.c: == Using SIP RTP CoS mark 5
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] netsock2.c: == Using SIP RTP CoS mark 5
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] netsock2.c: == Using SIP RTP CoS mark 5
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] netsock2.c: == Using SIP RTP CoS mark 5
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] app_queue.c: – SIP/100101-0000031b connected line has changed. Saving it until answer for SIP/Common-00000317
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] app_queue.c: – SIP/100102-0000031a connected line has changed. Saving it until answer for SIP/Common-00000317
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] app_queue.c: – SIP/100103-00000319 connected line has changed. Saving it until answer for SIP/Common-00000317
[Dec 4 20:17:32] VERBOSE[1763][C-000000bf] app_queue.c: – SIP/100104-00000318 connected line has changed. Saving it until answer for SIP/Common-00000317
[Dec 4 20:17:33] VERBOSE[1763][C-000000bf] app_queue.c: – SIP/100102-0000031a is ringing
[Dec 4 20:17:33] VERBOSE[1763][C-000000bf] app_queue.c: – SIP/100104-00000318 is ringing
[Dec 4 20:17:33] VERBOSE[1763][C-000000bf] app_queue.c: – SIP/100103-00000319 is ringing
[Dec 4 20:17:33] VERBOSE[1763][C-000000bf] app_queue.c: – SIP/100103-00000319 is ringing
[Dec 4 20:17:33] VERBOSE[1763][C-000000bf] app_queue.c: – SIP/100101-0000031b is ringing
[Dec 4 20:17:39] VERBOSE[1763][C-000000bf] app_queue.c: – SIP/100104-00000318 connected line has changed. Saving it until answer for SIP/Common-00000317
[Dec 4 20:17:39] VERBOSE[1763][C-000000bf] app_queue.c: – SIP/100104-00000318 answered SIP/Common-00000317
[Dec 4 20:17:39] VERBOSE[1763][C-000000bf] res_musiconhold.c: – Stopped music on hold on SIP/Common-00000317

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.