error on restore : invalid request BLR

[Marcel PL]

During restore of my database (22GB) i get error:

Invalid request BLR at offset 604
Input parameter mismatch for procedure SP_PPLINE_GETPRICE
unknown ISC error 336330835

FB 2.5.9

I know that last week some work was done on this stored procedure :(

Is there any way to still get this DB retored?  (if not i am so very f...)

thx

M.

[eric.gu...@gmail.com]

Hello,

You have this error because some dependents stored procedures or triggers are not recompiled after have change number of input/output parameters of  procedure SP_PPLINE_GETPRICE

You must recompile all depenencies of  procedure SP_PPLINE_GETPRICE

I don't know if can restore your backup with such error, may be you can with -N option ...

gbak:restore options are: -BU(FFERS) override page buffers default -FIX_FSS_D(ATA) fix malformed UNICODE_FSS data -FIX_FSS_M(ETADATA) fix malformed UNICODE_FSS metadata -I(NACTIVE) deactivate indexes during restore -K(ILL) restore without creating shadows -MO(DE) <access> "read_only" or "read_write" access -N(O_VALIDITY) do not restore database validity conditions -O(NE_AT_A_TIME) restore one table at a time -P(AGE_SIZE) override default page size -USE_(ALL_SPACE) do not reserve space for record versions

Eric

[i...@kaabnl.nl]

Hi Eric,

i tried this -N  option but no result. Just before creating and activating deferred indexes, restore will stop.

Any other options?

thx

M.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/b817799c-4123-4dff-95bb-a494bb03d61cn%40googlegroups.com.

Virus-free. www.avg.com

[eric.gu...@gmail.com]

Backup will stop, but data are restored ? you can read them ?

If yes, you can make a script with metadata only to update the database structure

Eric

[Dimitry Sibiryakov]

i...@kaabnl.nl wrote 06.02.2022 15:44:
> i tried this -N  option but no result. Just before creating and activating
> deferred indexes, restore will stop.
>
> Any other options?

Call the professionals: http://www.ibphoenix.com/services/repair

--
WBR, SD.

[i...@kaabnl.nl]

Hi Eric, thanks, this was the path i followed and it worked. Took 6 hours off my Sunday though :(

For people who google this same situation in the future: You also loose the triggers.

thx

M.

You received this message because you are subscribed to a topic in the Google Groups "firebird-support" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/firebird-support/S2SsT62HK3s/unsubscribe.
To unsubscribe from this group and all its topics, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/ffbd7684-7356-47f5-b5b3-e5ee79d8ec02n%40googlegroups.com.

[i...@kaabnl.nl]

Hi Dimitry,

Thanks for pointing that out, but i needed the database to be back
online at 23:00 yesterday evening.

With a few hours of manual cleaning it all got back to work.

thx

M.

This email has been checked for viruses by AVG.
https://www.avg.com