[Solved] Runtime error in UNO af file 257

Java, C++, C#, Delphi, ??? - Using the UNO bridges

[Solved] Runtime error in UNO af file 257

Postby alan_m6 » Fri Dec 18, 2020 11:38 am

hi All,
I have a piece of code that is used to analyse text files produced from an oracle database. the files have exactly the same format and layout.

whilst using MS excel i can load thousands of files however i hit a limit of 257 files when using calc.
the reported error is as follows

ERROR: com.sun.star.uno.RuntimeException:

Does anyone have any idea what this error indicates?

regards

Alan
Last edited by Hagar Delest on Wed Dec 23, 2020 5:43 pm, edited 3 times in total.
Reason: tagged solved.
Alan
openoffice 4.1.8 on windows
alan_m6
 
Posts: 5
Joined: Fri Dec 18, 2020 11:32 am

Re: runtime error in calc

Postby RoryOF » Fri Dec 18, 2020 11:44 am

There are "magic numbers" in computing, all powers of 2. One of these is 256, so an error at 257 suggests you have hit an inbuilt limit to the number of files.
Apache OpenOffice 4.1.9 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32395
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: runtime error in calc

Postby alan_m6 » Fri Dec 18, 2020 11:54 am

RoryOF wrote:There are "magic numbers" in computing, all powers of 2. One of these is 256, so an error at 257 suggests you have hit an inbuilt limit to the number of files.


Thanks for the reply. I hope that this is not the case. if so it seems to limit the functionality of calc severely.

regards

Alan
Alan
openoffice 4.1.8 on windows
alan_m6
 
Posts: 5
Joined: Fri Dec 18, 2020 11:32 am

Re: Runtime error in Calc

Postby John_Ha » Fri Dec 18, 2020 12:04 pm

You may find LibreOffice has a higher limit.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 8323
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Runtime error in Calc

Postby Hagar Delest » Fri Dec 18, 2020 12:05 pm

You may be limited by the max number of sheets that is 256 in AOO IIRC.
In LibreOffice, it's 10000.
LibreOffice 7.1.2.2 / Xubuntu 21.04 and LibreOffice 7.0.5 portable on Windows 10
User avatar
Hagar Delest
Moderator
 
Posts: 29648
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Runtime error in Calc

Postby alan_m6 » Fri Dec 18, 2020 12:20 pm

Hagar Delest wrote:You may be limited by the max number of sheets that is 256 in AOO IIRC.
In LibreOffice, it's 10000.



ok, possibly that is the issue. Excel has more or less unlimited sheets.

ok then its a sad day for the venture away from MS office.

thanks for the help.
Alan
openoffice 4.1.8 on windows
alan_m6
 
Posts: 5
Joined: Fri Dec 18, 2020 11:32 am

Re: Runtime error in Calc

Postby RoryOF » Fri Dec 18, 2020 12:47 pm

It may be that a spreadsheet is not the optimum tool to do your task. It might perhaps be better handled using customised reports from the originating database.
Apache OpenOffice 4.1.9 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32395
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Runtime error in Calc

Postby alan_m6 » Fri Dec 18, 2020 1:00 pm

RoryOF wrote:It may be that a spreadsheet is not the optimum tool to do your task. It might perhaps be better handled using customised reports from the originating database.


Oracle has 2 types of reporting tools, a free option or a high cost option which also requires a high cost version of the database. we talk in terms off £30k per core license for the database and then £11k per core option to report. the numbers dont add up.

looks like its excel for now then

thanks for the replies.
Alan
openoffice 4.1.8 on windows
alan_m6
 
Posts: 5
Joined: Fri Dec 18, 2020 11:32 am

Re: Runtime error in UNO af file 257

Postby Hagar Delest » Sat Dec 19, 2020 11:22 am

Have you tried LO?
Don't you know what does your code exactly? To check if it's a number of sheets issue or something else?
LibreOffice 7.1.2.2 / Xubuntu 21.04 and LibreOffice 7.0.5 portable on Windows 10
User avatar
Hagar Delest
Moderator
 
Posts: 29648
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Runtime error in UNO af file 257

Postby alan_m6 » Wed Dec 23, 2020 4:51 pm

OK have installed LO and that works a treat, so it's bye bye OpenOffice

Regards

Alan
Alan
openoffice 4.1.8 on windows
alan_m6
 
Posts: 5
Joined: Fri Dec 18, 2020 11:32 am


Return to External Programs

Who is online

Users browsing this forum: No registered users and 2 guests