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