When importing customer notes into GP 10 via Web Services, a client discovered that typical 'new line' escape sequences were not working properly for Notes. It turns out that Web Services handles formatting differently than eConnect, at least when it comes to new lines in Notes.

With GP 10 Web Services, \r\n, \r, and \n (or vbCr, vbLf, or vbCrLf…

During Web Services for Dynamics GP installation in windows 2003 Server, we receive a Fatal Error during installation, if it doesn’t meet certain pre-requisites. I’ll cover the possible troubleshooting steps in this article.We also see Rolling back IIS Metabase transaction, then the installation fails giving fatal error. We also might receive an error “The user account specified for the Dynamics Security Service worker process is invalid”.

 Possible Resolutions:

1. Ensure Full permissions are assigned to the ASP.Net Temp folder to IIS_WPG group before installing Web services. The default location would be C://Windows/.Net Framework/V2.0.5727/Temp folder.
2. In the web server running IIS6.0, Ensure Directory security is set to Integrated Authentication and Unmark the Anonymous Access.
3. If installing to Default Website, Ensure the port-80 is free and unused by any other site
4. If SQL server and the Web server where Web services are being installed on different server boxes, Ensure…

Steps to remove Microsoft Dynamics GP Web Services



1. Remove “Adam Instance DynamicsSecurityService” in Add\Remove Programs.


2. In IIS Manager, delete “Dynamics Security Admin Service” Web site.


3. In IIS Manager, delete “DynamicsGPWebServices” and DynamicsSecurityService” virtual directories from the Web site that the Web Services for Microsoft Dynamics GP was installed on.


4. In IIS Manager, delete the “DynamicsSecurityAdminServiceAppPool”, DynamicsSecurityServiceAppPool”, and “GPWebServicesAppPool” application pools.


5. Delete the “Microsoft Dynamics” folder from C:\Program Files\Common Files\Microsoft Shared.


6. Delete “GPWebServices” folder from C:\Program Files\Microsoft Dynamics (This is the default location for Web site files.).


7. Delete “Dynamics GP Web Service Exception Management Console” and “Dynamics Security Console” shortcuts from Administrative Tools program folder.


8. Delete related Registry Keys for Web Services for Microsoft Dynamics GP 9.0.


9. Remove the DynamicsGPWebServices key under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\


Run following SQL Script to remove SQL Objects from DYNAMICS as well as Company Database.


Against DYNAMICS DB :

drop view ReqCurrency
drop view ReqCurrencyAccess
drop table WSErrorProperties
drop table WSExceptionLog
drop table WSInstallStatus
drop table WSInstallSteps
drop procedure ws_delete_WSExceptionLog
drop procedure ws_deleteall_WSExceptionLog
drop procedure ws_get_MC40200
drop procedure ws_get_SY01500
drop procedure ws_get_WSErrorProperties
drop procedure ws_get_WSExceptionLog
drop procedure ws_get_WSExceptionLog_Summary
drop procedure ws_get_WSExceptionLog_ValidationException
drop procedure ws_get_WSInstallStatus
drop procedure ws_getall_WSInstallStatus
drop procedure ws_insert_WSExceptionLog
delete eConnect_Out_Setup where DOCTYPE in('WSCompany', 'WSCurrency', 'WSCurrencyAccess')

Run following sql script against all Company Database

drop view ReqCurrencyPostingAccountView
drop view ReqGLAcct
drop view ReqGLFixedAllocAcct
drop view ReqGLFixedAllocDistAcct
drop view ReqGLHeaderView
drop view ReqGLLineView
drop view ReqGLPostingAcct
drop view ReqGLPostingAcctCurrencies
drop view ReqGLUnitAcct
drop view ReqGLVarAllocAcct
drop view ReqGLVarAllocDistAcct
drop view ReqGLVarAllocDistBreakAcct
drop view ReqIVFee
drop view ReqIVHeaderView
drop view ReqIVItemCurrency
drop view ReqIVItemHeader
drop view ReqIVItemQuantity
drop view ReqIVItemQuantityBinDetail
drop view ReqIVItemVendor
drop view ReqIVItemWarehouse
drop view ReqIVKit
drop view ReqIVKitComponent
drop view ReqIVLineBinDetailView
drop view ReqIVLineLotDetailView
drop view ReqIVLineSerialDetailView
drop view ReqIVLineView
drop view ReqIVPricing
drop view ReqIVPricingDetail
drop view ReqIVSalesItem
drop view ReqIVService
drop view ReqPAAccounts
drop view ReqPAChangeOrderHeader
drop view ReqPAContractHeader
drop view ReqPAEmpExpDist
drop view ReqPAEmpExpHeader
drop view ReqPAEmpExpLine
drop view ReqPAEmpExpLineTax
drop view ReqPAMiscLog
drop view ReqPAMiscLogDist
drop view ReqPAMiscLogLines
drop view ReqPAProjectBudgetHeader
drop view ReqPAProjectHeader
drop…

Over at Developing for Dynamics GP, my good friend Scott Stephenson with Microsoft Dynamics GP Tools Support has released a schedule with…