You’re offline. This is a read only version of the page.
10
Hello, during the installation (upgrade) of the dynamics connector v3.1, the following error occures:
"Error SQL72014" "Cannot insert the value NULL into column 'RetryState', table 'MSDI.Scheduling.RetryTask'.
I updated the currently installed 2 version from v2.0 to v2.3, also used the v3.0 msi instead of the v3.1, same result (error).
Next thing I tried to cleanup the database (all mappings set on inactive) & executed the following SQL statements:
delete from logs
delete from MapDefinitions where DefinitionId not in (select DefinitionId from Maps)
delete from TaskRegister where RegisterId not in (select RegisterId from Maps)
delete from TaskTriggers where TriggerId not in (select TriggerId from Maps)
Same result (error).
Anyone who can point me in the right direction?
*This post is locked for comments
I have the same question (0)*SOLVED*
I found it out myself. Procedure...
1) export & remove all current integrations (write down last runtime and filters)
2) run the following queries on the MSDI database
delete from MapDefinitions
where DefinitionId not in (select DefinitionId from Maps)
delete from TaskRegister
where RegisterId not in (select RegisterId from Maps)
delete from TaskTriggers
where TriggerId not in (select TriggerId from Maps)
3) import integrations (manually edit last runtime and filters)
Share
Report
All responses (
Answers (
