Error Calling Subroutine Datastage Dsr_project
Contents |
with "Error calling subroutine: *DataStage*DSR_PROJECT (Action=1); check DataStage is set up correctly in project
Error Calling Subroutine *datastage* Dsr Select (action=4)
empty file called errlog under DSEngine directory. Make sure it does not have an extension and all users have read and write permission to it. For example, the errlog has: program "*DataStage*DSR_TRACE*; Line 222, Message [046019] This means it is reporting Invalid GCI subroutine. Make sure all the GCI libraries and dependent libraries do exist. You can run the following program to see which GCI libraries report errors: start a command window on the DataStage server cd c:\IBM\InformationServer\Server\DSEngine .\bin\uvsh.exe COMO ON GCI.NTMAP.B.OUT RUN APP.PROGS GCI.NTMAP.B DETAIL COMO OFF press N to stop paging the results are captured in DSEngine\&COMO&\GCI.NTMAP.B.OUT For exmaple, here are some possible errors: COMO GCI.NTMAP.B.OUT established 08:38:42 26 MAY 2011 >RUN APP.PROGS GCI.NTMAP.B DETAIL Error 126 loading GCI library E:\IBM\InformationServer\Server\DSEngine\bin\dsdgci.dll. The specified module could not be found. Error 126 loading GCI library E:\IBM\InformationServer\Server\DSEngine\bin\dsradmin.dll. The specified module could not be found. Error 126 loading GCI library E:\IBM\InformationServer\Server\DSEngine\bin\DSPlugin.dll. The specified module could not be found. Error 126 loading GCI library E:\IBM\InformationServer\Server\DSEngine\bin\DSOLEint.dll. The specified module could not be found. [2JGCI libraries currently loaded Check the PATH system variable and verify it includes the following. Information server is looking at the following path for those libraries and their dependent libraries. C:\IBM\InformationServer\Server\DSEngine\bin\dsdgci.dll. C:\IBM\InformationServer\Server\DSEngine\bin\dsradmin.dll C:\IBM\InformationServer\Server\DSEngine\bin\DSPlugin.dll C:\IBM\InformationServer\Server\DSEngine\bin\DSOLEint.dll If the PATH is set correctly. Use Dependency Walker to check to make sure those dependent libraries exist. Obtain the program called Dependency Walker via the internet (free version
with connection is broken (81002) error connection is broken (81002); 81002; action; action=; client crashes Technote (troubleshooting) Problem(Abstract) The DataStage client crashes frequently with the following error messages: - Error calling subroutine: DSR_NLS (Action=4_; check DataStage is set up correctly in project
DataStage Director View next topic View previous topic Add To Favorites This topic has been marked "Resolved." This topic is not resolved, but there is http://www.dsxchange.com/viewtopic.php?p=459001 a WORKAROUND. Post new topic Reply to topic DSXchange Forum Index » http://etl-tools.info/en/datastage-faq-222_error-30107-subroutine-failed-complete-successfully.htm General Author Message just4geeks Group memberships:Premium Members Joined: 26 Aug 2006 Posts: 644 Location: Mclean, VA Points: 6160 Posted: Thu May 05, 2011 8:22 am Reply with quote Back to top DataStage Release: 8x Job Type: Parallel OS: Unix Hello error calling Everyone, We are getting "Error calling subroutine " while opening the Director. There are multiple errors one after another: Error calling subroutine: DSR_EXECJOB (Action=23); check DataStage is set up correctly in project DSTESTPROJECT (The connection is broken (81002)) Error calling subroutine: *DataStage*DSR_SELECT (Action=3); check DataStage is set up correctly in project DSTESTPROJECT (The error calling subroutine connection is broken (81002)) Error calling subroutine: *DataStage*DSR_PROJECT (Action=7); check DataStage is set up correctly in project DSTESTPROJECT (The connection is broken (81002)) Here are some observations: - This is specific is one project. All other projects are fine - Error is in Director only. Designer is working fine- I can open the jobs in designer etc. - All users are getting this error in director. - Disk space seems to be fine This is what I have done so far: 1. Use "Reindex all" for rebuilding the indexes - used DS.TOOLS for this 2. clearing &PH& directory: Used CLEAR.FILE command Any help will be deeply appreciated: Can there be an issue with RT log files?- How can I check that? Please share your thoughts. Thanks in advance. _________________Attitude is everything....Last edited by just4geeks on Thu May 05, 2011 8:31 am; edited 1 time in total View user's profile Send private message just4geeks Group memberships:P
DataStage FAQ BI resources Datstage solutions, knowledge base, FAQ and best practices 2.22. ERROR 30107 Subroutine failed to complete successfully Error message: Error calling subroutine: DSR_RECORD (Action=2); or *DataStage*DSR_SELECT (Action=7); check DataStage is set up correctly in project Development (Subroutine failed to complete successfully(30107)) Datastage system help gives the following error desription: SYS.HELP. 930107 MESSAGE.. DataStage/SQL: Illegal placement of parameter markers The problem appears when a project is moved from one project to another (for example when deploying a project from a development environment to production). The solution to the issue is: Rebuild the repository index by executing the DS.REINDEX ALL command from the Datastage shell Back to the list of all Datastage FAQ topics © 2006-2016 ETL-Tools.Info| Disclaimer | Privacy Policy All Rights Reserved