Extended Analytic output uses field type "VARGRAPHIC" exporting to DB2, incompatible with EIS (Doc ID 605572.1)

Last updated on AUGUST 08, 2016

In this Document
  Symptoms
  Changes
  Cause
  Solution


Symptoms

Run an Extended Analytics database from HFM 9.3.1 to a DB2 schema. Columns which should be created with data-type "NVARCHAR" are being created with data-type "VARGRAPHIC".

This data-type cannot be read by Essbase Integration Services, so the resulting database cannot be used by EIS to create an application.

Changes

This problem will not be seen when using SQLServer or Oracle as target database for Extended Analytics, so you might encounter it when switching to a DB2 instance.

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