All Forums Database
nagendratrpth 25 posts Joined 03/14
26 Sep 2014
Teradata Error 5533

Hi ,
What is teradata error 5533 about and how to resolve the problem .
Thanks,
Nagendra

Tags:
Raja_KT 1246 posts Joined 07/09
26 Sep 2014

Frod doucment:

5533 Too many MULTITSR Parcels.

Explanation:

The submitted Stored Procedure is too large to handle.

Generated By:

Pardrivr.

For Whom:

End User

Remedy:

Reduce the size of the Stored procedure and submit the request.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

nagendratrpth 25 posts Joined 03/14
26 Sep 2014

what does size mean here ? is it number of  rows , chracters etc a proc request can have ? 
if yes , what are the limitations on size for TD14 ?

Raja_KT 1246 posts Joined 07/09
26 Sep 2014

The stored procedure body size of a stored procedure is limited to 6.4 MB in 14.10. But there is no
limit on the stored procedure object code (compiled stored procedure) size.
If this is not your error, you can contact your DBA.
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

nagendratrpth 25 posts Joined 03/14
26 Sep 2014

Thanks Raja for update.
I reduced stored proc size by remmoving unwanted words and made it with of 3.5 MB as of now and it compiled fine .

You must sign in to leave a comment.