Dynamics GP Error - Cannot drop the index 'taErrorCode.AK2taErrorCode' because it does not exist or you do not have permission

So you are upgrading GP and get the below error.

This is due to a missing index.

Script one out from a working machine and script into your 'troubled' environment. Be sure to also script in the primary key as well in case it is also missing.

Error: the stored procedure smgrantaccessonaccountmstr returned the following results dbms:0 Microsoft Dynamics GP

So you receive the above error on doing an update/upgrade.

You have re-run the grant sql script, change db owner, etc, multiple times.

Even reviewed the stored procedure.

Reason for issue:
-There is a mis-named table. Possibly with a period in the name.

Resolution:
- Just rename the table.
-Continue to utilities.

Voila!

SSRS - An error has occurred during report processing. (rsProcessingAborted) The processing of Parent for tablix 'Tablix1' cannot be performed. Cannot compare data of types System.String and System.DateTime. Please check the data type returned by the Parent. (rsComparisonTypeError)

So you get the above error when generating a report that usually works.

This is because there is a conflict on your tablix group.

For mine the issue was resolved when i removed the Recursive Parent from my group on the Tablix1 tablix.

Error in SSRS

Group Properties on Tablix, Remove the Recursive Parent

Analysis Cubes Creating Pivot Error - Cannot access file

So you are creating a pivot after upgrading and then when you save the file, you get an error that the file cannot be accessed and it refers to an excel file in the folder of the older version of Dynamics GP.



What to do:
- Change the Server name in the Pivot window which is Microsoft Dynamics GP>> Tools>> Analysis Cubes>> Create PivotTable Reports.
- Pick back the module/cube
- Click Save.
-This will generate the pivot to the new GP version.
-Now you can click excel icon to open your Pivot.

Analysis Cubes Upgrade Dynamics GP Error in Cube - Unhandled Object Exception Class not registered

So you have upgraded Analysis Cubes for Dynamics GP and then go into GP to Microsoft Dynamics GP>> Tools>> Analysis Cubes>>Create Pivot Reports and when creating a new pivot, you click save and get an unhandled object exception: class not registered.

This is due to not having excel on the machine you are trying to deploy on. Use another machine.

SSRS Address is Invalid

The correct address existed, the Configuration Manager could be reached and everything however, my reports could not be deployed.

I removed SSRS Native Feature from my SQL 2016 installation.
I deleted the SSRS Databases in SQL.
I confirmed the log and mdf files were also deleted.
I reinstalled SSRS Native Feature to my SQL 2016.
Configured SSRS in the Configuration Manager - Create SSRS Database, click apply on the web services and other window to register the site.

Run GP as Admin.
SSRS Reports are being deployed!


If this does not work for you it could be due to security. If you are unable to access the site in ie then it means the administrator has not reduced the security on the internet. Thus reduce the security and you should be able to proceed. We had a hard customer so we instead got edge installed, set that as the default web browser, redeployed and it worked. This information is from Skwah #2. Thank you!!

How to add Nodes in Smartconnect after Installation.

Smartconnect
-After installation of Smartconnect Application
-Register Smartconnect
-Install GP Smartconnect
-Process Cache in GP Smartconnect
-Then go back into Smartconnect application
-Create GP Connector
-Run System Maintenance

-BOOM! Nodes added!