Small and medium business | Business Central, N...

Issue with TryFunction in BC on-premise

(0) Share

Report

Posted on by Govinda Kumar

2,304 Moderator

Hi,

I'm facing an issue with TryFunction in BC on-premise. Unlike in BC online, it is not throwing an error during code execution.

Here's an example of my code:

procedure Test()
begin
    if (batchAllocation.FindSet()) then
        repeat begin
            if (DistributionProcess()) then begin
                ErrorInProcess := false;
            end
            else begin
                ErrorInProcess := true;
                RevertProcess();
            end;
        end;
        until batchAllocation.Next() = 0;
end;

[TryFunction]
procedure DistributionProcess()
begin
    // Perform various tasks
end;

The RunTime problem occurs when inserting records in the purchase header table

I would greatly appreciate any suggestions on how to resolve the issue in on-premise version.

Thank you in advance for your help

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

RE: Issue with TryFunction in BC on-premise

The problem has been resolved, and the issue mentioned above is explained in detail in this blog demiliani.com/.../

Was this reply helpful? Yes No
JJMc 291 on at

Like (0)

Report

RE: Issue with TryFunction in BC on-premise

Good morning.

Try functions's behavior are diffrent in cloud and OnPrem, but you can change it:

According to Microsoft:

This behavior is different from the behavior in Microsoft Dynamics NAV 2016, which did not include this restriction by default. Therefore, you might encounter errors if you have application code that was written for Microsoft Dynamics NAV 2016 and you run the code in Microsoft Dynamics NAV 2017.

In practice, this means that you should not include the following function calls inside a try function scope:

Data Type

Function

Record and RecordRef

- INSERT
- MODIFY
- MODIFYALL
- RENAME
- DELETE
- DELETEALL
- >ADDLINK
- DELETELINK
- DELETELINKS

Database

- COMMIT

If you want to change this behavior, you can set the DisableWriteInsideTryFunctions setting in the CustomSettings.config file of the server instance to false. However, we recommend that you design your code to suit the default behavior instead.

So you may find the CustomSettings.config file at: C:\Program Files\Microsoft Dynamics NAV\100\Service

Once you find the file, open it (Make sure the service is stopped) and search for DisableWriteInsideTryFunctions in this file. Change it to false.

Save and close the file and then start the service again. Now try the operation again and It must be fixed. Enjoy!!!

Reference: docs.microsoft.com/.../handling-errors-by-using-try-functions

Note

This behavior is different from the behavior in Microsoft Dynamics NAV 2016, which did not include this restriction by default. Therefore, you might encounter errors if you have application code that was written for Microsoft Dynamics NAV 2016 and you run the code in Microsoft Dynamics NAV 2017.

In practice, this means that you should not include the following function calls inside a try function scope:

TABLE 1

Data Type

Function

Record and RecordRef

- INSERT
- MODIFY
- MODIFYALL
- RENAME
- DELETE
- DELETEALL
- >ADDLINK
- DELETELINK
- DELETELINKS

Database

- COMMIT

If you want to change this behavior, you can set the DisableWriteInsideTryFunctions setting in the CustomSettings.config file of the server instance to false. However, we recommend that you design your code to suit the default behavior instead

Discalimer:

I hope it is usefull.

Was this reply helpful? Yes No
Govinda Kumar 2,304 Moderator on at

Like (0)

Report

RE: Issue with TryFunction in BC on-premise

Thanks, JJMc2.. I'm glad to inform you that the issue is resolved, and I have found an alternative way to achieve my desired functionality that works both in the on-premise and on-cloud, thank you for your response.

Was this reply helpful? Yes No
JJMc 291 on at

Like (0)

Report

RE: Issue with TryFunction in BC on-premise

Just out of curiosity. Could you please share how you solve it? Using a codeunit for this purpose?

Thank you.

Was this reply helpful? Yes No

Data Type	Function
Record and RecordRef	- INSERT - MODIFY - MODIFYALL - RENAME - DELETE - DELETEALL - >ADDLINK - DELETELINK - DELETELINKS
Database	- COMMIT

TABLE 1
Record and RecordRef	- INSERT - MODIFY - MODIFYALL - RENAME - DELETE - DELETEALL - >ADDLINK - DELETELINK - DELETELINKS
Database	- COMMIT

Join the conversation

Community site session details

Issue with TryFunction in BC on-premise

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Issue with TryFunction in BC on-premise

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates