I am able to access the table from server job successfully but not in parallel job.
Whenever I use the oracle enterprise stage, I get the following error.
Code: Select all
Error:
Oracle_Enterprise_7: Error occurred during initializeFromArgs().
Oracle_Enterprise_7: Connect failed: Oracle client version 0 is NOT supported.
Oracle_Enterprise_7: APT_OraReadOperator: connect failed.
Dump:
main_program: Dump:
{
text="oraread
-nchar_cs UTF-8
-db_cs UTF-8
-dboptions '{user=bbbb,password=******}'
-query 'select
server_name
from
tb_server_details'
-server 'database_name'
-use_strings
[ident('Oracle_Enterprise_7'); jobmon_ident('Oracle_Enterprise_7')]
0> [modify(keep server_name;server_name:nullable string[max=40]=server_name;)] 'Oracle_Enterprise_7:DSLink9.v'
;
peek
-nrecs 10
-name
[ident('Peek_0'); jobmon_ident('Peek_0')]
0< [] 'Oracle_Enterprise_7:DSLink9.v'
;",
line=1, column=1, name="", qualname="",
op={
text="oraread
-nchar_cs UTF-8
-db_cs UTF-8
-dboptions '{user=bbbb,password=******}'
-query 'select
server_name
from
tb_server_details'
-server 'database_name'
-use_strings
[ident('Oracle_Enterprise_7'); jobmon_ident('Oracle_Enterprise_7')]
0> [modify(keep server_name;server_name:nullable string[max=40]=server_name;)] 'Oracle_Enterprise_7:DSLink9.v'",
line=1, column=1, name=oraread, qualname=Oracle_Enterprise_7,
wrapout={},
wrapperfile=oraread, kind=non_wrapper_cdi_op, exec_mode=none,
args="'UTF-8'-db_cs'UTF-8'-dboptions'{user=bbbb,password=******}'-query'select\nserver_name\nfrom\ntb_server_details'-server'database_name'-use_strings'",
output={
text="
0> [modify(keep server_name;server_name:nullable string[max=40]=server_name;)] 'Oracle_Enterprise_7:DSLink9.v'",
line=12, column=1, name="",
qualname="Oracle_Enterprise_7[o0]",
data="Oracle_Enterprise_7:DSLink9.v",
outadapt="keep server_name;server_name:nullable string[max=40]=server_name;"
}
},
op={
text="
peek
-nrecs 10
-name
[ident('Peek_0'); jobmon_ident('Peek_0')]
0< [] 'Oracle_Enterprise_7:DSLink9.v'",
line=18, column=1, name=peek, qualname=Peek_0,
wrapout={},
wrapperfile=peek, kind=non_wrapper_cdi_op, exec_mode=none,
args="'10'-name'",
input={ text="
0< [] 'Oracle_Enterprise_7:DSLink9.v'", line=22,
column=1, name="", qualname="Peek_0[i0]",
data="Oracle_Enterprise_7:DSLink9.v"
}
},
data={
text="
0> [modify(keep server_name;server_name:nullable string[max=40]=server_name;)] 'Oracle_Enterprise_7:DSLink9.v'",
line=12, column=1, name="Oracle_Enterprise_7:DSLink9.v",
qualname="Oracle_Enterprise_7:DSLink9.v",
partwrapout={},
collwrapout={},
dir=flow, kind=ds, writer=Oracle_Enterprise_7, reader=Peek_0,
pp=none, trunc=default, ident="Oracle_Enterprise_7:DSLink9.v"
}
}
Thanks & Regards
Prasad