Permission issue on execution of codeunit.

(0) Share

Report

Posted on by lynix_x

259

Hello Everyone,

For i while i'm trying to make a 2013 tenant database upgrade to 2016. I use powershell to this, but when i sync the tenant, i get following error:

you do not have permission to run codeunit data upgrade. execute. I searched on forums, and someone had the same issue. I have a developer license, and importet it to the database. Can anybody provide me a workaround or a actual solution.

The thing is, when i force sync the tenant, the error disapears, but i want to sync with validiate.

I created myself as SUPER user on tenant database, but thats not enough i think

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

when you say import, is it Upload? did you restart service after upload?

Was this reply helpful? Yes No
lynix_x 259 on at

Like (0)

Report

i DID IT, and now it work. but when i ran upgrade process, got following error.

Sync-NAVTenant : The schema synchronization may result in deleted data. The following destructive changes were detected:
Table: 372, Payment Buffer
Field: 170, Creditor No.: Length reduced
Field: 171, Payment Reference: Length reduced
Examples of code to migrate data:
DataUpgradeMgt.SetTableSyncSetup(DATABASE::"Payment Buffer",[Upgrade Table Id],TableSynchSetup.Mode::[Mode]);

I don't think it is an license issue now. I cannot continue the process.

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

Hi ,

If you correctly install developer license and still you get this means you don't have manipulation access to DB

make your user as DB user

Was this reply helpful? Yes No
lynix_x 259 on at

Like (0)

Report

thanks for the reply Maneesha. I solved the permission issue, now when i run the upgrade, i get below error.

CodeunitId : 104025

FunctionName : UpdateItemNextCountingPeriod

StartTime : 3/27/2017 1:37:57 PM

Duration :

State : FailedPendingResume

Error : The UPG Item does not exist. Identification fields and values: No.='1000'

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

Please close this post if your initial issue is solved and create a new one.

Was this reply helpful? Yes No
Suggested answer

dkatson 2,263 on at

Like (0)

Report

This is absolutely data problem, some data is corrupted

Was this reply helpful? Yes No