we are having a generic database connector for SQL server. since we are using a lot more operations we went with generic DB connector.
During the create account operation my stored procedure is failing, with error message,
Error code = -1
com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range.
syntax i am using to call stored procedure is,
CALL [dbo].[JE_SaveUser] (UserId = '${UserId}', UserName = '${UserName}', RoleId = '${RoleId}', ApprovalLevel = '${ApprovalLevel}', Status = '${Status}', CompanyIds = '${CompanyIds}', LoginUserId = '${LoginUserId}', Email = '${Email}', EntityId = '${EntityId}' )
this stored procedure works fine, outside of connector.
any pointers would be greatly appreciated.RSA Identity Governance & Lifecycle Client/Partner Community#afx, #img,#via
What if you try using EXEC instead of CALL?
Recently I had a similar issue also where the AFX connector was expecting some value to be returned from the stored procedure, and since my particular SP didn't return anything, we had a similar error.
So my AFX connector looked like this:
EXEC sp_name(parm1,2,3);
select 'success';
This basically just forced a return value.