Internal Error (Manager 23.2.2.607)

1

Hi Team,

Kindly note that when i try to edit summary for a specific date or try to post any documents, I face below issue:

SQLite.SQLiteException: database disk image is malformed

at SQLite.PreparedSqlLiteInsertCommand.ExecuteNonQuery(Object source)

at SQLite.SQLiteConnection.Insert(Object obj, String extra, Type objType)

at SQLite.SQLiteConnection.Insert(Object obj)

at Manager.ApplicationData.Process(String entityId, Action actions, String user, String description, Boolean history) in /home/runner/work/Manager/Manager/Manager/ApplicationData.cs:line 248

at Manager.ApplicationData.Process(String entityId, Object o, String user, String description) in /home/runner/work/Manager/Manager/Manager/ApplicationData.cs:line 209

at ManagerServer.HttpHandlers.Businesses.Business.VueForm`1.InnerPost() in /home/runner/work/Manager/Manager/ManagerServer/HttpHandlers/Businesses/Business/VueForm.cs:line 605

at ManagerServer.Startup.<>c.<b__1_1>d.MoveNext() in /home/runner/work/Manager/Manager/ManagerServer/Startup.cs:line 126

— End of stack trace from previous location —

at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)

Please need your support.

2

I think the file has become corrupt. Open a backup and see if that one works OK.

3

The database is getting updated, I’m afraid that the data won’t be updated.
Do we have any chance to get the database fixed ?

4

Did you try to open a backup? What is the edition (Desktop, Server or Cloud) of Manager you are using and what OS?

5

Server edition on windows server 2016

6

You don’t give an answer about opening a backup so I’m not going to waste more time. Good luck.

7

I tried the backup & same issue

8

@ahmede, based on your initial post, you do not have an internal error. Those are always headed by the phrase Internal Error. You mention trying “to post any documents.” What do you mean by this? You do not post documents in Manager. Tell us exactly what you did that triggered the problem.

Rather than transcribe the message, please post a screen shot of what you actually see on your screen.

9

Capture2
Capture2233×823 45.7 KB

When trying to edit the summary for a specific period

10

What does this mean? How is the database being updated? And if it is, why are you concerned it will not be?

Also, what browser (including version number) are you using to access Manager? On what operating system?

11

the database is corrupted & I need any clues to recover it.
We are using Manager Server Edition Version 23.2 on Windows Server 2016

12

You did not answer my questions. What do your comments about updating mean? And what browser, including version, are you using? Like @Mark, if you won’t answer my questions, I will not spend more time trying to help.

13

that i tried the backup & it has the same error, in the beginning, i didn’t want to do that because the app was in production & users are making updates on it.
Browser is google chrome, Version 109.0.5414.120 & we just purchased server edition verion 23.2 & license is updated successfully.
I think it’s a DB SQLITE error which is corrupted or something.
Do you have any clues how to recover the database or we can have a quick call & you can help on this?

14

Try a different browser first. More problems are reported with Chrome than any other browser.

Create a test business and see if things work. If your data base is corrupt, the problem will be limited to that business file.

There is no phone support. I am just a forum moderator, not customer support.

15

True and that needs to be fixed because Chrome is by far the most used web-browser. Just search for browser ranking by usage 2022 and you will notice that most report more than 65% of all browsers used is Chrome, followed by Safari (about 12%) and then Edge (about 5%). Sure, these stats include phone browsers Safari (IOS) and Chrome (Android).

Searching on Desktop Browsers Market Share 2022 still shows Chrome to be over 60% but Edge is then second with about 15% and Safari about 10%.

Manager is browser based and even though it is developed using Microsoft tools it is important that it will not be buggy on Chrome.

16

Please could we have a live support as the business is affected.
If it’s not included, we are happy to pay any extra charge to get immediate support.

17

There is no support other than this forum

18

Have you

  • tried using a backup on a different computer

  • low level disk check on that disk

19

image
image1814×428 9.7 KB

The DB is corrupted & we don’t have a new backup

20

See Fix SQLite Database Disk Image is Malformed