My Oracle Support Banner

IBMIS 8.5 DataStage ETL Job Fails When There Is An Upside Down Question Mark In A Source Description Field (Doc ID 1596018.1)

Last updated on JUNE 26, 2018

Applies to:

PeopleSoft Enterprise EPM Performance Management Warehouse - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

PeopleSoft Enterprise EPM Performance Management Warehouse 9.1
DataStage Version = 8.5.0.2
Information Server 8.5 FixPack 2 (fixpack.is_85.linux64.FP2_RC1.7.111216)

DataStage Jobs fail when there is an upside down question mark in a Description Field. The job fails during the Select of Source Data (DRS Connector).

ERROR
-----------------------
DRS Connector Error
Error Message: SCTW_HR_NOTE_STG..IPC_in.IDENT2: Exception thrown from CC_OraStatement::logArrayReturnCodes, file CC_OraStatement.cpp, line 4103: While reading data for column HR_NP_SUBJECT, the connector received Oracle error code ORA-1406.
Data => HR_NP_SUBJECT = "Corrected: Leave of Absence/Acting Appts ¿ UNIV On"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. IBM InfoShpere DataStage Designer or Director
2. Select any OWS Staging Sequence Job
3. Run

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot move Source Data into Target Warehouse.
ODM Issue Clarification

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.