Issue:
Clicking on the “View CDRs” link in any Report (Traffic Analyzer, QoS, Fraud or Billing) creates the 404 error. The report is viewable, but the CDR details are not.
Log message:
Server response - The requested file does not exist and there is no compressed folder (Code 404)*
Troubleshoot:
The problem is caused when CDR details files are deleted before the report is deleted. The CDR details file has probably been deleted by the delete_old_report_details_files.sh utility script which is run by Cron. Below is an example for finding and viewing this script from the Command Line Interface. This script can be edited with any text editor.
-bash-3.00$ pwd
/export/home/ossadmin/OSS/nexoss/unix/utils
-bash-3.00$ ls
IsFileOldEnough.pl
compress_rate_files.sh
delete_old_invoices_by_account.sh
README.txt
compress_report_details_files.sh
delete_old_log_files.sh
compress_archived_cdr_files.sh
compress_report_files.sh
delete_old_rate_files.sh
compress_backup_files.sh
delete_old_backup_files.sh
delete_old_report_details_files.sh
compress_cdrs_archived_by_account.sh
delete_old_cdr_files.sh
delete_old_report_files.sh
compress_invoices_by_account.sh
delete_old_cdrs_archived_by_account.sh
mysql_delete_old_database_records.sql
compress_log_files.sh
delete_old_database_records.sql
-bash-3.00$ cat delete_old_report_details_files.sh
#!/bin/sh
# delete_old_report_details_files.sh
#
# This script automates the process of deleting all files from the
# $NexOSS_HOME/REPORTS directory that have a .report.details* file name
# extension and have been unchanged for more days than the number of
# days defined by the DELETE_FILES_OLDER_THAN_DAYS variable. The
# default value for this variable is 15 days.
#
# For example, if DELETE_FILES_OLDER_THAN_DAYS=45 all report files,
# compressed and uncompressed, that have not been changed,
# compressed, renamed, etc. for more than 45 days will be deleted.
#
# This script must be run by user ossadmin. This script uses the
# IsFileOldEnough.pl script which must also be located in the
# $NexOSS_HOME/unix/utils directory.
DELETE_FILES_OLDER_THAN_DAYS=15
FILE_MASK="REPORTS/*.report.details*"
if [ ! "$NexOSS_HOME" ]
then
echo "The NexOSS_HOME variable is not set."
exit 1
fi
if [ ! -d $NexOSS_HOME/unix/utils ]
then
echo "Directory $NexOSS_HOME/unix/utils does not exist"
echo "Make sure that NexOSS_HOME variable is correctly set."
exit 1
fi
cd $NexOSS_HOME
for file in $FILE_MASK
do
if ./unix/utils/IsFileOldEnough.pl $DELETE_FILES_OLDER_THAN_DAYS $file
then rm -Rf ./$file
fi
done