Question & Answer
Question
When trying to execute a Stored Procedure, you might hit into the following error. "FATAL...input buffer overflow, can't enlarge buffer because scanner uses REJECT" What does that means ?
Cause
The error is triggered by the use of a string literal that is longer than 16k long used in the stored procedure body.
(The size might various depends on the Netezza version you are using.)
Answer
The solution is to break the long literal string into smaller string and concat them using "||"
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21626744