Posts Tagged ‘Error Message’

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]

You may not enter number manually

Importing to NAV/Business Central and receive the following error message.‘You may not enter numbers manually. If you want to enter numbers manually, please activate manual Nos. in No. Series XXXX.’ To resolve the errorIn NAV/Business Central search for ‘No Series’ and open the No. Series window.Locate the No. Series referenced in the error message and check…

[Read More]

RECENT POSTS


Failed to create record.: Entity does not support insert
Too Many Fields Defined After Microsoft Update
The operating system is not presently configured to run this application
SmartConnect Service Stops and ServerName==0 Shows in Event Log
No 'Access-Control-Allow-Origin' header is present on the requested resource.

POPULAR POSTS


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
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
Shortcuts Template for Extender

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM 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 SmartView SOP SQL Support Tech Tuesday Templates training