Bug 778030 (SOA-553)

Summary: Document the Sybase related issue - page size
Product: [JBoss] JBoss Enterprise SOA Platform 4 Reporter: Jiri Pechanec <jpechane>
Component: JBPM - within SOAAssignee: Joshua Wulf <jwulf>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 4.2 CP01CC: lcarlon
Target Milestone: ---   
Target Release: 4.2 CP02   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-553
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2008-06-25 08:54:20 UTC Type: Feature Request
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Jiri Pechanec 2008-05-22 12:47:35 UTC
Date of First Response: 2008-05-29 21:32:27
project_key: SOA

See JBPM-1176

Comment 1 Jiri Pechanec 2008-05-22 12:47:43 UTC
Link: Added: This issue depends JBPM-1176


Comment 2 Joshua Wulf 2008-05-30 01:32:27 UTC
Release notes:

7.1. Sybase database cuts the payload according to pagesize by default

When a database is created Sybase sets the maximum size of text and image datatypes to the default page size of 2 KB. The longer message payload is truncated without any information or warning. The database parameters have to be updated to change the page size.

Further information: http://jira.jboss.com/jira/browse/SOA-554 | http://jira.jboss.com/jira/browse/SOA-553 

Comment 3 Joshua Wulf 2008-05-30 01:35:56 UTC
Release notes

Comment 4 Jiri Pechanec 2008-06-10 09:33:49 UTC
This is different case, in this case the limitation is on the whole row length and requires database instance configuration at the level of command line of started instance. Please check the links on the linked issue. 

Comment 5 Joshua Wulf 2008-06-24 03:29:09 UTC
8.4. Sybase database may throw Error 511 if pagesize is too small

Sybase database may fail to insert a row if the total size of the row exceeds the page size allocated for the database. A command line option passed to the dataserver command used to start the database can be used to change the page size.

Further information: http://jira.jboss.com/jira/browse/SOA-553 

Comment 6 Jiri Pechanec 2008-06-25 08:54:20 UTC
Verified in CR4