Dynamics GP

Posts tagged with Dynamics GP

After GP Company database restore: The selected company is not configured as a company of the current Microsoft Dynamics GP syst

After restoring a GP Company Database from another SQL server you may get the following error when trying to log into the restored company:

"The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company"

The following SQL scripts may resolve the issue.

select
CompanyDbId = c.CMPANYID
,DynamicsDbId = d.CMPANYID
,DynamicsDbName = d.INTERID
,DynamicsCompanyName = d.CMPNYNAM
from sy00100 c
left join dynamics..sy01500 d
on d.interid = db_name()

--update SY00100 set CMPANYID = (select CMPANYID from DYNAMICS..sy01500 where INTERID = db_name())

HTML code displayed on the bottom of a navigation list pane instead of returning actual results. GP 2013 and GP 2015.

This has been an issue that Njevity has been struggling with on new GP 2013 and GP 2015 installs. The confusing part has been that it will occasionally go away. With a lot of help from Daryl Anderson at Microsoft we finally found a work around. First of all, the issue goes away as soon as an application is installed that drops a DLL file in the AddIn folder of the GP program files.

For cases where there are no DLL files in the AddIns folder simply copy the Microsoft.Dynamics.GP.BusinessIntelligence.Homepage.dll
file from the root of the GP installation (example: c:\Program Files (x86)\Microsoft Dynamics\GP2013) to the AddIns sub-folder.

Give users access to SSRS Report Builder

To create role assignments that grant access to Report Builder

Start Report Manager.

Click Site Settings.

Click Security.

If a role assignment already exists for the user or group for which you want to configure Report Builder access, click Edit.

Otherwise, click New Role Assignment. In Group or user, enter a Windows domain user or group account in this format: \. If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment.

Select System User, and then click OK.

Click Home.

Click the Properties tab.

Click the Security tab.

If a role assignment already exists for the user or group for which you want to configure Report Builder access, click Edit.

Otherwise, click New Role Assignment. In Group or user, enter a Windows domain user or group account in this format: \. If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment.

Select Report Builder, and then click Apply.

Repeat to create or modify role assignments for additional users or groups.

Dynamics GP Excel Drillback. A connection Microsoft Dynamics GP could not be established. Be sure you are logged on to the appr

According to the following link : http://support.microsoft.com/en-us/kb/2966672

If you're moving your Microsoft Dynamics GP databases and you use the drilldown functionality in the SQL Server Reporting Services or Excel integrated reports, you need to follow the steps below in order to update your server links so the drilldowns will continue to work after the server move:

1. Ensure that everyone has logged out of Microsoft Dynamics GP and close all instances of SQL Server Management Studio.

2. On a machine where Dynamics GP is installed click on Start, then point to All Programs. Then click to expand Microsoft Dynamics, then GP and click on Database Maintenance.

3. When the utility opens select or enter the SQL Server instance name where the Dynamics GP databases are stored. If you are logged in as a domain account with rights to this SQL Server instance you can select the Windows Trusted Authentication method. Otherwise select SQL Authentication and enter an appropriate user name and password. Click Next.

4. Select Mark All to choose each of the Dynamics GP databases. Click Next.

5. Select the Microsoft Dynamics GP product. Click Next.

6. Select Functions and Stored Procedures. Click Next.

7. Review the confirmation window. Click Next to begin the process.

Note: This process can take some time to run. It will depend on the number of products installed along with the number of databases that need to be addressed. Once this process has completed, your external report drilldowns will work in the new S

GP 2013 and 2015 GP Web Services "Exception message: The security object does not exist"

After moving the GPWEBSECURITY database for GP Web Services and running a repair we received the following error opening the Security Console:

"Exception message: The security object does not exist. Missing Key: 25cc1a21-2cc4-4b13-a1c8-eea186fb688a"

Turns out we ran the wrong repair.  DO NOT run the repair from the GP Web Services Configuration Console.  Instead, launch the GP Setup.exe from the GP installation media.  This will detect the existing install and give you the option to repair.I used information from the following link and updated it for the new web services that does not run in IIS:

https://support.microsoft.com/en-us/kb/943949

To determine the scopes in the ADAM database, use the Authorization Manager (Azman.msc) Microsoft Management Console (MMC) snap-in to browse the database. To do this, follow these steps:

  1. Click Start, click Run, type azman.msc, and then click OK.
  2. On the Action menu, click Open Authorization Store.
  3. Click Active Directory.
  4. In Windows Explorer, open the following folder:
    C:\Program Files\Microsoft Dynamics\GPWebServices\WebServices
  5. Use Notepad to open the DynamicsSecurity.config file.
  6. Copy the following value for the AzManConnectionString setting:
    mssql://Driver={SQL Server};Server={MySqlServer\MyInstance};/GPWEBSECURITY/DynamicsGPWebServices
  7. Paste the value into the Store Name field in the Open Authorization Store window, and then click OK.
  8. Expand the DynamicsSecurityService store.
  9. Expand 25cc1a21-2cc4-4b13-a1c8-eea186fb688a to view the scopes. A folder graphic designates the scopes that are installed and that have an assigned integer value.

I was able to verify that the database in the new GPWEBSECURITY database did not contain the data from the original database.  I restored from backup.  Reran the repair.


NOTE: I also had to search all .config files in the install folders for the original MyOldSqlServer\MyOldInstance and replace it with the MyNewSqlServer\MyNewInstance.

I used FNR.exe from codeplex.

Syndicate content