Business Central Error After Login

(0) Share

Report

Posted on by Rumon Kumar Prosad

I am new to Business Central. I am getting the following attached image error after login into Business central. I have installed the Business Central On-Prem version. Please help me!

I have the same question (0)

All responses (10)

Answers (1)

Inge M. Bruvik 1,057 Moderator on at

Like (0)

Report

RE: Business Central Error After Login

did you try to restart the BC middle tier service?

And what can you see in the event log of the server?

Was this reply helpful? Yes No
Rumon Kumar Prosad 25 on at

Like (0)

Report

RE: Business Central Error After Login

I have restarted the Business Central Server Service several times. The issue did not fix,

I have also checked the event viewer and seen the following error

Could not open the company.

Exception:

Microsoft.Dynamics.Nav.Client.Web.NavWebFailedOpenCompanyException: Could not open the company.

---> Microsoft.Dynamics.Nav.Types.Exceptions.NavSCOpenCompanyException: While opening company 'CRONUS Danmark A/S', the following error occured: 'Database transaction has been detected, no writes are allowed during this test. RecordID is User Login: {6E9C943B-D248-468B-929C-A2450EA3AF25}, Operation MODIFY.'

AL stack trace:

"No Transactions Subscriber"(CodeUnit 130630).ThrowErrorOnModify line 8 - Library - No Transactions by Microsoft

"Global Triggers"(CodeUnit 2000000002).OnDatabaseModify(Event) line 2

"User Login Time Tracker Impl."(CodeUnit 9013).CreateOrUpdateLoginInfo line 10 - System Application by Microsoft

"User Login Time Tracker"(CodeUnit 9026).CreateOrUpdateLoginInfo line 4 - System Application by Microsoft

"System Initialization Impl."(CodeUnit 151).Init line 12 - System Application by Microsoft

"Company Triggers"(CodeUnit 2000000003).OnCompanyOpen(Event) line 2

---> Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideException: While opening company 'CRONUS Danmark A/S', the following error occured: 'Database transaction has been detected, no writes are allowed during this test. RecordID is User Login: {6E9C943B-D248-468B-929C-A2450EA3AF25}, Operation MODIFY.'

AL stack trace:

"No Transactions Subscriber"(CodeUnit 130630).ThrowErrorOnModify line 8 - Library - No Transactions by Microsoft

"Global Triggers"(CodeUnit 2000000002).OnDatabaseModify(Event) line 2

"User Login Time Tracker Impl."(CodeUnit 9013).CreateOrUpdateLoginInfo line 10 - System Application by Microsoft

"User Login Time Tracker"(CodeUnit 9026).CreateOrUpdateLoginInfo line 4 - System Application by Microsoft

"System Initialization Impl."(CodeUnit 151).Init line 12 - System Application by Microsoft

"Company Triggers"(CodeUnit 2000000003).OnCompanyOpen(Event) line 2

---> Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideException: While opening company 'CRONUS Danmark A/S', the following error occured: 'Database transaction has been detected, no writes are allowed during this test. RecordID is User Login: {6E9C943B-D248-468B-929C-A2450EA3AF25}, Operation MODIFY.'

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,057 Moderator on at

Like (0)

Report

RE: Business Central Error After Login

Are there any customizations in your installation or is it a vanilla Cronus demo installation?

If it is a vanilla demo installation i would try to uninstall it and install it again.

If you have any addon's installed i would try to uninstall them to check how it works without them.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 93,820 Super User 2025 Season 2 on at

Like (0)

Report

RE: Business Central Error After Login

Hi, This is a really weird problem, it looks like the database doesn't have write permissions.

I think you can check the user permissions in the database first. Make sure the user you log in to BC On-Premise has read and write permissions.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Rumon Kumar Prosad 25 on at

Like (0)

Report

RE: Business Central Error After Login

I got the reason why this error is happening. After searching I can see there are some table like (Table 49 "Invoice Post. Buffer", Table 265 "Document Entry", Table 269 "G/L Account Net Change") are temporary, that's why Business central raises error while try to write date in these table.

Anyone can help me to change these table's property type from temporary to Database Table/Physical/Base Table.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,057 Moderator on at

Like (0)

Report

RE: Business Central Error After Login

There are tables you should not change.

Have you implemented some custom code that is being triggered at log in?

If you have you should review that code.

Was this reply helpful? Yes No
Rumon Kumar Prosad 25 on at

Like (0)

Report

RE: Business Central Error After Login

After Installing the Business central I did not change any code. Please give me suggestion how can I change the table type "Temporary" to database table. Please see the site and let me your opinion.

docs.microsoft.com/.../known-issues

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Business Central Error After Login

Hello,

From the AL stack it looks like the system is running some test code via CU 130630). Best is to raise a support request via your partner or CSP to Microsoft.

Thank you.

Was this reply helpful? Yes No
Verified answer

Rumon Kumar Prosad 25 on at

Like (1)

Report

RE: Business Central Error After Login

Thanks. I am thinking so.

Was this reply helpful? Yes No
Suggested answer

baunp 5 on at

Like (0)

Report

RE: Business Central Error After Login

I think the problem is that you have installed the app "Microsoft_Library-NoTransactions.app". The solution is to unpublish it.

Was this reply helpful? Yes No