dbunload error .dbr already exists

[former_member594221]

SQL Anywhere v 17.0.8.4103

Our production DB is replicated. I am trying to work through REBUILD steps on a not-replicated copy before carrying out the steps on production. I'm stuck on the dbunload step

dbunload -c "UID=[***];PWD=[***];DBF=[myPath/myFile].db" -ar e:\[myDir]

and am receiving this error:

Connecting and initializing
Unloading user and group definitions
Unloading spatial units of measure
Unloading spatial reference systems
Unloading sequences
Unloading table definitions
Unloading text configurations
Unloading materialized view definitions
Unloading index definitions
Unloading functions
Unloading view definitions
Unloading procedures
Unloading triggers
Unloading SQL Remote definitions
Unloading MobiLink definitions
Creating new database
***** SQL error: Item '[...myFile].dbR' already exists

Please help. Thank you

[chris_keating]

Does the file myfile.dbR exist? This is an intermediate file created in some dbunload configurations which if still exists indicates that a previous attempt failed or is not completed. Since this is a test, you should be able to delete that file. If the unload fails, please post details.

[former_member186998 · Accepted solution]

FYI
This problem is explained by the next manual.

Unload utility (dbunload)

> If a failure occurs during an internal rebuild of a database using -ar, the new database and transaction log file have the .dbr and .logr file extensions, respectively. Use the following steps to apply the unprocessed.sql file and finish the reload manually:
>
> 1.Start the new database.
> 2.Apply the updated unprocessed.sql file.
> 3.Shut down the database.
> 4.Move original-name.db and original-name.log to a new directory.
> 5.Rename the original-name.dbr and original-name.logr files to original-name.db and original-name.log respectively.
> 6.Run the following command:
>
> dblog -t original-name.log original-name.db