28.01.2013 15:25, Alex Peshkoff wrote: >> gbak: ERROR:action cancelled by trigger (3) to preserve data integrity >> gbak: ERROR: table/procedure has non-SQL security class defined >> gbak:Exiting before completion due to errors >> >> What does the error signify? > > Probably a bug. Can it be reproduced with metadata-only backup? If yes, > can we take a look at that .gbak?
AFAIR, this is a known issue. ODS 11.2 databases cannot be restored on older FB versions because it has other conventions to name security classes (SQL$number instead of SQL$tablename, this was done to fix the old security issue with longer than 27 chars metadata names) and these new names, after being backed up successfully, are not accepted by older FB versions due to their system triggers expecting the name in the old format (SQL$tablename). I don't know about any solution other than migrating via a script. Dmitry ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
