PREVIOUS

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

NEXT