Install fails with "cannot insert null" error (Doc ID 1541902.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Sites - Version 11.1.1.6.1 to 11.1.1.8.0 [Release FatWire]
Information in this document applies to any platform.

Symptoms

Webcenter Sites 11.1.1.6.1 installation fails during installer, after completing the installer tests. Installation halts and cannot proceed.
The sites.log shows:


[2013-03-26 16:12:59,672 GMT]
[ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db]
Exception executing prepared statement: INSERT INTO tt1364314376494
(ELEMENTNAME,DESCRIPTION) VALUES (?,?)
ELEMENTNAME = OpenMarket/ContentServer/Installation/DeleteCatalog
DESCRIPTION = Remove a CS Catalog
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert null NULL in ("CSUSER"."TT1364314376494"."URL")

 

Install.log shows the following error:
[2013-03-26 16:13:00.719][CS.INSTALL][ERROR] ActionHandlerExecuteCommand:  ExecuteCommand failed for http://localhost:7003/CS/Install?COMMANDNAME=IMPORTCATALOG&USERNAME=ContentServer&PASSWORD=<hidden password value>&CATALOGDIRECTORY=D%3A%2FUsers%2FNB11240%2FProjects%2FeStore%2FSoftware%2FSites%2FContentServer%2FInstallation&ELEMENTDIRECTORY=D%3A%2FOracle%2Fwebcenter%2FShared%2Felements
The response that was received =
HTTP/1.1 200 OK
HOST_SERVICE: FutureTenseContentServer:11.1.1.6.1
Transfer-Encoding: chunked
Date: Tue, 26 Mar 2013 16:12:58 GMT
Set-Cookie: JSESSIONID=D4mgRRJK11Hn2DjM27kc0vmSVXzHXfD3xQhhLZPbp6dnc82xpyfy!-2109374566; path=/; HttpOnly
Content-Type: text/html; charset=UTF-8
X-Powered-By: Servlet/2.5 JSP/2.1


<!--FTCS|||result=success|||reason=|||err=12|||command=mirrorgetconfig|||params=columnslowercase=true&CSVersion=11.1.1.6.1&databasetype=Oracle&mirrorprotocolversion=3|||-->
<!--FTCS|||result=failure|||reason= Error importing the file D:\customer\Software\Sites\ContentServer\Installation\ElementCatalog.html|||err=-300|||command=ImportCatalog|||params=|||-->
[2013-03-26 16:13:00.776][CS.INSTALL][ERROR] ActionHandlerExecuteCommand:  Error Importing Installation Elements

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