0
Views
2
Comments
Null Values in Integration Service Extension Module
Question
I have an application that uses a xif extension module that read data from an external database using stored procedures. When some field of the returned recordlist contains null values, the message "Data is Null. This method or property cannot be called on Null values" is showed in an exception screen (Internal Error) and the execution is aborted, How can I do continue the execution? I already defined the field in the structure as not mandatory with no success.

2016-04-21 20-09-55
J.
 
MVP
In the action where you call the xif-action, you add an exceptionhandler where you set the property "abort transaction" to no


2018-06-14 12-24-08
Roberto Campos
Hi Statler,

Thank you by your attention. I think that I solved the problem with a better option. To resolve the null question was enough to use the Getsafe method of the SQLReader class instead the Get method. After this change the application worked.

Best Regards,

Roberto
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.