SQLNonQuery inside Referenced Workflow

Permanently deleted user

July 19, 2017 19:44

I am using a SQLNonQuery activity in a workflow and inside I'm executing a stored procedure. Although the 3x parameters feeding the stored procedure, I'm getting an error "Object reference not set to an instance of an object"

 

Even when I run this activity with text strings representing the incoming parameters, it still fails with the same error.

 

Also, when I use Fiddler to trace the traffic from my server, I see no sql activity calls inside Fiddler. Is there a way to captue sql traffic in Fiddler?

 

What could be the cause of this error, even though the string values being passed are correct?

 

Walter

0

• 

  Permanently deleted user

  July 20, 2017 07:35

  Hi Walter,

   

  To capture Geocortex Fiddler traffic you would need to set proxy configuration in REST\web.config to use Fiddler proxy port … something like

   

  <defaultProxy>

   

        <proxy autoDetect="false" bypassonlocal="false" proxyaddress="http://localhost:8888" usesystemdefault="false" />

   

      </defaultProxy>

   

  If Fiddler port is 8888. I never tried to debug SQL activities but it might help you.

   

  Re SQLNonQuery I noticed that syntax needs to be precise as activity expects it. Particularly pay attention to parameters name.

   

  Which DB are you using?

   

  Please see below and example of a call to an Oracle store procedure in a package with an output parameter.

   

  BEGIN

   

  MY_PKG.Insert_SP(:p_id,:p_another_value,:o_rows_affected);

   

  END;

   

  I hope this helps

  0
• 

  Permanently deleted user

  July 20, 2017 11:46

  Francesca,

   

  I do have my web.config set up to track activity through Fiddler with the aid of that defaultProxy item you mentioned. I'm using SQL Server as my database and I've even tried to find some activity with the aid of SQL Server Management Studio's Profiler. 

   

  When I run the exact line in SQL Server, the ones that executes my stored procedure, it works perfectly.

   

  Odd enough, when I run my workflow through the simulator, it passes throught the SQLNonQuery successfully, but then fails later on in the workflow. 

   

  So why does the workflow fail in my viewer on the SQLNonQuery activity, yet be successful in the simulator?

   

  Walter

  0
• 

  Permanently deleted user

  July 20, 2017 14:36

  One difference between simulator and runtime flow is the web.config used …

   

  Silly question: do REST\web.config and Manager\web.config have same configuration? Any helpful clue out of that comparison?

   

  In SQL server can you see if requests are the same or any difference there?

  0

Please sign in to leave a comment.