Troubleshooting Import Oracle Data rules

Summary: After adding a new column to the Oracle table you may get the following error during execution of any Import Oracle Data rules: Exception calling "Fill" with "1" argument(s): "Internal error" 

This article contains step-by-step instructions on how to resolve this issue.

Applies to: Cayosoft Administrator 7.3.0 or later

ID: KB20210210-1

Resolution

1. In Admin Console navigate to Import Oracle Data rule that causes the error.
2. Open More Options section. 
3. In Return these SQL columns specify the explicit list of DB columns instead of the default Return All Columns value.
4. Save changes

OR

1.  Restart Cayosoft administrator Service after oracle DB schema changes were made.