PSTL Registration Error

Microsoft Dynamics GPEarlier this month the Microsoft Dynamics GP Support Blog announced that the Professional Services Tools Library had been made free of charge and can be downloaded from here (PartnerSoruce login required; Customers will need to contact their partner).

It’s a while since I did much with PSTL so I decided to download it and take a look. I got it installed correctly but when I tried to open it I got this error;

Microsoft Dynamics GP - Unhandled script exception: [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'PI.dbo.smChangeAccountIndex2'.

When I clicked OK, I got this follow on error;

Microsoft Dynamics GP - The stored procedure 1TA_Territory_Combiner returned the following results: DBMS: 103, Microsoft Dynamics GP: 0.

I did a little digging around and found this Microsoft KB Article:
You may receive a “Could not find stored procedure” error message when you install the Microsoft Great Plains Professional Services Tools Library
which is for an old version of Microsoft Great Plains but is still applicable.

The problem was the ODBC connection, on the test client, was setup with the incorrect settings;

Microsoft SQL Server DSN Configuration

Use ANSI quoted identifiers and Use ANSI nulls, padding and warnings should both be unchecked but for some reason on the test clients ODBC they were enabled;

Microsoft SQL Server DSN Configuration

Once I removed the checks against these two settings PSTL worked correctly.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.
Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

Your Name (required) -
Your Email (required) -

2 thoughts on “PSTL Registration Error

Leave a Reply

Your email address will not be published. Required fields are marked *