Further to above error, I am getting below error while disabling the constraints via pre-sql script:
2022-11-15T04:05:15,363Z [pool-5-thread-2] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |7|
2022-11-15T04:05:15,366Z [pool-5-thread-2] INFO c.d.d.m.t.MaskingMarshalling - select-value and SM table input steps generation finished for table:MSAH_PER_COV_HIST
2022-11-15T04:05:15,366Z [pool-5-thread-2] INFO c.d.d.m.t.MaskingMarshalling - SM steps generation finished for table:MSAH_PER_COV_HIST
2022-11-15T04:05:15,366Z [pool-5-thread-2] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST: User-defined steps generation finished
2022-11-15T04:05:15,367Z [pool-5-thread-2] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST: Dump-distinct and seq-id in-place steps generation finished
2022-11-15T04:05:15,367Z [pool-5-thread-2] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST: MA-algo table input/output steps generation finished
2022-11-15T04:05:15,367Z [pool-5-thread-2] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST: table-input/ output steps for MA generation finished
2022-11-15T04:05:15,370Z [pool-5-thread-2] WARN c.d.d.xmlartist.XmlArtist - Step 'SegColSelect values' is not reachable.
2022-11-15T04:05:15,371Z [pool-5-thread-2] INFO c.d.d.m.t.MaskingMarshalling - marshalling of transformation object finished for table:MSAH_PER_COV_HIST
2022-11-15T04:05:15,372Z [pool-5-thread-2] INFO c.d.d.m.t.MaskingMarshalling - Finished generating transformation steps for table:MSAH_PER_COV_HIST
2022-11-15T04:05:15,374Z [pool-5-thread-2] INFO c.d.dmsApplicator.ApplicatorUtil - [JOB_ID_8_201] Saved Job details in job history table
2022-11-15T04:05:15,382Z [pool-5-thread-2] INFO c.d.d.j.t.JobXMLGenerator - isCreateIdentityColumnFlag:: ::false
2022-11-15T04:05:15,382Z [pool-5-thread-2] INFO c.d.d.j.t.JobXMLGenerator - logFolder /var/delphix/masking/logs/JobLogs
2022-11-15T04:05:15,382Z [pool-5-thread-2] INFO c.d.d.j.t.JobXMLGenerator - inner job filePath >>>>>>>>>>>>>>>>>>>>>>>>>>> /var/delphix/masking/output/BOSSPKG/DMSApplicator/bosspkg_new/8
2022-11-15T04:05:15,386Z [pool-5-thread-2] INFO c.d.d.j.t.JobXMLGenerator - Job 8, Env BOSSPKG, Ruleset bosspkg_new: kettle xml path /var/delphix/masking/output/BOSSPKG/DMSApplicator/bosspkg_new/8
2022-11-15T04:05:15,387Z [pool-5-thread-2] WARN c.d.d.xmlartist.XmlArtist - Step 'ABORT_JOB_FOR_MA' is not reachable.
2022-11-15T04:05:15,388Z [pool-5-thread-2] INFO c.d.d.m.t.MaskingMarshalling - Transformation XML completed successfully....
2022-11-15T04:05:15,388Z [pool-5-thread-2] INFO com.dmsuite.manager.JobManager - prescript query to store in transformation generated successfully.
2022-11-15T04:05:15,394Z [pool-5-thread-2] INFO com.dmsuite.manager.JobManager - Job and collection 8
2022-11-15T04:05:15,446Z [pool-5-thread-2] INFO com.dmsuite.manager.JobManager - postscript query to store in transformation generated successfully.
2022-11-15T04:05:15,454Z [pool-5-thread-2] INFO com.dmsuite.manager.JobManager - Job and collection 8
2022-11-15T04:05:15,509Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - prescript transformation generate successfully
2022-11-15T04:05:15,509Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - postscript transformation generate successfully
2022-11-15T04:05:15,509Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - targetConnector.getInstanceNm():::oracle
2022-11-15T04:05:15,520Z [pool-5-thread-2] INFO c.d.dmsApplicator.ApplicatorUtil - In Run Command line job
2022-11-15T04:05:15,521Z [pool-5-thread-2] INFO c.d.dmsApplicator.ApplicatorUtil - OSParamenter :l
2022-11-15T04:05:15,522Z [pool-5-thread-2] INFO c.d.dmsApplicator.ApplicatorUtil - shCommand :/opt/delphix/masking/DMSApplicator/kitchen.sh /file:/var/delphix/masking/output/BOSSPKG/DMSApplicator/bosspkg_new/8/8.xml -level:Basic
2022-11-15T04:05:15,525Z [pool-5-thread-2] INFO c.d.dmsApplicator.ApplicatorUtil - JAVA Options: -Xms1024m -Xmx1024m -Xss256m -DMASKING_HOME=/opt/delphix/masking -DMASKING_DATA=/var/delphix/masking -Duser.home=/var/delphix/masking/user_home -DPENTAHO_METASTORE_FOLDER=/var/delphix/masking/DMSApplicator -Djavax.net.ssl.trustStore=/var/delphix/server/etc/.truststore -Djavax.net.ssl.keyStore=/var/delphix/server/etc/.keystore -Djavax.xml.parsers.DocumentBuilderFactory=org.apache.xerces.jaxp.DocumentBuilderFactoryImpl
2022-11-15T04:05:15,535Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 0 detected, some features will be unavailable
2022-11-15T04:05:15,536Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] Consider installing the package with apt-get or yum.
2022-11-15T04:05:15,536Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] e.g. 'sudo apt-get install libwebkitgtk-1.0-0'
2022-11-15T04:05:15,536Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] #######################################################################
2022-11-15T04:05:18,746Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] Invalid entry, ignoring '/opt/delphix/masking/DMSApplicator/launcher/../../../../../var/delphix/masking/resources/jarfiles/db2jcc_license_cisuz.jar'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:16 - General - Plugin class com.masking.MaskingTwoWayPasswordEncoder registered for plugin type 'TwoWayPasswordEncoder'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] Loading security manager
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:16 - Kitchen - Logging is at level : Basic
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:16 - Kitchen - Start of run.
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:17 - General - Plugin class com.masking.MaskingTwoWayPasswordEncoder registered for plugin type 'TwoWayPasswordEncoder'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:17 - General - Plugin class dmsuite.customFileOutput.plugin.DelphixFileOutputStepMeta registered for plugin type 'Step'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:17 - General - Plugin class dmsuite.customFileOutput.plugin.DelphixTableInsertStepMeta registered for plugin type 'Step'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:17 - General - Plugin class dmsuite.customFileOutput.plugin.DelphixTableUpdateStepMeta registered for plugin type 'Step'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:17 - General - Plugin class dmsuite.customFileInput.plugin.DelphixFileInputStepMeta registered for plugin type 'Step'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:17 - General - Plugin class dmsuite.customFileInput.plugin.DelphixTableInputStepMeta registered for plugin type 'Step'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:17 - General - Plugin class com.dmsuite.kettle.vsaminput.VSAMInputMeta registered for plugin type 'Step'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:17 - General - Plugin class com.dmsuite.kettle.vsamoutput.VSAMOutputMeta registered for plugin type 'Step'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:17 - General - Plugin class dmsuite.StaxCustomInputStep.CustomXMLInputStreamMeta registered for plugin type 'Step'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:17 - General - Plugin class com.delphix.kettle.algorithmStep.AlgorithmStepMetadata registered for plugin type 'Step'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:17 - General - Plugin class dmsuite.charStreaming.plugin.CharStreamingFileInputMeta registered for plugin type 'Step'
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - 8_201 - Start of job execution
2022-11-15T04:05:18,747Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - 8_201 - Starting entry [PRESCRIPT TRANSFORMATION]
2022-11-15T04:05:18,750Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - Loading transformation from XML file [/var/delphix/masking//output/BOSSPKG/DMSApplicator/bosspkg_new/8/KETTLE_PRESCRIPT_TRANSFORMATION_8.xml]
2022-11-15T04:05:18,750Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - Using legacy execution engine
2022-11-15T04:05:18,750Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Prescript_Transformation - Dispatching started for transformation [Prescript_Transformation]
2022-11-15T04:05:18,750Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Execute_Prescript.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : An error occurred, processing will be stopped:
2022-11-15T04:05:18,750Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Execute_Prescript.0 - Couldn't execute SQL: alter table MSAF_PER_COV disable constraint PK_MSAF_PER_COV
2022-11-15T04:05:18,750Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Execute_Prescript.0 -
2022-11-15T04:05:18,750Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Execute_Prescript.0 - ORA-02297: cannot disable constraint (BOSSPKG.PK_MSAF_PER_COV) - dependencies exist
2022-11-15T04:05:18,750Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Execute_Prescript.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Error initializing step [Execute_Prescript]
2022-11-15T04:05:18,750Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Prescript_Transformation - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Step [Execute_Prescript.0] failed to initialize!
2022-11-15T04:05:18,750Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Execute_Prescript.0 - Finished reading query, closing connection.
2022-11-15T04:05:18,750Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Unable to prepare for execution of the transformation
2022-11-15T04:05:18,751Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : org.pentaho.di.core.exception.KettleException:
2022-11-15T04:05:18,751Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - We failed to initialize at least one step. Execution can not begin!
2022-11-15T04:05:18,751Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION -
2022-11-15T04:05:18,751Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION -
2022-11-15T04:05:18,751Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1157)
2022-11-15T04:05:18,751Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.trans.Trans.execute(Trans.java:627)
2022-11-15T04:05:18,786Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1152)
2022-11-15T04:05:18,786Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.job.Job.execute(Job.java:724)
2022-11-15T04:05:18,786Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.job.Job.execute(Job.java:865)
2022-11-15T04:05:18,786Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.job.Job.execute(Job.java:546)
2022-11-15T04:05:18,786Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.job.Job.run(Job.java:436)
2022-11-15T04:05:18,786Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - 8_201 - Starting entry [ABORT_JOB_FOR_PRESCRIPT]
2022-11-15T04:05:18,786Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - ABORT_JOB_FOR_PRESCRIPT - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Job failed, because of Pre-Script execution failure.
2022-11-15T04:05:18,791Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - 8_201 - Finished job entry [ABORT_JOB_FOR_PRESCRIPT] (result=[false])
2022-11-15T04:05:18,791Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - 8_201 - Finished job entry [PRESCRIPT TRANSFORMATION] (result=[false])
2022-11-15T04:05:18,791Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - 8_201 - Job execution finished
2022-11-15T04:05:18,791Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Kitchen - Finished!
2022-11-15T04:05:18,791Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Kitchen - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Finished with errors
2022-11-15T04:05:18,791Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Kitchen - Start=2022/11/15 04:05:16.871, Stop=2022/11/15 04:05:18.763
2022-11-15T04:05:18,792Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] 2022/11/15 04:05:18 - Kitchen - Processing ended after 1 seconds.
2022-11-15T04:05:18,792Z [pool-5-thread-2] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_201] p.waitFor() is :: 1
2022-11-15T04:05:18,792Z [pool-5-thread-2] ERROR c.d.d.m.t.RunServiceImpl - Failed to run Kettle without error ::
com.dmsuite.exception.JobFailedException: Kettle returned a non zero exit value: 1
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.runKettleJob(RunServiceImpl.java:1617)
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.run(RunServiceImpl.java:1018)
at com.dmsuite.threads.JobExecutorService$JobCallable.call(JobExecutorService.java:300)
at com.dmsuite.threads.JobExecutorService$JobCallable.call(JobExecutorService.java:276)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
2022-11-15T04:05:18,796Z [pool-5-thread-2] INFO c.dmsuite.threads.TaskMonitorService - EXECUTIONS mask Task with id 201 deregistered from the monitoring
2022-11-15T04:05:18,796Z [pool-5-thread-2] INFO c.d.t.ExecutionProgressReporter - Removing execution '201' from being tracked.
2022-11-15T04:05:18,813Z [pool-5-thread-2] ERROR c.d.d.m.t.RunServiceImpl - Failed to transform 'KETTLE_MASK_XML_8_MSAH_PER_COV_HIST-c4cabc27-69e5-3d0b-b489-4752a4aa1edf_201'. There was a star log error found for the transformation
2022-11-15T04:05:18,825Z [pool-5-thread-2] ERROR c.d.d.m.t.RunServiceImpl - Failed to transform 'KETTLE_MASK_XML_8_MSAF_PER_COV-f00d27ac-b712-31f7-98be-046dd0bae7d4_201'. There was a star log error found for the transformation
2022-11-15T04:05:18,837Z [pool-5-thread-2] ERROR c.d.d.m.t.RunServiceImpl - Failed to transform 'KETTLE_MASK_XML_8_MSAG_SURNAME-df65bfe2-07da-35d7-9b35-44bd108c17ce_201'. There was a star log error found for the transformation
2022-11-15T04:05:18,866Z [pool-5-thread-2] ERROR c.dmsuite.threads.JobExecutorService - [JOB_ID_8_201] - Execution 201 for job 8 failed
com.dmsuite.exception.JobFailedException: Exception executing job 8:
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.run(RunServiceImpl.java:1170)
at com.dmsuite.threads.JobExecutorService$JobCallable.call(JobExecutorService.java:300)
at com.dmsuite.threads.JobExecutorService$JobCallable.call(JobExecutorService.java:276)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: com.dmsuite.exception.JobFailedException: Job has failed due to error in running Kettle
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.runKettleJob(RunServiceImpl.java:1635)
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.run(RunServiceImpl.java:1018)
... 8 common frames omitted
Caused by: com.dmsuite.exception.JobFailedException: Kettle returned a non zero exit value: 1
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.runKettleJob(RunServiceImpl.java:1617)
... 9 common frames omitted
2022-11-15T04:05:18,870Z [pool-5-thread-2] INFO c.d.report.core.UserReportGenerator - jobNm BOSSPKG, displayEnvName BOSSPKG : Generating pdf report for masking
2022-11-15T04:05:19,044Z [pool-5-thread-2] INFO c.d.report.core.UserReportGenerator - Masking report pdf file path: /var/delphix/masking/reports/masking_201_Tue_Nov_15_040518_UTC_2022.pdf
2022-11-15T04:05:27,155Z [http-nio-127.0.0.1-8284-exec-10] INFO c.d.common.utils.FileDownloadUtil - Downloading file /var/delphix/masking/logs/JobLogs/8_201.log
2022-11-15T04:06:03,784Z [http-nio-127.0.0.1-8284-exec-4] INFO c.dmsuite.manager.EnvironmentManager - User is admin: true
2022-11-15T04:06:03,867Z [http-nio-127.0.0.1-8284-exec-4] INFO c.dmsuite.manager.EnvironmentManager - User is admin: true
2022-11-15T04:06:06,255Z [http-nio-127.0.0.1-8284-exec-2] INFO c.d.w.inventory.InventoryController - Inside public ModelAndView view(HttpServletRequest request,HttpServletResponse response,InventoryDTO inventoryDTO)
2022-11-15T04:06:06,263Z [http-nio-127.0.0.1-8284-exec-2] INFO c.d.w.inventory.InventoryController - Connector type table
2022-11-15T04:06:06,263Z [http-nio-127.0.0.1-8284-exec-2] INFO c.d.w.inventory.InventoryController - CollectionName BOSSPKG ALL
2022-11-15T04:06:06,434Z [http-nio-127.0.0.1-8284-exec-2] INFO c.d.w.inventory.InventoryController - getInventoryRowTypes for envId 5, Table name ABD_ENTRY_AGE
2022-11-15T04:06:10,021Z [http-nio-127.0.0.1-8284-exec-8] INFO c.d.w.inventory.InventoryController - Inside public ModelAndView view(HttpServletRequest request,HttpServletResponse response,InventoryDTO inventoryDTO)
2022-11-15T04:06:10,029Z [http-nio-127.0.0.1-8284-exec-8] INFO c.d.w.inventory.InventoryController - Connector type table
2022-11-15T04:06:10,030Z [http-nio-127.0.0.1-8284-exec-8] INFO c.d.w.inventory.InventoryController - CollectionName bosspkg_new
2022-11-15T04:06:10,160Z [http-nio-127.0.0.1-8284-exec-8] INFO c.d.w.inventory.InventoryController - getInventoryRowTypes for envId 5, Table name MSAF_PER_COV
2022-11-15T04:06:33,301Z [Thread-93] INFO c.d.common.utils.MonitorJobUtil - After calculating count. Total count is :: 10875393
2022-11-15T04:06:33,301Z [Thread-93] INFO com.dmsuite.manager.MonitorManager - total rows for table MSAF_PER_COV with execution 201 is 10875393
2022-11-15T04:06:33,375Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:06:33,383Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:06:33,383Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:06:33,383Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:06:33,383Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:06:33,383Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:06:33,383Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAG_SURNAME_SEQ|
2022-11-15T04:06:33,383Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |6|
2022-11-15T04:06:33,387Z [Thread-93] INFO c.d.d.masking.steps.TableInputImpl - Env 5, Ruleset bosspkg_new, table MSAG_SURNAME: Query to source DB SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAG_SURNAME_SEQ" FROM "BOSSPKG"."MSAG_SURNAME"
2022-11-15T04:06:33,387Z [Thread-93] INFO com.dmsuite.manager.MonitorManager - XF-tableInputSQL: SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAG_SURNAME_SEQ" FROM "BOSSPKG"."MSAG_SURNAME"
2022-11-15T04:06:33,387Z [Thread-93] INFO com.dmsuite.manager.MonitorManager - fetching total rows for table MSAG_SURNAME with execution 201
2022-11-15T04:06:33,387Z [Thread-93] INFO c.d.common.utils.MonitorJobUtil - ####### connection:oracle.jdbc.driver.T4CConnection@603ce2fc sqlQuery:SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAG_SURNAME_SEQ" FROM "BOSSPKG"."MSAG_SURNAME"
2022-11-15T04:06:33,387Z [Thread-93] INFO c.d.common.utils.MonitorJobUtil - Before calculating count. Query to get count is :: SELECT COUNT(*) FROM "BOSSPKG"."MSAG_SURNAME"
2022-11-15T04:06:33,809Z [Thread-93] INFO c.d.common.utils.MonitorJobUtil - After calculating count. Total count is :: 1887425
2022-11-15T04:06:33,809Z [Thread-93] INFO com.dmsuite.manager.MonitorManager - total rows for table MSAG_SURNAME with execution 201 is 1887425
2022-11-15T04:06:33,843Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:06:33,846Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:06:33,846Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:06:33,846Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:06:33,846Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:06:33,846Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:06:33,846Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAH_DATE_FROM|
2022-11-15T04:06:33,846Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAH_SCHD_CD|
2022-11-15T04:06:33,846Z [Thread-93] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |7|
2022-11-15T04:06:33,848Z [Thread-93] INFO c.d.d.masking.steps.TableInputImpl - Env 5, Ruleset bosspkg_new, table MSAH_PER_COV_HIST: Query to source DB SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAH_DATE_FROM" , "MSAH_SCHD_CD" FROM "BOSSPKG"."MSAH_PER_COV_HIST"
2022-11-15T04:06:33,848Z [Thread-93] INFO com.dmsuite.manager.MonitorManager - XF-tableInputSQL: SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAH_DATE_FROM" , "MSAH_SCHD_CD" FROM "BOSSPKG"."MSAH_PER_COV_HIST"
2022-11-15T04:06:33,848Z [Thread-93] INFO com.dmsuite.manager.MonitorManager - fetching total rows for table MSAH_PER_COV_HIST with execution 201
2022-11-15T04:06:33,848Z [Thread-93] INFO c.d.common.utils.MonitorJobUtil - ####### connection:oracle.jdbc.driver.T4CConnection@603ce2fc sqlQuery:SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAH_DATE_FROM" , "MSAH_SCHD_CD" FROM "BOSSPKG"."MSAH_PER_COV_HIST"
2022-11-15T04:06:33,849Z [Thread-93] INFO c.d.common.utils.MonitorJobUtil - Before calculating count. Query to get count is :: SELECT COUNT(*) FROM "BOSSPKG"."MSAH_PER_COV_HIST"
2022-11-15T04:06:35,441Z [Thread-93] INFO c.d.common.utils.MonitorJobUtil - After calculating count. Total count is :: 6917565
2022-11-15T04:06:35,441Z [Thread-93] INFO com.dmsuite.manager.MonitorManager - total rows for table MSAH_PER_COV_HIST with execution 201 is 6917565
2022-11-15T04:06:35,446Z [Thread-93] INFO c.d.jobs.monitor.MonitorCountThread - Successfully updated total row count for table 'MSAF_PER_COV' in execution '201' with count '10875393'.
2022-11-15T04:06:35,448Z [Thread-93] INFO c.d.jobs.monitor.MonitorCountThread - Successfully updated total row count for table 'MSAG_SURNAME' in execution '201' with count '1887425'.
2022-11-15T04:06:35,449Z [Thread-93] INFO c.d.jobs.monitor.MonitorCountThread - Successfully updated total row count for table 'MSAH_PER_COV_HIST' in execution '201' with count '6917565'.
2022-11-15T04:06:35,449Z [Thread-93] INFO c.d.jobs.monitor.MonitorCountThread - Execution '201' in environment 'BOSSPKG': Total table count 3
Total rows in job 19680383
2022-11-15T04:09:11,748Z [http-nio-127.0.0.1-8284-exec-5] INFO c.dmsuite.manager.EnvironmentManager - User is admin: true
2022-11-15T04:09:11,839Z [http-nio-127.0.0.1-8284-exec-5] INFO c.dmsuite.manager.EnvironmentManager - User is admin: true
2022-11-15T04:09:14,387Z [http-nio-127.0.0.1-8284-exec-8] INFO c.d.m.a.p.utils.DriverSupportUtil - Successfully loaded driver support class 'class masking.driverSupport.OracleDriverSupport'
2022-11-15T04:09:14,419Z [http-nio-127.0.0.1-8284-exec-7] INFO c.d.m.a.p.utils.DriverSupportUtil - Successfully loaded driver support class 'class masking.driverSupport.OracleDriverSupport'
2022-11-15T04:09:17,716Z [http-nio-127.0.0.1-8284-exec-1] INFO c.d.common.utils.FileSystemUtil - Old Pre Script file deletion status :true
2022-11-15T04:09:36,871Z [http-nio-127.0.0.1-8284-exec-10] INFO c.d.common.utils.FileSystemUtil - Old Pre Script file deletion status :true
2022-11-15T04:09:36,872Z [http-nio-127.0.0.1-8284-exec-10] INFO c.d.common.utils.FileSystemUtil - Old Pre Script file deletion status :true
2022-11-15T04:09:39,440Z [http-nio-127.0.0.1-8284-exec-5] INFO c.dmsuite.manager.EnvironmentManager - User is admin: true
2022-11-15T04:09:39,525Z [http-nio-127.0.0.1-8284-exec-5] INFO c.dmsuite.manager.EnvironmentManager - User is admin: true
2022-11-15T04:09:41,582Z [http-nio-127.0.0.1-8284-exec-4] INFO c.d.common.utils.JobExecutionHelper - Launching JOB_ID_8 with job configuration: Job(jobId=8, generatorNm=kettle, generatorConfigNm=kettle_config, preScriptPathTx=test.sql, postScriptPathTx=test1.sql, createTm=2022-05-11 03:21:16.439, jobDescTx=, emails=, onTheFlyFlag=N, reportNm=/var/delphix/masking/reports/masking_201_Tue_Nov_15_040518_UTC_2022.pdf, isConstraintCheck=N, isTruncateCheck=N, environmentJobName=BOSSPKG, paramFileName=null, importMapplet=y, xmx=1024, xms=1024, isTriggerCheck=N, maskNoOfCopies=1, noOfStreams=1, isBulkData=0, feedbackSize=50000, commitSize=10000, isDynamicConnector=0, batchUpdate=1, mapperTaks=0, isProfilerMultipleCheck=0, indexDrop=N, failImmediately=false, transformationRowLimit=20000)
2022-11-15T04:09:41,682Z [http-nio-127.0.0.1-8284-exec-4] INFO c.dmsuite.threads.JobExecutorService - Job with execution ID: 202 submitted to thread pool
2022-11-15T04:09:41,682Z [http-nio-127.0.0.1-8284-exec-4] INFO c.d.t.ExecutionProgressReporter - Adding execution '202' to be tracked
2022-11-15T04:09:41,748Z [pool-5-thread-6] INFO c.dmsuite.threads.TaskMonitorService - EXECUTIONS mask Task with id 202 registered for the monitoring
2022-11-15T04:09:41,752Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - profilerLogPath ::/var/delphix/masking/logs/JobLogs
2022-11-15T04:09:41,752Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - logFileName ::8_202.log
2022-11-15T04:09:41,752Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - logPath::/var/delphix/masking/logs/JobLogs/8_202.log
2022-11-15T04:09:41,761Z [pool-5-thread-6] INFO c.d.d.masking.XMLGenerator - dbJob.getParamFileName() :- null
2022-11-15T04:09:41,810Z [pool-5-thread-6] INFO c.d.d.masking.XMLGenerator - finished preparing request xml object.........
2022-11-15T04:09:41,815Z [pool-5-thread-6] INFO c.d.d.masking.XMLGenerator - Generate request xml started successfully.
2022-11-15T04:09:41,823Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - Path to Job : /var/delphix/masking/output/BOSSPKG/DMSApplicator/bosspkg_new/8/
2022-11-15T04:09:41,827Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Generate Transformation XML started successfully
2022-11-15T04:09:42,078Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8 : Begin generating transformation kettle xml
2022-11-15T04:09:42,115Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAF_PER_COV : Started generating transformation steps
2022-11-15T04:09:42,115Z [Thread-94] INFO c.d.jobs.monitor.MonitorCountThread - Execution '202': Begin table count
2022-11-15T04:09:42,121Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAF_PER_COV : Finished preparing masking and provisioning columnlists
2022-11-15T04:09:42,142Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Hop generation finished for table:MSAF_PER_COV
2022-11-15T04:09:42,142Z [pool-5-thread-6] INFO c.d.d.masking.steps.SelectValues - atLeastOneColFound : true
2022-11-15T04:09:42,142Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Select value step generation finished for table:MSAF_PER_COV
2022-11-15T04:09:42,189Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:09:42,195Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:09:42,195Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:09:42,195Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:09:42,195Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:09:42,195Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:09:42,195Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |5|
2022-11-15T04:09:42,199Z [pool-5-thread-6] INFO c.d.d.masking.steps.UpdateImpl - ~~~~~~~~~~~~~~~~~~~~~~ update step :: extension ~~~~~~~~~~~~~~~~
2022-11-15T04:09:42,199Z [pool-5-thread-6] INFO c.d.d.masking.steps.SelectValues - ########## slColList = []
2022-11-15T04:09:42,199Z [pool-5-thread-6] INFO c.d.d.masking.steps.SelectValues - ########## minMaxColList = []
2022-11-15T04:09:42,221Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:09:42,221Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Output steps generation finished for table:MSAF_PER_COV
2022-11-15T04:09:42,228Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:09:42,228Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:09:42,228Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:09:42,228Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:09:42,228Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:09:42,228Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |5|
2022-11-15T04:09:42,229Z [Thread-94] INFO c.d.d.masking.steps.TableInputImpl - Env 5, Ruleset bosspkg_new, table MSAF_PER_COV: Query to source DB SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" FROM "BOSSPKG"."MSAF_PER_COV"
2022-11-15T04:09:42,229Z [Thread-94] INFO com.dmsuite.manager.MonitorManager - XF-tableInputSQL: SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" FROM "BOSSPKG"."MSAF_PER_COV"
2022-11-15T04:09:42,229Z [Thread-94] INFO com.dmsuite.manager.MonitorManager - fetching total rows for table MSAF_PER_COV with execution 202
2022-11-15T04:09:42,229Z [Thread-94] INFO c.d.common.utils.MonitorJobUtil - ####### connection:oracle.jdbc.driver.T4CConnection@4a86a892 sqlQuery:SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" FROM "BOSSPKG"."MSAF_PER_COV"
2022-11-15T04:09:42,229Z [Thread-94] INFO c.d.common.utils.MonitorJobUtil - Before calculating count. Query to get count is :: SELECT COUNT(*) FROM "BOSSPKG"."MSAF_PER_COV"
2022-11-15T04:09:42,265Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:09:42,271Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:09:42,271Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:09:42,271Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:09:42,271Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:09:42,271Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:09:42,271Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |5|
2022-11-15T04:09:42,273Z [pool-5-thread-6] INFO c.d.d.masking.steps.TableInputImpl - Env 5, Ruleset bosspkg_new, table MSAF_PER_COV: Query to source DB SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" FROM "BOSSPKG"."MSAF_PER_COV"
2022-11-15T04:09:42,273Z [pool-5-thread-6] INFO c.d.d.masking.steps.TableInputImpl - Env BOSSPKG, Connector BOSSSNAP_BOSSPKG: Query to source DB SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" FROM "BOSSPKG"."MSAF_PER_COV"
2022-11-15T04:09:42,273Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAF_PER_COV: Lookup and input steps generation finished
2022-11-15T04:09:42,273Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAF_PER_COV: Get-data-from xml and decrypt steps generation finished
2022-11-15T04:09:42,273Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - XF-generateXML - isInventoryPresent is True.
2022-11-15T04:09:42,273Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Split-field and constant steps generation finished for table:MSAF_PER_COV
2022-11-15T04:09:42,274Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Stream-lkup steps generation finished for table:MSAF_PER_COV
2022-11-15T04:09:42,316Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:09:42,323Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:09:42,323Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:09:42,323Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:09:42,323Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:09:42,323Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:09:42,323Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |5|
2022-11-15T04:09:42,326Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - select-value and SM table input steps generation finished for table:MSAF_PER_COV
2022-11-15T04:09:42,326Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - SM steps generation finished for table:MSAF_PER_COV
2022-11-15T04:09:42,326Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAF_PER_COV: User-defined steps generation finished
2022-11-15T04:09:42,327Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAF_PER_COV: Dump-distinct and seq-id in-place steps generation finished
2022-11-15T04:09:42,327Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAF_PER_COV: MA-algo table input/output steps generation finished
2022-11-15T04:09:42,327Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAF_PER_COV: table-input/ output steps for MA generation finished
2022-11-15T04:09:42,330Z [pool-5-thread-6] WARN c.d.d.xmlartist.XmlArtist - Step 'SegColSelect values' is not reachable.
2022-11-15T04:09:42,331Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - marshalling of transformation object finished for table:MSAF_PER_COV
2022-11-15T04:09:42,333Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Finished generating transformation steps for table:MSAF_PER_COV
2022-11-15T04:09:42,333Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAG_SURNAME : Started generating transformation steps
2022-11-15T04:09:42,335Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAG_SURNAME : Finished preparing masking and provisioning columnlists
2022-11-15T04:09:42,359Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Hop generation finished for table:MSAG_SURNAME
2022-11-15T04:09:42,359Z [pool-5-thread-6] INFO c.d.d.masking.steps.SelectValues - atLeastOneColFound : true
2022-11-15T04:09:42,359Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Select value step generation finished for table:MSAG_SURNAME
2022-11-15T04:09:42,399Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:09:42,406Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:09:42,406Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:09:42,406Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:09:42,406Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:09:42,406Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:09:42,406Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAG_SURNAME_SEQ|
2022-11-15T04:09:42,406Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |6|
2022-11-15T04:09:42,409Z [pool-5-thread-6] INFO c.d.d.masking.steps.UpdateImpl - ~~~~~~~~~~~~~~~~~~~~~~ update step :: extension ~~~~~~~~~~~~~~~~
2022-11-15T04:09:42,409Z [pool-5-thread-6] INFO c.d.d.masking.steps.SelectValues - ########## slColList = []
2022-11-15T04:09:42,409Z [pool-5-thread-6] INFO c.d.d.masking.steps.SelectValues - ########## minMaxColList = []
2022-11-15T04:09:42,414Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Output steps generation finished for table:MSAG_SURNAME
2022-11-15T04:09:42,463Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:09:42,467Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:09:42,467Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:09:42,467Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:09:42,467Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:09:42,467Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:09:42,467Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAG_SURNAME_SEQ|
2022-11-15T04:09:42,467Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |6|
2022-11-15T04:09:42,470Z [pool-5-thread-6] INFO c.d.d.masking.steps.TableInputImpl - Env 5, Ruleset bosspkg_new, table MSAG_SURNAME: Query to source DB SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAG_SURNAME_SEQ" FROM "BOSSPKG"."MSAG_SURNAME"
2022-11-15T04:09:42,471Z [pool-5-thread-6] INFO c.d.d.masking.steps.TableInputImpl - Env BOSSPKG, Connector BOSSSNAP_BOSSPKG: Query to source DB SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAG_SURNAME_SEQ" FROM "BOSSPKG"."MSAG_SURNAME"
2022-11-15T04:09:42,471Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAG_SURNAME: Lookup and input steps generation finished
2022-11-15T04:09:42,471Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAG_SURNAME: Get-data-from xml and decrypt steps generation finished
2022-11-15T04:09:42,471Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - XF-generateXML - isInventoryPresent is True.
2022-11-15T04:09:42,471Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Split-field and constant steps generation finished for table:MSAG_SURNAME
2022-11-15T04:09:42,471Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Stream-lkup steps generation finished for table:MSAG_SURNAME
2022-11-15T04:09:42,515Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:09:42,522Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:09:42,522Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:09:42,522Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:09:42,522Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:09:42,522Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:09:42,522Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAG_SURNAME_SEQ|
2022-11-15T04:09:42,522Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |6|
2022-11-15T04:09:42,524Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - select-value and SM table input steps generation finished for table:MSAG_SURNAME
2022-11-15T04:09:42,524Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - SM steps generation finished for table:MSAG_SURNAME
2022-11-15T04:09:42,524Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAG_SURNAME: User-defined steps generation finished
2022-11-15T04:09:42,524Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAG_SURNAME: Dump-distinct and seq-id in-place steps generation finished
2022-11-15T04:09:42,525Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAG_SURNAME: MA-algo table input/output steps generation finished
2022-11-15T04:09:42,525Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAG_SURNAME: table-input/ output steps for MA generation finished
2022-11-15T04:09:42,527Z [pool-5-thread-6] WARN c.d.d.xmlartist.XmlArtist - Step 'SegColSelect values' is not reachable.
2022-11-15T04:09:42,528Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - marshalling of transformation object finished for table:MSAG_SURNAME
2022-11-15T04:09:42,529Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Finished generating transformation steps for table:MSAG_SURNAME
2022-11-15T04:09:42,529Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST : Started generating transformation steps
2022-11-15T04:09:42,532Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST : Finished preparing masking and provisioning columnlists
2022-11-15T04:09:42,553Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Hop generation finished for table:MSAH_PER_COV_HIST
2022-11-15T04:09:42,553Z [pool-5-thread-6] INFO c.d.d.masking.steps.SelectValues - atLeastOneColFound : true
2022-11-15T04:09:42,553Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Select value step generation finished for table:MSAH_PER_COV_HIST
2022-11-15T04:09:42,594Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:09:42,599Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:09:42,600Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:09:42,600Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:09:42,600Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:09:42,600Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:09:42,600Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAH_DATE_FROM|
2022-11-15T04:09:42,600Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAH_SCHD_CD|
2022-11-15T04:09:42,600Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |7|
2022-11-15T04:09:42,602Z [pool-5-thread-6] INFO c.d.d.masking.steps.UpdateImpl - ~~~~~~~~~~~~~~~~~~~~~~ update step :: extension ~~~~~~~~~~~~~~~~
2022-11-15T04:09:42,602Z [pool-5-thread-6] INFO c.d.d.masking.steps.SelectValues - ########## slColList = []
2022-11-15T04:09:42,602Z [pool-5-thread-6] INFO c.d.d.masking.steps.SelectValues - ########## minMaxColList = []
2022-11-15T04:09:42,606Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Output steps generation finished for table:MSAH_PER_COV_HIST
2022-11-15T04:09:42,646Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:09:42,651Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:09:42,651Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:09:42,651Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:09:42,651Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:09:42,651Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:09:42,651Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAH_DATE_FROM|
2022-11-15T04:09:42,651Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAH_SCHD_CD|
2022-11-15T04:09:42,651Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |7|
2022-11-15T04:09:42,655Z [pool-5-thread-6] INFO c.d.d.masking.steps.TableInputImpl - Env 5, Ruleset bosspkg_new, table MSAH_PER_COV_HIST: Query to source DB SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAH_DATE_FROM" , "MSAH_SCHD_CD" FROM "BOSSPKG"."MSAH_PER_COV_HIST"
2022-11-15T04:09:42,655Z [pool-5-thread-6] INFO c.d.d.masking.steps.TableInputImpl - Env BOSSPKG, Connector BOSSSNAP_BOSSPKG: Query to source DB SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAH_DATE_FROM" , "MSAH_SCHD_CD" FROM "BOSSPKG"."MSAH_PER_COV_HIST"
2022-11-15T04:09:42,655Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST: Lookup and input steps generation finished
2022-11-15T04:09:42,655Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST: Get-data-from xml and decrypt steps generation finished
2022-11-15T04:09:42,655Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - XF-generateXML - isInventoryPresent is True.
2022-11-15T04:09:42,655Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Split-field and constant steps generation finished for table:MSAH_PER_COV_HIST
2022-11-15T04:09:42,655Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Stream-lkup steps generation finished for table:MSAH_PER_COV_HIST
2022-11-15T04:09:42,689Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:09:42,697Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:09:42,697Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:09:42,697Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:09:42,697Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:09:42,697Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:09:42,697Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAH_DATE_FROM|
2022-11-15T04:09:42,697Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAH_SCHD_CD|
2022-11-15T04:09:42,697Z [pool-5-thread-6] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |7|
2022-11-15T04:09:42,699Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - select-value and SM table input steps generation finished for table:MSAH_PER_COV_HIST
2022-11-15T04:09:42,699Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - SM steps generation finished for table:MSAH_PER_COV_HIST
2022-11-15T04:09:42,700Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST: User-defined steps generation finished
2022-11-15T04:09:42,700Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST: Dump-distinct and seq-id in-place steps generation finished
2022-11-15T04:09:42,702Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST: MA-algo table input/output steps generation finished
2022-11-15T04:09:42,702Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Job 8, Table MSAH_PER_COV_HIST: table-input/ output steps for MA generation finished
2022-11-15T04:09:42,707Z [pool-5-thread-6] WARN c.d.d.xmlartist.XmlArtist - Step 'SegColSelect values' is not reachable.
2022-11-15T04:09:42,709Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - marshalling of transformation object finished for table:MSAH_PER_COV_HIST
2022-11-15T04:09:42,711Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Finished generating transformation steps for table:MSAH_PER_COV_HIST
2022-11-15T04:09:42,714Z [pool-5-thread-6] INFO c.d.dmsApplicator.ApplicatorUtil - [JOB_ID_8_202] Saved Job details in job history table
2022-11-15T04:09:42,721Z [pool-5-thread-6] INFO c.d.d.j.t.JobXMLGenerator - isCreateIdentityColumnFlag:: ::false
2022-11-15T04:09:42,721Z [pool-5-thread-6] INFO c.d.d.j.t.JobXMLGenerator - logFolder /var/delphix/masking/logs/JobLogs
2022-11-15T04:09:42,721Z [pool-5-thread-6] INFO c.d.d.j.t.JobXMLGenerator - inner job filePath >>>>>>>>>>>>>>>>>>>>>>>>>>> /var/delphix/masking/output/BOSSPKG/DMSApplicator/bosspkg_new/8
2022-11-15T04:09:42,725Z [pool-5-thread-6] INFO c.d.d.j.t.JobXMLGenerator - Job 8, Env BOSSPKG, Ruleset bosspkg_new: kettle xml path /var/delphix/masking/output/BOSSPKG/DMSApplicator/bosspkg_new/8
2022-11-15T04:09:42,727Z [pool-5-thread-6] WARN c.d.d.xmlartist.XmlArtist - Step 'ABORT_JOB_FOR_MA' is not reachable.
2022-11-15T04:09:42,728Z [pool-5-thread-6] INFO c.d.d.m.t.MaskingMarshalling - Transformation XML completed successfully....
2022-11-15T04:09:42,728Z [pool-5-thread-6] INFO com.dmsuite.manager.JobManager - prescript query to store in transformation generated successfully.
2022-11-15T04:09:42,734Z [pool-5-thread-6] INFO com.dmsuite.manager.JobManager - Job and collection 8
2022-11-15T04:09:42,799Z [pool-5-thread-6] INFO com.dmsuite.manager.JobManager - postscript query to store in transformation generated successfully.
2022-11-15T04:09:42,804Z [pool-5-thread-6] INFO com.dmsuite.manager.JobManager - Job and collection 8
2022-11-15T04:09:42,861Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - prescript transformation generate successfully
2022-11-15T04:09:42,861Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - postscript transformation generate successfully
2022-11-15T04:09:42,861Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - targetConnector.getInstanceNm():::oracle
2022-11-15T04:09:42,871Z [pool-5-thread-6] INFO c.d.dmsApplicator.ApplicatorUtil - In Run Command line job
2022-11-15T04:09:42,872Z [pool-5-thread-6] INFO c.d.dmsApplicator.ApplicatorUtil - OSParamenter :l
2022-11-15T04:09:42,873Z [pool-5-thread-6] INFO c.d.dmsApplicator.ApplicatorUtil - shCommand :/opt/delphix/masking/DMSApplicator/kitchen.sh /file:/var/delphix/masking/output/BOSSPKG/DMSApplicator/bosspkg_new/8/8.xml -level:Basic
2022-11-15T04:09:42,875Z [pool-5-thread-6] INFO c.d.dmsApplicator.ApplicatorUtil - JAVA Options: -Xms1024m -Xmx1024m -Xss256m -DMASKING_HOME=/opt/delphix/masking -DMASKING_DATA=/var/delphix/masking -Duser.home=/var/delphix/masking/user_home -DPENTAHO_METASTORE_FOLDER=/var/delphix/masking/DMSApplicator -Djavax.net.ssl.trustStore=/var/delphix/server/etc/.truststore -Djavax.net.ssl.keyStore=/var/delphix/server/etc/.keystore -Djavax.xml.parsers.DocumentBuilderFactory=org.apache.xerces.jaxp.DocumentBuilderFactoryImpl
2022-11-15T04:09:42,884Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 0 detected, some features will be unavailable
2022-11-15T04:09:42,885Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] Consider installing the package with apt-get or yum.
2022-11-15T04:09:42,885Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] e.g. 'sudo apt-get install libwebkitgtk-1.0-0'
2022-11-15T04:09:42,885Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] #######################################################################
2022-11-15T04:09:46,106Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] Invalid entry, ignoring '/opt/delphix/masking/DMSApplicator/launcher/../../../../../var/delphix/masking/resources/jarfiles/db2jcc_license_cisuz.jar'
2022-11-15T04:09:46,107Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class com.masking.MaskingTwoWayPasswordEncoder registered for plugin type 'TwoWayPasswordEncoder'
2022-11-15T04:09:46,107Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] Loading security manager
2022-11-15T04:09:46,107Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - Kitchen - Logging is at level : Basic
2022-11-15T04:09:46,107Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - Kitchen - Start of run.
2022-11-15T04:09:46,107Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class com.masking.MaskingTwoWayPasswordEncoder registered for plugin type 'TwoWayPasswordEncoder'
2022-11-15T04:09:46,107Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class dmsuite.customFileOutput.plugin.DelphixFileOutputStepMeta registered for plugin type 'Step'
2022-11-15T04:09:46,108Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class dmsuite.customFileOutput.plugin.DelphixTableInsertStepMeta registered for plugin type 'Step'
2022-11-15T04:09:46,108Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class dmsuite.customFileOutput.plugin.DelphixTableUpdateStepMeta registered for plugin type 'Step'
2022-11-15T04:09:46,108Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class dmsuite.customFileInput.plugin.DelphixFileInputStepMeta registered for plugin type 'Step'
2022-11-15T04:09:46,108Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class dmsuite.customFileInput.plugin.DelphixTableInputStepMeta registered for plugin type 'Step'
2022-11-15T04:09:46,108Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class com.dmsuite.kettle.vsaminput.VSAMInputMeta registered for plugin type 'Step'
2022-11-15T04:09:46,108Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class com.dmsuite.kettle.vsamoutput.VSAMOutputMeta registered for plugin type 'Step'
2022-11-15T04:09:46,108Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class dmsuite.StaxCustomInputStep.CustomXMLInputStreamMeta registered for plugin type 'Step'
2022-11-15T04:09:46,108Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class com.delphix.kettle.algorithmStep.AlgorithmStepMetadata registered for plugin type 'Step'
2022-11-15T04:09:46,108Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:44 - General - Plugin class dmsuite.charStreaming.plugin.CharStreamingFileInputMeta registered for plugin type 'Step'
2022-11-15T04:09:46,109Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:45 - 8_202 - Start of job execution
2022-11-15T04:09:46,109Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:45 - 8_202 - Starting entry [PRESCRIPT TRANSFORMATION]
2022-11-15T04:09:46,114Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:45 - PRESCRIPT TRANSFORMATION - Loading transformation from XML file [/var/delphix/masking//output/BOSSPKG/DMSApplicator/bosspkg_new/8/KETTLE_PRESCRIPT_TRANSFORMATION_8.xml]
2022-11-15T04:09:46,114Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:45 - PRESCRIPT TRANSFORMATION - Using legacy execution engine
2022-11-15T04:09:46,115Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:45 - Prescript_Transformation - Dispatching started for transformation [Prescript_Transformation]
2022-11-15T04:09:46,115Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - Execute_Prescript.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : An error occurred, processing will be stopped:
2022-11-15T04:09:46,115Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - Execute_Prescript.0 - Couldn't execute SQL: alter table MSAF_PER_COV disable constraint PK_MSAF_PER_COV
2022-11-15T04:09:46,115Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - Execute_Prescript.0 -
2022-11-15T04:09:46,115Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - Execute_Prescript.0 - ORA-02297: cannot disable constraint (BOSSPKG.PK_MSAF_PER_COV) - dependencies exist
2022-11-15T04:09:46,115Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - Execute_Prescript.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Error initializing step [Execute_Prescript]
2022-11-15T04:09:46,115Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - Prescript_Transformation - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Step [Execute_Prescript.0] failed to initialize!
2022-11-15T04:09:46,115Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - Execute_Prescript.0 - Finished reading query, closing connection.
2022-11-15T04:09:46,115Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Unable to prepare for execution of the transformation
2022-11-15T04:09:46,115Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : org.pentaho.di.core.exception.KettleException:
2022-11-15T04:09:46,115Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION - We failed to initialize at least one step. Execution can not begin!
2022-11-15T04:09:46,116Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION -
2022-11-15T04:09:46,116Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION -
2022-11-15T04:09:46,116Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1157)
2022-11-15T04:09:46,116Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.trans.Trans.execute(Trans.java:627)
2022-11-15T04:09:46,142Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:1152)
2022-11-15T04:09:46,142Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.job.Job.execute(Job.java:724)
2022-11-15T04:09:46,143Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.job.Job.execute(Job.java:865)
2022-11-15T04:09:46,143Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.job.Job.execute(Job.java:546)
2022-11-15T04:09:46,143Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - PRESCRIPT TRANSFORMATION - at org.pentaho.di.job.Job.run(Job.java:436)
2022-11-15T04:09:46,143Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - 8_202 - Starting entry [ABORT_JOB_FOR_PRESCRIPT]
2022-11-15T04:09:46,145Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - ABORT_JOB_FOR_PRESCRIPT - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Job failed, because of Pre-Script execution failure.
2022-11-15T04:09:46,149Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - 8_202 - Finished job entry [ABORT_JOB_FOR_PRESCRIPT] (result=[false])
2022-11-15T04:09:46,149Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - 8_202 - Finished job entry [PRESCRIPT TRANSFORMATION] (result=[false])
2022-11-15T04:09:46,149Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - 8_202 - Job execution finished
2022-11-15T04:09:46,149Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - Kitchen - Finished!
2022-11-15T04:09:46,149Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - Kitchen - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Finished with errors
2022-11-15T04:09:46,150Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - Kitchen - Start=2022/11/15 04:09:44.249, Stop=2022/11/15 04:09:46.120
2022-11-15T04:09:46,150Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] 2022/11/15 04:09:46 - Kitchen - Processing ended after 1 seconds.
2022-11-15T04:09:46,150Z [pool-5-thread-6] INFO c.d.d.m.t.RunServiceImpl - [JOB_ID_8_202] p.waitFor() is :: 1
2022-11-15T04:09:46,150Z [pool-5-thread-6] ERROR c.d.d.m.t.RunServiceImpl - Failed to run Kettle without error ::
com.dmsuite.exception.JobFailedException: Kettle returned a non zero exit value: 1
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.runKettleJob(RunServiceImpl.java:1617)
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.run(RunServiceImpl.java:1018)
at com.dmsuite.threads.JobExecutorService$JobCallable.call(JobExecutorService.java:300)
at com.dmsuite.threads.JobExecutorService$JobCallable.call(JobExecutorService.java:276)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
2022-11-15T04:09:46,155Z [pool-5-thread-6] INFO c.dmsuite.threads.TaskMonitorService - EXECUTIONS mask Task with id 202 deregistered from the monitoring
2022-11-15T04:09:46,155Z [pool-5-thread-6] INFO c.d.t.ExecutionProgressReporter - Removing execution '202' from being tracked.
2022-11-15T04:09:46,175Z [pool-5-thread-6] ERROR c.d.d.m.t.RunServiceImpl - Failed to transform 'KETTLE_MASK_XML_8_MSAF_PER_COV-f00d27ac-b712-31f7-98be-046dd0bae7d4_202'. There was a star log error found for the transformation
2022-11-15T04:09:46,186Z [pool-5-thread-6] ERROR c.d.d.m.t.RunServiceImpl - Failed to transform 'KETTLE_MASK_XML_8_MSAG_SURNAME-df65bfe2-07da-35d7-9b35-44bd108c17ce_202'. There was a star log error found for the transformation
2022-11-15T04:09:46,198Z [pool-5-thread-6] ERROR c.d.d.m.t.RunServiceImpl - Failed to transform 'KETTLE_MASK_XML_8_MSAH_PER_COV_HIST-c4cabc27-69e5-3d0b-b489-4752a4aa1edf_202'. There was a star log error found for the transformation
2022-11-15T04:09:46,225Z [pool-5-thread-6] ERROR c.dmsuite.threads.JobExecutorService - [JOB_ID_8_202] - Execution 202 for job 8 failed
com.dmsuite.exception.JobFailedException: Exception executing job 8:
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.run(RunServiceImpl.java:1170)
at com.dmsuite.threads.JobExecutorService$JobCallable.call(JobExecutorService.java:300)
at com.dmsuite.threads.JobExecutorService$JobCallable.call(JobExecutorService.java:276)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: com.dmsuite.exception.JobFailedException: Job has failed due to error in running Kettle
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.runKettleJob(RunServiceImpl.java:1635)
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.run(RunServiceImpl.java:1018)
... 8 common frames omitted
Caused by: com.dmsuite.exception.JobFailedException: Kettle returned a non zero exit value: 1
at com.dmsuite.dmsApplicator.masking.transformation.RunServiceImpl.runKettleJob(RunServiceImpl.java:1617)
... 9 common frames omitted
2022-11-15T04:09:46,231Z [pool-5-thread-6] INFO c.d.report.core.UserReportGenerator - jobNm BOSSPKG, displayEnvName BOSSPKG : Generating pdf report for masking
2022-11-15T04:09:46,438Z [pool-5-thread-6] INFO c.d.report.core.UserReportGenerator - Masking report pdf file path: /var/delphix/masking/reports/masking_202_Tue_Nov_15_040946_UTC_2022.pdf
2022-11-15T04:09:56,634Z [http-nio-127.0.0.1-8284-exec-2] INFO c.d.common.utils.FileDownloadUtil - Downloading file /var/delphix/masking/logs/JobLogs/8_202.log
2022-11-15T04:10:29,317Z [Thread-94] INFO c.d.common.utils.MonitorJobUtil - After calculating count. Total count is :: 10875393
2022-11-15T04:10:29,317Z [Thread-94] INFO com.dmsuite.manager.MonitorManager - total rows for table MSAF_PER_COV with execution 202 is 10875393
2022-11-15T04:10:29,380Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:10:29,386Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:10:29,386Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:10:29,386Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:10:29,386Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:10:29,386Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:10:29,386Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAG_SURNAME_SEQ|
2022-11-15T04:10:29,386Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |6|
2022-11-15T04:10:29,389Z [Thread-94] INFO c.d.d.masking.steps.TableInputImpl - Env 5, Ruleset bosspkg_new, table MSAG_SURNAME: Query to source DB SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAG_SURNAME_SEQ" FROM "BOSSPKG"."MSAG_SURNAME"
2022-11-15T04:10:29,389Z [Thread-94] INFO com.dmsuite.manager.MonitorManager - XF-tableInputSQL: SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAG_SURNAME_SEQ" FROM "BOSSPKG"."MSAG_SURNAME"
2022-11-15T04:10:29,389Z [Thread-94] INFO com.dmsuite.manager.MonitorManager - fetching total rows for table MSAG_SURNAME with execution 202
2022-11-15T04:10:29,389Z [Thread-94] INFO c.d.common.utils.MonitorJobUtil - ####### connection:oracle.jdbc.driver.T4CConnection@4a86a892 sqlQuery:SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAG_SURNAME_SEQ" FROM "BOSSPKG"."MSAG_SURNAME"
2022-11-15T04:10:29,389Z [Thread-94] INFO c.d.common.utils.MonitorJobUtil - Before calculating count. Query to get count is :: SELECT COUNT(*) FROM "BOSSPKG"."MSAG_SURNAME"
2022-11-15T04:10:29,886Z [Thread-94] INFO c.d.common.utils.MonitorJobUtil - After calculating count. Total count is :: 1887425
2022-11-15T04:10:29,886Z [Thread-94] INFO com.dmsuite.manager.MonitorManager - total rows for table MSAG_SURNAME with execution 202 is 1887425
2022-11-15T04:10:29,931Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - ownerName: |BOSSPKG|
2022-11-15T04:10:29,935Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAA_CONTRIBNO|
2022-11-15T04:10:29,935Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_BIRTH_DATE|
2022-11-15T04:10:29,935Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_GIVENAME|
2022-11-15T04:10:29,935Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_INITIAL|
2022-11-15T04:10:29,935Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAF_RELNSHIP|
2022-11-15T04:10:29,935Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAH_DATE_FROM|
2022-11-15T04:10:29,935Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumn: |MSAH_SCHD_CD|
2022-11-15T04:10:29,936Z [Thread-94] INFO c.d.d.masking.steps.StepImpl - XF-getPrimaryColumnNames - pkColumns size: |7|
2022-11-15T04:10:29,938Z [Thread-94] INFO c.d.d.masking.steps.TableInputImpl - Env 5, Ruleset bosspkg_new, table MSAH_PER_COV_HIST: Query to source DB SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAH_DATE_FROM" , "MSAH_SCHD_CD" FROM "BOSSPKG"."MSAH_PER_COV_HIST"
2022-11-15T04:10:29,938Z [Thread-94] INFO com.dmsuite.manager.MonitorManager - XF-tableInputSQL: SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAH_DATE_FROM" , "MSAH_SCHD_CD" FROM "BOSSPKG"."MSAH_PER_COV_HIST"
2022-11-15T04:10:29,938Z [Thread-94] INFO com.dmsuite.manager.MonitorManager - fetching total rows for table MSAH_PER_COV_HIST with execution 202
2022-11-15T04:10:29,938Z [Thread-94] INFO c.d.common.utils.MonitorJobUtil - ####### connection:oracle.jdbc.driver.T4CConnection@4a86a892 sqlQuery:SELECT ROWID, "MSAF_GIVENAME" , "MSAA_CONTRIBNO" , "MSAF_BIRTH_DATE" , "MSAF_INITIAL" , "MSAF_RELNSHIP" , "MSAH_DATE_FROM" , "MSAH_SCHD_CD" FROM "BOSSPKG"."MSAH_PER_COV_HIST"
2022-11-15T04:10:29,938Z [Thread-94] INFO c.d.common.utils.MonitorJobUtil - Before calculating count. Query to get count is :: SELECT COUNT(*) FROM "BOSSPKG"."MSAH_PER_COV_HIST"
2022-11-15T04:10:31,724Z [Thread-94] INFO c.d.common.utils.MonitorJobUtil - After calculating count. Total count is :: 6917565
2022-11-15T04:10:31,724Z [Thread-94] INFO com.dmsuite.manager.MonitorManager - total rows for table MSAH_PER_COV_HIST with execution 202 is 6917565
2022-11-15T04:10:31,729Z [Thread-94] INFO c.d.jobs.monitor.MonitorCountThread - Successfully updated total row count for table 'MSAF_PER_COV' in execution '202' with count '10875393'.
2022-11-15T04:10:31,731Z [Thread-94] INFO c.d.jobs.monitor.MonitorCountThread - Successfully updated total row count for table 'MSAG_SURNAME' in execution '202' with count '1887425'.
2022-11-15T04:10:31,733Z [Thread-94] INFO c.d.jobs.monitor.MonitorCountThread - Successfully updated total row count for table 'MSAH_PER_COV_HIST' in execution '202' with count '6917565'.
2022-11-15T04:10:31,733Z [Thread-94] INFO c.d.jobs.monitor.MonitorCountThread - Execution '202' in environment 'BOSSPKG': Total table count 3
Total rows in job 19680383
2022-11-15T04:23:24,104Z [http-nio-127.0.0.1-8284-exec-8] INFO c.d.w.s.ProfilerSettingsController - in ProfilerController
2022-11-15T04:23:38,122Z [http-nio-127.0.0.1-8284-exec-2] INFO c.d.common.utils.FileDownloadUtil - Downloading file /var/delphix/masking/logs/JobLogs/8_202.log
------------------------------
Raman Gulati
Data Masking Specialist
Bupa Australia Pty Ltd.
------------------------------
Original Message:
Sent: 11-10-2022 06:53:54 PM
From: Raman Gulati
Subject: Unable to disable constraints-Oracle
Hi Experts,
I am trying to mask a column (containing first name) but having primary key and Parent-child relationship with other 2 tables & Delphix couldn't able to disable the constraint, here is the error:
Seems some drive for Oracle is not supported and not allowing disabling constraint.
so do we've resolution to this or any other option apart from running the pre & post SQL script to disable & enable the constraint & will it work in this case where parent-child relationship is there.
Looking forward to expert advice & happy to share more details, if required.
Regards,
Raman
------------------------------
Raman Gulati
Data Masking Specialist
Bupa Australia Pty Ltd.
------------------------------