Professional Services Tools Library – DBMS Error 4920

Microsoft Dynamics GPI ws recently doing some work for a client, one part of which was to configure Microsoft Dynamics GP to duplicate creditors created in one company into another using the PM Master Trigger functionality in the Professional Services Tools Library (PSTL).

When I tried to enable the trigger I received the following error message:

Microsoft Dynamics GP - The stored procedure failed to enable taVendorInsert returned the following results: DBMS: 4920, Microsoft Dynamics GP: 0Microsoft Dynamics GP – The stored procedure failed to enable taVendorInsert returned the following results: DBMS: 4920, Microsoft Dynamics GP: 0

Continue reading

Integration Manager – The RPC Server Is Unavailable

Microsoft Dynamics GPDuring a recent implementation I was importing a file of 30,000 items into Microsoft Dynamics GP using Integration Manager when, part way through the integration, the following error started being produced:

9057:  ITEM-NUMBER-1 Insert Failed 6. Seconds 
    DOC 9057 ERROR: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) - The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
9058:  ITEM-NUMBER-2 Insert Failed 0. Seconds 
    DOC 9058 ERROR: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) - The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
9059:  ITEM-NUMBER-3 Insert Failed 0. Seconds 
    DOC 9059 ERROR: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) - The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

Continue reading

Error 800AC351 While Saving Microsoft Dynamics GP

Microsoft Dynamics GPI was working onsite with a client during an upgrade of Microsoft Dynamics GP from version 10 to 2013 recently, and after doing some work on a client we started receiving an error when trying to log out..

The error we received was the following:

Microsoft Dynamics GP - Unknown error 0 - 800AC351 occurred saving the project fileMicrosoft Dynamics GP – Unknown error 0 – 800AC351 occurred saving the project file

After a little testing to see if we could easily determine the problem, I did a quick online search and came up with this post from Vaidy Mohan which was the same error, but for a different VBA project.

The steps I tried and found to be successful were slightly shorter and easier than those Vaidy needed:

  1. Launch GP and open the Visual Basic Editor
  2. Opened modified report in the Microsoft Dynamics GP VBA project
  3. Added and removed a space from the end of one line
  4. Compiled the entire project to check for errors
  5. Save VBA project
  6. Log off from GP

To verify the problem was resolved we closed and reopened Dynamics GP and didn’t see the error when closing it again.

Upgrading Management Reporter 2012: Post Upgrade Connection Problem

Microsoft Dynamics GPIn this short series of posts, I’m going to take a look at upgrading an installation of Management Reporter 2012 to the latest Rollup. The series index can be found here.

Over the last three posts I covered the upgrade of the Management Reporter server and client components. If the components and database has been upgraded as covered in the posts then you should not see the error message shown below:

Management Reporter – Can’t connect to the Management Reporter server. Do you want to specify a different server address?Management Reporter – Can’t connect to the Management Reporter server. Do you want to specify a different server address?

This error is one seen at a client who had done the upgrade on the server and the majority of clients. But one user who had been on holiday that day hadn’t had their PC updated and wasn’t aware it had been done. So when they tried logging into Management Reporter they logged the issue.

A short client upgrade later and they were up and running without further problems.

Upgrading Management Reporter 2012
Upgrade the Server Components
Upgrading the Database
Upgrading the Clients
Post Upgrade Connection Problem

FRx Migration Wizard Failure

Microsoft Dynamics GPI have a number of clients who have been using Microsoft Dynamics GP for a number of years and who we are now upgrading again. A few of them continued using FRx when they upgraded to Microsoft Dynamics GP 2010, but now they are upgrading to Microsoft Dynamics GP 2013 they also need to switch to Management Reporter 2012 as FRx is not supported with the latest versions of Microsoft Dynamics GP.

Most of these migrations proceed without a problem, but I did have one client where the Migration Wizard ran through and returned a successfully completed message. However, when I logged into the Report Designer to check the migrated building blocks, I found that there was nothing there.

As a double-check, I re-ran the Migration Wizard to the same effects so I started to do some investigation. I eventually took a look in the FRx database and found a number of corrupt rows in the Catalog table like the one below:

FRx Database - Catalog Table

Continue reading

Integration Manager Error: ‘Input string was not in a correct format’

Microsoft Dynamics GPI was working on a new integration template for a client recently and after accidentally closed Integration Manager instead of just the Destination Mappings window I started getting the below error message when I reopened and tried running the integration:

Integration Manager - The destination could not be initialized due to the following problem: - Input string was not in a correct formatIntegration Manager – The destination could not be initialized due to the following problem: – Input string was not in a correct format

It took me a few minutes of fiddling around to work out the problem, but when I did it was a bit of a face/palm moment.

The project I was working on had some customisations in Microsoft Dynamics GP as well as a new integration template. When I logged in first thing I had started GP using Run as Administrator and then launched Integration Manager from the Tools menu (Microsoft Dynamics GP menu >> Tools >> Integrate >> Integration Manager); but, when reopening it, I had launched it from the Windows Start screen.

This meant that GP itself was running under the administrator account, but Integration Manager was running under my user account. I closed Integration Manager again and then launched it from the GP menu, so that it was running under the same user account as GP itself, and was able to run the integration without further problems.

Management Reporter Error Opening Column Definition

Microsoft Dynamics GPDuring a recent upgrade of a client from Microsoft Dynamics GP 2010 to Microsoft Dynamics GP 2013 we also did a migration of FRx to Management Reporter.

After doing the test upgrade and migration I tested Management Reporter and everything was working fine. However, a month later when I was back on site for the live upgrade and some additional training, I found that Management Reporter was no longer working correctly.

When I tried to open a column definition I received an error:

Management Reporter: The operation could not be completed due to a problem in the data provider framework.Management Reporter: The operation could not be completed due to a problem in the data provider framework.

Continue reading

Integration Manager Log Report Failure

Microsoft Dynamics GPAfter recently upgrading a client to Microsoft Dynamics GP 2013 they have been doing some testing. As well as GP itself they also use Integration Manager to integrate data from other systems.

Part of their testing plan involved testing the integrations; good thing they did as one problem, not a large one though, was found.

When trying to view the error logs the following error was produced:

Log Report Failure: Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=9.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specifiedLog Report Failure: Could not load file or assembly ‘Microsoft.ReportViewer.WinForms, Version=9.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. The system cannot find the file specified

The solution is to install the Microsoft Report Viewer Redistributable which can be found here.

Management Reporter ‘Bad or missing data…’ error

Microsoft Dynamics GPI’ve had this post in my queue for a while after it got overlooked, but I figure it is still worth posting.

We received a call on the service desk from a client who was having problems with Management Reporter; whenever they tried to generate a report they received the following error:

Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled.Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled.

Continue reading

SmartList Builder Will Be Disabled Until It Is Initialized By The System Administrator

Microsoft Dynamics GPI have been involved in several upgrade projects with clients recently where we have been upgrading them from Microsoft Dynamics GP 2010 through to Microsoft Dynamics GP 2013. Since this version was launched, SmartList Builder has been pushed back out to eOne, the original ISV.

So, after doing the normal upgrade process, we have then installed the latest version of SmartList Builder from the eOne website. However, this has not been a smooth process.

One of the clients started receiving the following error message whenever a user tried to access SmartList:

SmartList Builder Will Be Disabled Until It Is Initialized By The System Administrator

Continue reading