roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anil Gangolli (JIRA)" <>
Subject [jira] Commented: (ROL-1814) getting exception when adding a new entry to the weblog
Date Fri, 22 May 2009 15:36:46 GMT


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 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

A system temporary table space with sufficient page size does not exist.

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:
>             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.content, t0.contenttype,,, t0.notify, t0.plugins, t0.posttime,
t0.referrer, t0.remotehost, t0.status, t0.url, t0.useragent,, t1.allowcomments, t1.anchor,, t2.description, t2.image,,, t3.description, t3.image,, t3.path,
t3.websiteid, t2.path,, t4.about, t4.isactive, t4.allowcomments, t4.blacklist,,
t5.description, t5.image,, t5.path, t5.websiteid,, 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.description,
t7.image,, 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.pagemodels, t4.showalllangs, t4.timeZone,
t4.weblogdayid, t1.commentdays, t1.content_src, t1.content_type,, t8.activationcode,
t8.datecreated, t8.emailaddress, t8.isenabled, t8.fullname, t8.locale, t8.passphrase, t8.screenname,
t8.timeZone, t8.username,, t1.locale, t1.pinnedtomain, t1.plugins, t1.pubtime, t1.righttoleft,
t1.status, t1.summary, t1.text, t1.title, t1.updatetime,, 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.pagemodels, t9.showalllangs, t9.timeZone, t9.weblogdayid FROM roller_comment
t0 LEFT OUTER JOIN weblogentry t1 ON t0.entryid = LEFT OUTER JOIN weblogcategory t2
ON t1.categoryid = LEFT OUTER JOIN rolleruser t8 ON t1.userid = LEFT OUTER JOIN
website t9 ON t1.websiteid = LEFT OUTER JOIN weblogcategory t3 ON t2.parentid =
LEFT OUTER JOIN website t4 ON t2.websiteid = LEFT OUTER JOIN weblogcategory t5 ON t4.bloggercatid
= LEFT OUTER JOIN rolleruser t6 ON t4.userid = LEFT OUTER JOIN weblogcategory
t7 ON t4.defaultcatid = 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.

View raw message