|FATAL error when using tMSSQLSP component|
|Product||Talend Data Integration|
The following error is reported when a stored procedure not within the dbo schema is invoked:
'Could not find stored procedure'
The output says:
Exception in component tMSSqlSP_1
Even though the schema used was not a dbo schema, it had necessary permissions to be involved based on tests done using SQL clients.
|Problem root cause||The schema was assigned to the variable dbschema_tMSSqlSP_1 but was not used in the stored procedure call.|
|Solution or Workaround||
Prefix the stored procedure name with the schema [Schema].storedProcedure. If the schema is blank, call the stored procedure.
The schema must be retrieved from the tMSSqlSP component, or from the tMSSqlConnection component if the first use is as an existing connection.
|JIRA ticket number|