Error executing view data command while reading from table
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
Error executing view data command while reading from table
Hi,
I am getting the error while executing view data command. The detail error is :
##I TOSH 000002 10:27:53(001) <main_program> orchgeneral: loaded
##I TOSH 000002 10:27:53(002) <main_program> orchsort: loaded
##I TOSH 000002 10:27:53(003) <main_program> orchstats: loaded
##I TFSC 000001 10:27:53(004) <main_program> APT configuration file:
/home/dsadm/Ascential/DataStage/Configurations/dimdevt.apt
##I TFSC 000000 10:27:53(005) <main_program>
This step has no datasets.
It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(APT_LicenseCountOp in APT_LicenseOperator)
(APT_LicenseCheckOp in APT_LicenseOperator)
) on nodes (
node1[op0,p0]
)}
It runs 1 process on 1 node.
##W TCOS 000049 10:27:54(000) <main_program> Parameter specified but not used in flow: _APT_CONFIG_FILE
>##E TOSH 000205 10:27:54(001) <main_program> PATH search failure:
>##E TOSH 000000 10:27:54(002) <main_program> Error loading "orchoracle": Could not load "orchoracle": No such file or directory.
>##E TOSH 000000 10:27:54(003) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
>##E TCOS 000029 10:27:54(004) <main_program> Creation of a step finished with status = FAILED.
Please help me in solving this issue. What should be done in config file or in path setting so that this error will not come
Regards,
Param
I am getting the error while executing view data command. The detail error is :
##I TOSH 000002 10:27:53(001) <main_program> orchgeneral: loaded
##I TOSH 000002 10:27:53(002) <main_program> orchsort: loaded
##I TOSH 000002 10:27:53(003) <main_program> orchstats: loaded
##I TFSC 000001 10:27:53(004) <main_program> APT configuration file:
/home/dsadm/Ascential/DataStage/Configurations/dimdevt.apt
##I TFSC 000000 10:27:53(005) <main_program>
This step has no datasets.
It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(APT_LicenseCountOp in APT_LicenseOperator)
(APT_LicenseCheckOp in APT_LicenseOperator)
) on nodes (
node1[op0,p0]
)}
It runs 1 process on 1 node.
##W TCOS 000049 10:27:54(000) <main_program> Parameter specified but not used in flow: _APT_CONFIG_FILE
>##E TOSH 000205 10:27:54(001) <main_program> PATH search failure:
>##E TOSH 000000 10:27:54(002) <main_program> Error loading "orchoracle": Could not load "orchoracle": No such file or directory.
>##E TOSH 000000 10:27:54(003) <main_program> Could not locate operator definition, wrapper, or Unix command for "oraread"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
>##E TCOS 000029 10:27:54(004) <main_program> Creation of a step finished with status = FAILED.
Please help me in solving this issue. What should be done in config file or in path setting so that this error will not come
Regards,
Param
Re: Error executing view data command while reading from tab
So, what are you trying to do? What stage?
The error pretty much says a lot:
"This step has no datasets."
The error pretty much says a lot:
"This step has no datasets."
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Its most likely the connection problem. Something to do with your Oracle client couldn't be located. You might want to check if you have installed the drivers correctly.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Premium Member
- Posts: 66
- Joined: Sun Apr 08, 2007 12:34 pm
JoshGeorge wrote:Its most likely the connection problem. Something to do with your Oracle client couldn't be located. You might want to check if you have installed the drivers correctly.
This error is coming when i am trying to view data using oracle stage. Oracle is installed correctly. I am able to login from datastage server. Problem is when i am trying to view data in oracle stage I am getting the above error. But when I am trying to import metadata (orchestrate definition ) I am getting below error:
*** Error executing command: orchdbutil tablenames -dbtype oracle -server 10.70.83.221 -dboptions *********
##I TCDU 000005 10:49:59(001) <main_program> Unable to access database {0}DB type 'oracle' presumed to be oracle.
##E TCDU 000002 10:49:59(002) <main_program> Unable to access database {0}Oracle: not present
##E TCDU 000006 10:49:59(003) <main_program> Unable to access database {0}Unable to load library 'orchoracle'.
It will be a great help if someone can give suggestion/solutions .
Thanks,
Param
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
orchoracle link...
Just researching an error i am getting:
"Error loading "orchoracle": Could not load "orchoracle": Could not load module"
In the previous response the reference to:
thanks..
"Error loading "orchoracle": Could not load "orchoracle": Could not load module"
In the previous response the reference to:
I have checked our directory and find no link. Where should this orchoracle point to?probably you do not have the link for orchoracle in your library path $DSHOME/../PXEngine/lib
Code: Select all
/apps/Ascential/DataStage/PXEngine.751.1/lib
datadev1./usr/bin/ksh.dsdev.c23360125:$ ls -l *orcho*
lrwxrwxrwx 1 dsadm dstage 10 May 22 2007 liborchodbcaix3.so -> orchodbc.o
lrwxrwxrwx 1 dsadm dstage 15 May 22 2007 liborchoracle10gaix3.so -> orchoracle10g.o
lrwxrwxrwx 1 dsadm dstage 14 May 22 2007 liborchoracle8iaix3.so -> orchoracle8i.o
lrwxrwxrwx 1 dsadm dstage 14 May 22 2007 liborchoracle9iaix3.so -> orchoracle9i.o
-rw-r--r-- 1 dsadm dstage 1527361 Mar 22 2005 liborchoslaix3.a
-rwxr-xr-x 1 dsadm dstage 617014 Mar 22 2005 orchodbc.o
-rwxr-xr-x 1 dsadm dstage 1754119 Mar 22 2005 orchoracle10g.o
-rwxr-xr-x 1 dsadm dstage 1753871 Mar 22 2005 orchoracle8i.o
-rwxr-xr-x 1 dsadm dstage 1754091 Mar 22 2005 orchoracle9i.o
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: