TSM Could Not Process Radius Account Because TRANS_ID Value Is Too Long (Doc ID 731662.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 to 7.3.1.0.0 [Release 7.2.1 to 7.3.1]
Information in this document applies to any platform.
Checked for relevance on 22-Apr-2013

Symptoms

Accounting packets could not be inserted in "event_session_dialup_t" table because one of the
fields, presumedly "TRANS_ID", does not have enough room to store the information.

Made test calls and monitor packet processing in TSM as well as in DM_ORACLE. The error message
was captured from dm_oracle.log:

E Tue Jul 08 16:05:49 2008 infranet3 dm:27421 dm_subr.c(97):1983
1:tsm1int:pin_radiusd:10095:6:355:1215551149:316
   ORACLE error: do_sql_insert: PINStmtExecute: code 1401, op -4306056
   =ORA-01401: inserted value too large for column
  "insert into event_session_dialup_t ( termserv_id, termserv_port, login, trans_id, network,
timezone, ipaddr, ani, type, timezone_id, bytes_in, bytes_out, descr, dnis, packets_in,
packets_out, speed, status, term_cause, units, obj_id0 ) values ( :termserv_id, :termserv_port,
:login, :trans_id, :network, :timezone, :ipaddr, :ani, :type, :timezone_id, :bytes_in, :bytes_out,
:descr, :dnis, :packets_in, :packets_out, :speed, :status, :term_cause, :units, :obj_id0 )"
E Tue Jul 08 16:05:49 2008 infranet3 dm:27421 dm_do_ops.c(58):376
1:tsm1int:pin_radiusd:10095:6:355:1215551149:316
   ERROR do_create_create sql_insert 1
E Tue Jul 08 16:05:49 2008 infranet3 dm:27421 dm_do_ops.c(58):541
1:tsm1int:pin_radiusd:10095:6:355:1215551149:316
   do_create_create do_create... field name 10/416, err 43
E Tue Jul 08 16:05:49 2008 infranet3 dm:27421 dm_back.c(19):1354
1:tsm1int:pin_radiusd:10095:6:355:1215551149:316
   DMbe #10: process_op: op 1, err 43


Steps To Reproduce:
Make test calls and monitor packet processing in TSM as well as in DM_ORACLE.


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