Skip to main content
J
JoBo
Newcomer
December 15, 2022

FDX query throws an exception error when empty.

  • December 15, 2022
  • 1 reply
  • 0 views

Hi, I'm currently using a FDX query to create an automated Journal. Works basically fine but when the FDX query is completely empty it throws an exception error message. Not a very big deal but the users experience this as a failure of the system. Does someone know a way to avoid this throw or to customize the exception error message in case of an empty datatable?

FYI a check on the datatable (f (Not dt Is Nothing) And (dt.Rows.count > 0) Then) still gives the throw.

 

Thanks!

 

1 reply

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
December 16, 2022

Hard to say without looking at the code or the error, but did you try just surrounding the guilty call with a try/catch block...? So that you can then ignore the exception.

Terms & ConditionsAccessibility statement