Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Error during upgrade o...

Error during upgrade of dynamics (NAV) connector v2 to v3

(0) Share

Report

Posted on by VincentP

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

All responses (1)

Answers (1)

Verified answer

VincentP 10 on at

Like (0)

Report

RE: Error during upgrade of dynamics (NAV) connector v2 to v3

*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)