Troubleshooting CUBE “No Data Found” in Variphy’s CUBE Analytics

Troubleshooting CUBE “No Data Found” in Variphy’s CUBE Analytics

If CUBE CDR data is not visible in Variphy for the current or previous day(s), there could be a few possible causes. Here’s what you can do to troubleshoot in Variphy’s CUBE analytics when data cannot be found.

Step 1) Confirm that Variphy CDR Processing is enabled for the CUCM cluster.

Log in to Variphy. In the setup menu (gear icon), navigate to the Clusters section and select CUBE/IOS. 

Under CDR Processing, the status for the cluster should display “Enabled.”

If the status for the cluster is “Disabled,” enable CDR processing by clicking the settings icon on the right and switching the Enable Database Processing toggle button. Follow the steps in the modal dialog that appears.

Step 2) Confirm that Variphy is receiving CDR data files from CUBE into the proper directory.

For the CUBE cluster, identify the directory location for the saved data files.

Navigate to the directory to view the folder contents:

On Windows: Open Windows Explorer and head to the appropriate directory location.

On OVA/Linux: Open an SSH session via CLI or an sFTP client and navigate to the appropriate directory location.

cd /opt/variphy/data/cisco2901

Since the CUBE FTP CDR delivery is set to run hourly, there may be no files present. Check the ‘Last Modified’ date on the Progress and Processed directories. If it is not the current day, CUBE CDR files are not being delivered to the Variphy server’s expected data directory.

If running Variphy on Windows, check the FTP server logs on the application server.

If running the Variphy Linux OVA, check the VSFTPD (FTP server) logs on the application server using a CLI or an sFTP client (WinSCP, FileZilla, etc.).

sudo cat /var/log/vsftpd.log

One scenario is an FTP failure being logged (account credentials, home directory paths, etc.). However, it is more than likely the logging of CUBE’s hourly connections has ceased, meaning CUBE is not attempting to deliver CDR files using the built FTP configuration for Variphy.

You should now disable CDR processing on the CUBE cluster. Doing so will allow you to check the data directories on the application server to confirm CUBE is delivering CDR files to Variphy without the application processor ingesting the data on its routine.

Step 3) If CUBE CDR is not being delivered to Variphy, you must access the CUBE via an SSH session with a CLI.

You will need to run some checks, redefine the CDR delivery configuration, and bulk copy and delete the CDR files in CUBE flash.

Check the CUBE flash directory for CDR* files. With the existing FTP connection not functioning properly, CDR* data files will pile up in CUBE flash.

show flash:

Check the configuration of the CDR delivery job in CUBE.

sh run | begin gw-accounting file

Run a “push now” command from CUBE to Variphy.

file-acct flush with-close

Check the corresponding home data directory on the application server.

If the Variphy server and CUBE are communicating properly, a file should appear.. 

Restart the FTP push to run on its scheduled time frame by executing a “file-acct reset”. This does not reset the configurations; it only resets the automatic push of files.

file-acct reset

The hourly job should then resume. Check Variphy in one hour to confirm the delivery of new data. 

If a file does not show up within two minutes, it may be necessary to remove the CDR FTP job (GW-Accounting File) in CUBE and redefine it.

config t

no gw-accounting file This will remove the hourly CDR FTP job

exit

sh run | begin gw-accounting file confirms the job has been removed by returning no results

Redefine the CDR FTP job in CUBE.

enable

configure t

gw-accounting file

primary ftp 10.20.30.180/cdr username cisco2901 password Variphy!!

maximum cdrflush-timer 55

maximum fileclose-timer 60

cdr-format detailed

acct-template callhistory-detail

end

wr mem

Once the configuration is finished, check the application data directory for a delivered CDR file. If no CDR file shows up in the data directory, there may be a firewall or some security measures preventing delivery – FTP port 21.

Once CDR files are being delivered again, the hourly routine should resume.

However, you must still copy and delete the CDR files in CUBE’s flash over to Variphy. You do not want the CUBE flash filling up due to CDR files.

At this point, you will want to use the TCL (Tool Command Language) shell built into CUBE.

This will allow the bulk copy of CDR* files ONLY, not all of flash.

config t

file prompt quiet

exit

Tclsh

set fileList [glob -directory flash: -nocomplain “cdr*”] creates a bulk list of CDR* files only.

foreach file $fileList {copy $file ftp://cisco2901:Variphy!!@10.20.30.180} copy command delivers the CDR files from CUBE flash to Variphy’s FTP server.

file prompt alert: This command will reset the file prompting protection in the global configuration

OPTIONAL: You can use this command if you want to copy the files to a TFTP server uploaded to Variphy.

foreach file $fileList {copy $file tftp://10.20.50.228}

exit

FTP Copy DeliveryTFTP Copy Delivery

CUBE CDR* files from flash should have been copied over FTP to the data directory in the application server.

FTP Directory on Variphy serverFTP Directory on Variphy server

Optional (TFTP Server copy)

TFTP Home Directory

Now that you have copied all the CDR* files from CUBE flash over to Variphy, you must delete those files from CUBE flash.

delete /force flash:/cdr*

Confirm that all CDR* files that were copied over to Variphy are no longer in CUBE flash.

show flash:

Back on the CUBE cluster, switch the Enable Database Processing toggle on.

Give the application a few minutes to process missing files, then refresh your Variphy history searches, reports, and dashboard widgets. All missing data should then be present.

Check out our weekly workshop recording here for more details on Variphy’s Cisco CUBE Reporting.

  1. Very interesting information!Perfect just what I was searching for! «Neurotics build castles in the air, psychotics live in them. My mother cleans them.» by Rita Rudner.

  2. Howdy! I could have sworn I’ve been to your blog before but after browsing through some of the articles I realized it’s new to me. Nonetheless, I’m definitely happy I came across it and I’ll be bookmarking it and checking back frequently!

  3. I enjoy what you guys are up too. This kind of cleverwork and coverage! Keep up the good works guys I’ve included you guys tomy blogroll.

  4. I’m really enjoying the dedsign and layoutof your blog. It’s a very easy on the eyes which makes itmuch more enjoyable for me to come here and isitmore often. Did you hire out a developer to create your theme?Outstanding work!

  5. Beneficial document helps make frequent advance, appreciate it write about, this pile-up connected with expertise is usually to hold finding out, focus is usually the beginning of money.

  6. Hi! I’m at work surfing around your blog from my new iphone! Just wanted to say I love reading through your blog and look forward to all your posts! Keep up the fantastic work!

  7. What’s up every one, here every person is sharingthese experience, so it’s pleasant to read this blog, and I used to pay a quick visit this blog all the time.

  8. I like what you guys tend to be up too. This kind of clever work and coverage! Keep up the amazing works guys I’ve incorporated you guys to our blogroll.

  9. I am really impressed with your writing skills as well as with the layout on yourblog. Is this a paid theme or did you modify it yourself?Anyway keep up the nice quality writing, it is rare tosee a great blog like this one these days.

  10. You can definitely see your enthusiasm in the articleyou write. The world hopes for even more passionate writers like you who aren’t afraidto mention how they believe. Always follow your heart.

  11. Hey there just wanted to give you a quick heads up and let you know afew of the pictures aren’t loading properly.I’m not sure why but I think its a linking issue.I’ve tried it in two different internet browsers and both show the same results.

  12. I read this post completely regarding the difference of newest and preceding technologies, it’s awesome article.Also visit my blog post – habbonews10.altervista.org

  13. I will immediately take hold of your rss feed as I can’t to find your e-mail subscription link or e-newsletter service. Do you have any? Please permit me understand so that I may just subscribe. Thanks.

  14. Excellent post. I was checking continuously thisblog and I am impressed! Extremely useful information particularly the lastpart 🙂 I care for such info a lot. I was looking for this particular info fora very long time. Thank you and best of luck.

  15. I’m truly enjoying the design and layout of your blog. It’s a very easy on the eyeswhich makes it much more pleasant for me to come here and visit more often. Did you hire out a designer to create your theme?Outstanding work!

  16. Hi! I just wanted to ask if you ever have any issues with hackers? My last blog (wordpress) was hacked and I ended up losing months of hard work due to no back up. Do you have any methods to protect against hackers?

  17. Aw, this was a really good post. Spending some time and actual effort to make a reallygood article… but what can I say… I put things off a lot and don’t manage to get nearly anything done.

  18. Thanks for a marvelous posting! I certainly enjoyed reading it, you will be a great author. I will make certain to bookmark your blog and will come back in the future. I want to encourage you continue your great posts, have a nice holiday weekend!

  19. Id should examine with you here. Which is not something I usually do! I get pleasure from reading a put up that will make people think. Also, thanks for permitting me to remark!

  20. Aw, this was an extremely good post. Taking the time and actual effort to create a superb article… but what can I say… I put things off a lot and don’t seem to get nearly anything done.

  21. lowest prescription prices online india [url=https://indiamedfast.shop/#]buying prescription drugs from india[/url] online pharmacy india

  22. online medicine shopping in india [url=https://indiamedfast.shop/#]IndiaMedFast[/url] IndiaMedFast

  23. Mexican Pharm Inter [url=https://mexicanpharminter.com/#]mexican pharmacy online order[/url] mexican pharmacy online store

  24. Mexican Pharm Inter [url=https://mexicanpharminter.com/#]MexicanPharmInter[/url] MexicanPharmInter

  25. mexican pharmacy online order [url=https://mexicanpharminter.com/#]reliable mexican pharmacies[/url] mexican pharmacy online store

  26. Tadalafil Easy Buy [url=https://tadalafileasybuy.shop/#]Tadalafil Easy Buy[/url] cialis without a doctor prescription

  27. Generic 100mg Easy [url=https://generic100mgeasy.com/#]Generic 100mg Easy[/url] buy generic 100mg viagra online

  28. Viagra tablet online [url=https://generic100mgeasy.com/#]Generic 100mg Easy[/url] Generic 100mg Easy

  29. When someone writes an post he/she retains the thoughtof a user in his/her mind that how a user can be aware of it.So that’s why this article is perfect. Thanks!

  30. I want to to thank you for this good read!! I definitely loved every little bit of it. I have you saved as a favorite to check out new stuff you post…

  31. kamagra kopen nederland [url=https://kamagrakopen.pro/#]Kamagra Kopen Online[/url] Officiele Kamagra van Nederland

  32. บาคาร่าออนไลน์ ที่ แทงบอลออนไลน์ เว็บนี้เด็ดจ่ายจริงๆ ท่านกล้ามาเล่นกับเรา ได้เงินเราก็กล้าจ่ายให้เต็มๆ ไม่อิดออด ไม่งอแง เล่นบาคาร่ากับเราสัญญาณชัดเจน ภาพสวยงาม มีกลุ่มของเหล่าเซียนที่กล้านำเล่นแล้วได้เงินจริงๆไปใช้กันเลย

  33. I just like the valuable info you provide on your articles.I will bookmark your blog and take a look at again right here frequently.I’m fairly sure I will be told many new stuff right here!Good luck for the following!

  34. Kamagra Kopen Online [url=https://kamagrakopen.pro/#]kamagra jelly kopen[/url] kamagra pillen kopen

  35. kamagra kopen nederland [url=https://kamagrakopen.pro/#]Kamagra Kopen Online[/url] Officiele Kamagra van Nederland

  36. Generic Cialis price [url=http://tadalafileasybuy.com/#]TadalafilEasyBuy.com[/url] TadalafilEasyBuy.com

  37. kamagra kopen nederland [url=https://kamagrakopen.pro/#]kamagra kopen nederland[/url] KamagraKopen.pro

  38. cialis without a doctor prescription [url=http://tadalafileasybuy.com/#]buy cialis pill[/url] TadalafilEasyBuy.com

  39. Generic 100mg Easy [url=https://generic100mgeasy.shop/#]sildenafil online[/url] Generic 100mg Easy

  40. Kamagra kaufen [url=https://kamagrapotenzmittel.shop/#]kamagra[/url] Kamagra Gel

  41. Kamagra Gel [url=http://kamagrapotenzmittel.com/#]Kamagra online bestellen[/url] Kamagra kaufen ohne Rezept

  42. Kamagra Original [url=https://kamagrapotenzmittel.com/#]Kamagra kaufen ohne Rezept[/url] Kamagra kaufen

  43. Kamagra Oral Jelly kaufen [url=http://kamagrapotenzmittel.com/#]Kamagra Gel[/url] Kamagra kaufen

  44. apotek online [url=https://apotekonlinerecept.shop/#]apotek pa nett[/url] apotek pa nett

Leave a Reply

Your email address will not be published. Required fields are marked *