ORA-01407 error code

Openfire Openfire Support
#1

Hello,

I have following lines in my error log:

2006.07.04 13:22:24 org.jivesoftware.wildfire.group.Group.updateProperty(Group.java:587)

java.sql.SQLException: ORA-01407: cannot update (“JABBER”.“JIVEGROUPPROP”.“PROPVALUE”) to NULL

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)

at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.jav a:954)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:11 67)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatem ent.java:3284)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatemen t.java:3367)

at org.jivesoftware.wildfire.group.Group.updateProperty(Group.java:584)

at org.jivesoftware.wildfire.group.Group.access$800(Group.java:41)

at org.jivesoftware.wildfire.group.Group$PropertiesMap.put(Group.java:451)

at org.jivesoftware.wildfire.admin.group_002dedit_jsp._jspService(group_002dedit_j sp.java:179)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:830)

at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)

at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:65)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:471)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:633)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.http.HttpServer.service(HttpServer.java:909)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

I have users taken from LDAP, however groups are created manually. Sometimes when I update setting for a group, operation never finishes. When I then click stop and submit again, opreation is completed within a second. Sometimes Users/Groups page does not load even after few minutes. Not sure if that is related. There are 5000 users in LDAP.

Any idea what am I doing wrong?

#2

Hi,

for me it is not clear what action you perform to get this error, if any.

Do you see this error just sometimes, maybe as a result of a user action or only while you are working with the web admin console?

LG

#3

Hey eagtstools,

Were you modifying a group to stop being a shared group? I think I know which the problem is. Unfortunately, the Oracle JDBC driver is replacing empty strings with null values since Oracle treats empty strings as null. A quick workaround would be to change the jiveGroupProp table to let the propValue column accept null values.

Let me know how it goes.

Thanks,

– Gato

#4

Hello Dombiaq,

thanks for answer, yes that could be. I was modifying shared groups settings. This is also related to http://www.jivesoftware.org/community/message.jspa?messageID=123628#123628 , as sometimes when I modify groups settings it never finishes. We have problem with presence of users withing the shared groups, but this is tracked somwhere else in this forums.

I’'ve updated value of column and try to play with shared groups. Will get back with results.

#5

No more errors in my error.log. Thanks.