Error At Line 20 - Set RsAppend = DW.DataAccess.farsTable(strWorkTableName) In FDM (Doc ID 1453187.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.1.3.00 to 11.1.2.1.000 [Release 11.1]
Information in this document applies to any platform.

Symptoms

I created the data table in SQL server. Put in the identical code from the FDM admin guide for the integration script.

When I execute from the script section, I get the following error.

When executed from the script section
=======================
Error: An error occurred running the script:
-2147217865 - Data access error.
At Line: 20

Line 20 points to Set rsAppend = DW.DataAccess.farsTable(strWorkTableName)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms