In the options file for FDM the following values are set as …
AUDIT=ROW0
AUDITDIR=X:\xxxxxxxxxxx\xxxxxxxxxxxxxx\xxxxxxxxxxxx
AUDITFILE=XXXXXXXXXXXXXXXXXXXXX.csv
BACKUPDIR= X:\xxxxxxxxxxx\xxxxxxxxxxxxxx\xxxxxxxxxxxx
BATCHSIZE=10000
CHUNKSIZE=0
COMMIT=10000
DB2BATCHUPDATE=Y
DROPRESTART=N
EMPTYASNULL=Y
ERRORDIR= X:\xxxxxxxxxxx\xxxxxxxxxxxxxx\xxxxxxxxxxxx
FETCHSIZE=5000
FORMATENCRYPTEXTENDEDCHARS=N
LARGETABLESPLITENABLED=Y
LARGETABLESPLITSIZE=20000
LOGDIR= X:\xxxxxxxxxxx\xxxxxxxxxxxxxx\xxxxxxxxxxxx
ORDERBY=N
PARALLEL=2
RESETRESTART=N
RESTART=N
TRIMVALUES=Y
The values come from the portal configuration file option.
For « ORDERBY », the Portal default value is « Y », but we set it to « N »
When we execute FDM with this option file, we get the following error in RED.
2020-06-01 13:09:47.821 exit value = 1
2020-06-01 13:09:47.821 exit value = 1 à Equals « PARALLEL=2 » in the option file.
To get the real error we re-execute FDM with the DB2 java tracing set to on. The following is the error we get in the trace file.
[jcc] BEGIN TRACE_DIAGNOSTICS
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6] java.sql.SQLException
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6][Sqlca@71b56782] DB2 SQLCA from server
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6][Sqlca@71b56782] SqlCode = -104
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6][Sqlca@71b56782] SqlErrd = { -2145779603, 0, 0, 0, -705, 0 }
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6][Sqlca@71b56782] SqlErrmc = SELECT "NOM_EMPE","COD_USAG_WEB_E;BEGIN-OF-STATEMENT;<query_expr_body>
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6][Sqlca@71b56782] SqlErrmcTokens = { SELECT "NOM_EMPE","COD_USAG_WEB_E, BEGIN-OF-STATEMENT, <query_expr_body> }
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6][Sqlca@71b56782] SqlErrp = SQLNP01F
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6][Sqlca@71b56782] SqlState = 42601
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6][Sqlca@71b56782] SqlWarn =
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6] SQL state = 42601
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6] Error code = -104
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6] Tokens = SELECT "NOM_EMPE","COD_USAG_WEB_E;BEGIN-OF-STATEMENT;<query_expr_body>
[jcc][Thread:pool-1-thread-2][SQLException@674efbf6] Stack trace follows
Release : 4.9
Component : FDM
Product defect.
Open a support case and ask for patch FastDataMasker-4.9.28.0.zip or later of FDM 4.9.