YJP Keyword report is not generating after running the campaign report script.

Steps:

1.Run ./campaign-report.sh -a 192 -d 3

2.Observe the logs

[12:12:55] TSAIndia_Varshini.Padmanabhan: 2016-07-21 06:33:14 [pool-2-thread-3] INFO - Running query: select k.accountId,k.campaignId,k.campaignName,k.adGroupId,k.adGroupName,k.criterionUse,k.criterionId,k.criterionType,k.text,k.keywordMatchType,k.us erStatus,k.approvalStatus,k.disapprovalReasonCodes,p.qualityScore,p.firstPageBidEstimate,p.topOfPageBidEstimate,k.date from YJKeywordReport k left join YJKwPerformanceReports p on p.keywordId=k.criterionId wh ere k.date = ? and k.server = ? and ( criterionUse = 'NEGATIVE' || approvalStatus NOT IN ('APPROVED') ) and accountId in (586827) order by approvalStatus desc
2016-07-21 06:33:31 [main] INFO - ------------YJCampaignReportGenerator done
2016-07-21 06:33:33 [pool-1-thread-1] INFO - ------------YJCampaignReportGenerator done
[12:13:12] TSAIndia_Varshini.Padmanabhan: 2016-07-21 06:32:34 [pool-2-thread-1] INFO - Generating report file for CAMPAIGN, file:/var/local/tsa/sedata/yahoojapan/ops-reports/YJP_Report_qa7_campaign_U_2016-07-21.csv
2016-07-21 06:32:34 [pool-2-thread-1] INFO - Completed generating report file for CAMPAIGN, file:/var/local/tsa/sedata/yahoojapan/ops-reports/YJP_Report_qa7_campaign_U_2016-07-21.csv
2016-07-21 06:32:34 [pool-2-thread-1] INFO - === Completed Server : qa7, Report Type : CAMPAIGN ===
2016-07-21 06:32:35 [pool-2-thread-2] INFO - Rows found: 840
2016-07-21 06:32:35 [pool-2-thread-2] INFO - Generating report file for TEXT_AD, file:/var/local/tsa/sedata/yahoojapan/ops-reports/YJP_Report_qa7_text_ad_U_2016-07-21.csv
2016-07-21 06:32:35 [pool-2-thread-2] INFO - Completed generating report file for TEXT_AD, file:/var/local/tsa/sedata/yahoojapan/ops-reports/YJP_Report_qa7_text_ad_U_2016-07-21.csv
2016-07-21 06:32:35 [pool-2-thread-2] INFO - === Completed Server : qa7, Report Type : TEXT_AD ===
2016-07-21 06:33:14 [pool-2-thread-3] INFO - Rows found: 3632
2016-07-21 06:33:14 [pool-2-thread-3] INFO - Running query: select k.accountId,k.campaignId,k.campaignName,k.adGroupId,k.adGroupName,k.criterionUse,k.criterionId,k.criterionType,k.text,k.keywordMatchType,k.us erStatus,k.approvalStatus,k.disapprovalReasonCodes,p.qualityScore,p.firstPageBidEstimate,p.topOfPageBidEstimate,k.date from YJKeywordReport k left join YJKwPerformanceReports p on p.keywordId=k.criterionId wh ere k.date = ? and k.server = ? and ( criterionUse = 'NEGATIVE' || approvalStatus NOT IN ('APPROVED') ) and accountId in (586827) order by approvalStatus desc
2016-07-21 06:33:31 [main] INFO - ------------YJCampaignReportGenerator done
2016-07-21 06:33:33 [pool-1-thread-1] INFO - ------------YJCampaignReportGenerator done

Actual Result:

It doesn't generate the keyword report for the campaign.

Expected Result:

It should generate the keyword report successfully.