Phone Lines icon GFI Support

Articles in this section

See more

Error: 'STORE RDB$PROCEDURE_PARAMETERS failed' When Upgrading the Schema of an Old Firebird Based Archive Store

Author: Luis Fernandes Updated

Overview

This article describes the issue and its resolution, which occurs when upgrading the schema of an old Firebird based Archive Store and the schema upgrade fails with the exact logging as shown below (versions, steps and error are all important here).

Note: Not all Firebird Archive Stores are affected. If an Archive Store was created with MailArchiver 6.4 build 20100702 the issue seems not to occur, but if an Archive Store was created with MailArchiver 4 build 20070616 the issue does occur. Therefore the issue occurs only with Firebird databases which were created with versions between 4 and (max.) 6.3.

2014-07-30,10.49.18,020,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Database On-disk structure (ODS) version 11.0" 2014-07-30,10.49.18,020,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Upgrading to version [74]. Number of steps to execute [40] >>" 2014-07-30,10.49.18,035,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [1] Completed" 2014-07-30,10.49.18,067,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [2] Completed" 2014-07-30,10.49.18,067,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [3] Completed" 2014-07-30,10.49.18,082,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [4] Completed" 2014-07-30,10.49.18,082,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [5] Completed" 2014-07-30,10.49.18,082,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [6] Completed" 2014-07-30,10.49.18,098,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [7] Completed" 2014-07-30,10.49.18,098,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [8] Completed" 2014-07-30,10.49.18,098,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [9] Completed" 2014-07-30,10.49.18,098,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [10] Completed" 2014-07-30,10.49.18,098,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [11] Completed" 2014-07-30,10.49.18,098,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [12] Completed" 2014-07-30,10.49.18,113,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [13] Completed" 2014-07-30,10.49.18,113,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [14] Completed" 2014-07-30,10.49.18,113,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [15] Completed" 2014-07-30,10.49.18,113,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [16] Completed" 2014-07-30,10.49.18,113,1,"#000002E8","#00000010","info ","ManagementProviders","(FB) Step [17] Completed" 2014-07-30,10.49.18,176,1,"#000002E8","#00000010","error ","ManagementProviders","Error: (FB) UpgradeSchema. Rolling back ;message: unsuccessful metadata update ;STORE RDB$PROCEDURE_PARAMETERS failed ;Feature not supported on ODS version older than 11.1 ;stack trace: at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() ; at Store.Management.FBSchemaProvider.UpgradeSchema(String connectionString, Schema schemaConfiguration, SchemaDetails schemaDetails) ;message: unsuccessful metadata update ;STORE RDB$PROCEDURE_PARAMETERS failed ;Feature not supported on ODS version older than 11.1 ;stack trace: at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector(IntPtr[] statusVector) ; at FirebirdSql.Data.Client.Native.FesStatement.Execute() ; at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) ; at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() ;"

 

Environment

GFI Archiver Build 20140616

 

Resolution

The issue is fixed in MARC2015 build 20141117. To resolve the issue, perform one of the following resolutions:

  • Upgrade to MARC2015 build 20141117 or newer.
  • Apply patch and upgrade schema (using BulkSchemaUpgrade or web page).