I'm afraid I not used to EMS and it's SP editing but it would be always
better to commit transactions after editing your first SP and before making
edits on the second. Is there a Commit button for this?
Alan

-----Original Message-----
From: Bayu [mailto:bayu@...]
Sent: Saturday, 18 January 2003 10:52 PM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Help me please. Restore db, but SP not
available ( error invalid request BLR at offset 569. )


Alan,

Thanks for reply

Just trying with your suggestion but sp still not available :(


For my first rescue attention, i just see the internal of gbk files with dos
editor.
And i can "see" my SP code.

So far, i still making my SP again with info from my dos editor (the
parameter is not shown, but all of the sp code is still available )

For information,

- all data is ok
- all of triger doesn't available.

Here is the cronologies about this error

I have to SP

- SP_KALKULASI_BIAYA ( in english SP_CALCULATE_COST )
- SP_KALKULASI_1 ( SP_CALCULATE_1 )

The code in SP_Calculate_cost is to call SP_calculate_1

I open this 2 SP together...

Switch to SP_calculate_1 and add out parameter and compiled this SP ( with
EMS IB Manager tools ). Done...
Switch to SP_calculate_cost and add new parameter in the existing calls to
SP_calculate_1 ( adjust/add with new parameter )
and try to compile SP

Then errors occured with message invalid request BLR XXX

After that, i try to backup this db and still errors occured. (but gbk files
created)
And ( this is my fault ) restore to db production with this gbk ...

And the problem is occured.


End cronologies.

So far after rebuild all of my SP ( all of bussines rule is in sp ), i still
check all of db aspect ( sp code in gbk files is my first attention )

Maybe there is an chance to restore a gbk files and my SP is available again
without "hard" mode ?


regards
Bayu

> -----Original Message-----
> From: Alan McDonald [mailto:alan@...]
> Sent: Saturday, January 18, 2003 6:26 PM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Help me please. Restore db, but SP not
> available ( error invalid request BLR at offset 569. )
>
>
> can you try to restore with deactiating indexes set to true?
> Alan
>
> -----Original Message-----
> From: Bayu [mailto:bayu@...]
> Sent: Saturday, 18 January 2003 8:21 PM
> To: IB Support
> Subject: [ib-support] Help me please. Restore db, but SP not available (
> error invalid request BLR at offset 569. )
>
>
> Hi all,
>
> Please help me.
>
> I have a db which i restore from my backup files.
>
> My fault is i restore and overwrite the original db
>
> But there is error like
>
> Invalid token.
> invalid request BLR at offset 569.
> parameter mismatch for procedure SP_KALKULASI_1.
>
> And right now, i can't see all of my Stored Procedure.
>
> Please help me, how can't i restore or see my Stored Procedure again
> crying ... )
>
> My fault is i restore and overwrite the original db.
>
> Thanks and regards

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/