DSXchange

I am using DS 8.5 and facing the same issue - Datastage Client doesnot exist on the system..

In the above post, people resolved this issue by upgrading it to fix pack 1.

What shall be done without upgrading it to fix the problem. ?

Like warning starting with "TRNF_FULL_LOAD,3: Invalid character(s) ([xFFFD]) found converting Unicode string (code point(s)" should be bypass.

It was just an example.

I had tried everything with the DBA.

I just want to bypass the warning.

The challenge is that every warning is different.But the starting few words of the warning are the same.

Can anyone please suggest....how to handle it?

Can we use some logic like wildcard logic to bypass these warnings?

How do you think it can be handled through message handler as each warning is different based on the data?

Let me give you some examples of the warning which will help you to understand the problem properly: TRNF_FULL_LOAD,3: Invalid character(s) ([xFFFD]) found converting Unicode string (code point(s): CALLE JORGE JUAN, 19 - - PISO 6[xFFFD] IZDA) to codepage ISO-8859-1, substituting. TRNF_FULL_LOAD,3: I...

Hi, There is a job which loads almost 80 million records. This job takes long time to finish because it faces a lot of warning for the data. Almost 20 million records must be getting warning. But the challenge is that warning for each record is a different based on the data. If there is any feature ...

Can anyone please help me on this?

I have a SAS dataset in sas7bdat format. I want to read this SAS dataset using SAS Parallel Dataset stage. When I am trying to view the data then I am getting the following error: Error executing View Data command:##E IIS-DSEE-TOSE-00035 20:14:49(006) <APT_SasImport> Error when checking composite op...

There is a job which reads from a sequential file and writing into a SAS dataset. The job is failing due to an error: main_program: Syntax error: Error in "copy" operator: Error in output redirection: Expected output name, got: "]", line 95; text: 0>] Please someone help me to ge...

Getting this error after following the above advice:

APT_CombinedOperatorController,0: Data string '25/10/2011' does not match format '%yyyy-%mm-%dd': the value for tag %yyyy has fewer characters than expected.

The sample date format is 10/25/2011. As mentioned earlier,the data type of target table in job 1 is DATE.In the Job 2,the source oracle stage in which table which got populated from job 1 is the source also has the column datatype as DATE. I want to use ORACLE stage. I am just using SELECT .... FRO...

In Job1, I am getting a column CREATED_DT in an oracle table populated with current date using datastage date function CurrentDate().This column is having DATE datatype. In Job2, this column CREATED_DT from the table which got loaded in Job1 is mapped to another column CREATED_DT in a different tabl...

Did anyone ever faced this issue before?

I am getting this error even after using StringToDate function: This below error is from the oracle stage: Oracle_Enterprise_0: Error when checking operator: When binding output interface field "DW_CREATE_DT" to field "DW_CREATE_DT": No default type conversion from type "str...

I am getting this error after using the above advice: >##E IIS-DSEE-TFIP-00011 23:07:44(000) <Oracle_Enterprise_0> Error when checking operator: When binding output interface field "DW_CREATE_DT" to field "DW_CREATE_DT": No default type conversion from type "string[max=75]&q...