Dynamic SQL Error = SQL error code = -303

[newbie01.others]

Hi,

I am getting the error below when Adding a Child. The size of the EPIM FRee database is 7G = 7,086,788KB. I am not doing anything special. I am only adding a new child. Have a reach a limit of some sort? At the moment, I can still read current notes and stuff, delete etc. but can't add. I've empty the trash, run optimize and still the same problem. I thought I can delete some, empty trash and then delete but it is the same error message. I am now trying to make a copy of the current file and then delete lots to size it down and se if that helps. Hopefully it does but then that means I am hitting some kind of limits somewhere, number of notes

Any advice much appreciated. Thanks in advance.

There was an error during the execution of this program.
Click "Send" to submit the report to the developer. Please also provide any steps necessary to reproduce the problem.

Dynamic SQL Error
SQL error code = -303
arithmetic exception, numeric overflow, or string truncation.

------------------------------------------------------------------------------
Exception log with detailed tech info. Generated on 25/09/2014 2:05 p.m..
You may send it to the application vendor, helping him to understand what had happened.
Application title: [ Name of the EPIM file and the EPIM Executable = Essential PImport\EssentialPIM.exe ]
Application: EssentialPIM Portable 5.82
------------------------------------------------------------------------------
Exception class: EIBInterBaseError
Exception message: Dynamic SQL Error
SQL error code = -303
arithmetic exception, numeric overflow, or string truncation.
Exception address: 00874014
------------------------------------------------------------------------------
Main thread ID = 9664
Exception thread ID = 9664
------------------------------------------------------------------------------
Object Logs:
12839646 SetViewMode OK
12839521 SetViewMode 3
12837837 SetViewMode OK
12837649 SetViewMode 0
12823984 DBOpen

------------------------------------------------------------------------------
Active Controls:
12863873 ExceptionDialog TextMemo
12859240 NotePropDialog Panel1 NameEd
12857181 MainForm FormPan FormPan2 NotesForm TreesTC NotesVT
12855652 MainForm FormPan FormPan2 NotesForm RichEditFrame1 TabsTC RichViewEdit
12855137 AdvertForm HtmlViewer1 TPaintPanel ThtTabControl
12854903 MainForm FormPan FormPan2 NotesForm RichEditFrame1 TabsTC RichViewEdit
12837337 MainForm
12824186 PassDialog GroupBox1 PasswordEd

------------------------------------------------------------------------------
Exception stack
Stack list, generated 25/09/2014 2:05 p.m.
[0087400F] IB.IBDataBaseError (Line 420, "IB.pas" + 39) [0089804E] IBDatabase.TIBTransaction.Call (Line 1665, "IBDatabase.pas" + 11) [0087BB21] IBSQL.TIBSQL.Call (Line 2483, "IBSQL.pas" + 3) [0087BE04] IBSQL.TIBSQL.ExecQuery (Line 2556, "IBSQL.pas" + 50) [00D44166] SyncObj.TNote.StoreUserDataToSQL (Line 5310, "SyncObj.pas" + 7) [0054DB5F] Vcl.Controls.TControl.Click (Line 7340, "Vcl.Controls.pas" + 9)
------------------------------------------------------------------------------
Call stack for main thread
Stack list, generated 25/09/2014 2:05 p.m.
(000460F4) [775F70F4]
------------------------------------------------------------------------------
System : Windows 7 Professional, Version: 6.1, Build: 1DB1, "Service Pack 1"
Memory: 2993; free 1891
Display : 1920x1080 pixels, 32 bpp, 96 PPI
------------------------------------------------------------------------------

[newbie01.others]

FYI, the number of notes is 32,779. Not sure if that helps.

Workaround I did is as below:
01 - Make a copy of the epim that is not working and open this
02 - Start removing more notes, number of notes is now at 32,709
03 - I am now able to add more notes again after that
04 - Presumably, if it reach 32,779 notes it will start failing again? - Will test and see if this is the one that is causing the error

[Max]

Hello,

try re-sorting Notes (i.e. right-click on some root Note, then "Arrange by..." After this you should be able to add more Notes.

[newbie01.others]

Hi Maxim

- What you suggested does not work? I do "Arrange by ..." manually from time to time 'coz the Auto option sometimes can take awhile.

- I am able to reproduce the problem as below:

01 = On the backup that I created that is at 32,709 Notes. I add more notes until the number of notes is now at 32,767
02 = Try adding a new note, I get the error.
03 = I can however copy and paste note to get around this

So currently, this is the workaround that I am doing, copy and paste note and rename the note -

I can test this creating a new blank database and see if it is a 'real' problem or it is the file itself. I can send you the file but it is 7GB in size though. I will test again with a new EPIM file and update this post.

Thanks for your reply.

[newbie01.others]

Hi,

The magic number seems to 32,767 notes
When I reached this, I am not able to Add
The only workaround that I am doing is to Copy-and-Paste and then do a rename.
Alternatively, I have to remove as much notes as I can to get it below 32,767.
For the time being, I am just using EPIM + another FREE product.
I can't test on a PRO version unless you can give me a FREE LICENSE KEY

Anyway, I've uploaded the test EPIM file if you want to have a look at it. The EPIM file initially contains 32,767 notes, I tested adding and it gives error, then I tested copy-and-paste to get it to 34,000 BLANK Notes to prove that I can copy-and-paste but not add.

Hope it helps.

[newbie01.others]

HI,

Tried uploading the .EPIM file, but it does not seem to be working. The file is about 16M.
Compressed to 2.5MB .7z but the forum says .7z upload is not allowed
.ZIP file on the other hand says not allowed 'coz it is more than 2MB

I can email the test file if you want to.

[Max]

Yes, that would be excellent, feel free to send it. If it is 7Gb though, I guess you will need it to upload to DropBox or Google Drive and send me the link. My email is ma@essentialpim...

[Max]

Meanwhile, can you send me a screenshot of your Notes (at least of some part of it)- I need to see structure. You can send it to ma@essentialpim...

[newbie01.others]

Hi,

I've emailed the sample EPIM file to ma@essentialpim.com

Good luck.

[Max]

Thank you. I was able to add Notes successfully to your database in just released 6.0 Free, please see screenshot:

notes.png (6.07 KiB) Viewed 8283 times

[newbie01.others]

Hi Maxim,

Downloaded Version 6.0 and tested OK
Just one additional question, previously when I use new versions to open older version EPIM files, it does a conversion but this time when I open the the 5.8 file on Version 6.0 it didn't, is this 'normal'?

Thanks again for Version6.0

[Max]

Yes, there is no need to convert database between 5.82 and 6.0.