Hello Hannes, I think this is an error which was fixed with build 30. If you are using an older build please upgrade your software and proceed the recovery again.
Kind regards, Uwe -----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 6. Januar 2004 22:58 An: [EMAIL PROTECTED] Betreff: Urgent: Errors [-8] and [-3007] after restoring database Hello! I run SAP DB 7.4.3 on a Linux machine. After restoring a database instance from a backup file I get the following errors when processing data: [-8]: Execution failed, parse again. or [-3007]: Invalid sequence of DML and DDL statements. The errors occure in any case of data processing (insert, update, delete or select) but only some - not all - tables are affected. In the original database everything worked fine. Backup and restore were done on the same machine using dbmcli with the following commands: **** Backup: **** -> dbmcli -d [MyDB] -u [MyUSER],[MyPASS] medium_put [MyMEDIA] [MyFILE] FILE DATA 0 0 YES -> dbmcli -d [MyDB] -u [MyUSER],[MyPASS] -uUTL [MyUSER],[MyPASS] -c backup_start [MyMEDIA] DAT **** Restore: **** -> dbmcli -s -R MYROOTPATH db_create [MyNEWDB] [MyUSER],[MyPASS] -> dbmcli -d [MyNEWDB] -u [MyUSER],[MyPASS] medium_put [MyMEDIA] [MyFILE] FILE DATA 0 0 NO -> dbmcli -d [MyNEWDB] -u [MyUSER],[MyPASS] -uSRV -c recover_config [MyMEDIA] -> dbmcli -d [MyNEWDB] -u [MyUSER],[MyPASS] param_addvolume 1 DATA [MyDATAFILE] F 163840 -> dbmcli -d [MyNEWDB] -u [MyUSER],[MyPASS] param_addvolume 1 LOG [MyLOGFILE] F 20480 -> dbmcli -d [MyNEWDB] -u [MyUSER],[MyPASS] param_startsession param_put RUNDIRECTORY [MyRUNDIRECTORY] param_put DIAG_HISTORY_PATH [MyDIAGHISTORYPATH] param_put LOG_SEGMENT_SIZE 0 param_checkall param_commitsession -> dbmcli -d [MyNEWDB] -u [MyUSER],[MyPASS] db_admin -> dbmcli -d [MyNEWDB] -u [MyUSER],[MyPASS] util_connect [MyUSER],[MyPASS] util_execute INIT CONFIG -> dbmcli -d [MyNEWDB] -u [MyUSER],[MyPASS] db_cold -> dbmcli -d [MyNEWDB] -u [MyUSER],[MyPASS] -uUTL -c recover_start [MyMEDIA] -> dbmcli -d [MyNEWDB] -u [MyUSER],[MyPASS] db_online -> dbmcli -d [MyNEWDB] -u [MyUSER],[MyPASS] load_systab -u [MyDBAUSER],[MyDBAPASS] -ud [MyDOMAINPASS] No errors during backup/restore. This problem is pretty urgent, so any help would be more than just welcome! Thanks in advance! Hannes -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
