Posts Tagged ‘Error Message’

Web request did not return any data. Verify the mapID is correct and try again.

Using the Excel AddIn and attempting to run a SmartConnect map.  Receiving an error back that says “Web request did not return any data.  Verify the mapID is correct and try again.”   The error message in the Excel AddIn looks like this:This means you do not have the ASP.NET components installed on your IIS server.  1. …

[Read More]

WinSCP.SessionRemoteException: Network error: Connection to XXXX refused

I’m using the WinSCP application to connect to my SFTP server.I can connect and upload/download files successfully when using the WinSCP application included in the download, but when I try to connect via SmartConnect scripting per this blog article, it fails with the error:WinSCP.SessionRemoteException: Network error: Connection to “xxxx.com” refused.Make sure that you are connecting…

[Read More]

Type must be equal to ‘Inventory’ in Item: No.=XXXX. Current value is ‘Service’.

When importing a Sales Invoice or Sales Order to Business Central and receive the below error message.Type must be equal to ‘Inventory’ in Item: No.=XXXX. Current value is ‘Service’.CauseThe line item has been setup as a Service type Item. This can be verified by checking the Item Card for the field ‘Type’. Service Items are…

[Read More]

The Sales Header does not exist. Identification fields and values: Document Type=’Quote’No.=’’

If you are importing a Sales Transaction using the Business Central web services and receive this error, then a workaround will be required to import the record.The Sales Header does not exist. Identification fields and values: Document Type=’Quote’No.=’’ CauseThe cause for the error is the Business Central web services cannot set the ‘Tax_Area_Code’ field when creating…

[Read More]

The type initializer for ‘System.Data.SqlClient.SqlConnection’ threw an exception

Recently I encountered a scenario where a client machine was returning the error, “The type initializer for ‘System.Data.SqlClient.SqlConnection’ threw an exception”, when running a map that connects to SQL. The error message is a standard .NET Framework error, that is saying .NET can’t create the SQL connection.The error is caused by a corruption of the .NET…

[Read More]

Business Central error- Key “XXX” is not well formed! – when trying to delete a record

I’m trying to delete a Customer record in Business Central/NAV using the SmartConnect SOAP CustomerCard endpoint.When I run the integration, it fails with the error:Failed to delete record with Keys ‘Key = XXX’ Key “XXX” is not well formed!Why do I get this error?The reason for the error is a mismatch for the data provided…

[Read More]

Error Code 12005 not found when using Create Employee in SmartConnect

I’m running a SmartConnect map  to create employees using the Create Employee destination.  Most of the records are successful but a few give the error: Error Number = 12005  Stored Procedure=   Error Description = Error Codes were not found in table DYNAMICS..taErrorCode. Please insure that the table taErrorCode is up to update. 12005Since it doesn’t…

[Read More]

Error message when running the map “Conversion failed when converting the varchar value ‘The’ to data type Int.

Running a SmartConnect map using KEY2ACT eConnect nodes and receiving an error that says. “Conversion failed when converting the varchar value ‘The’ to data type Int.”   The word “The” might be replaced by the word “Job” or another random word.  This is caused by a setting in the Wennsoft eConnect nodes.  At the bottom of each…

[Read More]

MSSQL Real-Time Data Source Registration Error

When registering an MSSQL Real-Time data source receive the following error message.Latest version of MSSQL real time data source assembly does not exist in SERVER : DATABASETo enable real time data sources please run the script below as a MSSQL system administrator on the server and try again.How to resolve the error messageIn most cases…

[Read More]

RECENT POSTS


SmartConnect email task fails with error: An invalid character was found in the email header
Does SmartConnect import into Avalara Avatax software
Could not initialize a collection when launching SmartConnect
ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key when you open a SmartConnect map.
Connection could not be validated when using Excel data source

POPULAR POSTS


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training