Create Account failed for DB Connection

[rajeshg]

Hi Team,

We are getting below error when provisioning the create account for SQL DB connection. Please refer below.

JSON:

{
"createaccountqry": "EXEC dbo.usp_Account_Insert (@UserAccount,@EmployeeNumber,@AccountId,@OutputOnly) values ('${user.username}','${user.employeeid}','${@AccountId Output},{'1'})"
}

Tried Below:

{
"createaccountqry": "EXEC dbo.usp_Account_Insert (@UserAccount,@EmployeeNumber) values ('${user.username}','${user.employeeid}')"
}

Error:

SAV - Error while creating account - MRM1235-Exception occured while Excecuting Query

Appreciate your help on this.

Regards,

Rajesh

[rushikeshvartak]

{
"createAccountQry": "CALL dbo.usp_Account_Insert (@UserAccount,@EmployeeNumber) values ('${user.username}','${user.employeeid}')"
}

[rajeshg]

Hi Rushikesh,

Thanks for your response. We have the same issue and we are passing the below are mandatory and refer,

{
"createaccountqry": "declare @AccountId int", "exec dbo.usp_Account_Insert '${task.accountName}',${user.employeeid},@AccountId Output,1"
}

Here @accountID output will update the account ID number while inserting the new user account in DB.

Still we are getting the same error.

Regards,
Rajesh