Kbase 19640: SonicMQ: Durable Subscription Name Limit
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/03/2010 |
|
Status: Verified
SYMPTOM(s):
Durable subscription name exceeds a maximum length of 128 characters
Exception when client information is written to the database
SQLException(SQLState=22001, errorCode=20000):
Non-blank characters were found while truncating string
<durable subscription name> from length <n> to length 128.
FACT(s) (Environment):
All Supported Operating Systems
SonicMQ
CAUSE:
When a durable subscription is created in Progress SonicMQ, an ID is created that consists of:
"$DURABLE$" + <jclient clientId> + "$" + <name of
subscription>
The <jclient clientId> and the <name of subscription> are supplied by the application. The database column in which the ID is stored is defined with a maximum length of 128.
FIX:
Ensure that the durable subscription name is no greater than 128 characters, taking into consideration the <jclient clientId> and the <name of subscription> components of the durable subscription name.