Table Error on Backup

I have a relatively small table ~900 records with somewhat large, (70
scanned pages) PDF's stored in a blob field for each record.

On backup, suddenly I am getting an error:

[EIntOverFlow] Integer OverFlow [$3CA1/15521]

I can work around the problem for now.

It is interesting to note that the table otherwise functions normally.

I'm just curious as to what the cause may be.

Thanks,

John

John Turner wrote:

> I have a relatively small table ~900 records with somewhat large, (70 scanned
> pages) PDF's stored in a blob field for each record.
>
> On backup, suddenly I am getting an error:
>
> [EIntOverFlow] Integer OverFlow [$3CA1/15521]
>
> I can work around the problem for now.
>
> It is interesting to note that the table otherwise functions normally.
>
> I'm just curious as to what the cause may be.
>
> Thanks,
>
> John

Can't say without a callstack

On 6/10/2019 3:58 PM, Thorsten Engler [NDA] wrote:
> John Turner wrote:
>
>> I have a relatively small table ~900 records with somewhat large, (70 scanned
>> pages) PDF's stored in a blob field for each record.
>>
>> On backup, suddenly I am getting an error:
>>
>> [EIntOverFlow] Integer OverFlow [$3CA1/15521]
>>
>> I can work around the problem for now.
>>
>> It is interesting to note that the table otherwise functions normally.
>>
>> I'm just curious as to what the cause may be.
>>
>> Thanks,
>>
>> John
>
> Can't say without a callstack
>

Hope this helps...thanks.


Time: [493026488] 6/9/2019 2:24:20 PM
ExceptionInfo: nil
Exception: EnxDatabaseError
Message: Unexpected exception object raised: [EIntOverflow] Integer
overflow [$3CA1/15521]
Filesize: 21512448
Filedate: 2013-07-16 03:31:46
Computer: QBHSERVER3
User: Administrator
ThreadID: 21964
ProcessID: 4196
Version: 3.1202
AWE Enabled: False
Current Window Caption: NexusDB v3 Enterprise Manager 3.1202
Current Window Class: TfrmMain
--------------------------------------------------------------
Callstack (Frames):
[0073E440] nxdbBase.Check (Line 204, "nxdbBase.pas")
[0112384A] nxdbBackupController.TransferSingleTable (Line 424,
"nxdbBackupController.pas")
[0112430E] nxdbBackupController.BackupTable (Line 585,
"nxdbBackupController.pas")
[01124A8B] nxdbBackupController.TnxBackupController.Execute (Line 718,
"nxdbBackupController.pas")
[0112332D] nxdbBackupController.TnxBackupController.Backup (Line 318,
"nxdbBackupController.pas")
[011374E8] frmLiveBackup.TfmLiveBackup.btnStartClick (Line 242,
"frmLiveBackup.pas")
[005579BF] Vcl.Controls.TControl.Click
[0055BF25] Vcl.Controls.TWinControl.WndProc
[0057A06C] Vcl.StdCtrls.TButtonControl.WndProc
[0055C08B] Vcl.Controls.DoControlMsg
[0055BF25] Vcl.Controls.TWinControl.WndProc
[00644BC1] Vcl.Forms.TCustomForm.WndProc
[0055B568] Vcl.Controls.TWinControl.MainWndProc
[004DD80C] System.Classes.StdWndProc
[0055C036] Vcl.Controls.TWinControl.DefaultHandler
[0055BF25] Vcl.Controls.TWinControl.WndProc
[0057A06C] Vcl.StdCtrls.TButtonControl.WndProc
[004DD80C] System.Classes.StdWndProc
================================================== ============

That's a client side callstack.
I need the server side callstack.

John Turner wrote:

> On 6/10/2019 3:58 PM, Thorsten Engler [NDA] wrote:
> > John Turner wrote:
> >
> > > I have a relatively small table ~900 records with somewhat large, (70
> > > scanned pages) PDF's stored in a blob field for each record.
> > >
> > > On backup, suddenly I am getting an error:
> > >
> > > [EIntOverFlow] Integer OverFlow [$3CA1/15521]
> > >
> > > I can work around the problem for now.
> > >
> > > It is interesting to note that the table otherwise functions normally.
> > >
> > > I'm just curious as to what the cause may be.
> > >
> > > Thanks,
> > >
> > > John
> >
> > Can't say without a callstack
> >
>
> Hope this helps...thanks.
>
>
> Time: [493026488] 6/9/2019 2:24:20 PM
> ExceptionInfo: nil
> Exception: EnxDatabaseError
> Message: Unexpected exception object raised: [EIntOverflow] Integer overflow
> [$3CA1/15521] Filesize: 21512448
> Filedate: 2013-07-16 03:31:46
> Computer: QBHSERVER3
> User: Administrator
> ThreadID: 21964
> ProcessID: 4196
> Version: 3.1202
> AWE Enabled: False
> Current Window Caption: NexusDB v3 Enterprise Manager 3.1202
> Current Window Class: TfrmMain
> --------------------------------------------------------------
> Callstack (Frames):
> [0073E440] nxdbBase.Check (Line 204, "nxdbBase.pas")
> [0112384A] nxdbBackupController.TransferSingleTable (Line 424,
> "nxdbBackupController.pas") [0112430E] nxdbBackupController.BackupTable (Line
> 585, "nxdbBackupController.pas") [01124A8B]
> nxdbBackupController.TnxBackupController.Execute (Line 718,
> "nxdbBackupController.pas") [0112332D]
> nxdbBackupController.TnxBackupController.Backup (Line 318,
> "nxdbBackupController.pas") [011374E8]
> frmLiveBackup.TfmLiveBackup.btnStartClick (Line 242, "frmLiveBackup.pas")
> [005579BF] Vcl.Controls.TControl.Click [0055BF25]
> Vcl.Controls.TWinControl.WndProc [0057A06C]
> Vcl.StdCtrls.TButtonControl.WndProc [0055C08B] Vcl.Controls.DoControlMsg
> [0055BF25] Vcl.Controls.TWinControl.WndProc [00644BC1]
> Vcl.Forms.TCustomForm.WndProc [0055B568] Vcl.Controls.TWinControl.MainWndProc
> [004DD80C] System.Classes.StdWndProc [0055C036]
> Vcl.Controls.TWinControl.DefaultHandler [0055BF25]
> Vcl.Controls.TWinControl.WndProc [0057A06C]
> Vcl.StdCtrls.TButtonControl.WndProc [004DD80C] System.Classes.StdWndProc
> ================================================== ============

On 6/10/2019 5:06 PM, Thorsten Engler [NDA] wrote:
> That's a client side callstack.
> I need the server side callstack.
>
> John Turner wrote:
>
>> On 6/10/2019 3:58 PM, Thorsten Engler [NDA] wrote:
>>> John Turner wrote:
>>>
>>>> I have a relatively small table ~900 records with somewhat large, (70
>>>> scanned pages) PDF's stored in a blob field for each record.
>>>>
>>>> On backup, suddenly I am getting an error:
>>>>
>>>> [EIntOverFlow] Integer OverFlow [$3CA1/15521]
>>>>
>>>> I can work around the problem for now.
>>>>
>>>> It is interesting to note that the table otherwise functions normally.
>>>>
>>>> I'm just curious as to what the cause may be.
>>>>
>>>> Thanks,
>>>>
>>>> John
>>>
>>> Can't say without a callstack
>>>
>>
>> Hope this helps...thanks.
>>
>>
>> Time: [493026488] 6/9/2019 2:24:20 PM
>> ExceptionInfo: nil
>> Exception: EnxDatabaseError
>> Message: Unexpected exception object raised: [EIntOverflow] Integer overflow
>> [$3CA1/15521] Filesize: 21512448
>> Filedate: 2013-07-16 03:31:46
>> Computer: QBHSERVER3
>> User: Administrator
>> ThreadID: 21964
>> ProcessID: 4196
>> Version: 3.1202
>> AWE Enabled: False
>> Current Window Caption: NexusDB v3 Enterprise Manager 3.1202
>> Current Window Class: TfrmMain
>> --------------------------------------------------------------
>> Callstack (Frames):
>> [0073E440] nxdbBase.Check (Line 204, "nxdbBase.pas")
>> [0112384A] nxdbBackupController.TransferSingleTable (Line 424,
>> "nxdbBackupController.pas") [0112430E] nxdbBackupController.BackupTable (Line
>> 585, "nxdbBackupController.pas") [01124A8B]
>> nxdbBackupController.TnxBackupController.Execute (Line 718,
>> "nxdbBackupController.pas") [0112332D]
>> nxdbBackupController.TnxBackupController.Backup (Line 318,
>> "nxdbBackupController.pas") [011374E8]
>> frmLiveBackup.TfmLiveBackup.btnStartClick (Line 242, "frmLiveBackup.pas")
>> [005579BF] Vcl.Controls.TControl.Click [0055BF25]
>> Vcl.Controls.TWinControl.WndProc [0057A06C]
>> Vcl.StdCtrls.TButtonControl.WndProc [0055C08B] Vcl.Controls.DoControlMsg
>> [0055BF25] Vcl.Controls.TWinControl.WndProc [00644BC1]
>> Vcl.Forms.TCustomForm.WndProc [0055B568] Vcl.Controls.TWinControl.MainWndProc
>> [004DD80C] System.Classes.StdWndProc [0055C036]
>> Vcl.Controls.TWinControl.DefaultHandler [0055BF25]
>> Vcl.Controls.TWinControl.WndProc [0057A06C]
>> Vcl.StdCtrls.TButtonControl.WndProc [004DD80C] System.Classes.StdWndProc
>> ================================================== ============
>

Thorsten,

I copied the file to a non-production server and backed it up to another
server without incident... So, I'm satisfied that it resolved itself.
I'll try packing the original table on the production server at a time
when there a no users involved and report back FWIW.
Thanks,

John