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