Skip to Main Content

Application Development Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Installation failing on weblogic 10.3.5. Getting java.sql.SQLIntegrityConstraintViolationException:

Nelash JindalOct 17 2014 — edited Oct 23 2014

HI All,

I am getting SQLIntegrityConstraintViolationException error while installing sites on weblogic 10.3.5.

Loge are here:-

ELEMENTNAME = OpenMarket/Xcelerate/AssetType/DimensionSet/com_openmarket_xcelerate_asset_FallbackDimensionFilterInstance DESCRIPTION = Tile Dimensions java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("OSUSER"."TT1413544919853"."URL") at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1009) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172) at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans_logic(JDBCTable.java:1367) at COM.FutureTense.Servlet.JDBCTable.access$000(JDBCTable.java:68) at COM.FutureTense.Servlet.JDBCTable$1.execute(JDBCTable.java:1319) at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189) at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans(JDBCTable.java:1324) at COM.FutureTense.Servlet.JDBCTable.executeUpdate(JDBCTable.java:1211) at COM.FutureTense.Servlet.JDBCTable.AddRow(JDBCTable.java:943) at COM.FutureTense.Common.ftDBTable.insertRow(ftDBTable.java:1281) at COM.FutureTense.CatalogManager.CatalogEngine._replaceRows(CatalogEngine.java:1670) at COM.FutureTense.CatalogManager.CatalogEngine.access$400(CatalogEngine.java:45) at COM.FutureTense.CatalogManager.CatalogEngine$4.execute(CatalogEngine.java:1548) at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189) at COM.FutureTense.CatalogManager.CatalogEngine.replaceRows_trans(CatalogEngine.java:1558) at COM.FutureTense.CatalogManager.CatalogEngine.replaceRows(CatalogEngine.java:1355) at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:1987) at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3442) at COM.FutureTense.Common.CS.CatalogManager(CS.java:1503) at COM.FutureTense.Common.CS.CatalogManager(CS.java:1457) at COM.FutureTense.Apps.Install.command.ImportCatalog.doIt(ImportCatalog.java:522) at COM.FutureTense.Apps.Install.command.ImportCatalog.importCatalogDirectory(ImportCatalog.java:729) at COM.FutureTense.Apps.Install.command.ImportCatalog.doImport(ImportCatalog.java:271) at COM.FutureTense.Apps.Install.command.ImportCatalog.exec(ImportCatalog.java:189) at COM.FutureTense.Apps.Install.command.Command.execute(Command.java:130) at COM.FutureTense.Apps.Install.server.InstallManager.invokeCommand(InstallManager.java:479) at COM.FutureTense.Apps.Install.server.InstallManager.execute(InstallManager.java:104) at COM.FutureTense.Apps.Install.server.InstallServer.evalPage(InstallServer.java:123) at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:465) at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129) at COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:61) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:193) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at COM.FutureTense.Servlet.URLRewriteFilter.doFilter(URLRewriteFilter.java:81) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:701) at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209) at weblogic.work.ExecuteThread.run(ExecuteThread.java:178) [2014-10-17 16:56:14,318 IST] [ERROR] [.kernel.Default (self-tuning)'] [cs.core.db.DBTransaction] TransactionUnit failed to execute com.fatwire.cs.core.db.TransactionAbortException: replacerows failed at COM.FutureTense.CatalogManager.CatalogEngine$4.execute(CatalogEngine.java:1551) at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189) at COM.FutureTense.CatalogManager.CatalogEngine.replaceRows_trans(CatalogEngine.java:1558) at COM.FutureTense.CatalogManager.CatalogEngine.replaceRows(CatalogEngine.java:1355) at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:1987) at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3442) at COM.FutureTense.Common.CS.CatalogManager(CS.java:1503) at COM.FutureTense.Common.CS.CatalogManager(CS.java:1457) at COM.FutureTense.Apps.Install.command.ImportCatalog.doIt(ImportCatalog.java:522) at COM.FutureTense.Apps.Install.command.ImportCatalog.importCatalogDirectory(ImportCatalog.java:732) at COM.FutureTense.Apps.Install.command.ImportCatalog.doImport(ImportCatalog.java:271) at COM.FutureTense.Apps.Install.command.ImportCatalog.exec(ImportCatalog.java:189) at COM.FutureTense.Apps.Install.command.Command.execute(Command.java:130) at COM.FutureTense.Apps.Install.server.InstallManager.invokeCommand(InstallManager.java:479) at COM.FutureTense.Apps.Install.server.InstallManager.execute(InstallManager.java:104) at COM.FutureTense.Apps.Install.server.InstallServer.evalPage(InstallServer.java:123) at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:465) at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129) at COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:821) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57) at com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:193) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57) at COM.FutureTense.Servlet.URLRewriteFilter.doFilter(URLRewriteFilter.java:82) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57) at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:701) at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209) at weblogic.work.ExecuteThread.run(ExecuteThread.java:178) [2014-10-17 16:56:14,599 IST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Exception updating a row in table tt1413544919853 com.fatwire.cs.core.db.TransactionAbortException: replacerows failed at COM.FutureTense.CatalogManager.CatalogEngine$4.execute(CatalogEngine.java:1551) at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189) at COM.FutureTense.CatalogManager.CatalogEngine.replaceRows_trans(CatalogEngine.java:1558) at COM.FutureTense.CatalogManager.CatalogEngine.replaceRows(CatalogEngine.java:1355) at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:1987) at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3442) at COM.FutureTense.Common.CS.CatalogManager(CS.java:1503) at COM.FutureTense.Common.CS.CatalogManager(CS.java:1457) at COM.FutureTense.Apps.Install.command.ImportCatalog.doIt(ImportCatalog.java:522) at COM.FutureTense.Apps.Install.command.ImportCatalog.importCatalogDirectory(ImportCatalog.java:732) at COM.FutureTense.Apps.Install.command.ImportCatalog.doImport(ImportCatalog.java:271) at COM.FutureTense.Apps.Install.command.ImportCatalog.exec(ImportCatalog.java:189) at COM.FutureTense.Apps.Install.command.Command.execute(Command.java:130) at COM.FutureTense.Apps.Install.server.InstallManager.invokeCommand(InstallManager.java:479) at COM.FutureTense.Apps.Install.server.InstallManager.execute(InstallManager.java:104) at COM.FutureTense.Apps.Install.server.InstallServer.evalPage(InstallServer.java:123) at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:465) at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129) at COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:821) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57) at com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:193) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57) at COM.FutureTense.Servlet.URLRewriteFilter.doFilter(URLRewriteFilter.java:82) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57) at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:701) at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209) at weblogic.work.ExecuteThread.run(ExecuteThread.java:178) [2014-10-17 16:56:14,599 IST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.install] ImportCatalogError import the table. Error Number=-105

Can any body tell me anything about this bug.??

Any help will be highly appreciated.

Thanks,

Nelash Jindal

This post has been answered by Stephan Da Silva-Oracle on Oct 21 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 20 2014
Added on Oct 17 2014
6 comments
1,833 views