Category Archives: Dynamics

Integration Manager – An Item With The Same Key Has Already Been Added

I was working with a client the other day with Integration Manager to import some purchase orders when we received the following error on some of the purchase orders:

5. 820909 Insert Failed 0. Seconds
DOC 4 ERROR: An item with the same key has already been added.

The vast majority of the documents integrated without problem. When we examined the documents which failed, we determined that those which failed were those which had a currency of Euro.

Integration Manager errors are typically very unhelpful and this was no different; the first thing we checked was to see if the PO Number existed in GP, but as we expected it did not.

We did some investigating and found that the Euro Exchange Rate’s Transaction Rate Default in GP was defined as Exact Date; I was able to update this to Next Date after which the integration stopped producing errors.

Posted in Dynamics, GP, Integration Manager, Microsoft, Multicurrency | Tagged , , , , , , , | Leave a comment

Integration Manager Bank Transaction – Unimplemented Cast From Btype ‘BROWSETYPE_UNKNOWN’

I’ve been configuring an integration in Integration Manager for a client recently to assist with an Intercompany Bank Reconciliation process. When we started discussing the integration I had taken a quick look at the sample Bank Transaction integration which ships with Integration Manager and had no problem.

As the project progressed and I created the Bank Transaction integration on the client’s server I encountered the below error:

Intercompany Bank Transfer - Transaction Progress

Show/Hide Error Message

Integration Log
Integration: Intercompany Bank Transfer - Transaction (ID: 66)
Action: None
Start Time: 25/02/2014 14:36:53

25/02/2014 14:36:58 Source: IIntegrationEngine_Run, Status Code: 0 Opening source query...
25/02/2014 14:36:59 Source: IIntegrationEngine_Run, Status Code: 0 Establishing source record count...
25/02/2014 14:36:59 Source: IIntegrationEngine_Run, Status Code: 0 Beginning integration...
1: GBP Insert Failed 2. Seconds
DOC 1 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
2: GBP Insert Failed 0. Seconds
DOC 2 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
3: GBP Insert Failed 0. Seconds
DOC 3 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
4: GBP Insert Failed 0. Seconds
DOC 4 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
5: GBP Insert Failed 0. Seconds
DOC 5 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
6: GBP Insert Failed 0. Seconds
DOC 6 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
7: GBP Insert Failed 0. Seconds
DOC 7 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
8: GBP Insert Failed 0. Seconds
DOC 8 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
9: GBP Insert Failed 0. Seconds
DOC 9 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
10: GBP Insert Failed 0. Seconds
DOC 10 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
11: GBP Insert Failed 0. Seconds
DOC 11 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
12: GBP Insert Failed 0. Seconds
DOC 12 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
13: GBP Insert Failed 0. Seconds
DOC 13 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
14: GBP Insert Failed 0. Seconds
DOC 14 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
15: GBP Insert Failed 0. Seconds
DOC 15 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
16: GBP Insert Failed 0. Seconds
DOC 16 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
17: GBP Insert Failed 0. Seconds
DOC 17 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
18: GBP Insert Failed 0. Seconds
DOC 18 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
19: GBP Insert Failed 0. Seconds
DOC 19 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
20: GBP Insert Failed 0. Seconds
DOC 20 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
21: GBP Insert Failed 0. Seconds
DOC 21 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
22: GBP Insert Failed 0. Seconds
DOC 22 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
23: GBP Insert Failed 0. Seconds
DOC 23 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
24: GBP Insert Failed 0. Seconds
DOC 24 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
25: GBP Insert Failed 0. Seconds
DOC 25 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
26: GBP Insert Failed 0. Seconds
DOC 26 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
27: GBP Insert Failed 0. Seconds
DOC 27 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
28: GBP Insert Failed 0. Seconds
DOC 28 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
29: GBP Insert Failed 0. Seconds
DOC 29 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
30: GBP Insert Failed 0. Seconds
DOC 30 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
31: GBP Insert Failed 0. Seconds
DOC 31 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
32: GBP Insert Failed 0. Seconds
DOC 32 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
33: GBP Insert Failed 0. Seconds
DOC 33 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
34: GBP Insert Failed 0. Seconds
DOC 34 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
35: GBP Insert Failed 0. Seconds
DOC 35 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
36: GBP Insert Failed 0. Seconds
DOC 36 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
37: GBP Insert Failed 0. Seconds
DOC 37 ERROR: Unimplemented cast from Btype 'BROWSETYPE_UNKNOWN'
25/02/2014 14:37:12 Source: FinishIntegration, Status Code: 3 Integration Failed
25/02/2014 14:37:12 Source: FinishIntegration, Status Code: 3 Integration Results
37 documents were read from the source query.
37 documents were attempted:
0 integrated without warnings.
0 integrated with warnings.
37 failed to integrate.

Finish Time: 25/02/2014 14:37:12

Source Total: 37
Successfully Integrated: 0
Integrated With Warning: 0
Failed: 37

Completion Status: Completed
Integration Status: No Documents Succeeded

I fiddled around without being able to identify a cause of the problem and, while I was doing this, found that the 37 transactions in the file had actually integrated despite the error message (an error in IM usually means the transaction or line will not be successfully integrated).

I brought a copy of the Integration Manager back to my test system and ran it on there and all of the files integrated without error.

The difference between my test system and the client’s system is that I have Microsoft Dynamics GP 2013 Service Pack 2 while the client is still on Service Pack 1.

In the medium term we will be upgrading the clients system to service pack 2, but in the meantime we’ll need to make do with increasing the number of permitted errors and accepting that an error will be displayed even as the transaction is integrated.

Posted in Dynamics, GP, Microsoft | Tagged , , , , , , , , , , | Leave a comment

Reports Print With Overlapping Text

I had a curious one a few months ago (which I forgot to post). A client I was implementing Microsoft Dynamics GP for encountered a problem whenever they printed a report; all of the text was overlapping:

Overlapping text on report

If a document was printed from Microsoft Word it was fine; if a GP report as printed to XPS and then sent to the printer from there then it was also fine. It was just the reports printed directly from Microsoft Dynamics GP which had the overlapping text problem.

Doing some more testing I was able to narrow the problem down further, from thinking it was all GP reports, to only the text based reports. Not having seen this problem before I thought a quick online search might find me an answer.

And it did; I found an old post from David Musgrave on the Deveoping for Dynamics GP blog where he covers how to change the font used for Text reports.

By using the information in David’s post to update the settings in the dex.ini file I was able to resolve the problem.

I added the following lines to the dex.ini file on each client (and left notes with the client’s IT department so they could do this on any new installations):

FontCourier New=Lucida Console
Tolerance=-1
MinMilHeight=100
Posted in Dynamics, GP, Microsoft, Report Writer | Tagged , , , , , | Leave a comment

Integration Manager – Input String Was Not In A Correct Format

After installing Microsoft Dynamics GP in a new test system, I then installed Integration Manager and tried to run an integration to test.

After clicking the Run button the following message popped up:

Integration Manager: The destination could not be initialized due to the following problem: -Input string was not in a correct formatIntegration Manager: The destination could not be initialized due to the following problem: -Input string was not in a correct format

This error is typically one seen when Microsoft Dynamics GP is not running (I’ve seen it at a few clients running Citrix when they have Integration Manager running on one server and Microsoft Dynamics GP on another), but I had Microsoft Dynamics GP open in the background.

I quickly realised the problem; I had imported some modified reports into GP which contained VBA and to avoid an error I had right clicked and used Run as Administrator when starting Microsoft Dynamics GP, but had started Integration Manager normally.

This meant the two applications were running in different states and Integration Manager could not see Microsoft Dynamics GP.

To resolve the issue I closed Integration Manager and reopened it using the menu in Microsoft Dynamics GP (Microsoft Dynamics GP menu >> Integrate >> Integration Manager); this is the way I typically recommend clients open it in order to avoid this problem on Citrix XenApp or other ways of publishing applications.

Posted in Dynamics, GP, Integration Manager, Microsoft | Tagged , , , , | Leave a comment

File Not Found: VBA6.DLL

While VBA is falling out of favour with Microsoft Dynamics GP (by dint of not being supported in the web client) it is still useful for those clients who do not use, and have no intention of using, the web client.

One such client was recently installing some new XenAPp servers using Windows Server 2012; when they tried to open a window with a VBA customisation they received the following error:

File Not Found: VBA6.DLLFile Not Found: VBA6.DLL

Fortunately, Beth Gardner posted the answer to the Developing for Dynamics GP blog.

Posted in Dynamics, GP, Microsoft, Modifier with VBA | Tagged , , , , , , , , , , | Leave a comment

Cashbook Bank Management – Value Exists In The PM_Key_MSTR Table

A client had an odd error with the Cashbook Bank Management module the other day when trying to enter a deposit; the following was printed on the exception report when trying to post the transaction:

Value exists in the PM_Key_MSTR table

I did some digging around and found that the Next Voucher Number field in Payables Management Setup – Options (Microsoft Dynamics GP menu >> Tools >> Setup >> Purchasing >> Payables Setup) was blank.

I set a new value in the Next Voucher Number field and the deposit could be posted without problem.

Posted in Cashbook Bank Management, Dynamics, GP, Microsoft | Tagged , , , , , , , , , | Leave a comment

Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: Web Management Console – Unable To Access SnapIn Config Data Store

The final error I ave to post about for now following my scale-out deployment of the Microsoft Dynamics GP 2013 Web Client series is on a problem with the Web Management Console.

After logging into the Web Management Console the following error was displayed:

Unable to access SnapIn config data store. Home SnapIn will not be loaded

Show/Hide Error Message

Unable to access SnapIn config data store. Home SnapIn will not be loaded

Continue reading

Posted in Dynamics, GP, Microsoft, Web Client | Tagged , , , , , , , , | Leave a comment

Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: Target Principle Name Is Incorrect

As errors with a scale-out deployment of the Microsoft Dynamics GP 2013 Web Client go, the one covered in this post is not one that you are likely to encounter.

When I tried logging into the web client I received an unexpected error and went to the Windows Event Viewer on the Session Central for more details:

Event Viewer

Show/Hide Error Message

System.Data.SqlClient.SqlException (0x80131904): The target principal name is incorrect. Cannot generate SSPI context.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TdsLogin(SqlLogin rec)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user)
at System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe()
at System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode()
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Microsoft.Dynamics.GP.Web.Services.Session.Service.SessionCentralBaseHandler.GetServiceSecurityGroups(String serviceName, ILinqDataContextProvider dataContext)
at Microsoft.Dynamics.GP.Web.Services.Session.Service.SessionCentralDatabaseHandler.GetServiceSecurityGroups(String serviceName)
at Microsoft.Dynamics.GP.Web.Services.Session.Service.SessionCentralService.InitializePrincipalManager()
ClientConnectionId:52267e4f-774d-452b-9361-00a407058a3a

Continue reading

Posted in Dynamics, GP, Microsoft, Web Client | Tagged , , , , , , , | Leave a comment

Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: Could Not Establish Trust Relationship

If you do a scale-out deployment of the Microsoft Dynamics GP 2013 Web Client you may encounter trust relationship problems if you do not have the SSL certificates correctly installed:

Event Viewer

Show/Hide Error Message

An error occurred during session monitoring 'System.ServiceModel.Security.SecurityNegotiationException: Could not establish trust relationship for the SSL/TLS secure channel with authority 'sc1.domain.azurecurve.co.uk:48650'. ---> System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.AuthenticationException: The remote certificate is invalid according to the validation procedure.

Continue reading

Posted in Dynamics, GP, Microsoft, Web Client | Tagged , , , , , , , , , | Leave a comment

Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: No Endpoint Listening

While installing the scale-out deployment of the Microsoft Dynamics GP 2013 Web Client, I encountered an error which took me a lot longer than I liked to resolve:

IE - Unexpected error

Show/Hide Error Message

There was no endpoint listening at https://sc1.domain.azurecurve.co.uk:48650/SessioNCentralService that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---? Syste.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not propoerly respond after a period of time, or established connection failed because connected host has failed to respond: 198.252.71.316:48650

Continue reading

Posted in Dynamics, GP, Microsoft, Web Client | Tagged , , , , , , , , | Leave a comment