Billing and Revenue Management (MOSC)

MOSC Banner

Database error '[SERVERERROR] ORA-01461 while trying to rate a file

edited Jan 25, 2017 4:00AM in Billing and Revenue Management (MOSC) 2 commentsAnswered

Hi Team,

     we are getting below error while trying to process some files. Pipeline throws this error and becomes inactive. There is no error in pipeline stream logs.

     We have tried updating SEQ_GAPNUMBERS to -1 in IFW_SEQCHECK table, but no luck. Please suggest if there is something else that can be done to resolve the issue.

20.03.2017 14:05:10 PEN01BL04    ifw          IFW       CRITICAL [T:2034243904] 00217 - (ifw.SequencerPool.rating_check.Controller) ERR_DATABASE | Database error '[SERVERERROR] ORA-01461: can bind a LONG value only for insert into a LONG column'.

20.03.2017 14:05:14 PEN01BL04    ifw          IFW       NORMAL   [T:2034243904] 00093 - (ifw.Pipelines.RATING) INF_PIPELINE_STOP | The pipeline 'ifw.Pipelines.RATING' is stopped (inactive).

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