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.

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

Solution 1: specify the explicit list of DB columns instead of using all columns.

1. In the Cayosoft Administrator Console, navigate to the Import Oracle Data rule that causes the error.

2. Open the More Options section.

3. In the Return these SQL columns, specify the explicit list of DB columns instead of the default Return All Columns value.

4. Save changes.

Solution 2: restart the 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

Create a brand new oracle database account as it is described in this article: Creating a Cayosoft Oracle Database User Account.

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 right click the dll file.

2. Select Properties and under General tab, tick the Unblock checkbox.

3. Click Apply then OK.

4. Restart the Cayosoft Administrator Service.