Install fails with "cannot insert null" error
(Doc ID 1541902.1)
Last updated on MAY 11, 2021
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 <someTempTable>
(ELEMENTNAME,DESCRIPTION) VALUES (?,?)
ELEMENTNAME = OpenMarket/ContentServer/Installation/DeleteCatalog
DESCRIPTION = Remove a CS Catalog
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert null NULL in ("CSUSER"."<someTempTable>"."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:/Users/someUser/Projects/eStore/Software/Sites/ContentServer/Installation&ELEMENTDIRECTORY=D:/Oracle/webcenter/Shared/elements
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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |