Saturday, March 16, 2019

Troubleshooting a Dynamics GP SQL Posting Error

By Steve Endow

I recently had a call with my friend Windi Epperson to troubleshoot an odd SQL error that was occurring when posting a Dynamics GP batch.



Here is a video discussing the error and our journey to identify the cause and resolve the issue.



When posting a GL batch in Dynamics GP, the customer was getting this error:


The partner shared that the customer had a similar error several months ago when they uninstalled an ISV module.  As part of that uninstall, SQL scripts were run that replaced the modified ISV posting stored procedures with the original Dynamics GP stored procedures.

Thursday, March 7, 2019

C# SqlException: Procedure or function has too many arguments specified

By Steve Endow

I've been fighting this error for years in my Data Access class. Only yesterday did I figure out the cause.

It's related to the design of my Data Access class, and specific cases where I need to make multiple calls to the database in a single method.

This is the error:

SqlException: Procedure or function has too many arguments specified

This is an example of a stored procedure call that leads up to the error.

Assembling SQL Parameters for a Stored Procedure

Troubleshooting a Dynamics GP SQL Posting Error

By Steve Endow I recently had a call with my friend Windi Epperson to troubleshoot an odd SQL error that was occurring when posting a Dyna...