Git Product home page Git Product logo

Comments (4)

synopse avatar synopse commented on June 5, 2024

Sorry, I don't understand your language.

from mormot.

luizlobosysmo avatar luizlobosysmo commented on June 5, 2024

Translation by Google Translate:

Our company, Sysmo Sistemas, has a cashier application which is closing after a process of verifying the integrity of the SQLite database on some computers with Windows 10 Pro version 18363.900.

Code in Deplhi 6:

uses
  mORMot;

[...]

function TRgnSQLiteMaintenance.VerifyDatabaseIntegrity(AServerDatabase: TSQLRestServerDB): Boolean;
var
  oSQLTableJSON: TSQLTableJSON;
begin 
  try
    oSQLTableJSON := AServerDatabase.ExecuteList([], 'PRAGMA integrity_check');
    try
      Result := (oSQLTableJSON <> nil);

      if (Result) then
        Result := (LowerCase(String(oSQLTableJSON.GetS(1,0))) = 'ok');
    finally
      if (oSQLTableJSON <> nil) then
        FreeAndNil(oSQLTableJSON);
    end;
  except
    on E: Exception do
    begin
      Result := False;
      {$IFDEF VER140}
      if (Assigned(LogarErroGeral)) then
        LogarErroGeral('', 'TRgnSQLiteMaintenance.VerifyDatabaseIntegrity: Exception [' + E.Message + ']');
      {$ENDIF}
    end;
  end;
end;

As far as it was possible to identify by the logs, the application closed when executing the command oSQLTableJSON.GetS (1,0).

We suspect that an exception occurs in the process, but no error message is generated and simply closes the application.

We have identified in some clients with Windows 10 where if there is any exception in the code and it is not treated with try except the application is closed without presenting an error message.
However, in this case, even with try except, the error persists.

We were unable to simulate internally, only on a client.

We found that on other computers with the same configuration and version of Windows the problem does not happen.

User permissions have already been added for Full Control and placed SSD, but it has not been successful.

The error recorded in Windows events was:

Log Name: Application
Source: Application Error
Date: 11/06/2020 20:01:34
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: classic
User: N / A
Computer: Caixa01lj5
Description:
Faulting application name: pdv10.exe, version: 3.9.20.3, timestamp: 0x2a425e19
Faulty module name: unknown, version: 0.0.0.0, timestamp: 0x00000000
Exception code: 0xc0000005
Fault offset: 0x00000000
Failed process ID: 0xbe0
Failed application start time: 0x01d6402ff3dcb7b8
Faulting application path: c: \ pdv \ pdv10.exe
Faulty module path: unknown
Report ID: 04ede662-fca9-47c6-bcc4-8882091f9ebe
Failed package full name:
Application ID for the failed package:
Event XML:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Application Error" />
    <EventID Qualifiers="0">1000</EventID>
    <Level>2</Level>
    <Task>100</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2020-06-11T23:01:34.725905000Z" />
    <EventRecordID>7199</EventRecordID>
    <Channel>Application</Channel>
    <Computer>caixa01lj5</Computer>
    <Security />
  </System>
  <EventData>
    <Data>pdv10.exe</Data>
    <Data>3.9.20.3</Data>
    <Data>2a425e19</Data>
    <Data>unknown</Data>
    <Data>0.0.0.0</Data>
    <Data>00000000</Data>
    <Data>c0000005</Data>
    <Data>00000000</Data>
    <Data>be0</Data>
    <Data>01d6402ff3dcb7b8</Data>
    <Data>c:\pdv\pdv10.exe</Data>
    <Data>unknown</Data>
    <Data>04ede662-fca9-47c6-bcc4-8882091f9ebe</Data>
    <Data>
    </Data>
    <Data>
    </Data>
  </EventData>
</Event>

from mormot.

pavelmash avatar pavelmash commented on June 5, 2024

It's impossible to identify a source of a problem from information you provide.

For tracking such "unexpected" errors on client side you can add SynLog.pas unit, enable "detailed map file information" in the project option, and enhance exception logging.
You should have the stack trace of all exceptions, in the .log text file.

But without any more context, it is not possible to give you more help.

from mormot.

luizlobosysmo avatar luizlobosysmo commented on June 5, 2024

This process has been removed and the problem continues.
It must be something related to Windows.
Thank you.

from mormot.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.