[DataDirect][ODBC lib] Function sequence error Stored Proc
Posted: Tue May 31, 2016 10:02 pm
Hi,
I am executing a Sql server Stored Procedure (Which returns the Return value -no parameters )
Job is failing with following message
Where as the stored is executing properly in SQL server (sql assistant)
I read the forum but couldn't solve the issue
Please let me know whether changes needs to performed to the settings in the stage ?
Thanks
I am executing a Sql server Stored Procedure (Which returns the Return value -no parameters )
Code: Select all
Stored Procedure stage ---->Peek
Code: Select all
Procedure type :Source
Database Procedure type: Stored Procedure
Procedure name :TestSP
Syntax :exec schemaname.dbo.TestSP
Generate Procedure call :Unchecked
Code: Select all
SP,0: Warning: Test.SP: [DataDirect][ODBC lib] Invalid argument value
SP,0: Info: Test.SP: Database supports transactions, iso mode is 0, autocommit off
SP,0: Info: Test.SP: Connected to Microsoft SQL Server, version 11.00
SP,0: Info: Test.SP: CLI_NO_DATA
SP,0: Warning: Test.SP: SQLSTATE = HY010, fNativeError = 0
SP,0: Error: [DataDirect][ODBC lib] Function sequence error
SP,0: Error occurred in call to ORPHCallActivePluginTerminate().
SP,0: The runLocally() of the operator failed.
I read the forum but couldn't solve the issue
Please let me know whether changes needs to performed to the settings in the stage ?
Thanks