Posts Tagged ‘Change Tracking Table’

You do not have the following permissions on TableData eOneChangeMain: Read

ErrorA user in Business Central is receiving the error:You do not have the following permissions on TableData eOneChangeMain: ReadCauseThe SmartConnect Change Tracking Extension is installed in Business Central, and the current user is not assigned the SmartConnect Change Tracking permission set.ResolutionMake sure all users are assigned the SmartConnect Change Tracking permission set.There are 2 possible…

[Read More]

Configure a Business Central Change Data Source

What is a Business Central Change Data Source? If you are using the online SaaS version of Business Central, then you can enable Business Central Change tracking in SmartConnect so only records that have been created and/or modified since the last map run will be processed. If you are using an on-premise version of Business…

[Read More]

Plugin processing Failed : The given key was not preset in the dictionary

Receiving the following error in CRM/D365 Sales ‘System Jobs’Plugin processing Failed : The given key was not preset in the dictionaryThere are two known causes for this error.Blank Primary FieldThis error message can occur when the record that the change plugin was triggered on does not have a value in the primary field.SmartConnect change tracking…

[Read More]
Tech Tuesday

Use the SmartConnect Change Tracking Table as your Data Source

Use the SmartConnect Change Tracking Table as your Data Source The great thing about a SmartConnect Changes Only integration is that it sets up the SQL Trigger and tracking table for us. To make the process in SmartConnect work, we have to have a field that marks the change table as processed. This extra field,…

[Read More]

RECENT POSTS


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
You do not have the following permissions on TableData eOneChangeMain: Read
SOP Taxes not automatically calculating when using SmartConnect and Avalara AvaTax
Downloading older versions of SmartConnect

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
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms

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