jdistro07
jdistro07

Reputation: 165

Firebird "function FN_ROUND is not defined module name or entrypoint could not be found" when selecting a table

I am working with a very old .FDB database that runs on Firebird v2.1.5.18497 32-bits. I am currently dumping all the data of the tables to CSV files using DBeaver so I can import it to MSSQL. However there's a single table that is having this error during the export process:

SQL Error [335544343] [HY000]: invalid request BLR at offset 2; function FN_ROUND is not defined; module name or entrypoint could not be found [SQLState:HY000, ISC error code:335544343] invalid request BLR at offset 2; function FN_ROUND is not defined; module name or entrypoint could not be found [SQLState:HY000, ISC error code:335544343] invalid request BLR at offset 2; function FN_ROUND is not defined; module name or entrypoint could not be found [SQLState:HY000, ISC error code:335544343] invalid request BLR at offset 2 invalid request BLR at offset 2 function FN_ROUND is not defined; module name or entrypoint could not be found

I tried selecting that table using FlameRobin and I am getting the same error:

Engine Code : 335544343 Engine Message : invalid request BLR at offset 2 function FN_ROUND is not defined module name or entrypoint could not be found

enter image description here

Upon my inspection to the table, one of the columns seems to be using this function as shown here:

enter image description here

I am confused why this happens since the function is already at the "Functions" category on FlameRobin:

enter image description here

And I am able to view the details of this function as well:

enter image description here

I tried switching the UdfAccess from the firebird.conf between Unrestricted and Full which I referenced from here but it doesn't work. Can someone help me point out what seems to be wrong?

Upvotes: 0

Views: 458

Answers (0)

Related Questions