10:16 a.m.
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.1 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:42 a.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Viliam Rockai commented on JBPORTAL-2258:
-----------------------------------------
this is what i've found discovering
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=147155
maybe it can help...
when you create or upload file, you got errors as written above, but the file is there in
cms, you can see it in directory structure - seems like the system thought the file was
created correctly and has remember it in some inner representation, but after you restart
jboss, the file is gone.
i think this can be another error, that system doesn't know correctly when database
insert fails (maybe due the http error)
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.1 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:58 a.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Sohil Shah commented on JBPORTAL-2258:
--------------------------------------
After drilling through this issue for postgresql, I only came up with issues but no
solutions
The root of the problem is a buggy postgresql driver and its handling of BatchUpdates
issued by Hibernate. I tried upgrading to the latest driver with no luck. I even tried to
code around it via a session.flush hack (which solved a problem with an earlier JIRA
task).
However, in this case, within the context of the JBoss Cache, this hack does not work.
Batch Updates still fail.
I googled all over as well using postgresql hibernate BatchUpdateException and you get a
ton of complaints, but no solutions.
We may have to get to the bottom of this with help from the core Hibernate team as this
may require a Hibernate customization/hack.
Whatever the solution will be, it will be a code around/hack since the root of the problem
is the JDBC driver
Same issue also applies to Oracle but in their case I would try driver upgrade in hopes
atleast they may have fixed it
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.1 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:05 a.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Sohil Shah commented on JBPORTAL-2258:
--------------------------------------
Root of the problem seems associated with this Hibernate issue which is still open:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2723
If the CMS Hibernate Layer did not used Blobs and used Hibernate "binary" type
instead, this would not be a problem. However, just binary wouldn't cut it since it
would be a memory hog so would need to use a custom Hibernate type. However, now it will
need to use a custom Hibernate type with preserving the same "Blob" type at the
database level. Still looking into best/portable way to make this customization.
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.1 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:08 p.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Prabhat Jha commented on JBPORTAL-2258:
---------------------------------------
Viliam, I tried CMS create file test after cleaning up both oracle and postgre and I was
not able to reproduce. Can you try as well? May be you get lucky.
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.1 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:01 a.m.
New subject: [JBoss JIRA] Resolved: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Sohil Shah resolved JBPORTAL-2258.
----------------------------------
Resolution: Done
Note to QA. Since this bug is intermittent please run the cms module through
1/ single db test suite run
2/ multidb test suite run (atleast hsqldb, oracle10g, postgresql8, and mysql5) (Those are
the 4 I tested locally on my box)
3/ Run the selenium tests for the cms service
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.1 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:25 a.m.
New subject: [JBoss JIRA] Reopened: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Sohil Shah reopened JBPORTAL-2258:
----------------------------------
issues popping up when integrating cms module with core portal in
postgresql........looking into this
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.1 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4 a.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Sohil Shah commented on JBPORTAL-2258:
--------------------------------------
Prabhat/Viliam-
One usecase I would like for you guys to selenium test on for each database is:
1/ Start Portal with cleandb and let cms load default content
2/ Create a new file
3/ Restart Portal without cleandb
4/ Make sure this new file is still available
5/ Make sure you can delete this file cleanly
I had issues with Oracle with this. It is fixed for all DBs atleast locally for me. But I
will wait to see what you guys find out
This issue looks to be resolved but I will wait for your signal before closing it out
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.1 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:32 a.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Viliam Rockai commented on JBPORTAL-2258:
-----------------------------------------
i'm going to check it
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.1 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:48 a.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Viliam Rockai commented on JBPORTAL-2258:
-----------------------------------------
unfortunatelly i still see the error, i hope i'm doing something wrong during the
testing process.
i'm building the portal just the way like in "jboss-portal-cms-trunk-db"
hudson job for oracle9i configuration
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.1 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:23 a.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Sohil Shah commented on JBPORTAL-2258:
--------------------------------------
Few things to check:
1/ Make sure you are using the same JDBC driver that is being used on hudson. Also is your
database fully cleaned up before starting the test?
2/ You mention Oracle9i. Is the database instance Oracle10g? or Oracle9i
3/ What about Postgresql8?
4/ Can you upload full stacktrace so that I can get some details on the error (both Oracle
and Postgresql where the error is occuring) (preferably both INFO and DEBUG logging mode)
5/ What AS/JBoss Cache instance are you using. I am using 4.2.3 with JBoss Cache 1.4.1
6/ No Soup for you (Seinfeld Soup Nazi style) ;)
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.1 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:49 a.m.
New subject: [JBoss JIRA] Updated: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Thomas Heute updated JBPORTAL-2258:
-----------------------------------
Fix Version/s: 2.7.2 Final
(was: 2.7.1 Final)
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.2 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:47 a.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Prabhat Jha commented on JBPORTAL-2258:
---------------------------------------
Viliam,
We suspect something with DB instance in lab. Can you locally install oracle and try tests
with it?
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Sohil Shah
Fix For: 2.7.2 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:47 a.m.
New subject: [JBoss JIRA] Assigned: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Prabhat Jha reassigned JBPORTAL-2258:
-------------------------------------
Assignee: Viliam Rockai (was: Sohil Shah)
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Viliam Rockai
Fix For: 2.7.2 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:07 a.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Prabhat Jha commented on JBPORTAL-2258:
---------------------------------------
The latest CMS (1.2.3), test ran fine with postgresql but problem with oracle exists in
one form or another.
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Viliam Rockai
Fix For: 2.7.2 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:52 a.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Viliam Rockai commented on JBPORTAL-2258:
-----------------------------------------
at current state the problem is triggered only when no content is written into the
editor.
after typing some content to editor, tests will pass:
http://hudson.qa.jboss.com/hudson/view/JBoss%20Portal/job/jboss-portal-or...
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Viliam Rockai
Fix For: 2.7.2 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:55 p.m.
New subject: [JBoss JIRA] Resolved: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Prabhat Jha resolved JBPORTAL-2258.
-----------------------------------
Resolution: Done
Not it works in all scenarioes.
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Viliam Rockai
Fix For: 2.7.2 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:55 p.m.
New subject: [JBoss JIRA] Closed: (JBPORTAL-2258) Create file in CMS not working for several databases
[
https://jira.jboss.org/jira/browse/JBPORTAL-2258?page=com.atlassian.jira....
]
Prabhat Jha closed JBPORTAL-2258.
---------------------------------
Create file in CMS not working for several databases
----------------------------------------------------
Key: JBPORTAL-2258
URL: https://jira.jboss.org/jira/browse/JBPORTAL-2258
Project: JBoss Portal
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Portal CMS
Affects Versions: 2.7.0 Final
Reporter: Viliam Rockai
Assignee: Viliam Rockai
Fix For: 2.7.2 Final
there are problems with CMS when using oracle9i, oracle10g and postgresql databases. when
trying to create file, an error page (HTTP Status 500 - ) appears. please proceed these
steps on clean database.
create file with:
1. login as admin
2. click admin->cms
3. select create file and create file with these parameters
FileName:"testfile"
Description:"testdesc"
Title:"testtitle"
Language: English
and type "test content" into the content textarea.
4. click create
after clicking create you see and error page dependent on used database.
for oracle 9i:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0019847085) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0019847085)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----
for oracle 10g:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: ORA-00001: unique
constraint (PORTAL.SYS_C0017247442) violated
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: ORA-00001: unique constraint (PORTAL.SYS_C0017247442)
violated
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)
org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:620)
-----------
for postgres:
exception
javax.servlet.ServletException: java.sql.BatchUpdateException: Batch entry 0 insert into
jbp_cms_wsp_prop (PROP_ID, PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:278)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.sql.BatchUpdateException: Batch entry 0 insert into jbp_cms_wsp_prop (PROP_ID,
PROP_DATA, PK) values
(6bfbb6eb-47b9-472f-aadb-234861b8ddeb/{http://jboss.org/jcr/portalcms}lang..., <stream
of 28 bytes>, 33) was aborted. Call getNextException to see the cause.
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
------------
when the browsers back button is pressed, trying to click the create button again lead
into new error (same for each db):
ERROR
Cause: javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
Message: org.jboss.portal.cms.CMSException: javax.transaction.xa.XAException
StackTrace:
javax.portlet.PortletException: org.jboss.portal.cms.CMSException:
javax.transaction.xa.XAException
at
org.jboss.portal.core.cms.ui.admin.CMSAdminPortlet.processAction(CMSAdminPortlet.java:879)
at org.jboss.portlet.JBossPortlet.processAction(JBossPortlet.java:392)
at
org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl$Invoker.doFilter(PortletContainerImpl.java:557)
at
org.jboss.portal.portlet.impl.jsr168.api.FilterChainImpl.doFilter(FilterChainImpl.java:109)
------------------------------
the interesting part is that i.e. creation of a directory in cms is working fine at the
start, but once you try to create file, you have this exception and you cannot create even
the folder anymore.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5599
days inactive
5653
days old
17 comments
4 participants
participants (4)
-
Prabhat Jha (JIRA) -
Sohil Shah (JIRA)
-
Thomas Heute (JIRA)
-
Viliam Rockai (JIRA)