[Axapta-Knowledge-Village] Record ID generation (SystemSequences) problem

[baran_sasmaz]

Dear Axapta developers,
Yesterday, i am faced with a recId problem in Dynamics 4.0.
When i try to create a new record via any form, i get the error message
below:
"Cannot create a record in Record ID generation (SystemSequences). name:
SEQNO.
Error accessing database connection.
An error occurred while obtaining new RecId value for the table."

or sometimes this one:
"Cannot edit a record in Record ID generation (SystemSequences). name: .
Error accessing database connection.
Cannot read a record in  ().
Error accessing database connection."

If i try to insert the record via table browser, i succeed.
I debugged the code and i examined that the error comes from the
setGlobalTransId method of the numberseq class:

------------------------------------------------------------------------\
----------------------------
protected void setGlobalTransId()
{
     createdTransactionId        saveGlobalTransId;
     ;
     doCreateTTSLink = false;

     if (!globalTransId)
     {
         // the error is given in this part of the code
         globalTransId   = appl.curTransactionId(true);
         // the error is given in this part of the code
         doCreateTTSLink = true;
     }
     else
     {
         saveGlobalTransId   =  globalTransId;
         globalTransId       =  appl.curTransactionId(true);
         doCreateTTSLink     =  globalTransId != saveGlobalTransId ? true
: false;
     }
}

------------------------------------------------------------------------\
---------------------------

What may be the solution to solve this problem?
Thanks in advance for your interest.

Baran



[Non-text portions of this message have been removed]