Hello, we have this problem from time to time after a dataload. we drop the table(s) which produce the DML-Error. After a new "create Table" and another dataload you can work with this tables again.
> -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] > Gesendet am: 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]
