No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FTP conflict cause BMU can query new bills

Publication Date:  2014-07-30 Views:  85 Downloads:  0
Issue Description
customer install a EMS in the CDR server ,cause BMU can't query the bill.
Alarm Information
can't query the new bills ,but can query the old ones
Handling Process
1.we got the information from customer that ,the BMU can query the old bill ,but can't query the new bill ,so confirm the connection is ok。
2. check the BMU.log ,we found that
Line 42: java.sql.SQLException: Invalid object name 'tbl_billinfo201407'.
                Line 116: java.sql.SQLException: Invalid object name 'tbl_billinfo201407'.”
that means the table for bill in july of 2014  haven't  generate , only the bill have been import to DB ,the table can be genereated .
so bmu didn't get the bill from CDR server .

3.check if there are bill in the CDR server ,we check both the folder and the software ,we can find the new bills ,so cdr have got the bills .

now we can confirm the problem is that BMU haven't got the bill from CDR server ,thrgouth FTP .

ask customer if there are some modification these days .customer said only installed a EMS server ,
the FTP in the EMS was confict with the ftp in cdr server ,so import bill fail .

close the EMS ,issue resoved .
Root Cause
first we should know how the bill is generated ,
1.the orignal bill is generated in the U19XX gateway
2.the bill will transfer to CDR server through TCP protocol,
3.BMU will get the bill from CDR server through FTP ,and import to SQL server
4.when query the bill ,bmu will get the data from sql server

so we check the data follow the procedure .
1.if the connetion between BMU and DB is ok
2.if  BMU can get the bill from cdr server through FTP,
3.if CDR have got the bill
4.if the bill is generated by U19XX  
Suggestions
don't suggest to install the EMS in the same server of CDR server .

END