Showing posts with label ERROR 30107. Show all posts
Showing posts with label ERROR 30107. Show all posts

Monday, June 30, 2008


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