DSXchange

Yaah it is column import stage, by mistake written import stage.

Hi, I am getting below error, may i know the cause of the error. in job using Import stage, Transfofrmer and seq file. main_program: Syntax error: Error in "field_import" operator: Error in output redirection: Error in output parameters: Error in modify adapter: Error in binding: Could not...

hi craig,

whatever, but problem is problem, when i searched in IBM portal, they mentioned use APT_MAX_DELIMITED_READ_SIZE.

But without using and just simple oracle connector refresh only it was worked.

But we are testing it is temporary solution or permanent

Hi,

I am phasing below Fatal Error.

Parallel job reports failure (code 11)

there is temporary solution for this, Just remove the existing Oracle connection and add the Oracle connector, then it works fine.

But, i want permanent solution, in production i can't fix all the time in the same way.

yes,

we are feching records through oracle connector and done the manipulation through storeprocdure and store it in oracle table.

our project default NLS is UTF-18.

even i am going to check NLS change to ASCII let's check.

Hi, I am phasing below error, i searched in dsxchange but i didn't found the correct answer. DS Version : 9.1.2 Stage: oracle connector Read_Base_Table_Historical,0: The OCI function OCIStmtFetch2 returned status -1. Error code: 24,374, Error message: ORA-24374: define not done before fetch or execu...

Hi Eric,
Some one has changed the tns entries, still it's a mistry who has changed, after u r suggestion once ag we ain we checked everything and replace the correct one

Eric,

tnsfile is copied one, which one we are using with datastage 8.5, same one copied and using for 9.1.2..

there is no changes in tnsfile even.

i checked more than double with hard code the server name in DS.

but still showing same message.

Yes it problem with the host, DS is not connecting or Oracle host is not connecting with the DS, we are checking that.

what is meant "typo " eric

sorry craig...

with the same credentials we ran 1,2 sequencers but 3rd one failing and showing the above warning....

Hi, sequencer is not running fine and the showing below message. sorry small correction, with the same credentials we ran two more sequencers, those worked fine but we ran 3rd sequencer showing below message ExecStoredProc,0: Error: ORA-12545: Connect failed because target host or object does not ex...

sure, will search and find the solution.

May be it seems Parmeter issue...

Working fine After I have done the linksort for before and after data links in chagecapture.

Hi, Please find below error message and help me in that one. main_program: Data set, file set, or file "LookupPART_IDAttributes:AttributesOfRejPart_id.v": Non-pipe (or non-virtual data set) with .v in its name Data set, file set, or file "Lookup_53:PTI_CDNull.v": Non-pipe (or non...

Yes,

The source records are updating.

Please help some one