Skip to main content
Solved

EDI Invoices Server Error (Buffer Too Small)

  • October 24, 2023
  • 1 reply
  • 77 views

Forum|alt.badge.img

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

Best answer by Ralph Gericke

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

View original
Did this topic help you find an answer to your question?

1 reply

Ralph Gericke
Hero (Employee)
Forum|alt.badge.img+11
  • Hero (Employee)
  • 205 replies
  • Answer
  • October 24, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings