Unable to cast COM object of type 'System.__ComObject' to interface type 'System.EnterpriseServices.IRemoteDispatch'

Users were receiving the following error when submitting a transaction in a econnect application.

Unable to cast COM object of type 'System.__ComObject' to interface type 'System.EnterpriseServices.IRemoteDispatch'.

This operation failed because the QueryInterface call on the COM component for the interface with

IID '{6619A740-8154-43BE-A186-0319578E02DB}' failed due to the following error:

Illegal operation attempted on a registry key that has been marked for deletion. (Exception from HRESULT: 0x800703FA).

Reviewing the systems event log we also saw the following error

The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID

{46063B1E-BE4A-4014-8755-5B377CD462FC}

and APPID

{FAAFC69C-F4ED-4CCA-8849-7B882279EDBE}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

To correct the problem IISRESET works but the problem then comes back after a while.  We have added the Network Service to have local launch permission for the APP ID

{FAAFC69C-F4ED-4CCA-8849-7B882279EDBE} which is MsDTSServer100

Dynamics GP 2013 New Features

Dynamics GP 2013 New Features

•Excel Export Using Open XML

• Enable printing of SSRS report from forms

• Navigation Lists for Web Client (BA Functionality)

• Re-architect home pages to WPF

• New SSRS reports to support Web Client templated forms

• Business Analyzer WPF upgrade

• Additional Word Templates for SOP

• Single Email with multiple attachments

• SRS Reports

• Print Customer Items option

• Select invoice on one-off Email window

• Notes on Credit Documents

• Document Attach

• Item Standard Cost adjustment post to GL

• Multi-S/N select

• Inactivate a Site and Item Site

• Reason Codes for stock movements/adjustments

• Inactive Items - Inventory Status enhancements

• Bin Transfer History

• Tolerance Handling

• Track Serial Numbers for Drop Ship items

• Allow prepayments on a PO

• Prevent PO close prior to Invoice Match

• Print Button on Pick List Shortage Inquiry

• Ship to Address has different Company Name

• Relate / Link Items for suggestions on Sales

• Integrate AA with Copier Series SOP/POP and GL Copy

• Add Field Service Allocations to Item Allocation Inquiry Window

• Update Back Order Quantity in Item Maintenance

• RMA Entry - Update Contact & Address ID

• Consolidate Revenue Recognition

• Item Description from RMA Credit

• Multi-User check in RMA Entry

• Equipment Super Session

• Hotline Update

• RMA Return Quantity and Type

• Ship to Address Integration to SOP

• Cross Ship RMA consolidation

• Honor Discontinued Item Status

• Auto Populate Customer ID

• Add a Contract Number search in Revenue recognition window

• Allow contract line to be moved to another contract even if on an open service call

• Option to have an equipment card created when manufacturing receives a serialized item into inventory

• Contract Workflow

• Add BAI2 format support to eReconcile

• FA Calendar Setup

• FA Intercompany Asset Transfer

• FA Historical Depreciation Report

• Lock Current FA Year and Mass Backout

• FA to GL posting process updates

• FA Updates for MACRS

• Integrate Fixed Assets with AA

• GL Journal Entry Inquiry for History

• Reconcile Bank Reconciliation with GL

• Year End Close Options

• Subledger Reconcile IV to GL

• Calculate Average Exchange Rate for Currency Translation

• Integrate GL with encumbrance

• Enable Enc to assign Multiple GL Budgets for Fiscal Year

• Encumbrance Cost Diff Notification

• Restrict Void of reconciled check, display reconcile status in Check Inquiry

• Void of check returns applied Credits

• Void credit card payment vendor invoice - void to original vendor

• EFT add settlement date option

• EFT Field Length and Delimitation Options

• Edit Payables Transactions: Remit to Address, 1099 information, Edit Description

• PM Reprint Checks/Remittance forms

• Need a 1096 Form

• Allow renaming of user-defined fields on Customer Address

• Multicurrency apply in cash entry

• Database multi-tenancy (named system database)

• Application multi-tenancy

• Report deployment and retrieval for multi-tenant

• Multi-tenant Applications - tenant service

• Multi-tenant Integration Manager

• Multi-tenant web service

• Life Insurance enhancements

• Check Build Exception Report

• Stop Duplicate Checks

• Paycode History Edit

• Paycode, Deduction, Benefit Modifier

• FICA TSA Deductions

• Customer Fields

• Advanced Warning Notice and Delete History Records

• Mandatory Arrears Template and Reminders

• DIA Reporting

• Voucher Description and Voucher Document Number

• Voucher Consolidation

• HR Calendar

• Negative Carryover

• PTO Detail and History

• PTO Manual Checks

• Year End PTO

• Office Presence in Advanced HR, Advanced Payroll, Payroll Extensions & PTO Manager

• HR Requisition List View

• Consolidated Invoicing

• Additional String Resources (Dex)

• Key Relations tracked in index file for source control(Dex)

• Update VBA Components

• Enhance the AltMod windows with a mark all/unmark all functionality

• 64 Bit Support for Email (Dex)

• Default sort for Customer and Vendor lookups

•Email Indicators in Transaction lists

•Save batch approval information

•Select Printer at time of print AND Support for http:// on the Report Destination window

•Adding support for the Business Analyzer to NLB

•Grouped Reports

•SmartList Builder - remove dependency on having an Admin login after new install

•Extender Window export/import to include Smartlist integrations

•Add Extender & SmartList Builder Default Security

MR Report stuck in Report queue - startIndex cannot be larger than length of string

Management Report 2012
Trying to generate a report copied over from FRX 6.7 I experienced a problem.  What was happening is that the report would sit there stuck with a status of queued.  Looking in the event viewer application log on the server I saw the following error

System.ArgumentOutOfRangeException: startIndex cannot be larger than length of string.
Parameter name: startIndex
   at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.Definition.Row.HandleRelatedRow()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.Definition.Row.Load(XElement element)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.Definition.RowFormat.DeserializeRows(XElement xElement)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.Definition.RowFormat.Load(XElement element)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.ComponentKeyedCollection`2.Load(XElement element)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Common.Definition.Load(XElement element)
   at Microsoft.Dynamics.Performance.Reporting.Scheduler.ReportRunner.RunReport(String reportDefinitionXml, Guid repositoryId, Guid generatedByPrincipalId, Guid reportFileId)

No idea so took a smaller sample of the report and this work.  so I slowly added sections of the report until I found the problem.

The error was appearing due to two of the rows in the report contained a tree reference in the Related Formulas/Rows/Units  but had no reference in the Link to Financial Dimensions column
Once I removed the tree reference and changed the rows to be DES  type (so that the client could map the information at a later date), it then worked

Wrong number of parameters sent to script 'eiPROC_SOP_DP_Update_Header_Sub1'

An old problem came to revisit me today.  A client running Dynamics GP 10 Service Pack 5 (1685) was experiencing the following issue when printing Dispatch Notes for more then one sales order using the Navigation List window. 

Unhandled script exception:
Wrong number of parameters sent to script 'eiPROC_SOP_DP_Update_Header_Sub1'.

EXCEPTION_CLASS_SCRIPT_BAD_PARAM
SCRIPT_CMD_CALL


The problem is experienced when then client is setup to use Enhanced Intrastat.  A call logged with Mcirosoft previously stated that it had been fixed in Dynamics GP 10 SP5 and also Dynamics GP 2010 SP1.  It appears even with latest hotfix 10.00.1835 it is also still an issue.

I have now told the client to use the Print Sales Documents window in order to print multiple documents and abandon the new features they liked in Dynamics GP 10.  Not every one can afford the time to upgrade to the latest version

kind regards
Michael Nunes

Play Capoeira

Play Capoeira
Saturdays 11:30am - 13:00

www.PlayCapoeira.co.uk

In Cambridge there aren't many classes where you can get fit, learn a new language, brush up on your singing skills and play an instrument all at the same time. Play Capoeira is open to all ages and aims to connect and inspire people through the philosophy of Capoeira, an exhilarating and elegant dance, fight, game from Brazil.
The Bodywise Studio
Unit 4 Dales Brewery
Gwydir Street (off Mill Road)
Cambridge CB1 2LJ
Classes cost £5 For more information call Richard on 07878 093830  #Cambridge #Capoeira  

Attachment Id has bad format

When trying to send a file attachment using Hotmail, my partner ran into an issue.  She was reporting that the email would stop responding and closing the email would report "Attachment Id has bad format".  

Resolution:

The problem was due to the fact that the file name had spaces.  I renamed my attachment from  "my file.docx" to be "myfile.docx" and it was fine

Use Dynamic SQL To Generate a Dynamics GP Login Macro

Wow excellent blog by AARON BERQUIST

Use Dynamic SQL To Generate a Dynamics GP Login Macro

http://www.aaronberquist.com/2011/07/use-dynamic-sql-to-generate-a-dynamics-gp-login-macro/