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][[email protected]] java.sql.SQLException
[jcc][Thread:pool-1-thread-2][[email protected]][[email protected]] DB2 SQLCA from server
[jcc][Thread:pool-1-thread-2][[email protected]][[email protected]] SqlCode = -104
[jcc][Thread:pool-1-thread-2][[email protected]][[email protected]] SqlErrd = { -2145779603, 0, 0, 0, -705, 0 }
[jcc][Thread:pool-1-thread-2][[email protected]][[email protected]] SqlErrmc = SELECT "NOM_EMPE","COD_USAG_WEB_E;BEGIN-OF-STATEMENT;<query_expr_body>
[jcc][Thread:pool-1-thread-2][[email protected]][[email protected]] SqlErrmcTokens = { SELECT "NOM_EMPE","COD_USAG_WEB_E, BEGIN-OF-STATEMENT, <query_expr_body> }
[jcc][Thread:pool-1-thread-2][[email protected]][[email protected]] SqlErrp = SQLNP01F
[jcc][Thread:pool-1-thread-2][[email protected]][[email protected]] SqlState = 42601
[jcc][Thread:pool-1-thread-2][[email protected]][[email protected]] SqlWarn =
[jcc][Thread:pool-1-thread-2][[email protected]] SQL state = 42601
[jcc][Thread:pool-1-thread-2][[email protected]] Error code = -104
[jcc][Thread:pool-1-thread-2][[email protected]] Tokens = SELECT "NOM_EMPE","COD_USAG_WEB_E;BEGIN-OF-STATEMENT;<query_expr_body>
[jcc][Thread:pool-1-thread-2][[email protected]] Stack trace follows
Release : 4.9
Component : CA Test Data Manager
FastDataMasker-4.9.28.0.zip fixed the issue