customer install a EMS in the CDR server ,cause BMU can't query the bill.
can't query the new bills ,but can query the old ones
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 .
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
don't suggest to install the EMS in the same server of CDR server .