[12-02-2010 00:30:01]: [12-02-2010 00:30:01]:Main:/oas/RealMedia/ads/OpenAd/LogProcAdmin.sh [12-02-2010 00:30:01]:Checking the modules installed and setting the flag. [12-02-2010 00:30:01]:Open AdStream -- Log Processing is started [12-02-2010 00:30:01]:Installation: /oas/RealMedia/ads/OpenAd ====================================================================== [12-02-2010 00:30:01]:Creating dictionaries for log processing [12-02-2010 00:30:01]:=====accounts.txt===== [12/02/2010 00:30:02] INFO: dbExport: Version: Feb 28 2006 12:52:38 [12/02/2010 00:30:02] INFO: dbExport: Execution begins... [12/02/2010 00:30:02] INFO: Exporting Query Results... [12/02/2010 00:30:02] INFO: dbExport: Execution ends. [12-02-2010 00:30:02]:=====sites.txt===== [12/02/2010 00:30:02] INFO: dbExport: Version: Feb 28 2006 12:52:38 [12/02/2010 00:30:02] INFO: dbExport: Execution begins... [12/02/2010 00:30:02] INFO: Exporting Query Results... [12/02/2010 00:30:02] INFO: dbExport: Execution ends. [12-02-2010 00:30:02]:=====pages.txt===== [12/02/2010 00:30:02] INFO: dbExport: Version: Feb 28 2006 12:52:38 [12/02/2010 00:30:02] INFO: dbExport: Execution begins... [12/02/2010 00:30:02] INFO: Exporting Query Results... [12/02/2010 00:30:02] INFO: dbExport: Execution ends. [12-02-2010 00:30:02]:=====positions.txt===== [12/02/2010 00:30:02] INFO: dbExport: Version: Feb 28 2006 12:52:38 [12/02/2010 00:30:02] INFO: dbExport: Execution begins... [12/02/2010 00:30:02] INFO: Exporting Query Results... [12/02/2010 00:30:02] INFO: dbExport: Execution ends. [12-02-2010 00:30:02]:=====CampaignKeys.txt===== [12/02/2010 00:30:02] INFO: dbExport: Version: Feb 28 2006 12:52:38 [12/02/2010 00:30:02] INFO: dbExport: Execution begins... [12/02/2010 00:30:02] INFO: Exporting Query Results... [12/02/2010 00:30:02] INFO: dbExport: Execution ends. [12-02-2010 00:30:02]:Computing campaign delivery totals ====================================================================== [12-02-2010 00:30:02]:Check if .db files arrived, if not, then, wait & loop [12-02-2010 00:30:02]:Yet to receive reporting data from 'admain.cbs.co.kr' for 'PassGroup0' pass group [12-02-2010 00:30:02]:Info: Expected=100%, Data received (Approx) =0%, pass group=PassGroup0 [12-02-2010 00:30:02]: [12-02-2010 00:30:02]:WARNING: Waiting for reporting data from Log Processors, ATTEMPTS=1 [12-02-2010 00:30:02]: Wait list = (admain.cbs.co.kr:PassGroup0) [12-02-2010 00:30:02]: Please make sure, LogProcClient.sh is running on above box(s). [12-02-2010 00:30:02]: [12-02-2010 00:35:02]:Yet to receive reporting data from 'admain.cbs.co.kr' for 'PassGroup0' pass group [12-02-2010 00:35:02]:Info: Expected=100%, Data received (Approx) =0%, pass group=PassGroup0 [12-02-2010 00:35:02]: [12-02-2010 00:35:02]:WARNING: Waiting for reporting data from Log Processors, ATTEMPTS=2 [12-02-2010 00:35:02]: Wait list = (admain.cbs.co.kr:PassGroup0) [12-02-2010 00:35:02]: Please make sure, LogProcClient.sh is running on above box(s). [12-02-2010 00:35:02]: [12-02-2010 00:40:02]:Yet to receive reporting data from 'admain.cbs.co.kr' for 'PassGroup0' pass group [12-02-2010 00:40:02]:Info: Expected=100%, Data received (Approx) =0%, pass group=PassGroup0 [12-02-2010 00:40:02]: [12-02-2010 00:40:02]:WARNING: Waiting for reporting data from Log Processors, ATTEMPTS=3 [12-02-2010 00:40:02]: Wait list = (admain.cbs.co.kr:PassGroup0) [12-02-2010 00:40:02]: Please make sure, LogProcClient.sh is running on above box(s). [12-02-2010 00:40:02]: [12-02-2010 00:45:02]:Info: Expected=100%, Data received (Approx) =100%, pass group=PassGroup0 ====================================================================== [12-02-2010 00:45:02]:Running post impress [12-02-2010 00:45:02]:cmd:postImpress -P 0 -C -s admain.cbs.co.kr -l 750000 -e yesterday -a "RmWhen=2010-12-01" [12/02/2010 00:45:02] INFO: PostImpress: Version: Feb 28 2006 12:55:51 [12/02/2010 00:45:02] INFO: PostImpress: Execution begins... [12/02/2010 00:45:02] INFO: *** Processing for date 2010-12-01 [12/02/2010 00:45:02] INFO: *** Processing table rCam [12/02/2010 00:45:02] INFO: +++ No data found for table: rCam [12/02/2010 00:45:02] INFO: PostImpress: Execution ends. [12-02-2010 00:45:02]: ====================================================================== [12-02-2010 00:45:02]:Loading rCam data 1 ./Reports/2010-12/01/rCam.db [12-02-2010 00:45:02]:cmd:loadBulkData -p /oas/RealMedia/ads/OpenAd/./Reports/2010-12/01 -t rCam -d 2010-12-01 [12/02/2010 00:45:02] INFO: Table in progress: rCam [12/02/2010 00:45:02] INFO: Deleting records for: 2010-12-01 [12/02/2010 00:45:02] INFO: Successfully deleted. [12/02/2010 00:45:02] INFO: Datafile to upload: rCam.db sh: mysql: command not found [12/02/2010 00:45:02] INFO: Upload failed. *** PLEASE NOTE *** [12/02/2010 00:45:02] INFO: Table operation finished. [12/02/2010 00:45:02] INFO: Command Finished, Table(s) Operation Failed. [12-02-2010 00:45:02]:ERROR: Command 'loadBulkData -p /oas/RealMedia/ads/OpenAd/./Reports/2010-12/01 -t rCam -d 2010-12-01 ' failed, RC=1 [12-02-2010 00:45:02]: [12-02-2010 00:45:02]:Updating campaign delivery totals [12-02-2010 00:45:02]:cmd:camStat [12/02/2010 00:45:02] INFO: OK: camStat updated 0 campaign(s). [12-02-2010 00:45:02]: [12-02-2010 00:45:02]:Updating campaign status [12-02-2010 00:45:02]:cmd:update [12-02-2010 00:45:02]: [12-02-2010 00:45:02]:Computing dynamic campaign targets and hour of day profiles [12-02-2010 00:45:02]:cmd:tgtday -d [12-02-2010 00:45:02]: [12-02-2010 00:45:02]:cmd:dbUpdate -i ./Temp/tgtday.txt -t Campaign [12/02/2010 00:45:02] INFO: dbUpdate: Version: Feb 28 2006 12:53:23 [12/02/2010 00:45:02] INFO: dbUpdate: Execution begins... [12/02/2010 00:45:02] INFO: Updating table Campaign ... [12/02/2010 00:45:02] INFO: *** Updated 6 record(s); Rejected 0 record(s). [12/02/2010 00:45:02] INFO: dbUpdate: Execution ends. [12-02-2010 00:45:02]: [12-02-2010 00:45:02]:cmd:dbImport -t rTarget -d -w today [12/02/2010 00:45:02] INFO: dbImport: Version: Feb 28 2006 12:52:44 [12/02/2010 00:45:02] INFO: dbImport: Execution begins... [12/02/2010 00:45:02] INFO: Importing Database Report Tables ... [12/02/2010 00:45:02] INFO: Importing from: ./Reports/2010-12/02 [12/02/2010 00:45:02] INFO: Importing table rTarget ... [12/02/2010 00:45:02] INFO: *** Imported 39 record(s). [12/02/2010 00:45:02] INFO: dbImport: Execution ends. [12-02-2010 00:45:02]: [12-02-2010 00:45:02]:cmd:dbImport -t rTarget -d -w yesterday [12/02/2010 00:45:02] INFO: dbImport: Version: Feb 28 2006 12:52:44 [12/02/2010 00:45:02] INFO: dbImport: Execution begins... [12/02/2010 00:45:02] INFO: Importing Database Report Tables ... [12/02/2010 00:45:02] INFO: Importing from: ./Reports/2010-12/01 [12/02/2010 00:45:02] INFO: Importing table rTarget ... [12/02/2010 00:45:02] INFO: *** Imported 39 record(s). [12/02/2010 00:45:02] INFO: dbImport: Execution ends. [12-02-2010 00:45:02]: [12-02-2010 00:45:02]:Updating campaign daily targets to DE and daily targets [12-02-2010 00:45:02]:cmd:press.cgi -c -g -q -r [12-02-2010 00:45:02]:Didn't run this command as one or more previous commands failed. [12-02-2010 00:45:02]: [12-02-2010 00:45:02]:Synchronizing counts [12-02-2010 00:45:02]:cmd:./bean.sh [12-02-2010 00:45:02]:Didn't run this command as one or more previous commands failed. [12-02-2010 00:45:02]: [12-02-2010 00:45:02]:Message: Campaign maintenance applications (stat/update/tgtday/press ...) failed. [12-02-2010 00:45:02]:Severity=ERROR, RC=1, Processing HostName=admain.cbs.co.kr, Processing Date=2010-12-01 [12-02-2010 00:45:02]:Application: LogProcAdmin [12-02-2010 00:45:02]:Command: loadBulkData [12-02-2010 00:45:02]:email the message !!!!!