Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (6)

Resolved What is a "dynamic SQL error"?

  1. Beatrix Willius
    Beatrix Willius
  2. Valentina Database ADK
  3. Friday, May 20 2022, 04:46 AM
  4.  Subscribe via email
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
Comment
There are no comments made yet.
Responses (6)
Ivan Smahin
Ivan Smahin Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Beatrix Willius
Beatrix Willius Accepted Answer
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*/
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Ivan Smahin
Ivan Smahin Accepted Answer
Does it happen on MacOs?

Probably it helps:
http://macfixguides.com/fix-error-5-on-mac.html
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
Ivan Smahin
Ivan Smahin Accepted Answer
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...
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 4
Beatrix Willius
Beatrix Willius Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 5
Sergey Pashkov
Sergey Pashkov Accepted Answer
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()?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 6
  • Page :
  • 1


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