SAP Knowledge Base Article - Preview

2212790 - dbunload error "Creating indexes SQL error :: Table not found"

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

SAP Customer Relationship Management 7.0 on SAP enhancement package 1 for SAP NetWeaver 7.0

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.