Connecting to Oracle stage-Error
Posted: Wed May 17, 2006 4:20 am
Hi,
I have Oracle 10g installed.I could able connect through Dyanamic RDBMS,ODBC and used the orchbutil utility to import metadata but i cannot view data through Oracle Enterprise edtion stage i am getting the following error.
#I TOSH 000002 15:30:24(001) <main_program> orchgeneral: loaded
##I TOSH 000002 15:30:24(002) <main_program> orchsort: loaded
##I TOSH 000002 15:30:24(003) <main_program> orchstats: loaded
##W TDOR 000160 15:30:24(004) <main_program> An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG
>##E TDOR 000008 15:30:24(006) <Oracle_Enterprise_0> Missing server name. Can't connect
>##E TDOR 000140 15:30:24(007) <Oracle_Enterprise_0> APT_OraReadOperator: connect failed.
>##E TOPK 000000 15:30:24(010) <_PEEK_IDENT_> Input dataset does not have field: "EMPNO"
>##E TOPK 000000 15:30:24(011) <_PEEK_IDENT_> Input dataset does not have field: "ENAME"
>##E TOPK 000000 15:30:24(012) <_PEEK_IDENT_> Input dataset does not have field: "JOB"
>##E TOPK 000000 15:30:24(013) <_PEEK_IDENT_> Input dataset does not have field: "MGR"
>##E TOPK 000000 15:30:24(014) <_PEEK_IDENT_> Input dataset does not have field: "HIREDATE"
>##E TOPK 000000 15:30:24(015) <_PEEK_IDENT_> Input dataset does not have field: "SAL"
>##E TOPK 000000 15:30:24(016) <_PEEK_IDENT_> Input dataset does not have field: "COMM"
>##E TOPK 000000 15:30:24(017) <_PEEK_IDENT_> Input dataset does not have field: "DEPTNO"
>##E TFSR 000019 15:30:24(019) <main_program> Could not check all operators because of previous error(s)
##W TFOR 000000 15:30:24(020) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "EMPNO"
##W TFOR 000000 15:30:24(021) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "ENAME"
##W TFOR 000000 15:30:24(022) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "JOB"
##W TFOR 000000 15:30:24(023) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "MGR"
##W TFOR 000000 15:30:24(024) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "HIREDATE"
##W TFOR 000000 15:30:24(025) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "SAL"
##W TFOR 000000 15:30:24(026) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "COMM"
##W TFOR 000000 15:30:24(027) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "DEPTNO"
>##E TCOS 000029 15:30:24(028) <main_program> Creation of step finished with status = FAILED.
I walked through the error,its saying server name missing but i have given the same in the property additional connection information.
I guess i need to do some settings to make it work.Any inputs would be most appreciated.
Thanks in advance.
Regards,
Bala.
I have Oracle 10g installed.I could able connect through Dyanamic RDBMS,ODBC and used the orchbutil utility to import metadata but i cannot view data through Oracle Enterprise edtion stage i am getting the following error.
#I TOSH 000002 15:30:24(001) <main_program> orchgeneral: loaded
##I TOSH 000002 15:30:24(002) <main_program> orchsort: loaded
##I TOSH 000002 15:30:24(003) <main_program> orchstats: loaded
##W TDOR 000160 15:30:24(004) <main_program> An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG
>##E TDOR 000008 15:30:24(006) <Oracle_Enterprise_0> Missing server name. Can't connect
>##E TDOR 000140 15:30:24(007) <Oracle_Enterprise_0> APT_OraReadOperator: connect failed.
>##E TOPK 000000 15:30:24(010) <_PEEK_IDENT_> Input dataset does not have field: "EMPNO"
>##E TOPK 000000 15:30:24(011) <_PEEK_IDENT_> Input dataset does not have field: "ENAME"
>##E TOPK 000000 15:30:24(012) <_PEEK_IDENT_> Input dataset does not have field: "JOB"
>##E TOPK 000000 15:30:24(013) <_PEEK_IDENT_> Input dataset does not have field: "MGR"
>##E TOPK 000000 15:30:24(014) <_PEEK_IDENT_> Input dataset does not have field: "HIREDATE"
>##E TOPK 000000 15:30:24(015) <_PEEK_IDENT_> Input dataset does not have field: "SAL"
>##E TOPK 000000 15:30:24(016) <_PEEK_IDENT_> Input dataset does not have field: "COMM"
>##E TOPK 000000 15:30:24(017) <_PEEK_IDENT_> Input dataset does not have field: "DEPTNO"
>##E TFSR 000019 15:30:24(019) <main_program> Could not check all operators because of previous error(s)
##W TFOR 000000 15:30:24(020) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "EMPNO"
##W TFOR 000000 15:30:24(021) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "ENAME"
##W TFOR 000000 15:30:24(022) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "JOB"
##W TFOR 000000 15:30:24(023) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "MGR"
##W TFOR 000000 15:30:24(024) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "HIREDATE"
##W TFOR 000000 15:30:24(025) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "SAL"
##W TFOR 000000 15:30:24(026) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "COMM"
##W TFOR 000000 15:30:24(027) <Oracle_Enterprise_0> When checking operator: Modify operator has binding for non-existent output field "DEPTNO"
>##E TCOS 000029 15:30:24(028) <main_program> Creation of step finished with status = FAILED.
I walked through the error,its saying server name missing but i have given the same in the property additional connection information.
I guess i need to do some settings to make it work.Any inputs would be most appreciated.
Thanks in advance.
Regards,
Bala.