Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / [AX2009]: Call a store...
Finance forum
Answered

[AX2009]: Call a stored procedure

Posted on by 66
Hello together,
 
I'm currently facing a problem in MS Dynamics AX 2009. Im trying to call a stored procedure via x++ code with the following code:
 
 
The execution is successful (no errors) but the content of the stored procedure is not executed and the effect / result could not be seen in the DB.
 
If i run the stored procedure directly from the SQL Management Studio with the identical SQL Statement /EXEC [MY_ITEM]..../ everything is executed correctly.
 
Any idea why the code / the class is executed without errrors but no effect in the DB?
 
Thanks for any hint
Sebastian
  • Verified answer
    Basti Aurand Profile Picture
    Basti Aurand 66 on at
    [AX2009]: Call a stored procedure
    After a bit of trial and error I came out with a solution. My problem was a combination of two issues:
     
    1. You need to set the correct access rights on the stored procedure after creating it in the sql management studio (you could copy the rights from the AX standard SP "dbo.CREATESERVERSESSIONS")
    2. After changing the executeQuery to executeUpdate the SP is executed correctly:
     
  • Basti Aurand Profile Picture
    Basti Aurand 66 on at
    [AX2009]: Call a stored procedure
    Hi Martin,
     
    thanks for your response. The stored procedure copies values from AX tables to an external DB, therefore I did not check it in x++ / AX 2009. I checked the result (copied values are available or not) directly in the external database tables via the SQL management studio and I did not get any records / values when executing via x++. I extended the code a bit to get some more information:
     
     
    For me everything seems fine apart from the fact that nothing is done in the SQL DB.
     
    Any other ideas what I could try?
    Sebastian
  • Martin Dráb Profile Picture
    Martin Dráb 228,212 Most Valuable Professional on at
    [AX2009]: Call a stored procedure
    You seem to be saying that executeQuery() runs without error and it returns an empty result, but your code checks neither of that.
     
    Please look at what you get from executeQuery() and then call statement.getLastError()  and check its return value too.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,349 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,212 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans