Until next post!
MG.-
Mariano Gomez, MVP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
![]() |
Microsoft Dynamics GP 2010 and Bing Maps country view |
A general error has occured.A call to SSPI failed, see inner exception. Server stack trace: at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity) at System.ServiceModel.Channels.StreamSecurityUpgradeInitiatorBase.InitiateUpgrade(Stream stream) at System.ServiceModel.Channels.ConnectionUpgradeHelper.InitiateUpgrade(StreamUpgradeInitiator upgradeInitiator, IConnection& connection, ClientFramingDecoder decoder, IDefaultCommunicationTimeouts defaultTimeouts, TimeoutHelper& timeoutHelper) at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.SendPreamble(IConnection connection, ArraySegment`1 preamble, TimeoutHelper& timeoutHelper) at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.DuplexConnectionPoolHelper.AcceptPooledConnection(IConnection connection, TimeoutHelper& timeoutHelper) at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout) at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.CallOpenOnce.System.ServiceModel.Channels.ServiceChannel.ICallOnce.Call(ServiceChannel channel, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade) at System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.Dynamics.GP.ServiceIntegration.ProtocolHandler.DynamicsGPDrillBackService.IDrillBackToGP.CallAction(Uri uri) at Microsoft.Dynamics.GP.ServiceIntegration.ProtocolHandler.ProcessDrillBack.ProcessStart(Uri uriParameter) at Microsoft.Dynamics.GP.ServiceIntegration.ProtocolHandler.Program.LaunchApplicationByUri(Uri uri) at Microsoft.Dynamics.GP.ServiceIntegration.ProtocolHandler.Program.Main(String[] args) System.ServiceModel.Security.SecurityNegotiationException With this Inner Exception at System.Net.Security.NegoState.ProcessAuthentication(LazyAsyncResult lazyResult) at System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, ChannelBinding binding, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel) at System.Net.Security.NegotiateStream.AuthenticateAsClient(NetworkCredential credential, String targetName, ProtectionLevel requiredProtectionLevel, TokenImpersonationLevel allowedImpersonationLevel) at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity) System.Security.Authentication.AuthenticationException
![]() |
Microsoft.Dynamics.GP.ProtocolHandler.exe.config standard file content |
![]() |
Microsoft.Dynamics.GP.ProtocolHandler.exe.config with extra keys for logging and error handling |
![]() |
Microsoft Dynamics GP Home Page - IMHO |
Hi folks , weird one here. Have ran fine in the past,however we are now getting this error: 'The input tax for ths range hasn't been entered. Do you want to continue calculating?
The only change is that we have now set up all the reverse charge functionality for EU VAT. So the question is, where is the VAT return looking for the input tax?
Ok fixed it! Extracted all the transactions in SmartLists for the tax reporting period, and pivot tabled them on the tax detail id, compared the id's to those setup in GP only to discover that a tax detail id used 6 times does not physicly exist, [I then] changed the tax detail id in SQL to rectify to the correct id. ID must have been deleted some how.
//--------------------------------------------------------------------- // This file is a Microsoft Dynamics GP Business Intelligence Code Sample. // // Copyright (C) Microsoft Corporation. All rights reserved. // //This source code is intended only as a supplement to Microsoft //Development Tools and/or on-line documentation. See these other //materials for detailed information regarding Microsoft code samples. // //THIS CODE AND INFORMATION ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY //KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE //IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A //PARTICULAR PURPOSE. //--------------------------------------------------------------------- using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.IO; using DocumentFormat.OpenXml; using DocumentFormat.OpenXml.Packaging; using DocumentFormat.OpenXml.Wordprocessing; using wp = DocumentFormat.OpenXml.Wordprocessing; namespace NewTableAdHocText { class Program { public bool AddTableAdHocText(string WordDocPath, string TextPath) { try { //read the ad-hoc text and store it for later StreamReader srStreamReader = new StreamReader(TextPath); String sString = srStreamReader.ReadToEnd(); //open the word document and it's main document part using (WordprocessingDocument wdWordDoc = WordprocessingDocument.Open(WordDocPath, true)) { MainDocumentPart mdpWordDocMainPart = wdWordDoc.MainDocumentPart; //create then add a new paragraph wp.Paragraph wppParagraph = new wp.Paragraph(new wp.ParagraphProperties(new wp.ParagraphStyleId() { Val = "NoSpacing" })); mdpWordDocMainPart.Document.Body.Append(wppParagraph); //create new markup for the table Table wppTable = new Table( new TableProperties( new TableStyle() { Val = "TableGrid" }, new TableWidth() { Width = "0", Type = TableWidthUnitValues.Auto }, new wp.TableBorders( new TopBorder() { Val = BorderValues.None }, new LeftBorder() { Val = BorderValues.None }, new BottomBorder() { Val = BorderValues.None }, new RightBorder() { Val = BorderValues.None, }, new InsideHorizontalBorder() { Val = wp.BorderValues.None }, new InsideVerticalBorder() { Val = wp.BorderValues.None }), new TableLook() { Val = "04A0", FirstRow = true, LastRow = false, FirstColumn = true, LastColumn = false, NoHorizontalBand = false, NoVerticalBand = true }), new TableGrid( new GridColumn() { Width = "11016" }), new TableRow( new TableCell( new TableCellProperties( new TableCellWidth() { Width = "11016", Type = wp.TableWidthUnitValues.Dxa }), new Paragraph( new ParagraphProperties( new ParagraphStyleId() { Val = "NoSpacing" }, new KeepLines(), new PageBreakBefore(), new ParagraphMarkRunProperties( new RunFonts() { Ascii = "Trebuchet MS", HighAnsi = "Trebuchet MS" }, new FontSize() { Val = "17" }, new FontSizeComplexScript() { Val = "17" }), new LastRenderedPageBreak(), new Run( new RunProperties( new RunFonts() { Ascii = "Trebuchet MS", HighAnsi = "Trebuchet MS" }, new FontSize() { Val = "17" }, new FontSizeComplexScript() { Val = "17" }, new Text(sString)))))))); //text for the run comes from the adhoc text document //add then save the table to the document mdpWordDocMainPart.Document.Body.Append(wppTable); mdpWordDocMainPart.Document.Save(); } } catch (Exception e) { Console.WriteLine(e.InnerException); return false; //failure } return true; } static void Main(string[] args) { new Program().AddTableAdHocText(args[0], args[1]); } } }