Billing and Revenue Management (MOSC)

MOSC Banner

ORA-01489: result of string concatenation is too long while trying to load a file using pin_rel

edited Mar 17, 2017 5:00AM in Billing and Revenue Management (MOSC) 5 commentsAnswered

Hi, we are getting below error while trying to load a file using pin_rel. Issue happens only for one file, rest of the files are getting loaded. Please suggest.

Warning 03/09/17 7:21:13:0629 AM ( 1489065673629 )  T:main REL RELDriver 1:COP01BL02:UnknownProgramName:0:main:7:1489065670:0         virtual column setting is : 0 Error 03/09/17 7:21:39:0331 AM ( 1489065699331 )  T:PreUpdater SP Thread 1 REL RELPreUpdaterThread 1:COP01BL02:UnknownProgramName:0:PreUpdater SP Thread 1:0:1489065699:0         ORA-20010: Error -20010 occurred in the preupdate procedure ORA-06512: at "PIN420.PIN_REL", line 5763 ORA-20010: Failed to create item for account 1225388056, event poid is 1456105256980975480, i_bal_imp_rec_item_obj_db is 1, i_evt_bal_imp_rec_balgrp_poid is 1225391256, i_evt_bal_imp_rec_item_type is /item/usage/wireless/cellular/voice/longdist ORA-06512: at "PIN420.PIN_REL", line 2917 ORA-20003: Error updating Service item_poid_list where poid_id0 = 1225388696 ORA-06512: at "PIN420.PIN_REL", line 2735 ORA-01489: result of string concatenation is too long ORA-01403: no data found

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center