ORA-12899: value too large for column "INQ_ANALYTICS"."REP_USERACTIVITYLOG"."ACTIVITYTYPE (Doc ID 1039780.1)

Last updated on MARCH 09, 2015

Applies to:

Oracle Knowledge - Version 8.0.x and later
Information in this document applies to any platform.
Information in this document applies to any platform.

Symptoms

[1215182 Local Workclient-default-taskrun (1356)] UNKNOWN MESSAGE ID "Error: log file "inqim002_foo_kb_0_useractivity.log.2012-08-28" loading failed" called with: "java.sql.BatchUpdateException: ORA-12899: value too large for column "ANALYTICS"."REP_USERACTIVITYLOG"."ACTIVITYTYPE" (actual: 106, maximum: 64)

    at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656)
    at com.inquira.analytics.im.Log2Ods.loadLogFile(Log2Ods.java:438)
    at com.inquira.analytics.im.Log2Ods.loadLogFiles(Log2Ods.java:259)
    at com.inquira.analytics.im.Log2Ods.loadLogFiles(Log2Ods.java:155)
    at com.inquira.analytics.im.IMLoad.doWork(IMLoad.java:126)
    at com.inquira.analytics.OdsTask.run(OdsTask.java:265)
    at com.inquira.scheduler.job.Task.run(Task.java:1241)
    at com.inquira.scheduler.workclient.WorkClient$TaskThread.run(WorkClient.java:364)


This exception causes the IM Log Load task to fail.


When looking at the user activity logs you would see records like this.

1422810388239|1|||WHITE_PAPERS|902177f1c01bf012a44d1647c007800|02162b5ebe6601427829f2d10056f2|en_US|en_US

|90217064eac54f012a42bda4ba007fd4||||192.168.103.52|D5F0DDA5FB2D0D244F3DF3D3B8459380.ic1|WH122

|02169aa5240012ca93945c4006b57|LIST_RECENT             Result: ñêðèïòîçà ùèòà  Ã¤Ã¥Ã¸Ã¨Ã´Ã°Ã®Ã¢Ã íà ; íå íà øëîñü ôîðìû äëÿ îòïðà âêè;|2

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