[jboss-jira] [JBoss JIRA] Updated: (JBPORTAL-1278) CMS create content item fails on save

[ http://jira.jboss.com/jira/browse/JBPORTAL-1278?page=all ] Ian White updated JBPORTAL-1278: -------------------------------- Switching on sql view, the following clue appears reating to the ContentCreateCommand: 11:36:12,368 INFO [STDOUT] Hibernate: select permission0_.ID as ID47_, permission0_.NAME as NAME47_, permission0_.ACTION as ACTION47_, permission0_.NEGATED as NEGATED47_ from jbp_cms_perm permission0_ inner join jbp_cms_perm_user userassoc1_ on permission0_.ID=userassoc1_.CMS_PERM_ID where userasso c1_.USER_ID=? 11:36:12,446 INFO [STDOUT] Hibernate: SELECT * from jbp_cms_perm p,jbp_cms_perm_role r,jbp_role_membership m,jbp_roles roles,jbp_users users WHERE p.id=r.cms_perm_id AND r.role_id=roles.jbp_name AND m.jbp_rid=roles.jbp_rid AND m.jbp_uid=users.jbp_uid AND users.jbp_uname=? 11:36:12,446 INFO [STDOUT] Hibernate: select userassoc0_.CMS_PERM_ID as CMS3_1_, userassoc0_.ID as ID1_, userassoc0_.ID as ID45_0_, userassoc0_.USER_ID as USER2_45_0_ from jbp_cms_perm_user userassoc0_ where userassoc0_.CMS_PERM_ID=? 11:36:12,446 INFO [STDOUT] Hibernate: select roleassoc0_.CMS_PERM_ID as CMS3_1_, roleassoc0_.ID as ID1_, roleassoc0_.ID as ID44_0_, roleassoc0_.ROLE_ID as ROLE2_44_0_ from jbp_cms_perm_role roleassoc0_ where roleassoc0_.CMS_PERM_ID=? 11:36:12,462 INFO [STDOUT] Hibernate: select criteria0_.CMS_PERM_ID as CMS4_1_, criteria0_.ID as ID1_, criteria0_.ID as ID46_0_, criteria0_.NAME as NAME46_0_, criteria0_.VALUE as VALUE46_0_ from jbp_cms_perm_criteria criteria0_ where criteria0_.CMS_PERM_ID=? 11:36:12,462 INFO [STDOUT] Hibernate: select userassoc0_.CMS_PERM_ID as CMS3_1_, userassoc0_.ID as ID1_, userassoc0_.ID as ID45_0_, userassoc0_.USER_ID as USER2_45_0_ from jbp_cms_perm_user userassoc0_ where userassoc0_.CMS_PERM_ID=? 11:36:12,462 INFO [STDOUT] Hibernate: select roleassoc0_.CMS_PERM_ID as CMS3_1_, roleassoc0_.ID as ID1_, roleassoc0_.ID as ID44_0_, roleassoc0_.ROLE_ID as ROLE2_44_0_ from jbp_cms_perm_role roleassoc0_ where roleassoc0_.CMS_PERM_ID=? 11:36:12,462 INFO [STDOUT] Hibernate: select criteria0_.CMS_PERM_ID as CMS4_1_, criteria0_.ID as ID1_, criteria0_.ID as ID46_0_, criteria0_.NAME as NAME46_0_, criteria0_.VALUE as VALUE46_0_ from jbp_cms_perm_criteria criteria0_ where criteria0_.CMS_PERM_ID=? 11:36:39,274 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK39_, wspprop0_.PROP_ID as PROP2_39_, wspprop0_.PROP_DATA as PROP3_39_ from jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=? 11:36:39,290 INFO [STDOUT] Hibernate: select versionpro0_.PK as PK35_, versionpro0_.PROP_ID as PROP2_35_, versionpro0_.PROP_DATA as PROP3_35_ from jbp_cms_version_prop versionpro0_ where versionpro0_.PROP_ID=? 11:36:39,290 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK39_, wspprop0_.PROP_ID as PROP2_39_, wspprop0_.PROP_DATA as PROP3_39_ from jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=? 11:36:39,321 INFO [STDOUT] Hibernate: select versionpro0_.PK as PK35_, versionpro0_.PROP_ID as PROP2_35_, versionpro0_.PROP_DATA as PROP3_35_ from jbp_cms_version_prop versionpro0_ where versionpro0_.PROP_ID=? 11:36:39,352 INFO [STDOUT] Hibernate: select wspnode0_.PK as PK38_, wspnode0_.NODE_ID as NODE2_38_, wspnode0_.NODE_DATA as NODE3_38_ from jbp_cms_wsp_node wspnode0_ where wspnode0_.NODE_ID=? 11:36:39,368 INFO [STDOUT] Hibernate: select versionnod0_.PK as PK34_, versionnod0_.NODE_ID as NODE2_34_, versionnod0_.NODE_DATA as NODE3_34_ from jbp_cms_version_node versionnod0_ where versionnod0_.NODE_ID=? 11:36:39,383 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK39_, wspprop0_.PROP_ID as PROP2_39_, wspprop0_.PROP_DATA as PROP3_39_ from jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=? 11:36:39,383 INFO [STDOUT] Hibernate: select versionpro0_.PK as PK35_, versionpro0_.PROP_ID as PROP2_35_, versionpro0_.PROP_DATA as PROP3_35_ from jbp_cms_version_prop versionpro0_ where versionpro0_.PROP_ID=? 11:36:39,383 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK39_, wspprop0_.PROP_ID as PROP2_39_, wspprop0_.PROP_DATA as PROP3_39_ from jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=? 11:36:39,383 INFO [STDOUT] Hibernate: select versionpro0_.PK as PK35_, versionpro0_.PROP_ID as PROP2_35_, versionpro0_.PROP_DATA as PROP3_35_ from jbp_cms_version_prop versionpro0_ where versionpro0_.PROP_ID=? 11:36:39,399 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK39_, wspprop0_.PROP_ID as PROP2_39_, wspprop0_.PROP_DATA as PROP3_39_ from jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=? 11:36:39,399 INFO [STDOUT] Hibernate: select versionpro0_.PK as PK35_, versionpro0_.PROP_ID as PROP2_35_, versionpro0_.PROP_DATA as PROP3_35_ from jbp_cms_version_prop versionpro0_ where versionpro0_.PROP_ID=? 11:36:39,399 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK39_, wspprop0_.PROP_ID as PROP2_39_, wspprop0_.PROP_DATA as PROP3_39_ from jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=? 11:36:39,415 INFO [STDOUT] Hibernate: select versionpro0_.PK as PK35_, versionpro0_.PROP_ID as PROP2_35_, versionpro0_.PROP_DATA as PROP3_35_ from jbp_cms_version_prop versionpro0_ where versionpro0_.PROP_ID=? 11:36:39,415 ERROR [STDERR] javax.jcr.ValueFormatException: empty value 11:36:39,415 ERROR [STDERR] at org.apache.jackrabbit.value.StringValue.getInternalString(StringValue.java:87) 11:36:39,415 ERROR [STDERR] at org.apache.jackrabbit.value.BaseValue.getString(BaseValue.java:207) 11:36:39,415 ERROR [STDERR] at org.apache.jackrabbit.core.value.InternalValue.create(InternalValue.java:139) 11:36:39,415 ERROR [STDERR] at org.apache.jackrabbit.core.PropertyImpl.setValue(PropertyImpl.java:1010) 11:36:39,415 ERROR [STDERR] at org.apache.jackrabbit.core.NodeImpl.setProperty(NodeImpl.java:2222) 11:36:39,415 ERROR [STDERR] at org.jboss.portal.cms.impl.jcr.command.ContentCreateCommand.execute(ContentCreateCommand.java:62) 11:36:39,415 ERROR [STDERR] at org.jboss.portal.cms.impl.jcr.JCRCompositeCommand.execute(JCRCompositeCommand.java:49) 11:36:39,415 ERROR [STDERR] at org.jboss.portal.cms.impl.jcr.JCRCMS$1.invoke(JCRCMS.java:115) 11:36:39,415 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Unknown Source) 11:36:39,415 ERROR [STDERR] at org.jboss.portal.cms.impl.interceptors.ApprovalWorkflowInterceptor.invoke(ApprovalWorkflowInterceptor.java:87) 11:36:39,415 ERROR [STDERR] at org.jboss.portal.cms.CMSInterceptor.invoke(CMSInterceptor.java:36) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira