Siebel Tools >  Database Extract (DbXtract) task fails with error SBL-DBX-00003

Database Extract (DbXtract) task fails with error SBL-DBX-00003

CAUSE
Syntax error SBL-DBX-00003 was due to wrong value for one optional parameter added when starting the task.

In this case in the detailed log file this parameter was used when invoking the task/creating the job: 'Data File Type' (alias DataFileType) = Sql Anywhere
Documented acceptable values for DataFileType = 'DAT' or 'BCP'.

But same error can occur as well for any other parameters in case some invalid values are used for the DbXtract task.


SOLUTION

 

In order to resolve the issue, the DbXtract task was retried with correct value for that parameter:
- either from UI - define a new Job and ensure adding a valid value - i.e. DAT (default is BCP); It is generally advisable when starting extract jobs from UI to only explicitly add parameters that should have non-default values.
OR
- using srvrmgr command line utility - for instance using a command like:

srvrmgr> start task for comp DbXtract [server <ServerName>] with Client= <ClientName>, DataFileType=DAT [, other optional non-default parameters if needed]


Note: In recent versions (IP16 and later - that are using Oracle Database XE as Local Database engine instead of Sybase SQL Anywhere) - only the DAT value is supported for DataFileType parameter.