| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [IBM][CLI Driver] CLI0002W Data truncated. SQLSTATE=01004 |
« View previous topic :: View next topic » |
| Author |
Message
|
| Vanshul_MB |
 Posted: Fri Jun 17, 2011 11:16 pm Post subject: [IBM][CLI Driver] CLI0002W Data truncated. SQLSTATE=01004 |
 |
|
Acolyte
Joined: 09 Feb 2011
Posts: 68
|
We are getting an error
Child SQL exception, 01004, -99999, [IBM][CLI Driver] CLI0002W Data truncated. SQLSTATE=01004
while populating the Environment with resultset of a query.So our SET statement is
SET Environment.Variables.ConfigData.HotelPointOfInterests[ ] = PASSTHRU(CH_HotelPointOfInterests, Database.{dataSourceName});
This error says
CLI0002W
Data truncated.
Explanation
An output buffer specified is not large enough to contain the data.
User response
Increase the size of the output buffer.
Please let us know that are there some restrictions on the amount of data that can be stored in Environment or is it dependent on system configuration. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Sat Jun 18, 2011 9:27 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
It would be easier to help if you stated the case scenario...
How many rows are you trying to put into the environment, 1? 1,000? 1,000,000?
What is the size of a row, 1KB, 1MB, 100MB?
And finally what is the scope of the data: flow lifetime, instance lifetime?
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Vanshul_MB |
| Posted: Sat Jun 18, 2011 8:18 pm Post subject: |
|
|
Acolyte
Joined: 09 Feb 2011
Posts: 68
|
Hello,
Thanks for response.
The rows can be more than 100000 also as we are taking properties from tables and can extend upto several lines.
Its getting set in environment so its per flow lifetime.
Its working perfect on my local broker but on the linix broker setup by admin guys, it bombs.  |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sat Jun 18, 2011 10:01 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Vanshul_MB wrote: |
Its working perfect on my local broker but on the linix broker setup by admin guys, it bombs. |
Are you using the same physical DB server on both systems?
If so then I'd look at the kernel config for the Linux system. Did your local linux admin follow the WMQ Install manual and increase certain kernel params? These might not be enough for the sort of data you are retrieving.
Look at the sort of ipcs related settings that you'd need to run an Oracle Server on the box. That is what I use as the basis for my Linux based Broker installs.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
