Hi,
I have a problem with identity portlet and user portlet, when users add a new properties to their profile and confirm changes both portlets throw an exception :
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique constraint (JBOSSPORTAL.SYS_C0093012) violated org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:276) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) root cause java.sql.BatchUpdateException: ORA-00001: unique constraint (JBOSSPORTAL.SYS_C0093012) violated oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343) oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10768) org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774) org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237) ....
ALTER TABLE jbp_user_prop ADD PRIMARY KEY ( jbp_uid, jbp_name )
I got it, there were some properties into the table JBP_USER_PROP without value (the column jbp_value was null). When I removed these properties the identity portlet started to work.