SSP_log fails to execute due to size of command (Doc ID 441920.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Communications ASAP - Version 4.7.1 to 4.7.1 [Release 4.7]
Microsoft Windows (32-bit)
***Checked for relevance on 16-DEC-2014***

Symptoms

Description

One of the commands that we send through telnet to the NE is too large, so the SSP_log fails.  I need to know whether it's 
possible to increase the size of the column in question or whether some other fix is possible.

Impact

SSP_log will fail if switch command exceeds the column size ( 255 ).

Error Message

"Error: Failed to execute SSP_log for SRQ_ID xxxxx.  Inserted value too large for column: "".....removed..... "">>  
java.sql.SQLException: Inserted value too large for column: "".....removed.....""        at 
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)        at 
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)        at 
oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:861)        at 
oracle.jdbc.oracore.OracleTypeCHAR.pickle81(OracleTypeCHAR.java:362)        at 
oracle.jdbc.oracore.OracleTypeCOLLECTION.pickle81(OracleTypeCOLLECTION.java:639)        at 
oracle.jdbc.oracore.OracleTypeADT.pickle81(OracleTypeADT.java:1630)        at 
oracle.jdbc.oracore.OracleTypeADT.linearize(OracleTypeADT.java:1105)        at 
oracle.sql.ArrayDescriptor.toBytes(ArrayDescriptor.java:498)        at oracle.sql.ARRAY.toBytes(ARRAY.java:636)        
at oracle.jdbc.driver.OraclePreparedStatement.setARRAYInternal(OraclePreparedStatement.java:5022)        at 
oracle.jdbc.driver.OraclePreparedStatement.setArrayInternal(OraclePreparedStatement.java:4946)        at 
oracle.jdbc.driver.OracleCallableStatement.setArray(OracleCallableStatement.java:4281)        at 
com.mslv.activation.jinterpreter.Log.SSP_info_parm_n_log_array(Unknown Source)        at 
com.mslv.activation.jinterpreter.Log.log(Unknown Source)        at 
com.mslv.activation.jinterpreter.Log.logWithInfoParam(Unknown Source)        at 
com.mslv.activation.jinterpreter.NEConnection.flushLogWithInfoParams(Unknown Source)        at 
com.mslv.activation.jinterpreter.JProcessor.flushLogsWithInfoParams(Unknown Source)        at 
com.mslv.activation.jinterpreter.JInterpConnection.runClassMethod(Unknown Source)        at 
com.mslv.activation.jinterpreter.JInterpConnection.handleMessage(Unknown Source)        at 
com.mslv.activation.server.ConnectionHandler.run(ConnectionHandler.java:238)........"

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