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]
