Friday, 18 May 2012

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




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

Thursday, 17 May 2012

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

Tuesday, 15 May 2012

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