Dynamics GP Integration Manager: Prices need to be recalculated

Myridas Aggregate pricing causes this error to come up.

The transaction integrates anyway

Dynamics GP 2010 Integration Manager - error type_e_cantloadlibrary

The following problem was encountered during destination uninitialization:
 - Argument 'Number' is not a valid value.
Argument 'Number' is not a valid value.
Unable to cast COM object of type 'MSScriptControl.ErrorClass' to interface type 'MSScriptControl.IScriptError'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{70841C78-067D-11D0-95D8-00A02463AB28}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).


OR



Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Unable to cast COM object of type 'MSScriptControl.ErrorClass' to interface type 'MSScriptControl.IScriptError'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{70841C78-067D-11D0-95D8-00A02463AB28}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
DOC 1 ERROR: Argument 'Number' is not a valid value. - Argument 'Number' is not a valid value.
DOC 1 ERROR: Unable to cast COM object of type 'MSScriptControl.ErrorClass' to interface type 'MSScriptControl.IScriptError'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{70841C78-067D-11D0-95D8-00A02463AB28}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
Integration Failed
Integration Results
    1 documents were read from the source query.
    1 documents were attempted:
        0 integrated without warnings.
        0 integrated with warnings.
        1 failed to integrate.

To resolve this issue

RUN CMD AS ADMINISTRATOR

Register the MSScript.ocx file. To do this, click Start, click Run, type regsvr32 C:\Windows\System32\MSScript.ocx in the Open box, and then click OK
Note If you are on a 64-bit computer, use this command: regsvr32 C:\Windows\sysWOW64\MSScript.ocx.


http://support.microsoft.com/kb/942750

The Microsoft.ace.oledb.12.0 provider is not registered on the local machine

Install this

http://www.microsoft.com/download/en/confirmation.aspx?id=23734

EOne Smartconnect - Scheduler does not fire on 29 Feb for Leap Years

Scheduler does not schedule correctly if the maps are setup on the 29th of Feb.

1. To resolve it, open up the Scheduler Master Maintenance Window.  (Maps – Scheduled Maps)
2. Double-click on the first map in the list which will open the actual scheduler window
3.  Click Save on this window, which will update the next run time with today’s date. 
4. You will need to do this to each map you have scheduled. 

EOne Smartconnect - Could not retrieve this map

This happens if the Smartconnect log file is too large.

1) Backup the smartconnect database
2) Switch the database backup type from full to simple

EOne SmartPost - None of the windows open after installation

Issue:
After you install EOne Smartpost in Dynamics GP, the menus all appear, but when you click on them, none of the windows open.


Resolution:

1. Check the application error logs in the event viewer for smartpost
2. Reset the password for your Smartpost user account

If that doesn't work, move on

1. Install .net framework 3.5
1. http://www.microsoft.com/net/download
2. Upgrade to .net framework 4.5
3. Reset your Smartpost SQL user account password to confirm it is correct
4. Uninstall and reinstall Smartpost

Run the uninstaller.  After running the uninstall, go into the Great Plains directory and then go into the AddIns subfolder.  Delete the files named:

eOne.SmartPost.dll

eOne.SmartPost.dll.config

Then go into the GP directory and delete the SMRTPST.DIC and SMRTPST.vba files.

Then reinstall SmartPost again.  

http://www.eonesolutions.com/KnowledgeBase.aspx?article=QQF8AA002JGK

Exclusive access could not be obtained because the database is in use

Use Master

 Alter Database YOURDB

  SET SINGLE_USER With ROLLBACK IMMEDIATE

  RESTORE DATABASE YOURDB
  FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\YOURDB.bak'

Only use this if the database is not live, and users are not actively performing transactions.

This is a last resort option to be used in cases where all users have logged out, and some unknown service keeps accessing the database.

This will disconnect all other users, and run the restore.

The restore will remove the single_user flag.