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