Subject | invalid request BLR 623; LTRIM not defined; entrypoint not found. |
---|---|
Author | s hj |
Post date | 2015-09-29T04:44:35Z |
I am completely new to Firebird Database; I am working on a database Firebird 2.5 that already exists; I retrieve the stored procedures and views (database objects)
from this database to develop reports in Microsoft SSRS. I use Windows 7 Operating System.
Occasionally (not always) I get the following error when I run some stored procedures or views (database objects) that use the LTRIM function:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
can't format message 13:896 - message file C:Windows\firebird.msg not found; invalid request BLR at offset 623; function LTRIM is not defined; module name or entrypoint could not be found; Error while parsing procedure XXXXXXX (stored_procedure name) ;
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(I get this both in IB Expert and SSRS)
This said I am able to access other database objects that do not use LTRIM function!!
My temporary workaround:
Sometimes I restart the machine, and am able to run these same stored procedures and views that threw this error sometime back.
At other times, I restart the machine a couple of times, and am able to access these views and stored procedures.
At some other times, I restart the machine many times, still not able to run the database objects. I get frustrated and quit for the day.
When I open the machine fresh the next morning, I am able to run these objects again !!
What could be the reason for this ? And what will be the permanent solution ?
As I said earlier, this database is given by my client, and am not supposed to modify anything (such as changing LTRIM to something else)
Any suggestion will be greatly appreciated.