1. Beatrix Willius
  2. Valentina Database ADK
  3. Samstag, Dezember 09 2017, 06:12 AM
  4.  Abonnieren via E-Mail
Just got the above error from a user. However, my databases don't have an index. Let alone a unique constraint.

Here is the relevant part of the session log:

2017-12-08, 18:31:39 MaxModel.haveADatabase
2017-12-08, 18:31:39 VConnectionController.Constructor 1
2017-12-08, 18:31:39 VConnectionController.ConnectLocally
2017-12-08, 18:31:39 Valentina Version: 7.5.2
2017-12-08, 18:31:39 VConnectionController.ConnectLocally done
2017-12-08, 18:31:39 VConnectionController.OpenDB
2017-12-08, 18:31:39 VConnectionController.OpenDBLocally
2017-12-08, 18:31:39 getDatabase.get
2017-12-08, 18:31:39 getDatabase.openDB
2017-12-08, 18:31:39 trash is nil
2017-12-08, 18:31:39 Schema Version: 19
2017-12-08, 18:31:39 Dialog: Beim letzten Öffnen des Archivs "Mail ab 160722.vdb" wurde das Programm nicht korrekt beendet! Dafür wird nun die Integrität der Daten überprüft, was einige Zeit dauern kann. Du solltest AUF GAR KEINEN FALL Mail Archiver beenden! <---- app wasn't quit correctly. Journal file is checked
2017-12-08, 18:35:10 getDatabase.CreateTablesAndFields
2017-12-08, 18:46:55 getDatabase.CreateTablesAndFields done
2017-12-08, 18:46:56 getDatabase.openDB done
2017-12-08, 18:46:56 getDatabase.get done
2017-12-08, 18:46:56 VConnectionController.OpenDBLocally done
2017-12-08, 18:46:56 VConnectionController.OpenDB done
2017-12-08, 18:46:56 VConnectionController.Constructor 1 done
2017-12-08, 18:46:56 VConnectionController.getDatabase
2017-12-08, 18:46:56 VConnectionController.getDatabase done
2017-12-08, 18:46:56 MaxModel.haveADatabase archive path: /Volumes/Y_Backup/1-kst/3 Büroorganisation/Archive/Email Archiv neu/Mail ab 160722.vdb
2017-12-08, 18:46:56 MaxModel.haveADatabase done
2017-12-08, 18:46:56 MaxModel.OpenArchive done
2017-12-08, 18:46:56 DBWindow.doOpenArchive done
2017-12-08, 18:46:56 App.Open
2017-12-08, 18:46:56 Startup finished
2017-12-08, 18:46:56 Dialog: Es war nicht möglich, das Archiv "Mail ab 160722.vdb" zu öffnen! Fehler: 537860 Unique violation for index "UNKNOWN".
2017

The code is:


try
ValentinaDB.Open(theFolderitem)
DBHasBeenOpened = true

catch err as VException
DBHasBeenOpened = true
Globals.theErrorLog.DialogErrorProceed(Replace(kErrorNoOpen, "<<name>>", theFolderitem.Name) + " " + str(err.ErrorNumber) + " " + err.Message)
ValentinaDB = Nil
end try



Any idea what might have gone wrong here? What can I do to diagnose the cause of this problem?

As usual: Xojo 2017r1, macOS 10.13.2.

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.
Ivan Smahin Akzeptierte Antwort
I guess it was some "old-format" db and open.db calls "convert to actual db format" internally (in most cases it causes reading/writing db data + reindex database after all).
Obviously, there is some unique violation (probably it is calculated field which supposed to be unique but actually not).
Can you send us that "original" db for testing?
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Hi Ivan,

no old format. The schema version is the current one. There are no extra indexes except the basic ones for the recids. The only problem I see is that the user force-quit the app on the last start and Valentina tried to read the journal file.

Any other ideas? Should I be able to open the database in ValentinaStudio or would this give the same error?

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.
Ivan Smahin Akzeptierte Antwort
Well, restoring from the journal calls Reindex as well. Probably db was hardly damaged. Yes, it is a good idea to open db in vStudio and diagnose it.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Hi Ivan,

will try this.

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.
  • 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