#1  
Old 7th February 2012, 07:23 PM
jprenou jprenou is offline
Senior Member
 
Join Date: Oct 2008
Posts: 277
Default NLS Version / Backup file / Error

Hi,

Since you put the NLS stuff in NexusDB, I've got a lot of problem.

This morning again my customer is blocked with this error, after checked the database I've got a lot of backup file and I don't know where they come from.

07/02/2012 - 08:38 -
NexusDB: <unnamed TsiQuery instance>: Query execution failed:
INTERNAL: Error when seeking to position in file [\ServeurDONSOLUNEbaseAbonnements.nx1, offset 0, error 6, Descripteur non valide]

Can you help me to understand what's happening here ?

Thanks

JP
  #2  
Old 7th February 2012, 08:31 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: NLS Version / Backup file / Error

jprenou wrote:

> Since you put the NLS stuff in NexusDB, I've got a lot of problem.
>
> This morning again my customer is blocked with this error, after checked
> the database I've got a lot of backup file and I don't know where they
> come from.
>
> 07/02/2012 - 08:38 -
> NexusDB: <unnamed TsiQuery instance>: Query execution failed:
> INTERNAL: Error when seeking to position in file
> [\ServeurDONSOLUNEbaseAbonnements.nx1, offset 0, error 6, Descripteur
> non valide]
>
> Can you help me to understand what's happening here ?


That error message has absolutely nothing at all to do with the NLS checks.

The error indicates that a call against the SetFilePointer API failed with
error code 6 (ERROR_INVALID_HANDLE).

Without a reproducable testcase I can't tell you for sure what causes this. But
it's relatively likely that there is some anti-virus software running,
performing on access scanning of the database files and messing things up.

As for having "a lot of backup file", I don't know what you are talking about.
Could you please provide some more detailed information?
  #3  
Old 7th February 2012, 09:32 PM
jprenou jprenou is offline
Senior Member
 
Join Date: Oct 2008
Posts: 277
Default

My application is running as a client application against the nxserver.
After I copied pasted a database from an other PC to the server, when my application (client) open a database, I checked the NLS with this procedure
Code:
procedure PackTables(aDatabase: TnxDatabase);
var
  slTable: TStrings;
  i: integer;
begin
  if aDatabase.Active then
  begin
    slTable:= TStringList.Create;
    try
      aDatabase.GetTablesNeedingPack(slTable);
      for i:= 0 to slTable.Count - 1 do
        aDatabase.PackTable(slTable[i], '');
    finally
      slTable.Free;
    end;
  end;
end;
Each time I'm doing this, All my tables are renamed as MyTableName_Backup.nx1

The NexusDB line code responsable for that is this one (in nxsrServerEngine.pas)
Code:
Result := sdFolder.sfTableMakeUniqueName(srcSourceName + '_Backup', TempName);
  #4  
Old 7th February 2012, 09:40 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: NLS Version / Backup file / Error

Well, I'm not surprised that things are not working for you.

You are totally ignore the TaskInfo returned by the call to PackTable and are
missing the loop that waits for the pack operation to complete.

Please check the EM source for how PackTable should be used.

jprenou wrote:

>
> My application is running as a client application against the nxserver.
> After I copied pasted a database from an other PC to the server, when my
> application (client) open a database, I checked the NLS with this
> procedure
>
> Code:
> --------------------
>
> procedure PackTables(aDatabase: TnxDatabase);
> var
> slTable: TStrings;
> i: integer;
> begin
> if aDatabase.Active then
> begin
> slTable:= TStringList.Create;
> try
> aDatabase.GetTablesNeedingPack(slTable);
> for i:= 0 to slTable.Count - 1 do
> aDatabase.PackTable(slTable[i], '');
> finally
> slTable.Free;
> end;
> end;
> end;
>
> --------------------
>
> Each time I'm doing this, All my tables are renamed as
> MyTableName_Backup.nx1
>
> The NexusDB line code responsable for that is this one (in
> nxsrServerEngine.pas)
>
> Code:
> --------------------
> Result := sdFolder.sfTableMakeUniqueName(srcSourceName + '_Backup',
> TempName); --------------------


  #5  
Old 7th February 2012, 10:47 PM
jprenou jprenou is offline
Senior Member
 
Join Date: Oct 2008
Posts: 277
Default

You know what it working better now

Regards,

JP
  #6  
Old 7th February 2012, 10:53 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: NLS Version / Backup file / Error

jprenou wrote:

> You know what it working better now


I'm glad to hear that.


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: One or more system tables can not be opened. Encrypted butno or wrong password? in version 3.07The System tables was included automaticallywhen I start backup ? Samuel nexusdb.public.support 2 5th January 2015 02:22 PM
Problem in NexusDB File since Version NexusDB3 Bernhard Roos Binaries 0 8th September 2011 02:33 AM
New version of RFS file set Anders Gustavsson nexusdb.public.support.thirdparty 5 16th June 2011 11:20 PM
Message: NexusDB: INTERNAL: Error when reading from file [z:\ord\ITNETU.nx1, error 1006, The volume for a file has been externally altered Roberto Nicchi nexusdb.public.support 21 3rd September 2010 09:17 AM
Table is full error during backup Elric Pedder nexusdb.public.support 4 4th October 2007 06:17 AM


All times are GMT +11. The time now is 12:36 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.