Wednesday, 21 March 2018

Integration using stored procedure and smartconnect

So you run your integration file which is using a stored procedure instead of a table.

Then you get error messages in the form of a number. You check Event Viewer and find nothing.

For example '7' or '50997'.

















To figure out what this means you have to run the below select statement:

SELECT * FROM DYNAMICS..taErrorCode


Tuesday, 13 March 2018

GP 2013R2 Upgrade stuck in loop "Budiness Intelligence reports were not deployed"

This error occurs when you previously deployed the Excel Reports but have moved servers or the location where you originally installed them is no longer in place.


If you are just doing a test upgrade you can just exit GP Utilities.

GP would have been upgraded already. You can always re-deploy the reports within GP.

Re-open Closed Fiscal Period


Scenario
  • Closed February and March accidentally in AP.
  • Only February should have been closed in AP.

 
Resolution:
  • Have users log out of SL
  • Execute the below SQL statement on Test Company first. (Assuming March is the third period for Fiscal Year 2018)
    • update apsetup set CurrPerNbr = 201803, PerNbr = 201803
  • Test entering transaction for March 2018. Confirm all is well.
  • Complete same steps on live company.

Moving and Upgrading Integration Manager

Moving from server running GP2013  to a new server with GP2016.

Process for moving integrations to the new server:

Integration Manager can be migrated to a new location by moving the Integration Manager database. The location of the database file can be found by viewing the options menu window in the Default Integration Manager Database field on Integration Manager.
After this file has been moved to the new server, you should use the Convert Database tool in Integration Manager to convert the database to the newest version, matching the installation of Integration Manager.
All paths in the integration will not change automatically. This part will have to be done manually.

An error occurred while loading or initializing an addin. Ask your administrator to check the Windows event log for more details. Dynamics will now close.

So you are trying to upgrade GP 2013 to GP 2013R2.

You launch GP and get the message as per subject.

When you check event viewer you get 'An exception occurred while trying to load or initialize the add in located at Excel Builder'


Reason for issue:
Your client gives you a mismatched database to GP folder.


To Resolve:
- Ensure the SLB from eone is installed
-Remove the excel related add ins from the Add In Folder in GP.
- Manually add the SLB module in the add remove of GP
-Launch GP. You will be fine.