Extension Install-NAVApp error

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I installed a Naivison extension, and later removed it (I did not use the -DoNotSaveData parameter)

When I wanted to reinstall it, I got this error message:

Server instance: NAVTEST
Tenant ID: <ii>default</ii>
<ii>Session type: UnknownClient
Session ID: 543
User: navuser\nav
Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavSqlException
ErrorNumber: 3970
SuppressMessage: False
SuppressExceptionCreatedEvent: False
FatalityScope: None
Message:
The following SQL error was unexpected:
This operation conflicts with another pending operation on this transaction. The operation failed.
SQL statement:
IF (SELECT OBJECTPROPERTY(OBJECT_ID(N'dbo."$AppData$1b2f6c31-c74f-4f15-955c-2ad559bb8767$3b053437e3ed983de0f3344a8dfcc9af"'), N'IsTable'))=1 DROP TABLE dbo."$AppData$1b2f6c31-c74f-4f15-955c-2ad559bb8767$3b053437e3ed983de0f3344a8dfcc9af"

How can I get her to restore the data?

Thanks.

*This post is locked for comments

All responses (3)

Answers (0)

MatD 105 on at

Like (0)

Report

RE: Extension Install-NAVApp error

Hello,

Has anyone managed to resolve this error? I am struggling with this right now.

Best Regards

MatD
Community Member Microsoft Employee on at

Like (0)

Report

RE: Extension Install-NAVApp error

I use V1 extension. I use upgrade codeunit, It also restores data, but throws a sql drop table error on some tables.
Suggested answer

Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: Extension Install-NAVApp error

are you using V1 extension or V2 extension? (visual studio code)

you need to include Upgrade codeunit in your app to handle restoring data..