Order planing problem

csicso

Hi everyone!

I have a problem with Order Planning in NAV 4.0 SP2 on SQL Server.
When I try to create an Order, I've got an error:
"The following C/AL functions can be used only to limited degree during write transactions (because one or more tables will be locked).
Form.RunModal() is not allowed in write transactions.
CodeUnit.Run() is allowed in write transactions only if the ..."

This function is worked when we used the native database.

Any idea?

Thanks!

PS: sorry my english

kriki

Probably this function was not run on the native client. Or there was a COMMIT before it without starting a new transaction.
I would use the debugger to see where the error is how he got there.

csicso

Thanks, I try it

csicso

I've started the debugger, the error comes in this Codeunit:

333 Req. Wksh.-Make Order
In this function: TryCarryOutReqLineAction(ReqLine)

But this is too complicated for me, I'm a beginner NAV developer

kriki

I think you get the error on this line:

IF NOT TryCarryOutReqLineAction(ReqLine) THEN BEGIN

NAV gets to this line if this is true:

IF PlanningResiliency THEN BEGIN

Now you should search WHY this boolean is true.

This means you have to check the complete batch and follow how you get there.
This is not so easy for a beginning developer, so I would suggest you involve a senior developer.