NLS Version / Backup file / Error

[jprenou]

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

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?

[jprenou]

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

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)

Result := sdFolder.sfTableMakeUniqueName(srcSourceName + '_Backup', TempName);

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); --------------------

[jprenou]

You know what it working better now

Regards,

JP

jprenou wrote:

> You know what it working better now

I'm glad to hear that.