Solved

EDI Invoices Server Error (Buffer Too Small)

  • 24 October 2023
  • 1 reply
  • 49 views
U
Rank
Badge

when  a user try to send a lot of invoices via EDI at a time (eg-120 invoices) in “print customer invoices window” get a server error that the buffer is too small, but if  send them one customer at a time(in batches) they all send with no issues. Is there a way that the user can send  all the invoices at once without batch sending.

 

Error message

16:33:25 ERROR - PL/SQL: (Server Error) numeric or value error: character string

buffer too small Database error occurred. Contact administrator. undefined

 

16:33:25 ERROR - Command error: (PL/SQL) - numeric or value error: character string

buffer too small, details: undefined undefined

icon

Best answer by Ralph Gericke 24 October 2023, 16:57

View original

1 reply

Ralph Gericke
Rank
Userlevel 5
Badge +11

Hi,

most probably the number of invoices that you selected is too high. If you select 120 invoices the system needs keep the 10x120 characters =1200 Characters in the background to send each of them.
If the field can only store 1000 characters the function will throw an error.

Unfortunatley I dont know whats the max. size is. Is there a reason why you send them all one by one and not directly after their creation?

Regards

Ralph

Reply


Terms & ConditionsCookie settings