external executable Error in dbunload

ArthurHCH — Tue, 08 Apr 2014 07:21:40 GMT

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

Re: external executable Error in dbunload

VolkerBarth — Tue, 08 Apr 2014 07:46:37 GMT

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?

Re: external executable Error in dbunload

ArthurHCH — Tue, 08 Apr 2014 14:17:21 GMT

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

Question Re: external executable Error in dbunload in Technology Q&A

external executable Error in dbunload

Re: external executable Error in dbunload

Re: external executable Error in dbunload