Displaying Garbles in CDR Tables

Publication Date:  2015-06-30 Views:  175 Downloads:  0
Issue Description
After the SDRs are imported, t_dcs_billlog and tcurrentbilllog are unreadable.
Handling Process
Step 1 The value of row size in DataStation is different from that in CDRs.
1. Verify that the DataStation supported by the current CTI version is installed and import tasks have been obtained.
2. Configure the task of importing CDRs from the DataStation server to the database.
Step 2 Set the database client's character set configured on the DataStation server and the database server's character set to the same value.
1. Check the character set of the database server.
a. Log in to the database server as the oracle user.
b. Log in to the database as the administrator.
sqlplus / as sysdba
c. Check the character set.
SELECT * FROM v$nls_parameters;
2. Check the character set of the database client.
a. Log in to the database client (that is, DataStation server) as the icd user (that is, DataStation installation user).
b. Run the cat .cshrc command to check the database client's character set NLS_LANG.
If the two character sets are different, change them to the same value.
Root Cause
 The value of row size in DataStation is different from that in CDRs.
 The database client's character set configured on the DataStation server is different from the database server's character set.

END