V4MD - Error -39

[Ruslan Zasukhin]

On 9/7/04 4:54 PM, "Roland Hildebrandt" <r.hildebrandt at sbt.fr> wrote:

> Hi everyone,
> 
> On a database created with V4MD 1.9.8 on windows, with director 8.51 I get an
> error -39 while trying to make an insert using sqlexecute. We use 4 files
> formated for our databases (vdb ind dat (blb)).
> 
> The error happens only when some valentina code has been called from director
> before I make the insert.
> 
> In our project we use several instances of the valentina XTRA at the same time
> in order not to have to recreate instances of the XTRA each time we change
> database files.
> 
> Our project works fine for several months before the error comes up. And this
> using the same code.
> 
> So to sum up the only way to have the bug is :
> * Using a database which has been used for several months (no bug on a clean
> database)
> * Execute the insert using the code below (if you erase even one line of the
> code the insert works fine)
> 
> I tried several things which does not solve the problem including using XTRA
> 1.10... 
> 
> This is not due to some ponctual crash. Our client lost his databases on about
> 20 different computers (windows) during a week after 6 months of use without
> any problems. So it seems the problem is linked with an important amount of
> data in the database.
> 
> The code which causes the error is the following :
> 
> =====================================
> ValentinaDebugLevel(1)
> ValentinaInit( 100 * 1024, "", myserial )
> 
> myBaseA = new(xtra"VDataBase")
> SetEncryption( myBaseA,"gloubiboulga" )
> openDatabase(myBaseA, the moviepath & "bases\Accounts")
> 
> myBaseB = new(xtra"VDataBase")
> SetEncryption( myBaseB,"gloubiboulga" )
> openDatabase(myBaseB, the moviepath & "bases\Scoring")
> 
> myBaseC = new(xtra"VDataBase")
> SetEncryption( myBaseC,"gloubiboulga" )
> openDatabase(myBaseC, the moviepath & "bases\Data")
> 
> sqlstring="INSERT INTO Accounts_profil (Cle_accounts_profil, seniorid,
> date_training, ind_m, ind_a, ind_l, ind_fe, ind_vs) VALUES
> (769,1,'02/02/2004',10,10,10,10,10 )"
> SqlExecute(mybaseA, sqlstring)
> => error -39
> 
> ================================
> 
> 
> I have also made a diagnose on the Accounts Database (see below). The other
> ones (Scoring and Data) are not so important as far as we get the same bug
> even with clean Data and Scoring. So the problem seems to come from the
> Accounts Database.
> 
> I searched a big part of the valentina list archive for error -39 and I have
> found that this is an end of file error of the vdb file on macintosh. And also
> saw that this happens often with old valentina versions but not anymore with
> the newer ones.
> 
> So if someone has any ideas (error -39 , several instances of XTRA , amount of
> data which changes the way it works etc...) about this complicated bug this
> would be wonderful. I can send a test project. Or some other information.

Hi Roland,

It looks you have corrupted db files.

Only hope to fix this -- using XML dump than XML Load into new fresh db.
May happens that some info will be lost.



-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------