path search failed - Unable to locate dscapiop
Moderators: chulett, rschirm, roy
path search failed - Unable to locate dscapiop
Hi all,
I am getting following error message(job aborts) for only one job whereas other jobs are running fine.
main_program: orchgeneral: loaded
orchsort: loaded
orchstats: loaded
main_program: PATH search failure:
main_program: Error loading "@dscapiop": Could not load "dscapiop": Could not load module .
System error: No such file or directory.
main_program: Could not locate operator definition, wrapper, or Unix command for "dscapiop"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
main_program: Creation of a step finished with status = FAILED.
Job Job_name aborted.
(Sequence_name) <- Job_name: Job under control finished.
Note:
I have made change to .odbc.ini when the job aborts due to database down. since we are running on cluster environment I had given the virtual ip address of the database(earlier it was pointing to one database out of two)
After that I triggered the sequence, It was running for other parallel jobs when control comes to the particular job it aborts due to above error.
I have no clue to debug the error. since its in production i cannot avoid this job and run other.
Please share your views to debug and rectify the above error
thanks in advance
I am getting following error message(job aborts) for only one job whereas other jobs are running fine.
main_program: orchgeneral: loaded
orchsort: loaded
orchstats: loaded
main_program: PATH search failure:
main_program: Error loading "@dscapiop": Could not load "dscapiop": Could not load module .
System error: No such file or directory.
main_program: Could not locate operator definition, wrapper, or Unix command for "dscapiop"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
main_program: Creation of a step finished with status = FAILED.
Job Job_name aborted.
(Sequence_name) <- Job_name: Job under control finished.
Note:
I have made change to .odbc.ini when the job aborts due to database down. since we are running on cluster environment I had given the virtual ip address of the database(earlier it was pointing to one database out of two)
After that I triggered the sequence, It was running for other parallel jobs when control comes to the particular job it aborts due to above error.
I have no clue to debug the error. since its in production i cannot avoid this job and run other.
Please share your views to debug and rectify the above error
thanks in advance
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi ray,
other jobs are working fine only one particular job gets aborted(whereas the job structure like
ODBC-->TRANSFORMER--->PIVOT---->MODIFY---->FILTER---->ODBC
)
before the change in odbc file everything was running fine.
for example odbc file was changed to virtual ip 20.300.140.73 (which will pick up whatever database is up(that is 20.300.140.69))
database(down) --- 20.300.140.71
database(up) --- 20.300.140.69
netstat |grep ds "gives the following status"
datastage hostname database_hostname(20.300.140.71) close_wait
Also the warning says
"Error loading "@dscapiop": Could not load "dscapiop": Could not load module .
System error: No such file or directory."
why this warning comes? how can we avoid this and make the job running!
please share your views
thanks in advance
other jobs are working fine only one particular job gets aborted(whereas the job structure like
ODBC-->TRANSFORMER--->PIVOT---->MODIFY---->FILTER---->ODBC
)
before the change in odbc file everything was running fine.
for example odbc file was changed to virtual ip 20.300.140.73 (which will pick up whatever database is up(that is 20.300.140.69))
database(down) --- 20.300.140.71
database(up) --- 20.300.140.69
netstat |grep ds "gives the following status"
datastage hostname database_hostname(20.300.140.71) close_wait
Also the warning says
"Error loading "@dscapiop": Could not load "dscapiop": Could not load module .
System error: No such file or directory."
why this warning comes? how can we avoid this and make the job running!
please share your views
thanks in advance
The "dscapiop.o" library is in the "/DSParallel" subdirectory and is a library object, not an executable. If you revert your changes, does the job work again? (My feeling is that the two aren't directly related)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hi all,
I think, I had misguided you all by the words cluster environment I am correcting it to HIGH AVAILABILITY...
Also I have noticed that pivot stage seems to have problem...
Tested for keeping the pivot stage and populating record to dataset -- It aborts with same warnings..
After that I tested without pivot stage the job is running fine.
But how to fix the problem? Whether problem due to database change or due to pivot stage?
I think, I had misguided you all by the words cluster environment I am correcting it to HIGH AVAILABILITY...
Also I have noticed that pivot stage seems to have problem...
Tested for keeping the pivot stage and populating record to dataset -- It aborts with same warnings..
After that I tested without pivot stage the job is running fine.
But how to fix the problem? Whether problem due to database change or due to pivot stage?