Re: [firebird-support] RECREATE Procedure issue.

I am using firebird 2.5.5 version. As my application is .net application I am using Firebirdclient.dll to interact with firebird database. Also I am executing the query inside my .net application. There are many queries in my .net application, only this 'RECREATE' query fails to execute while

[firebird-support] RECREATE Procedure issue.

Hi All, I am facing a issue with 'RECREATE' procedure. Problem: I have a stored procedure that uses '*RECREATE *Procedure', this procedure does not execute properly when executed in EMS SQL manager for IB and Firebird. Dont know why... :( every time i execute it. Procedure execution

Re: [firebird-support] RECREATE Procedure issue.

otteveel m...@lawinegevaar.nl [firebird-support] wrote: On 2016-03-17 15:49, Joje j...@codework-solutions.com [firebird-support] wrote: > Hi All, > I am facing a issue with 'RECREATE' procedure. > > Problem: > I have a stored procedure that uses 'RECREATE Procedure', this > procedure do

RE: [firebird-support] Re: Fwd: Firebird database corrupt issue. Due to I/O error

Thanks. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Sunday, February 19, 2017 1:48 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Re: Fwd: Firebird database corrupt issue. Due to I/O error ---In

[firebird-support] Block size exceeds implementation restriction exception for varchar(31000)

Hi All, I want to alter an existing stored procedure with varchar parameters having length of 31000. Whenever I try to execute this query I get an exception of "Invalid token. Invalid request BLR at offset 102. Implementation limit exceeded. Block size exceeds implementation restriction."

RE: [firebird-support] Re: Block size exceeds implementation restriction exception for varchar(31000)

Thanx Jez. I will have to modify the stored procedure. Thank you once again. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 08 September 2016 16:41 To: firebird-support@yahoogroups.com Subject: [firebird-support] Re: Block size exceeds

RE: [firebird-support] Problem in executing query using 'IN' statement.

Hi Setysvar, Thank you for helping out. But I am unable to run it on my "SQL manager" on executing query I am getting 'Invalid Token' error. Below is error that is shown Invalid token. Dynamic SQL Error. SQL error code = -104. Token unknown - line 5, column 61. ','. Also,

[firebird-support] Problem in executing query using 'IN' statement.

Hi All, I have a query in which I check whether an NAME _IDS of type varchar is in another table with NAME _ID column having data type as int. Also, ID_1 have ID's separated by comma's example '1,2,3,4,5'. Below is the query which I am trying to execute SELECT Tb2.

[firebird-support] Unable to execute large text inside stored procedures.

Hello, I have a stored procedure that takes a parameter(a1) that has length excess of 25k. Inside this stored procedure I have declared a variable with a query , when this parameter(a1) combined with variable total length exceeds 32k and FB returns as error of concatenation. Below is

RE: [firebird-support] Unable to upgrade database to firebird 3.0

Thanks it worked now I am able to connect to database. And I have upgraded to FB 3.0.1 !! Another thing did anyone faced ODS version issue. Like I got this issue of database ODS ver. 11.5 is lower than Current ODS ver 12.0. If so then how could we solve this problem ? Thank you.

[firebird-support] Unable to fine registry entry of Firebird 3.0

Hi All, I am unable to find registry entry of firebird 3.0. In previous versions it was easy to find registry entry of firebird but now I am not able to see it in registry. The reason of looking for registry entry is I want to know the path where firebird is installed. Thank you.

RE: [firebird-support] Unable to fine registry entry of Firebird 3.0

Thanks got it..! Forgot to use 'instreg.exe -I' in command line :P :P :P From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 31 October 2016 14:36 To: firebird-support@yahoogroups.com Subject: [firebird-support] Unable to fine registry entry of

[firebird-support] Unable to upgrade database to firebird 3.0

Hello All, Recently I upgraded my Firebird from 2.5 to 3.0 and I am using 'EMS SQL Manager Interbase/Firebird' to connect and work with database. Now whenever I connect existing database or register a new database I get following error Unsuccessful execution caused by system error

[firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

Hello, Today one of our customer complained that removing clients from application is taking a lot of time around 30-40mins. So I looked into their database whose DB size is around 340MB and found that our DBA has a called deletion triggers in main table. Triggers will delete all the client

RE: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

Hi All, At last found the root cause for this issue basically it was database design issue where DBA used delete triggers in one of the tables let’s say ‘TableA’ that deletes it related rows from another table ‘TableB’. Another thing is are both are transaction tables containing large number

RE: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

Hi martin, Thanks for help but firebird database is in Windows server 2008 OS. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 18 April 2017 16:54 To: firebird-support@yahoogroups.com Subject: [firebird-support] Deletion of rows from

RE: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

Hi Karol, I will look into how the delete query plan works on customer environment and will revert back. Thanks From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 18 April 2017 20:16 To: firebird-support@yahoogroups.com Subject: Odp:

RE: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

Hi Sean, I will look into it and will revert-back with additional details. Thanks. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 18 April 2017 20:13 To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] Deletion of rows from

[firebird-support] Performing bulk update taking time.

Hello everyone, Is there anyway using which we could perform bulk update in firebird. I have two tables A & B. Both tables are referenced by a varchar(100) AR_ID column. - Total number of rows in each table is around 1 million. Now in order to get faster result I created a

RE: [firebird-support] Deadlock error from firebird during midnight

Hi All, In my case there is no large data to be analysed, only a timer that checks whether it is midnight or not. If it is midnight then update a single row in database this is done using stored procedure. Confusing part is below error occurs only between midnight that is from 12 to 2

[firebird-support] Firebird database corrupt with wrong page type error on table

Hello everyone, During inserting data to a table I received an error on my application log "database file appears corrupt (DB Path) wrong page type page 232333 is of wrong type (expected 5, found 7)". On looking in FB log I got following : DEVMACHINE (Server) Thu Dec 21 16:45:23

[firebird-support] Auto-increment generating old ID's for insertion

Hello, I have issue where auto-increment of ID column is generating older ID's that is already used in table. Currently, my transaction table has around 16 million rows and ID of last inserted row is 16,594,027. While the generator ID its 16,593,965. As you can see the generator is

RE: [firebird-support] Auto-increment generating old ID's for insertion

generating old ID's for insertion On 02/04/18 13:11, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > I have issue where auto-increment of ID column is generating older > ID’s that is already used in table. > > Currently, my transaction table has around 16 million

RE: [firebird-support] Auto-increment generating old ID's for insertion

Hi Mark, Below is details of database properties Database header page information: Version: WI-V2.5.4.26856 Firebird 2.5 Flags 0 Checksum 12345

RE: [firebird-support] Firebird database executing DML queries very slowly.

Thanks, I will try this command on customer end will upload the results. From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: Friday, January 25, 2019 20:32 To: firebird-support@yahoogroups.com Subject: ODP: [firebird-support] Firebird database executing

[firebird-support] Firebird database executing DML queries very slowly.

Hello, I am facing an issue on my client end where Firebird database is very slow in executing DML queries. I ran the customer database on my machine, it was working smoothly without any lag. This same database copied on customer machine gets very slow in executing DML queries. I replaced the

[firebird-support] String conversion to timestamp fails during insertion in 12 hour format

Hello, I have a table with a column of TIMESTAMP data type. I could not insert into this column if I use CAST('1/31/2018 08:09:30 PM' AS TIMESTAMP) on execution of the query it fails. Later if I change the datetime to 24 hour format conversion is successful. CAST('1/31/2018 08:09:30 PM' AS

RE: [firebird-support] Firebird database executing DML queries very slowly.

Ran the command and got the header information from the client. Below is database header page information of the affected database : Flags 0 Checksum 12345 Generation

RE: [firebird-support] Firebird database executing DML queries very slowly.

Hi , This issue was replicated only on client end while I copied the DB on our end it was working with any slowness. I took the remote of client DB , performed validation check on DB & backup - restore operation on DB. After doing this its working normally now. Thanks for help. :)