external executable Error in dbunload

on a database we have the problem that dbunload stops with an SQL Error during unload just before unloading the table. Another database works fine with the same parameters.

Command Line:

"%sqlany12%\bin64\dbunload" -c "dbf=database.db;uid=dba;pwd=sql" -ac "dbf=database_test.db;uid=dba;pwd=sql" -v -xx temp

Any idea? Arthur

SQL Anywhere Unload Utility Version 12.0.1.3769
Connecting and initializing
Unloading user and group definitions
Unloading table definitions
Unloading materialized view definitions
Unloading index definitions
Unloading functions
Unloading view definitions
Unloading procedures
Unloading triggers
Unloading SQL Remote definitions
Unloading MobiLink definitions
***** SQL error: External environment could not be started, 'external executable' could not be found

sa-12 external-environment dbunload

asked 08 Apr '14, 07:21

Arthur Hefti
166●8●8●16
accept rate: 0%

edited 08 Apr '14, 09:12

Graeme Perrow
9.6k●3●79●124

Does an "external" reload (i.e. one using a reload.sql file instead of a -ac) reveal more about what exact database object may cause the error?

(08 Apr '14, 07:46) Volker Barth

Thanks for the hint. The problem was "INSTALL JAVA FROM @byte_code"

(08 Apr '14, 14:17) Arthur Hefti

flat view

Be the first one to answer this question!

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

sa-12 ×438
dbunload ×51
external-environment ×24

question asked: 08 Apr '14, 07:21

question was seen: 1,640 times

last updated: 08 Apr '14, 14:17

SAP SQL Anywhere

external executable Error in dbunload

Follow this question

Related questions