Troubleshooting Import Oracle Data rules

Summary: During oracle rules execution you can face different error messages. The article describes how to resolve these issues.

Applies to: Cayosoft Administrator 7.3.0 or later

ID: KB20210210-1

---

Errors description and possible solutions

Error 1: 

Exception calling "Fill" with "1" argument(s): "Internal error" 

Root cause:

This error can appear after adding a new column to the Oracle table. Cayosoft Administrator caches tables and their columns so rules can fail if DB structure has been changed.

Resolution:

1. Solution 1: specify the explicit list of DB columns instead of using all columns
   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
2. Solution 2: restart Cayosoft administrator Service after oracle DB schema changes were made to refresh the cache.

Error 2: 

Exception calling "Open" with "0" argument(s): "ORA-00600: internal error code, arguments: [kziaVrfyAcctStatInRootCbk: !user],
[<userName>], [], [], [], [], [], [], [], [], [], []" 

Root cause:

This error can appear after migrating oracle database to another location.

Resolution:

1. Create a brand new oracle database account as it is described in this article: https://support.cayosoft.com/hc/en-us/articles/360015798071-Connecting-to-Oracle-Database-#CreatingaCayosoftOracleDatabaseUserAccount 
2. Use this account in Utils or in oracle rules directly (depends on your settings).

Error 3: 

Could not load file or assembly 'file:///C:\oracle\odp.net\managed\common\Oracle.ManagedDataAccess.dll' or
one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515)

Cannot find type
[Oracle.ManagedDataAccess.Client.OracleConnection]: make sure the assembly
containing this type is loaded. 

Root cause:

The Oracle.ManagedDataAccess.dll has beed blocked by operation system. 

Resolution:

You need to unblock the dll:

1. Go to the path specified in the error ("C:/oracle/odp.net/managed/common/Oracle.ManagedDataAccess.dll") and perform right click on it.
2. Select "Properties" and under General tab, tick the Unblock checkbox (at the bottom) and then click Apply then OK buttons.
3. Restart Cayosoft Administrator service.