WCI Analytics25update.bat Error 'ORA-01400: cannot insert NULL into' During CollabUpdate
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.
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")
Upgrade from Analytics 2.1 to 2.5/10.3.0.0 while using an Oracle DB.
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