New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
gbak does not restore SP with plan, when -I switch used [CORE6350] #6591
Comments
Modified by: Anatoliy Schegolskiy (atanas)description: When gbak -I used, there is an error appeared, see below. And then the restore database does not contain any stored procedures. Error while parsing procedure HP_INSERT_FIOLIST's BLR. I suppose, the reason is usage of plan clause in stored procedure queries. => When gbak -I used in my DB, there is an error appears, see below. And restored database does not contain ANY stored procedures. Error while parsing procedure HP_INSERT_FIOLIST's BLR. I suppose, the reason of this error is usage of PLAN clause in stored procedure queries. Procedure HP_INSERT_FIOLIST contains code below:
The proposal is to ignore saved query plan in the stored procedure source, when command line switches -I or -M used. |
Commented by: @pavel-zotov CORE1725 ? |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: Anatoliy Schegolskiy (atanas) Pavel, |
Submitted by: Anatoliy Schegolskiy (atanas)
Duplicates CORE1725
Votes: 1
When gbak -I used in my DB, there is an error appears, see below. And restored database does not contain ANY stored procedures.
Error while parsing procedure HP_INSERT_FIOLIST's BLR.
index FIOLIST_NAME1 cannot be used in the specified plan.
there is no index FIOLIST_NAME3 for table FIOLIST.
unknown ISC error 336330835.
I suppose, the reason of this error is usage of PLAN clause in stored procedure queries. Procedure HP_INSERT_FIOLIST contains code below:
The proposal is to ignore saved query plan in the stored procedure source, when command line switches -I or -M used.
The warning message can be enough.
The text was updated successfully, but these errors were encountered: