Skip to main content
I
itsm6335
November 9, 2023
Question

Stored Proc not working

  • November 9, 2023
  • 7 replies
  • 0 views

Hi,

I have created a simple stored Proc with 1 input parameter

Can someone let me know why am getting this error

    7 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    November 9, 2023

    Do you see this error while starting the model for debugging? If no, could it be that this is a instance of an older version of the model?

    I
    itsm6335Author
    November 9, 2023

    I tried multiple times to execute it. I only have this node in PM and have saved my PM. 

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    November 9, 2023

    Did you start the process this way?

    If note, did you just "save" or "save & publish"? If you start a process from a normal form, Appian will initiate the last published version. If you start it for debugging, it will start the last saved version directly from the modeller.

    BTW, that is the only idea I have, why this would not work ...

    jordand0005
    jordand0005
    November 9, 2023

    Hi David, your 'Execute Stored Procedure' input variable name needs to match the casing of your stored procedure input name. 

    i.e. In your node input name you have 'endpoint' but you need 'endPoint' (capitalise P)

      I
      itsm6335Author
      November 9, 2023

      Thanks jordan...You saved me..

      jordand0005
      jordand0005
      November 9, 2023

      Okay great, please verify my answer so that others can see this issue is resolved.

      Thanks

      Terms & ConditionsAccessibility statement