MQSeries.net :: View topic

jday123 · Posted: Thu Aug 09, 2007 9:29 am Post subject: Insufficient Memory error

Hi,

I get an insufficient memory error when trying to run a stored proc. Would you please tell me how to fix it.
The current MQ trigger is using an old Sybase open client version 4.x.
Below is an excerpt from the error log. I hope it makes more sense to you than it does to me.

Thanks for your help!
>
Application ID: <CAPACITY_PLANNING>
Sybase procedure name: <UP_UPDATE_GGS_YARNS>
buffer: <C C C C C C C C C C C C C C C C C C C C C C
M A B302 0162 K 0 D 29 000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <1> and value <M A B302 0162 K 0 D 29 000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <1> and size <1>
parameter <2> and value <A B302 0162 K 0 D 29 000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <2> and size <1>
parameter <3> and value <B302 0162 K 0 D 29 000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <3> and size <4>
parameter <4> and value <0162 K 0 D 29 000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <4> and size <4>
parameter <5> and value <K 0 D 29 000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <5> and size <1>
parameter <6> and value <0 D 29 000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <6> and size <1>
parameter <7> and value <D 29 000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <7> and size <1>
parameter <8> and value <29 000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <8> and size <2>
parameter <9> and value < 000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <9> and size <4>
parameter <10> and value < 000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <10> and size <2>
parameter <11> and value <000967 01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <11> and size <6>
parameter <12> and value <01 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <12> and size <4>
parameter <13> and value < 050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <13> and size <4>
parameter <14> and value <050000 03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <14> and size <6>
parameter <15> and value <03250 STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <15> and size <5>
parameter <16> and value <STRAIGHT B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <16> and size <30>
parameter <17> and value <B-CAM H-PH 14/32 A B0302/KZVCX Y
>
parameter <17> and size <30>
parameter <18> and value <H-PH 14/32 A B0302/KZVCX Y
>
parameter <18> and size <13>
parameter <19> and value <14/32 A B0302/KZVCX Y
>
parameter <19> and size <13>
parameter <20> and value <A B0302/KZVCX Y
>
parameter <20> and size <255>
parameter <21> and value <B0302/KZVCX Y
>
parameter <21> and size <30>
number of parameters: <22>
Log into server: <SU072SYT3>
whole rpc name: <cap_plan_db1.dbo.UP_UPDATE_GGS_YARNS>
DB-Library error message:
severity: 8
error num: 20010
error text: Unable to allocate sufficient memory.
DB-Library error message:
severity: 8
error num: 20010
error text: Unable to allocate sufficient memory.
RPC initialization OK
Sybase server error message:
Sybase server name: SU072SYT3
error message number: 249
severity: 16
error text: Syntax error during explicit conversion of CHAR value 'D ' to a FLOAT field.
-------------- new request -------------