1. Beatrix Willius
  2. Valentina Database ADK
  3. Freitag, Mai 20 2022, 04:46 AM
  4.  Abonnieren via E-Mail
Got an error report from a user:

2022-05-19 11:41:05 An error happened:
2022-05-19 11:41:05 Class/Method: MaxModel.Flush
2022-05-19 11:41:05 Time: Thursday, May 19, 2022 11:41:05 AM Pacific Daylight Time 12153372
2022-05-19 11:41:05 Type of Error: VException 5 Dynamic SQL error.
2022-05-19 11:41:05 Error Number: 5
2022-05-19 11:41:05 Error Message: Dynamic SQL error.
2022-05-19 11:41:05 --------------------------
2022-05-19 11:41:05 Stack:
2022-05-19 11:41:05
Sub VDatabase.Flush()
Sub MaxModel.Flush()

What does this mean? Using Valentina 12.0.5 on macOS 12.4.

Mit freundlichen Grüßen/Regards

Beatrix Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Beatrix,

"Dynamic SQL error" - is a group of errors related to the binding parameters.
5 is an error code from VException, right? But we do not have such value in this group.

Anyway, is there any query with parameters in this method? Or it is just VDatabase.Flush()?
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Hi Sergey,

this is really only flush. The flush method is done after adding data to the database is finished:


'reset process activity
if theProcessActivity <> nil and theProcessInfo <> nil then
theProcessInfo.endActivity theProcessActivity
theProcessActivity = Nil
end if

'flush archive if an archive is there
if theArchive <> Nil then theArchive.Flush


Of course, I flush during adding of data. The code above is part of handling the end of adding data.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Hi Beatrix.

It's your own logger, so it is hard to unwind the reasons for the exception. Could you show the code - what exactly you are doing for:
2022-05-19 11:41:05 Type of Error: VException 5 Dynamic SQL error.
2022-05-19 11:41:05 Error Number: 5
2022-05-19 11:41:05 Error Message: Dynamic SQL error.

Because really, "Dynamic SQL error" is a group of different exceptions, but all its error codes start with "0x07..."
"Error Number: 5" looks completely unrelated to this group...
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Does it happen on MacOs?

Probably it helps:
http://macfixguides.com/fix-error-5-on-mac.html
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
The method only has a couple of lines of code. The stack of my logging says:

Sub VDatabase.Flush()
Sub MaxModel.Flush()

The relevant line in my code is:

if theArchive <> Nil then theArchive.Flush

Yes, the website comes up when I google "macos error 5". But grammar like "Have a well know about your Mac error" and generic verbiage like

Error 5 often comes out and appear on the computer with a notification like "[program name] cannot be operated" or "[program name] quit unexpectedly", and the specific error code number often indicates a particular type of problem on the computer. When you receive error 5 when start up/shut down the computer, or try to launch a program, the error problem will be closely related to the action you are trying to perform on the Mac.


tells me that the website isn't really useful.

The OSStatus list is also not really useful because there are so many errors with the number 5:

https://osstatus.com/search/results?platform=all&;framework=all&search=5

Might this error be relevant:

dsChkErr = 5, /*check trap error*/
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
We just never throw such error code "5" except it comes from OS.
So, yes, it seems you need to check the disk.

The only strange thing is - it was thrown as xDynamicSQLError instead of xOSFileError
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories