Cannot edit a record in Number sequence Scope

(0) Share

Report

Posted on by ALAhmed

916

Hello ,

I have this problem , when i tried to update NumberSequenceScope the table but the following code i get the error message: "Cannot edit a record in Number sequence Scope (NumberSequenceScope). Reference: 0.The record already exists."

static void Job3(Args _args)
{
    NumberSequenceScope     oldNumSequScope;
    ttsBegin;
    select forUpdate oldNumSequScope where oldNumSequScope.RecId == 5637146826 
                    && oldNumSequScope.DataArea  == "123";
    if(oldNumSequScope)
    {
        oldNumSequScope.FiscalCalendarPeriod   = 5637146093;
        oldNumSequScope.update();
        info("ok");
    }
    ttsCommit;
}

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Mea_ 60,284 on at

Like (0)

Report

Hi Alex.

NumberSequenceScope table has one unique index that includes FiscalCalendarPeriod field. Probably there is already a record with same FiscalCalendarPeriod and other index fields you are trying to set, so data base throw error because of duplicates.

We don't know why do you want to change this field, but I can assume that you want to change scope of number seq record. My proposition to you is to find scope with required fiscal period and then update number seq record with it instead of changing existing scope.

Was this reply helpful? Yes No