[DataDirect][ODBC lib] Function sequence error Stored Proc

[Developer9]

Hi,

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

Job is failing with following message

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.

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