Using TIBCO Scribe® Insight, while setting up Rejected Source Rows to output to a new table, selecting 'Always append Rejected rows to the same table', adding the desired table, and clicking 'Create Table Now', the following may error may occur:
[42000] SQL call failed. Could not find stored procedure 'SCRIBE.tablename'



In the example above 'SCRIBE' is the table owner and 'orgtocrm' is the name of the table.

 

The cause of the problem is that the Table Owner specified in the Rejected Source Rows dialog does not have the needed rights in the database. The key to resolving the issue is to make sure that the user specified as the table owner has the needed rights. One solution is to check the rights for the Scribe user and increase their rights as needed. An alternate solution is to change the user specified in Table Owner to be a user with higher rights, such as the DBO user.