Topic Jobs that worked previously do not initiate
2018-01-03 04:40
Jobs that worked previously do not initiate
I had 3 different jobs saved that all ran profiling successfully. Then we I tried to execute the job again, it just stops and hangs. I tried it with other jobs and now this issue happens on each one of them. What should I check?
2018-01-03 07:10
You should start with checking the datacleaner.log file, which (on a typical windows install) is located in the .datacleaner\log folder inside your user home folder.
2018-01-03 17:07
Thanks for the response and I checked the log file but could not decipher what the error is that would affect all jobs. Below is a copy of the text in the log file.
INFO 11:51:54.754 [SwingWorker-pool-3-thread-3] SourceTableRowProcessingPublisher - No primary keys defined for table Merz_Stage_Party_10-15-17-Combined minus warning.txt, not pre-selecting primary keys
INFO 11:51:54.754 [SwingWorker-pool-3-thread-3] RowProcessingPublishers - Registered 1 publishers: [SourceTableRowProcessingPublisher[stream=Merz_Stage_Party_10-15-17-Combined minus warning.txt, consumers=6]]
INFO 11:51:54.832 [SwingWorker-pool-3-thread-3] AnalysisRunnerJobDelegate - Created 1 row processor publisher(s)
INFO 11:51:54.832 [analyzerbeans-pool1-thread-14] InjectionManagerImpl - Creating RowAnnotationFactory for job: ImmutableAnalysisJob[sourceColumns=26,filterJobs=0,transformerJobs=0,analyzerJobs=6]
INFO 11:51:54.832 [analyzerbeans-pool1-thread-20] ResultWindow - rowProcessingBegin: Merz_PROD_SAP_Stage_10-15-2017
INFO 11:51:54.896 [analyzerbeans-pool1-thread-20] CsvDataContext - Found 10574 lines breaks in 5242880 bytes
INFO 11:51:54.896 [analyzerbeans-pool1-thread-20] InfoLoggingAnalysisListener - Processing of 'Merz_Stage_Party_10-15-17-Combined minus warning.txt' start
INFO 11:51:58.384 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.415 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.478 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.509 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.540 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.571 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.618 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.634 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.589 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.605 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.667 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.683 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.683 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.698 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.698 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.714 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.714 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.730 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.730 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.745 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.823 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.886 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:52:00.042 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
WARN 11:52:14.256 [AWT-EventQueue-0] ErrorAwareAnalysisListener - errorUnknown(ImmutableAnalysisJob[sourceColumns=26,filterJobs=0,transformerJobs=0,analyzerJobs=6],org.datacleaner.job.runner.AnalysisJobCancellation)
INFO 11:52:16.176 [AWT-EventQueue-0] UserPreferencesImpl - Saving user preferences to /Users/bblomgren/.datacleaner/5.1.5/userpreferences.dat
INFO 11:51:54.754 [SwingWorker-pool-3-thread-3] SourceTableRowProcessingPublisher - No primary keys defined for table Merz_Stage_Party_10-15-17-Combined minus warning.txt, not pre-selecting primary keys
INFO 11:51:54.754 [SwingWorker-pool-3-thread-3] RowProcessingPublishers - Registered 1 publishers: [SourceTableRowProcessingPublisher[stream=Merz_Stage_Party_10-15-17-Combined minus warning.txt, consumers=6]]
INFO 11:51:54.832 [SwingWorker-pool-3-thread-3] AnalysisRunnerJobDelegate - Created 1 row processor publisher(s)
INFO 11:51:54.832 [analyzerbeans-pool1-thread-14] InjectionManagerImpl - Creating RowAnnotationFactory for job: ImmutableAnalysisJob[sourceColumns=26,filterJobs=0,transformerJobs=0,analyzerJobs=6]
INFO 11:51:54.832 [analyzerbeans-pool1-thread-20] ResultWindow - rowProcessingBegin: Merz_PROD_SAP_Stage_10-15-2017
INFO 11:51:54.896 [analyzerbeans-pool1-thread-20] CsvDataContext - Found 10574 lines breaks in 5242880 bytes
INFO 11:51:54.896 [analyzerbeans-pool1-thread-20] InfoLoggingAnalysisListener - Processing of 'Merz_Stage_Party_10-15-17-Combined minus warning.txt' start
INFO 11:51:58.384 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.415 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.478 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.509 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.540 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.571 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.618 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:58.634 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.589 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.605 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.667 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.683 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.683 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.698 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.698 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.714 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.714 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.730 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.730 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.745 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.823 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:51:59.886 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 11:52:00.042 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
WARN 11:52:14.256 [AWT-EventQueue-0] ErrorAwareAnalysisListener - errorUnknown(ImmutableAnalysisJob[sourceColumns=26,filterJobs=0,transformerJobs=0,analyzerJobs=6],org.datacleaner.job.runner.AnalysisJobCancellation)
INFO 11:52:16.176 [AWT-EventQueue-0] UserPreferencesImpl - Saving user preferences to /Users/bblomgren/.datacleaner/5.1.5/userpreferences.dat
2018-01-03 17:12
Actually, when I ran the other jobs first, they worked. However, something with one specific job creates an issue that seems to be nonrecoverable.
INFO 12:09:43.678 [SwingWorker-pool-3-thread-3] RowProcessingPublishers - Registered 1 publishers: [SourceTableRowProcessingPublisher[stream=Merz_Stage_Party_10-15-17-Combined minus warning.txt, consumers=6]]
INFO 12:09:43.678 [SwingWorker-pool-3-thread-3] AnalysisRunnerJobDelegate - Created 1 row processor publisher(s)
INFO 12:09:43.678 [analyzerbeans-pool1-thread-3] InjectionManagerImpl - Creating RowAnnotationFactory for job: ImmutableAnalysisJob[sourceColumns=26,filterJobs=0,transformerJobs=0,analyzerJobs=6]
INFO 12:09:43.678 [analyzerbeans-pool1-thread-3] ResultWindow - rowProcessingBegin: Merz_PROD_SAP_Stage_10-15-2017
INFO 12:09:43.725 [analyzerbeans-pool1-thread-3] CsvDataContext - Found 10574 lines breaks in 5242880 bytes
INFO 12:09:43.725 [analyzerbeans-pool1-thread-3] InfoLoggingAnalysisListener - Processing of 'Merz_Stage_Party_10-15-17-Combined minus warning.txt' start
WARN 12:10:11.331 [AWT-EventQueue-0] ErrorAwareAnalysisListener - errorUnknown(ImmutableAnalysisJob[sourceColumns=26,filterJobs=0,transformerJobs=0,analyzerJobs=6],org.datacleaner.job.runner.AnalysisJobCancellation)
INFO 12:10:11.346 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 12:10:11.362 [AWT-EventQueue-0] UserPreferencesImpl - Saving user preferences to /Users/bblomgren/.datacleaner/5.1.5/userpreferences.dat
INFO 12:10:16.806 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 12:10:16.838 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 12:10:21.510 [AWT-EventQueue-0] UserPreferencesImpl - Saving user preferences to /Users/bblomgren/.datacleaner/5.1.5/userpreferences.dat
INFO 12:10:21.510 [AWT-EventQueue-0] MultiThreadedTaskRunner - shutdown() called, shutting down executor service
INFO 12:10:21.510 [AWT-EventQueue-0] DCExitActionListener - Scheduling shutdown thread
INFO 12:10:21.525 [AWT-EventQueue-0] UserPreferencesImpl - Saving user preferences to /Users/bblomgren/.datacleaner/5.1.5/userpreferences.dat
INFO 12:09:43.678 [SwingWorker-pool-3-thread-3] RowProcessingPublishers - Registered 1 publishers: [SourceTableRowProcessingPublisher[stream=Merz_Stage_Party_10-15-17-Combined minus warning.txt, consumers=6]]
INFO 12:09:43.678 [SwingWorker-pool-3-thread-3] AnalysisRunnerJobDelegate - Created 1 row processor publisher(s)
INFO 12:09:43.678 [analyzerbeans-pool1-thread-3] InjectionManagerImpl - Creating RowAnnotationFactory for job: ImmutableAnalysisJob[sourceColumns=26,filterJobs=0,transformerJobs=0,analyzerJobs=6]
INFO 12:09:43.678 [analyzerbeans-pool1-thread-3] ResultWindow - rowProcessingBegin: Merz_PROD_SAP_Stage_10-15-2017
INFO 12:09:43.725 [analyzerbeans-pool1-thread-3] CsvDataContext - Found 10574 lines breaks in 5242880 bytes
INFO 12:09:43.725 [analyzerbeans-pool1-thread-3] InfoLoggingAnalysisListener - Processing of 'Merz_Stage_Party_10-15-17-Combined minus warning.txt' start
WARN 12:10:11.331 [AWT-EventQueue-0] ErrorAwareAnalysisListener - errorUnknown(ImmutableAnalysisJob[sourceColumns=26,filterJobs=0,transformerJobs=0,analyzerJobs=6],org.datacleaner.job.runner.AnalysisJobCancellation)
INFO 12:10:11.346 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 12:10:11.362 [AWT-EventQueue-0] UserPreferencesImpl - Saving user preferences to /Users/bblomgren/.datacleaner/5.1.5/userpreferences.dat
INFO 12:10:16.806 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 12:10:16.838 [AWT-EventQueue-0] InjectionManagerImpl - Creating RowAnnotationFactory for job: null
INFO 12:10:21.510 [AWT-EventQueue-0] UserPreferencesImpl - Saving user preferences to /Users/bblomgren/.datacleaner/5.1.5/userpreferences.dat
INFO 12:10:21.510 [AWT-EventQueue-0] MultiThreadedTaskRunner - shutdown() called, shutting down executor service
INFO 12:10:21.510 [AWT-EventQueue-0] DCExitActionListener - Scheduling shutdown thread
INFO 12:10:21.525 [AWT-EventQueue-0] UserPreferencesImpl - Saving user preferences to /Users/bblomgren/.datacleaner/5.1.5/userpreferences.dat