Additional GP Log In window titled 'Login' and error "An open operation on table 'sy_pathnames' failed because you are not logged into a valid data source"

Install new sub-feature to existing Dynamics GP installation and after running utilities you are able to upgrade the companies.

When launching GP a new login window pops up with three fields; one for you to select the ODBC Source another to enter username and then password.

You also receive an error relating to:

An open operation on table ‘SY_pathnames’ failed because you are not logged into a valid data source.

Unhandled script exception:

Illegal address for field ‘Company ID’ in script ‘SQL_GetDbName’

Script Terminated.

EXCEPTION_CLASS_SCRIPT_ADDRESSING

SCRIPT_CMD_LOAD_ATSI12

This is usually caused by having modifications to existing windows in GP. The add in does not know how to function on top those modifications.

To resolve, uninstall GP and all third party apps. Then reinstall GP and the add in then add the third party apps and import customizations.

Dynamics GP Print Different report based on windows user but same GP user

Mystery Debunked -
User signs into Windows as User A and signs into GP as User A - Original Report Prints
User signs into Windows as User B and signs into GP as User A - Modified Report Prints
User signs into Windows as User B and signs into GP as User B - Modified Report Prints



What to look for:
1. Dynamics set file is pointing to the correct dictionary
2. User has access to modified report
3. Confirm the short cut to access GP is the same on both profiles. Right click on shortcut and click properties, this will say where the shortcut is looking to in order to launch Dynamics GP.

Management Reporter - Unable to install 64 bit version of access database engine.

In installing Management Reporter Server you are unable to proceed with the install if you have Office 32 bit version installed.


Error: You cannot install the 32-bit version of Microsoft access database engine is installed. however the 64-bit version must be installed to generate reports with Microsoft excel data


To overcome the issue, this is, being able to install 64-bit Microsoft Access Database Engine redistributable, side by side with a 32-bit Microsoft Office installation, you must install the redistributable package in passive mode.

You will need to open the Command prompt (Start | Run | CMD) and change the path to the directory where the redistributable package was downloaded.

To change the command prompt to look at your downloads folder type the following:

cd C:\Users\username\Downloads\

Then type the following:
C:\Users\username\Downloads>AccessDatabaseEngine_x64.exe /passive
press enter

You should now be able to complete your install.

SmartConnect - there was no endpoint listening at http //localhost/microsoft/dynamics/gp/eConnect/EntityOperations that could accept the message

The error below shows when trying to run a SmartConnect map -

“There was no endpoint listening at net.pipe://localhost/Microsoft/Dynamics/GP.eConnect/EntityOperations that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details.”


The eConnect for Microsoft Dynamics GP 2015 Integration Service will also not stay running, it starts, and then immediately stops.

This is caused when port 80 is already in use on the machine with the eConnect service installed. To resolve this, you need to edit the eConnect config file.

1. Browse to the C:\Program Files\Microsoft Dynamics\eConnect 14.0\Service\ directory on the machine that is experiencing the issue.
2. Open up the Microsoft.Dynamics.GP.eConnect.Service.exe.config file using Notepad.
3. Find a parameter in the file that says: httpGetEnabled=”true”
4. Edit the parameter to say: httpGetEnabled=”false”
5. Close the file and save your changes.
6. Right click on the eConnect service and select start. If the service stays running, the map will run correctly.

Updated 2021

- This can also occur if the econnect service for Dynamics GP is not running. Once you start the service in services, you should be able to run the integration again. 

SmartConnect error when running map. Could not load file or assembly

ERROR: Could not load file or assembly 'Microsoft.Dynamics.GP.eConnect, Version=14.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

To resolve this:
1. Confirm Windows Identity Foundation feature is enabled on the machine in Server Roles.
2. Re-install econnect from GP installation media
3. Smartconnect> Setup> System Maintenance, unmark real time triggers and click process then when finished click ok.

Smartconnect - No groups in map

When creating a GP Map in smartconnect you don't see any groups to select from.

To fix this you need to:
1. Go to GP: Microsoft Dynamics GP> Tools> Smartconnect> GP Resource Cache - Run this
2. Go to Smartconnect: Setup> Setup> Smartconnect Dynamics GP Connector> Connector Setup - Register Maps.
3. Go to Smartconnect: Setup> System Maintenance> Process

You should be fine thereafter
P.S. these processes take a while to run, be patient.

Dynamics GP - Free any records locked by users

Use this script for all errors pertaining to locks / shares

Ensure all users log out of GP, then run
------------------------------------------------------------------------------

DELETE FROM [DYNAMICS].[dbo].[ACTIVITY]
DELETE FROM [DYNAMICS].[dbo].[SY00800]
DELETE FROM [DYNAMICS].[dbo].[SY00801]
DELETE FROM [tempdb].[dbo].[DEX_LOCK]
DELETE FROM [tempdb].[dbo].[DEX_SESSION]

------------------------------------------------------------------------------
If it says a batch is stuck / being edited, and there is no one else in the system

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'