Link to home
Start Free TrialLog in
Avatar of sbcole4
sbcole4

asked on

Deltek Vision API ExecuteStoredProcedure

We have created a stored procedure and it is sitting on the db server.  We have tested the server locally and against the server directly using the same data as we are sending in the API and the data loads correctly.  When we use the API nothing is being loaded.  Our parameter in the SP is a XML parameter.  We are not getting any errors returned.  We have try and catches, begins and ends in the SP and it's getting to the return without issue.  But like I said nothing is being loaded.  Are we missing something?
singlerow.txt
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Do you have the SP definition?
How are you calling the SP locally?
Avatar of sbcole4
sbcole4

ASKER

The stored procedure was executed just against the database locally using a normal sql execute SP pointing to  the payload in as an xml file.

We tested it originally with the test data in the SP originally.
SP.txt
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sbcole4

ASKER

we will make that change but, the data went in without issue when it was executed from SQL.
It's the only clue I have now (regional settings from both machines might be different).
sbcole4, a feedback will be appreciated.
Cheers
Recommendation to close this question by accepting the above comment as solution.