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


Use the REST Connector to parse nested Value Arrays
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.

POPULAR POSTS


SSL Security error using OLEDB Connection
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
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

CATEGORIES

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