You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by "Anne Priya Alexander (JIRA)" <ji...@apache.org> on 2009/05/22 11:56:45 UTC
[jira] Created: (ROL-1814) getting exception when adding a new
entry to the weblog
getting exception when adding a new entry to the weblog
-------------------------------------------------------
Key: ROL-1814
URL: https://issues.apache.org/jira/browse/ROL-1814
Project: Roller
Issue Type: Question
Components: Database Access & Data Model
Affects Versions: 4.0.1
Environment: Windows XP
Reporter: Anne Priya Alexander
Assignee: Roller Unassigned
Hi,
i have installed roller as per the steps and was able to create a new weblog but as soon as i submit a new entry to the blog and click on "post to weblog" i am getting the below mentioned exception
<0.9.7-incubating nonfatal general error> org.apache.openjpa.persistence.PersistenceException: DB2 SQL error: SQLCODE: -1585, SQLSTATE: 54048, SQLERRMC: null {prepstmnt 20121261 SELECT t0.id, t0.content, t0.contenttype, t0.email, t0.name, t0.notify, t0.plugins, t0.posttime, t0.referrer, t0.remotehost, t0.status, t0.url, t0.useragent, t1.id, t1.allowcomments, t1.anchor, t2.id, t2.description, t2.image, t2.name, t3.id, t3.description, t3.image, t3.name, t3.path, t3.websiteid, t2.path, t4.id, t4.about, t4.isactive, t4.allowcomments, t4.blacklist, t5.id, t5.description, t5.image, t5.name, t5.path, t5.websiteid, t6.id, t6.activationcode, t6.datecreated, t6.emailaddress, t6.isenabled, t6.fullname, t6.locale, t6.passphrase, t6.screenname, t6.timeZone, t6.username, t4.customstylesheet, t4.datecreated, t4.defaultallowcomments, t7.id, t7.description, t7.image, t7.name, t7.path, t7.websiteid, t4.defaultcommentdays, t4.defaultpageid, t4.defaultplugins, t4.description, t4.editorpage, t4.editortheme, t4.emailaddress, t4.emailcomments, t4.emailfromaddress, t4.enablebloggerapi, t4.enablemultilang, t4.isenabled, t4.displaycnt, t4.handle, t4.icon, t4.lastmodified, t4.locale, t4.commentmod, t4.name, t4.pagemodels, t4.showalllangs, t4.timeZone, t4.weblogdayid, t1.commentdays, t1.content_src, t1.content_type, t8.id, t8.activationcode, t8.datecreated, t8.emailaddress, t8.isenabled, t8.fullname, t8.locale, t8.passphrase, t8.screenname, t8.timeZone, t8.username, t1.link, t1.locale, t1.pinnedtomain, t1.plugins, t1.pubtime, t1.righttoleft, t1.status, t1.summary, t1.text, t1.title, t1.updatetime, t9.id, t9.about, t9.isactive, t9.allowcomments, t9.blacklist, t9.bloggercatid, t9.userid, t9.customstylesheet, t9.datecreated, t9.defaultallowcomments, t9.defaultcatid, t9.defaultcommentdays, t9.defaultpageid, t9.defaultplugins, t9.description, t9.editorpage, t9.editortheme, t9.emailaddress, t9.emailcomments, t9.emailfromaddress, t9.enablebloggerapi, t9.enablemultilang, t9.isenabled, t9.displaycnt, t9.handle, t9.icon, t9.lastmodified, t9.locale, t9.commentmod, t9.name, t9.pagemodels, t9.showalllangs, t9.timeZone, t9.weblogdayid FROM roller_comment t0 LEFT OUTER JOIN weblogentry t1 ON t0.entryid = t1.id LEFT OUTER JOIN weblogcategory t2 ON t1.categoryid = t2.id LEFT OUTER JOIN rolleruser t8 ON t1.userid = t8.id LEFT OUTER JOIN website t9 ON t1.websiteid = t9.id LEFT OUTER JOIN weblogcategory t3 ON t2.parentid = t3.id LEFT OUTER JOIN website t4 ON t2.websiteid = t4.id LEFT OUTER JOIN weblogcategory t5 ON t4.bloggercatid = t5.id LEFT OUTER JOIN rolleruser t6 ON t4.userid = t6.id LEFT OUTER JOIN weblogcategory t7 ON t4.defaultcatid = t7.id WHERE (t0.entryid = ?) ORDER BY t0.posttime ASC [params=(String) c1da0b48-0902-4a3e-affa-893fc390196a]} [code=-1585, state=54048]SQLCA OUTPUT[Errp=SQLNO24B, Errd=[-2145779603, 0, 0, 0, -1000, 0]]
Can anyone help me resolve this issue .
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (ROL-1814) getting exception when adding a new
entry to the weblog
Posted by "Anil Gangolli (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ROL-1814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12712138#action_12712138 ]
Anil Gangolli commented on ROL-1814:
------------------------------------
This looks like it may be a configuration issue on the database side. Please see the description below of the error code taken from IBM's site.
I would suggest that you subscribe to the user@roller.apache.org mailing list and try your question there in order to reach more people who might be using DB2 on a regular basis. I am not sure any of the developers reading this are using DB2 on a regular basis. Also, you should include your DB2 version and JDBC driver version information.
Please see the User Response section below and try that. If that doesn't help please post to user@roller.apache.org
-------------
SQL1585N
A system temporary table space with sufficient page size does not exist.
Explanation:
One of the following conditions could have occurred:
1. The row length of the system temporary table exceeded the limit that can be accommodated in the largest system temporary table space in the database.
2. The number of columns required in a system temporary table exceeded the limit that can be accommodated in the largest system temporary table space in the database.
The system temporary table space limits depend on its page size. These values are:
Max Max Page size of
Record Cols temporary
Length table space
----------- ---- ------------
1957 bytes 244 2K
4005 bytes 500 4K
8101 bytes 1012 8K
16293 bytes 1012 16K
32677 bytes 1012 32K
User Response:
Create a system temporary table space of a larger page size supported, if one does not already exist. If such a table space already exists, eliminate one or more columns from the system temporary table. Create separate tables or views, as required, to hold additional information beyond the limit.
sqlcode: -1585
sqlstate: 54048
> getting exception when adding a new entry to the weblog
> -------------------------------------------------------
>
> Key: ROL-1814
> URL: https://issues.apache.org/jira/browse/ROL-1814
> Project: Roller
> Issue Type: Question
> Components: Database Access & Data Model
> Affects Versions: 4.0.1
> Environment: Windows XP
> Reporter: Anne Priya Alexander
> Assignee: Roller Unassigned
> Original Estimate: 1.67h
> Remaining Estimate: 1.67h
>
> Hi,
> i have installed roller as per the steps and was able to create a new weblog but as soon as i submit a new entry to the blog and click on "post to weblog" i am getting the below mentioned exception
> <0.9.7-incubating nonfatal general error> org.apache.openjpa.persistence.PersistenceException: DB2 SQL error: SQLCODE: -1585, SQLSTATE: 54048, SQLERRMC: null {prepstmnt 20121261 SELECT t0.id, t0.content, t0.contenttype, t0.email, t0.name, t0.notify, t0.plugins, t0.posttime, t0.referrer, t0.remotehost, t0.status, t0.url, t0.useragent, t1.id, t1.allowcomments, t1.anchor, t2.id, t2.description, t2.image, t2.name, t3.id, t3.description, t3.image, t3.name, t3.path, t3.websiteid, t2.path, t4.id, t4.about, t4.isactive, t4.allowcomments, t4.blacklist, t5.id, t5.description, t5.image, t5.name, t5.path, t5.websiteid, t6.id, t6.activationcode, t6.datecreated, t6.emailaddress, t6.isenabled, t6.fullname, t6.locale, t6.passphrase, t6.screenname, t6.timeZone, t6.username, t4.customstylesheet, t4.datecreated, t4.defaultallowcomments, t7.id, t7.description, t7.image, t7.name, t7.path, t7.websiteid, t4.defaultcommentdays, t4.defaultpageid, t4.defaultplugins, t4.description, t4.editorpage, t4.editortheme, t4.emailaddress, t4.emailcomments, t4.emailfromaddress, t4.enablebloggerapi, t4.enablemultilang, t4.isenabled, t4.displaycnt, t4.handle, t4.icon, t4.lastmodified, t4.locale, t4.commentmod, t4.name, t4.pagemodels, t4.showalllangs, t4.timeZone, t4.weblogdayid, t1.commentdays, t1.content_src, t1.content_type, t8.id, t8.activationcode, t8.datecreated, t8.emailaddress, t8.isenabled, t8.fullname, t8.locale, t8.passphrase, t8.screenname, t8.timeZone, t8.username, t1.link, t1.locale, t1.pinnedtomain, t1.plugins, t1.pubtime, t1.righttoleft, t1.status, t1.summary, t1.text, t1.title, t1.updatetime, t9.id, t9.about, t9.isactive, t9.allowcomments, t9.blacklist, t9.bloggercatid, t9.userid, t9.customstylesheet, t9.datecreated, t9.defaultallowcomments, t9.defaultcatid, t9.defaultcommentdays, t9.defaultpageid, t9.defaultplugins, t9.description, t9.editorpage, t9.editortheme, t9.emailaddress, t9.emailcomments, t9.emailfromaddress, t9.enablebloggerapi, t9.enablemultilang, t9.isenabled, t9.displaycnt, t9.handle, t9.icon, t9.lastmodified, t9.locale, t9.commentmod, t9.name, t9.pagemodels, t9.showalllangs, t9.timeZone, t9.weblogdayid FROM roller_comment t0 LEFT OUTER JOIN weblogentry t1 ON t0.entryid = t1.id LEFT OUTER JOIN weblogcategory t2 ON t1.categoryid = t2.id LEFT OUTER JOIN rolleruser t8 ON t1.userid = t8.id LEFT OUTER JOIN website t9 ON t1.websiteid = t9.id LEFT OUTER JOIN weblogcategory t3 ON t2.parentid = t3.id LEFT OUTER JOIN website t4 ON t2.websiteid = t4.id LEFT OUTER JOIN weblogcategory t5 ON t4.bloggercatid = t5.id LEFT OUTER JOIN rolleruser t6 ON t4.userid = t6.id LEFT OUTER JOIN weblogcategory t7 ON t4.defaultcatid = t7.id WHERE (t0.entryid = ?) ORDER BY t0.posttime ASC [params=(String) c1da0b48-0902-4a3e-affa-893fc390196a]} [code=-1585, state=54048]SQLCA OUTPUT[Errp=SQLNO24B, Errd=[-2145779603, 0, 0, 0, -1000, 0]]
> Can anyone help me resolve this issue .
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.