Error "Implementation limit exceeded transactions count exceeded. Perform backup and restore to make database operable again"

[Angelith Rodriguez]

Hi,

i have a program in my job, but today we cant used, cause this message

"Implementation limit exceeded transactions count exceeded. Perform backup and restore to make database operable again"

i can see all folders of installations, but i dont know how to fixed

the actually  file .FDB dont open, but i found another that ok, but the data its to older.

How can I open those .fdb or .fir files for repair?

i have a file .xml with this information

<?xml version="1.0" encoding="utf-8"?>
<configuracion>
  <BiometricOption>1</BiometricOption>
  <ClockUpdateInterval>01:00:00</ClockUpdateInterval>
  <ClockUpdateOption>0</ClockUpdateOption>
  <ComPort>Ninguno</ComPort>
  <ConfigDataPath>
  </ConfigDataPath>
  <DataPath>C:\ProgramData\Maynar SRL\Servidor\Data\RP601.FDB</DataPath>
  <DataServer>localhost</DataServer>
  <EventsDataPath>
  </EventsDataPath>
  <RemotingPort>9500</RemotingPort>
  <AdmsPort>8081</AdmsPort>
  <ServerType>1</ServerType>
  <BackupDay>-1</BackupDay>
  <BackupPath>\Backup\Le</BackupPath>
  <BackupTime>23:00</BackupTime>
  <BackupEnabled>0</BackupEnabled>
  <ZkTime>1</ZkTime>
  <DatabaseEngine>FB</DatabaseEngine>
  <DataSourceSQL>SERV-LENOX\MSSQLSERVER2008</DataSourceSQL>
  <DefaultInitialCatalog>master</DefaultInitialCatalog>
  <AuthenticationType>WINDOWS_AUTHENTICATION_MODE</AuthenticationType>
  <UserSql>sa</UserSql>
  <PassSql>T20Q==</PassSql>
  <FirebirdServer>localhost</FirebirdServer>
  <SoftwareKey>MUAFTQQ==</SoftwareKey>
  <SoftwareCode>16191452</SoftwareCode>
  <MaskFilesPath>
  </MaskFilesPath>
  <MaskFilesSftp>NO</MaskFilesSftp>
  <LastBackupDate>03-04-2025</LastBackupDate>
</configuracion>

[Mark Rotteveel]

On 08/04/2025 20:48, Angelith Rodriguez wrote:
> i have a program in my job, but today we cant used, cause this message
>
> "Implementation limit exceeded transactions count exceeded. Perform
> backup and restore to make database operable again"
>
> i can see all folders of installations, but i dont know how to fixed
>
> the actually  file .FDB dont open, but i found another that ok, but the
> data its to older.
>

> *How can I open those .fdb or .fir files for repair? *

As the error says, you need to backup and restore the database. However,
what it doesn't say is that you need to mark the database read-only with
gfix before backup, and mark it read-write after restore.

See also my answer on Stack Overflow:
https://stackoverflow.com/a/56253020/466862

Mark
--
Mark Rotteveel

[Angelith Rodriguez]

Hi,

when i want to do for example gbak

cant format message 12:169 ......firebird.msg not foundcant format message 12:91

cant format message 12:256 ......firebird.msg not foundunable to complete network request to host "xnet:\\Global\FIREBIRD

cant format message 12:169

[Mark Rotteveel]

On 09/04/2025 17:18, Angelith Rodriguez wrote:
> when i want to do for example gbak
>
> cant format message 12:169 ......firebird.msg not foundcant format
> message 12:91
> cant format message 12:256 ......firebird.msg not foundunable to
> complete network request to host "xnet:\\Global\FIREBIRD
> cant format message 12:169

Sounds like you're running gbak in isolation without its supporting
files, and without a server running.

If you have Firebird server installed, then use the `gbak` of your
server installation, or make sure you specify the correct connection
string with the hostname. It will also help to have firebird.msg in the
same directory as your gbak and/or as the fbclient.dll it's loading.

The error `unable to complete network request to host
"xnet:\\Global\FIREBIRD"` means that it couldn't load Firebird Embedded,
and it fell back to an XNET connection to a Firebird server on the local
machine, but there is no Firebird server running on localhost (or at
least, not with the IPC name FIREBIRD).

If you're using an application that uses Firebird Embedded, then to
create a backup, you'll need to have a gbak that can use Firebird
Embedded as well, which means you basically need an entire Firebird
installation (or at least gbak.exe, fbclient.dll, plugins/engineXX.dll
and some supporting files). Just having gbak.exe is not enough in that case.

Alternatively, you need to contact the developer or supplier of your
application for help.

Mark
--
Mark Rotteveel

[Angelith Rodriguez]

Hi,

I installed Firebird version 5.0 and none of the gfix tools work. For the latter, gstat shows me the message "Wrong ODS version, expected 13, encountered 11."
If I have Firebird embedded, is there a way to perform a fix or backup from another tool or separately?

[Mark Rotteveel]

On 09/04/2025 20:44, Angelith Rodriguez wrote:
> I installed Firebird version 5.0 and none of the gfix tools work. For
> the latter, gstat shows me the message "Wrong ODS version, expected 13,
> encountered 11."
> If I have Firebird embedded, is there a way to perform a fix or backup
> from another tool or separately?

That error means you need Firebird 2.5.

Mark
--
Mark Rotteveel

[AlexPeshkoff]

Angelith, to use command line tools like gbak, gfix, etc. with firebird embedded before FB3 you should 

copy fbembed.dll fbclient.dll

After it tools will work in embedded mode, and you will be able to backup your database.

Next, I recommend you to upgrade FB version. It will help you avoid error 'transactions count exceeded'.

четверг, 10 апреля 2025 г. в 09:42:25 UTC+3, ma...@lawinegevaar.nl:

[Angelith Rodriguez]

Hello, I think I was able to repair it, or at least the application starts, but it doesn't update. It seems to be "read-only" or something similar. 

The information isn't updated. 

In parallel, I installed SQL Manager Lite for Interbase and Firebird. 

I can start and register the host and I can also start and register, but if I try to perform the "Validate" task, the database displays the following message:

 ================= START OF LOG ==================

Operation started! 

Error: Failed: Connection error. 

Bad parameters on attach or create database. 

Secondary server attachments cannot validate databases. 

End of operation! 

Bring online database complete

================= END OF LOG ==================

[Angelith Rodriguez]

I have a new error from my .FDB

Attempted update on read-only database.
SQL Code: -817
IB Error Number: 335544765

What can I do?

[Mark Rotteveel]

On 15/04/2025 21:30, Angelith Rodriguez wrote:
> I have a new error from my .FDB
>
> Attempted update on read-only database.
> SQL Code: -817
> IB Error Number: 335544765
>
> What can I do?

The instructions I linked in my initial reply told you to mark the
database read-only to be able to back it up. *If* you restored the
database successfully, you now need to mark it read-write again.

If you're still stuck at backing up or restoring, then you first need to
resolve that problem.

Mark
--
Mark Rotteveel