BLR 623 invalid request - LRTRIM is not defined - module name or entrypoint
could not be found
-------------------------------------------------------------------------------------------------
Key: CORE-4960
URL: http://tracker.firebirdsql.org/browse/CORE-4960
Project: Firebird Core
Issue Type: Task
Components: API / Client Library, Build Issues / Porting,
Installation, Scripts, UDF
Affects Versions: 2.5.0
Environment: Windows 7 OS; FIrebird 32-bit and Firebird 64-bit
clients; IB Expert and Microsoft SSRS.
Reporter: Sen
Priority: Blocker
I am completely new to Firebird Database; I am working on a Firebird 2.5
database 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:
Invalid token.
invalid request BLR at offset 623
function LRTRIM 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 LRTRIM
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?
This database is given by my client, and am not supposed to modify anything
(such as changing LTRIM to something else). I can just use the existing objects
to develop reports.
Can you provide me a step-by-step solution to resolve this issue? I am not
able to move on without solving this issue permanently.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
