· 9 years ago · Oct 06, 2016, 03:30 AM
105-10-2016 12:33:23 IST payments_log_rs INFO - Starting job payments_log_rs at 1475651003486
205-10-2016 12:33:23 IST payments_log_rs INFO - azkaban.webserver.url property was not set
305-10-2016 12:33:23 IST payments_log_rs INFO - job JVM args: -Dazkaban.flowid=payments_log_rs -Dazkaban.execid=644934 -Dazkaban.jobid=payments_log_rs
405-10-2016 12:33:23 IST payments_log_rs INFO - Building command job executor.
505-10-2016 12:33:23 IST payments_log_rs INFO - 1 commands to execute.
605-10-2016 12:33:23 IST payments_log_rs INFO - Command: /bin/sh /myntra/intelligence/current_repo/MyntraDW/azkaban/redshift_job_scripts/payments_log_rs.sh
705-10-2016 12:33:23 IST payments_log_rs INFO - Environment variables: {JOB_NAME=payments_log_rs, JOB_PROP_FILE=/myntra/softwares/azkaban/azkaban-execserver/build/package/executions/644934/HourlyJobs/payments_log_rs_props_504576792188100745_tmp, JOB_OUTPUT_PROP_FILE=/myntra/softwares/azkaban/azkaban-execserver/build/package/executions/644934/HourlyJobs/payments_log_rs_output_1544576919013391699_tmp}
805-10-2016 12:33:23 IST payments_log_rs INFO - Working directory: /myntra/softwares/azkaban/azkaban-execserver/build/package/executions/644934/HourlyJobs
905-10-2016 12:33:25 IST payments_log_rs INFO - 2016/10/05 12:33:25 - Kitchen - Logging is at level : Basic logging
1005-10-2016 12:33:25 IST payments_log_rs INFO - 2016/10/05 12:33:25 - Kitchen - Start of run.
1105-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - redshift_generic_load_job - Start of job execution
1205-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - redshift_generic_load_job - Starting entry [etl_activity [insert]]
1305-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - etl_activity [insert] - Loading transformation from XML file [/myntra/intelligence/etl/codebase/pentaho_jobs/common/etl_logger/loggerETLActivity_Insert.ktr]
1405-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - loggerETLActivity_Insert - Dispatching started for transformation [loggerETLActivity_Insert]
1505-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - INS ETL Activity__308.0 - Connected to database [ConfigDB] (commit=1)
1605-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - Get System Info__307.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
1705-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - Set Variables - ID__309.0 - Setting environment variables...
1805-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - Set Variables - ID__309.0 - Set variable ETL_Activity_ID to value [1263360]
1905-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - Set Variables - ID__309.0 - Set variable etl_start_time to value [2016/10/05 12:33:26.431]
2005-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - INS ETL Activity__308.0 - Finished processing (I=0, O=1, R=1, W=1, U=0, E=0)
2105-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - Set Variables - ID__309.0 - Finished after 1 rows.
2205-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - Set Variables - ID__309.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2305-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - redshift_generic_load_job - Starting entry [Check Table Existence]
2405-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - redshift_generic_load_job - Starting entry [table_delta]
2505-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - table_delta - Loading transformation from XML file [file:///myntra/intelligence/etl/codebase/redshift/pentaho_jobs/payments_log_rs/payments_log_rs_delta.ktr]
2605-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - payments_log_rs_delta - Dispatching started for transformation [payments_log_rs_delta]
2705-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - Table input 2.0 - Finished reading query, closing connection.
2805-10-2016 12:33:26 IST payments_log_rs INFO - 2016/10/05 12:33:26 - Table input 2.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2905-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - Modified Java Script Value.0 - Optimization level set to 9.
3005-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - Table input.0 - Finished reading query, closing connection.
3105-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - Table input.0 - Finished processing (I=501, O=0, R=1, W=501, U=0, E=0)
3205-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - Modified Java Script Value.0 - Finished processing (I=0, O=0, R=501, W=501, U=0, E=0)
3305-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - Text file output.0 - Finished processing (I=0, O=501, R=501, W=501, U=0, E=0)
3405-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - redshift_generic_load_job - Starting entry [put files to s3]
3505-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - Running on platform : Linux
3605-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - Executing command : /myntra/intelligence/etl/codebase/redshift/scripts/redshift_data_upload.sh payments_log_rs Daily 4 20161005
3705-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) checking the existence of file
3805-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) payments_log_rs_20161005
3905-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) /myntra/redshift/delta_files/payments_log_rs_20161005
4005-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) file exists
4105-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) Number of rows to be processed :
4205-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) 501
4305-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) Number of Split Files :
4405-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) 1
4505-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) Number of rows per File :
4605-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) 501
4705-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) splitting the file into specified number of files
4805-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) splitting the file succesfully done
4905-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) Successfully Zipped all the files
5005-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) Size of Files Before S3 Upload is :
5105-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) 0.0257711
5205-10-2016 12:33:27 IST payments_log_rs INFO - 2016/10/05 12:33:27 - put files to s3 - (stdout) Checking if there are any same day run files on S3
5305-10-2016 12:33:28 IST payments_log_rs INFO - 2016/10/05 12:33:28 - put files to s3 - (stdout) File s3://testashutosh/backups/payments_log_rs_20161005_0.gz deleted
5405-10-2016 12:33:28 IST payments_log_rs INFO - 2016/10/05 12:33:28 - put files to s3 - (stdout) File 'payments_log_rs_20161005_0.gz' stored as 's3://testashutosh/backups/payments_log_rs_20161005_0.gz' (27023 bytes in 0.0 seconds, 665.27 kB/s) [1 of 1]
5505-10-2016 12:33:28 IST payments_log_rs INFO - 2016/10/05 12:33:28 - put files to s3 - (stdout) Size of Files After S3 Upload is :
5605-10-2016 12:33:28 IST payments_log_rs INFO - 2016/10/05 12:33:28 - put files to s3 - (stdout) 0.0257711
5705-10-2016 12:33:28 IST payments_log_rs INFO - 2016/10/05 12:33:28 - put files to s3 - (stdout) $hour is empty
5805-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) File 'payments_log_rs.manifest' stored as 's3://testashutosh/backups/payments_log_rs.manifest' (106 bytes in 0.1 seconds, 1760.62 B/s) [1 of 1]
5905-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) files have been uploaded to S3 succesfully
6005-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payments_log_rs
6105-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) BEGIN;
6205-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) BEGIN
6305-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) DROP TABLE IF EXISTS merge.payments_log_rs_merge;
6405-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) DROP TABLE
6505-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) create table merge.payments_log_rs_merge as select * from bidb.payments_log_rs where 1=2;
6605-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) SELECT
6705-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) copy merge.payments_log_rs_merge
6805-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) (
6905-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) order_id,
7005-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) insert_date,
7105-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_gateway_name,
7205-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_option,
7305-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_issuer,
7405-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) is_complete,
7505-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_status,
7605-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) user_agent,
7705-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) bin_number,
7805-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) card_bank_name,
7905-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) instrument_identifier,
8005-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) last_modified_on,
8105-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) bi_last_modified_on
8205-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) )
8305-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) from 's3://testashutosh/backups/payments_log_rs.manifest'
8405-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) credentials 'aws_access_key_id=AKIAJ5HEDBVJTXTBSJNQ;aws_secret_access_key=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'
8505-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) gzip delimiter AS '\t' escape
8605-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) removequotes
8705-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) emptyasnull
8805-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) blanksasnull
8905-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) TRIMBLANKS
9005-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) TRUNCATECOLUMNS
9105-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) ACCEPTANYDATE
9205-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) ACCEPTINVCHARS AS ' '
9305-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) maxerror 150 explicit_ids
9405-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) manifest
9505-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) compupdate off statupdate off;
9605-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stderr) psql:/myntra/redshift/delta_files/load_payments_log_rs.sql:34: INFO: Load into table 'payments_log_rs_merge' completed, 501 record(s) loaded successfully.
9705-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) COPY
9805-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) update
9905-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) bidb.payments_log_rs
10005-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) set
10105-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) order_id=src.order_id,
10205-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) insert_date=src.insert_date,
10305-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_gateway_name=src.payment_gateway_name,
10405-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_option=src.payment_option,
10505-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_issuer=src.payment_issuer,
10605-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) is_complete=src.is_complete,
10705-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_status=src.payment_status,
10805-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) user_agent=src.user_agent,
10905-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) bin_number=src.bin_number,
11005-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) card_bank_name=src.card_bank_name,
11105-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) instrument_identifier=src.instrument_identifier,
11205-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) last_modified_on=src.last_modified_on,
11305-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) bi_last_modified_on=src.bi_last_modified_on
11405-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) FROM
11505-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) (
11605-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) SELECT
11705-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) order_id,
11805-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) insert_date,
11905-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_gateway_name,
12005-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_option,
12105-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_issuer,
12205-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) is_complete,
12305-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) payment_status,
12405-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) user_agent,
12505-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) bin_number,
12605-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) card_bank_name,
12705-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) instrument_identifier,
12805-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) last_modified_on,
12905-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) bi_last_modified_on
13005-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) FROM
13105-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) merge.payments_log_rs_merge
13205-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) ) src
13305-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) WHERE
13405-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) src.order_id=payments_log_rs.order_id
13505-10-2016 12:33:29 IST payments_log_rs INFO - 2016/10/05 12:33:29 - put files to s3 - (stdout) ;
13605-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stderr) psql:/myntra/redshift/delta_files/load_payments_log_rs.sql:73: ERROR: Out of memory
13705-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stderr) DETAIL:
13805-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stderr) -----------------------------------------------
13905-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stderr) error: Out of memory
14005-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stderr) code: 1004
14105-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stderr) context: alloc(67108864,35)
14205-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stderr) query: 2727484
14305-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stderr) location: alloc.cpp:818
14405-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stderr) process: query3_21 [pid=15103]
14505-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stderr) -----------------------------------------------
14605-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stderr)
14705-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - put files to s3 - (stdout) Either there is a Redshift DB connectivity issue or there might be an error in the script
14805-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Starting entry [Set variables (Fail)]
14905-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Starting entry [etl_activity [update]]
15005-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - etl_activity [update] - Loading transformation from XML file [/myntra/intelligence/etl/codebase/pentaho_jobs/common/etl_logger/loggerETLActivity_Update.ktr]
15105-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - loggerETLActivity_Update - Dispatching started for transformation [loggerETLActivity_Update]
15205-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Get System Info__311.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
15305-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Get Variables__312.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
15405-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Calculator__310.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
15505-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Abort__315.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Row nr 1 causing abort : [payments_log_rs], [Delta ETL], [ETL Failed], [2016/10/05 12:33:37.324], [redshift], [BIDB], [ 00000000000000001263360.00], [2016/10/05 12:33:26.431], [ 10.0], [ 60.0], [ 0.166666667]
15605-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Abort__315.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Aborting after having seen 1 rows.
15705-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Abort__315.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=1)
15805-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - loggerETLActivity_Update - loggerETLActivity_Update
15905-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - loggerETLActivity_Update - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected!
16005-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - loggerETLActivity_Update - loggerETLActivity_Update
16105-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - loggerETLActivity_Update - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Errors detected!
16205-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - UPD ETL Activity__313.0 - Finished processing (I=1, O=0, R=1, W=1, U=1, E=0)
16305-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Filter rows__314.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
16405-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Starting entry [Simple evaluation]
16505-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Starting entry [Abort job]
16605-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Abort job - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Some Error in Job
16705-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Finished job entry [Abort job] (result=[false])
16805-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Finished job entry [Simple evaluation] (result=[false])
16905-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Finished job entry [etl_activity [update]] (result=[false])
17005-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Finished job entry [Set variables (Fail)] (result=[false])
17105-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Finished job entry [put files to s3] (result=[false])
17205-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Finished job entry [table_delta] (result=[false])
17305-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Finished job entry [Check Table Existence] (result=[false])
17405-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Finished job entry [etl_activity [insert]] (result=[false])
17505-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - redshift_generic_load_job - Job execution finished
17605-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Kitchen - Finished!
17705-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Kitchen - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Finished with errors
17805-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Kitchen - Start=2016/10/05 12:33:25.186, Stop=2016/10/05 12:33:37.508
17905-10-2016 12:33:37 IST payments_log_rs INFO - 2016/10/05 12:33:37 - Kitchen - Processing ended after 12 seconds.
18005-10-2016 12:33:37 IST payments_log_rs INFO - Some Problem Original Transformation
18105-10-2016 12:33:37 IST payments_log_rs INFO - Process completed unsuccessfully in 14 seconds.
18205-10-2016 12:33:37 IST payments_log_rs ERROR - Job run failed!
183java.lang.RuntimeException: azkaban.jobExecutor.utils.process.ProcessFailureException
184 at azkaban.jobExecutor.ProcessJob.run(ProcessJob.java:91)
185 at azkaban.execapp.JobRunner.runJob(JobRunner.java:590)
186 at azkaban.execapp.JobRunner.run(JobRunner.java:443)
187 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
188 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
189 at java.util.concurrent.FutureTask.run(FutureTask.java:166)
190 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
191 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
192 at java.lang.Thread.run(Thread.java:701)
193Caused by: azkaban.jobExecutor.utils.process.ProcessFailureException
194 at azkaban.jobExecutor.utils.process.AzkabanProcess.run(AzkabanProcess.java:105)
195 at azkaban.jobExecutor.ProcessJob.run(ProcessJob.java:85)
196 ... 8 more
19705-10-2016 12:33:37 IST payments_log_rs ERROR - azkaban.jobExecutor.utils.process.ProcessFailureException cause: azkaban.jobExecutor.utils.process.ProcessFailureException
19805-10-2016 12:33:37 IST payments_log_rs INFO - Finishing job payments_log_rs attempt: 0 at 1475651017562 with status FAILED