[
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 [email protected] 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 [email protected]
-------------
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.
