Error executing view data command while reading from table

[parameswar]

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

[siddesai]

So, what are you trying to do? What stage?

The error pretty much says a lot:
"This step has no datasets."

[JoshGeorge]

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.

[parameswar]

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

[chulett]

Oracle may be 'installed properly' but it sounds like you haven't configured DataStage for Oracle. Check the Install and Upgrade Guide for the procedure. The documentation for the Oracle stages should also contain the information.

[keshav0307]

Error loading "orchoracle": Could not load "orchoracle": No such file or directory.

probably you do not have the link for orchoracle in your library path
$DSHOME/../PXEngine/lib

[SBSA_DW2]

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:

probably you do not have the link for orchoracle in your library path $DSHOME/../PXEngine/lib

I have checked our directory and find no link. Where should this orchoracle point to?

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

thanks..

[ray.wurlod]

Point it to the correct version (8i, 9g or 10g) in the lib directory.

[SBSA_DW2]

thanks - it's working now.
:D

[ray.wurlod]

Please mark as Resolved using the green button at the top of the screen.