WCI Analytics25update.bat Error 'ORA-01400: cannot insert NULL into' During CollabUpdate

(Doc ID 1072688.1)

Last updated on NOVEMBER 18, 2016

Applies to:

Oracle WebCenter Analytics - Version 2.5 to 10.3.0.1
Information in this document applies to any platform.

Symptoms

When you upgrade from Analytics 2.1 to 2.5/10.3, the documentation instructs you to run Analytics25Update.bat to move data from old tables into the new 2.5/10.3 tables. The scripts created by CollabUpdate.java do not work in Oracle and so all legacy Collaboration data is not moved and consequently is not available in Analytics reports.

Analytics25Update.log will contain a message similar to the following:
ERROR CollabUpdate - [plumtree][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("PTANALYT_OLS"."ASDIM_CLB_DOCUMEN_0"."ID")

Changes

Upgrade from Analytics 2.1 to 2.5/10.3.0.0 while using an Oracle DB.

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