error when "check integrity"

Bing Qiu

unread,

Jul 31, 2015, 12:46:24 PM7/31/15

to dotCMS User Group

Hi,

I set up the push content, and want to "check integrity" first. It shows error, and errors in the log are as below. What can I do to avoid the insert of "Null" value?

Thanks
Bing

2015-07-31 09:40:01,271 ERROR com.dotcms.rest.IntegrityResource - Error checking integrity
java.lang.Exception: Error running the HTML Pages Integrity Check
    at com.dotcms.rest.IntegrityUtil.checkHtmlPagesIntegrity(IntegrityUtil.java:749)
    at com.dotcms.rest.IntegrityResource$2.run(IntegrityResource.java:386)
Caused by: com.dotmarketing.exception.DotDataException: ORA-01400: cannot insert NULL into ("DOTCMSAUTH"."CONTENTPAGES_TEMP_8042DE49013"."LIVE_INODE")

    at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:234)
    at com.dotcms.rest.IntegrityUtil.checkPages(IntegrityUtil.java:827)
    at com.dotcms.rest.IntegrityUtil.checkHtmlPagesIntegrity(IntegrityUtil.java:743)
    ... 1 more
Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("DOTCMSAUTH"."CONTENTPAGES_TEMP_8042DE49013"."LIVE_INODE")

    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3482)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1085)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)
    at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:564)
    at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:486)
    at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:232)
    ... 3 more

Jason Tesser

unread,

Jul 31, 2015, 12:55:22 PM7/31/15

to dotCMS User Group

Strange works in oracle. We are doing temp tables here. Could there be a permission issue or something with your oracle install that would hurt temp tabl eactivity

--
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.
Visit this group at http://groups.google.com/group/dotcms.
For more options, visit https://groups.google.com/d/optout.

Bing Qiu

unread,

Jul 31, 2015, 1:27:25 PM7/31/15

to dotCMS User Group, jason...@gmail.com

I ask our DBA, there is no permission limitation for the temp table.

My quesition now is:

1. Is it ok to insert null into the ("DOTCMSAUTH"."CONTENTPAGES_TEMP_8042DE49013"."LIVE_INODE")?

2. If yes, is the creation statement of the "DOTCMSAUTH"."CONTENTPAGES_TEMP_8042DE49013" requesting it's not null?

Thanks
Bing

Jason Tesser

unread,

Jul 31, 2015, 4:21:41 PM7/31/15

to Bing Qiu, dotCMS User Group

It shouldn't be happening. Can you tell me which version you are using?

Bing Qiu

unread,

Jul 31, 2015, 4:42:21 PM7/31/15

to dotCMS User Group, bingq...@gmail.com, jason...@gmail.com

dotcms_3.2.1

Reply all

Reply to author

Forward