It seems that regardless of how much testing you do, something can still slip through the cracks. Well after v10.00 Service Pack 4 was released, an issue with the SmartList Builder/Excel Report Builder code was identified. A Hot Topic has been posted with a temporary workaround fix.

Here is an excerpt from the Hot Topic:

After installing Service Pack 4 for Microsoft Dynamics GP 10.0, you will receive the error Wrong…

Sometimes Microsoft Dynamics GP reports unusual errors with temporary tables. Here are some example error messages that you might see:

An open operation on table 'IV_Reconcile_PO_TEMP' has an incorrect record length.

An open operation on table 'PM_Inquiry_Summary_TEMP' failed because the path does not exist.

While these errors can seem confusing and not make any sense at first, there is one important fact that will help explain how the error can be generated.

Not all temporary tables used by Microsoft Dynamics GP are SQL tables created in the tempdb system database.  Many temporary tables used…

A little while ago I downloaded and installed the RTM (Released to Manufacturing) build of Microsoft Dynamics GP 2010. After installing GP and Dexterity I started on the process of updating my Dexterity projects to use the RTM build of Dynamics.dic (build 11.00.1247) and Dexterity…

Sometimes you finds your self in a very deep technical investigations looking for the cause of a very stupid error message or behavior that does not represents the actual cause of the message, such as situations below:

1. “All Call Stack in use. Cannot Start Script” When opening GL Transaction Entry From.

2. Smart-list has no objects and tree view that holds the smart-lists is empty.

https://community.dynamics.com/forums/p/25304/43005.aspx

If you have looked a DEXSQL.LOG file to see the communication between SQL Server and the Microsoft Dynamics GP application, you might have noticed messages with errors 5701 and 5703 being reported.  See the example below:

/*
/*  Date: 08/10/2009  Time: 20:09:49
SQLSTATE:(01000) Native Err:(5701) stmt(0):*/
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master'.*/
/*
/*  Date: 08/10/2009  Time: 20:09:49
SQLSTATE:(01000) Native Err:(5703) stmt(0):*/
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.*/
/*

You…

In my previous post, I mentioned that I was assisting a developer with an issue. It turned out that the issue he was having was not the cause of an error, but the result of a previous error that the users had not told him about.  Once the original error was fixed, the entire problem was solved.

So, this raised an issue which is probably one of the most frustrating aspects of support a system that support engineers and consultants have to face on a day to day basis.  So I will get up on my soapbox again to discuss this subject.

<SoapBox>

When an error or an exception…