Rate Table Import Fails with Java Exception "Fail to convert to internal representation" (Doc ID 2017954.1)

Last updated on APRIL 27, 2016

Applies to:

Oracle Communications Network Charging and Control - Version 5.0.2 to 5.0.3 [Release 5.0]
Information in this document applies to any platform.

Symptoms

On Oracle Communications Network Charging and Control (NCC) version 5.0.2, a problem exists when attempting to import a rate table using the Charging Control Services (CCS) Rate Table import feature, the following Java exception may be thrown:

java.sql.SQLException: Fail to convert to internal representation
    at oracle.jdbc.driver.CharCommonAccessor.getInt(CharCommonAccessor.java:147)
    at oracle.jdbc.driver.T4CVarcharAccessor.getInt(T4CVarcharAccessor.java:828)
    at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
    at com.eservglobal.ccs.rateTable.ImportRateTable.doImportBillingPeriods(ImportRateTable.java:3822)
    at com.eservglobal.ccs.rateTable.ImportRateTable.doImport(ImportRateTable.java:2935)
    at com.eservglobal.ccs.rateTable.ImportRateTable.<init>(ImportRateTable.java:172)
    at com.eservglobal.ccs.RateTablesPanel$1.actionPerformed(RateTablesPanel.java:129)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

    ...

This results in the data failing to import.

Changes

Attempting to import a rate table into the CCS Rate Table screens.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms