Symptom
- dbunload is not working properly with "-ar" option. (e.g. dbunload -c "DBF=C:\TEST\test.db;UID=dba;PWD=sql" -ar )
- You can see the following error message on command line
....
Creating indexes
***** SQL error: Table 'table_name' not found
You already deleted the table and You can not find out the name of table in system table (SYSTAB, SYSIDX).
- You can see the following type of files on ".db" file directory because unload job did not finish properly.
e.g. db_name.dbR, db_name.logR
Read more...
Environment
- SQL Anywhere 12,SAP SQL Anywhere 16, SAP SQL Anywhere 17
- SUP 2.1 ,SUP 2.2, SUP 2.3 (SMP 2.3)
In case, you are trying to unload and reload your "default.db".
Product
Keywords
unload, SA12, SA16, SA17, unload fail, Creating New Database, , KBA , MOB-SUP-RT , SUP Runtime , BC-SYB-SQA-ADM , SQL Anywhere - Admin tools , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.