TDM Issue with Order by in FDM 4.9

Article Id: 194480
Status: Published
Updated On: 06-07-2020 13:47
Products:
CA Test Data Manager (Data Finder / Grid Tools)
Issue/Introduction:

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

 

 

 

 

Environment:

Release : 4.9

Component : CA Test Data Manager

Resolution:

 

FastDataMasker-4.9.28.0.zip fixed the issue