1) mysql> SELECT * FROM dataSources JOIN dataAvailability ON (dataSources.id = dataAvailability.dataSourceID ) WHERE dataAvailability.date = "2010-12-14" AND accountID=17 AND TYPE IN ('searchengine','wh_searchengine','client','wh_client','pixel','wh_pixel'); +--------+-----------------+--------+-----------+----------+------------+------------+---------------------+--------------+-------------+------------+------------+----------+ | id | type | typeID | accountID | id | date | oldUpdated | updated | dataSourceID | status | statusText | needsRerun | override | +--------+-----------------+--------+-----------+----------+------------+------------+---------------------+--------------+-------------+------------+------------+----------+ | 8373 | wh_pixel | NULL | 17 | 13587091 | 2010-12-14 | 00:00:00 | 2010-06-03 10:52:43 | 8373 | not started | NULL | false | false | | 8832 | wh_searchengine | 5 | 17 | 13629681 | 2010-12-14 | 00:00:00 | 2010-06-03 10:55:07 | 8832 | not started | NULL | false | false | | 8854 | wh_searchengine | 3 | 17 | 13629671 | 2010-12-14 | 00:00:00 | 2010-06-03 10:55:07 | 8854 | not started | NULL | false | false | | 8968 | wh_searchengine | 147 | 17 | 13629691 | 2010-12-14 | 00:00:00 | 2010-06-03 10:55:07 | 8968 | not started | NULL | false | false | | 9199 | wh_searchengine | 164 | 17 | 13629701 | 2010-12-14 | 00:00:00 | 2010-06-03 10:55:07 | 9199 | not started | NULL | false | false | | 13895 | wh_client | NULL | 17 | 13587121 | 2010-12-14 | 00:00:00 | 2010-06-03 10:52:45 | 13895 | not started | NULL | false | false | | 222991 | client | NULL | 17 | 13626071 | 2010-12-14 | 00:00:00 | 2010-06-03 10:54:59 | 222991 | not started | NULL | false | false | +--------+-----------------+--------+-----------+----------+------------+------------+---------------------+--------------+-------------+------------+------------+----------+ 7 rows in set (0.05 sec) 2)mysql> SELECT * FROM dataSources JOIN dataAvailability ON (dataSources.id = dataAvailability.dataSourceID ) WHERE dataAvailability.date = "2010-12-14" AND accountID=17 AND TYPE IN ('publisher', 'wh_publisher'); +--------+--------------+--------+-----------+----------+------------+------------+---------------------+--------------+-------------+------------+------------+----------+ | id | type | typeID | accountID | id | date | oldUpdated | updated | dataSourceID | status | statusText | needsRerun | override | +--------+--------------+--------+-----------+----------+------------+------------+---------------------+--------------+-------------+------------+------------+----------+ | 223001 | publisher | 177 | 17 | 13626081 | 2010-12-14 | 00:00:00 | 2010-06-03 10:54:59 | 223001 | not started | NULL | false | false | | 223011 | publisher | 180 | 17 | 13626091 | 2010-12-14 | 00:00:00 | 2010-06-03 10:54:59 | 223011 | not started | NULL | false | false | | 223021 | publisher | 188 | 17 | 13626101 | 2010-12-14 | 00:00:00 | 2010-06-03 10:54:59 | 223021 | not started | NULL | false | false | | 223101 | publisher | 197 | 17 | 13626171 | 2010-12-14 | 00:00:00 | 2010-06-03 10:55:00 | 223101 | not started | NULL | false | false | | 223031 | wh_publisher | NULL | 17 | 13626111 | 2010-12-14 | 00:00:00 | 2010-06-03 10:54:59 | 223031 | not started | NULL | false | false | +--------+--------------+--------+-----------+----------+------------+------------+---------------------+--------------+-------------+------------+------------+----------+ 5 rows in set (0.02 sec) 3)Upload pupblisher feed for Facebook and Kontera using ADmax UI and pull it to staging-xml1. 4)./load-all-publishers.sh -d 3 2>&1|tee /var/local/tsa/log/2010-12-14/atultest2.log 5)mysql> SELECT * FROM dataSources JOIN dataAvailability ON (dataSources.id = dataAvailability.dataSourceID ) WHERE dataAvailability.date = "2010-12-14" AND accountID=17 AND TYPE IN ('publisher', 'wh_publisher'); +--------+--------------+--------+-----------+----------+------------+------------+---------------------+--------------+-------------+------------+------------+----------+ | id | type | typeID | accountID | id | date | oldUpdated | updated | dataSourceID | status | statusText | needsRerun | override | +--------+--------------+--------+-----------+----------+------------+------------+---------------------+--------------+-------------+------------+------------+----------+ | 223001 | publisher | 177 | 17 | 13626081 | 2010-12-14 | 00:00:00 | 2010-12-15 22:49:18 | 223001 | success | NULL | false | false | | 223011 | publisher | 180 | 17 | 13626091 | 2010-12-14 | 00:00:00 | 2010-06-03 10:54:59 | 223011 | not started | NULL | false | false | | 223021 | publisher | 188 | 17 | 13626101 | 2010-12-14 | 00:00:00 | 2010-12-15 22:49:17 | 223021 | success | NULL | false | false | | 223101 | publisher | 197 | 17 | 13626171 | 2010-12-14 | 00:00:00 | 2010-06-03 10:55:00 | 223101 | not started | NULL | false | false | | 223031 | wh_publisher | NULL | 17 | 13626111 | 2010-12-14 | 00:00:00 | 2010-06-03 10:54:59 | 223031 | not started | NULL | false | false | | 230931 | wh_publisher | 188 | 17 | 13631071 | 2010-12-14 | 00:00:00 | 2010-12-15 22:49:25 | 230931 | success | NULL | false | false | | 230941 | wh_publisher | 177 | 17 | 13631081 | 2010-12-14 | 00:00:00 | 2010-12-15 22:49:25 | 230941 | success | NULL | false | false | +--------+--------------+--------+-----------+----------+------------+------------+---------------------+--------------+-------------+------------+------------+----------+ 7 rows in set (0.01 sec) 6)mysql> SELECT * FROM dataSources JOIN dataAvailability ON (dataSources.id = dataAvailability.dataSourceID ) WHERE dataAvailability.date = "2010-12-14" AND accountID=17 AND typeID=188 AND TYPE IN ('publisher', 'wh_publisher'); +--------+--------------+--------+-----------+----------+------------+------------+---------------------+--------------+---------+------------+------------+----------+ | id | type | typeID | accountID | id | date | oldUpdated | updated | dataSourceID | status | statusText | needsRerun | override | +--------+--------------+--------+-----------+----------+------------+------------+---------------------+--------------+---------+------------+------------+----------+ | 223021 | publisher | 188 | 17 | 13626101 | 2010-12-14 | 00:00:00 | 2010-12-15 22:49:17 | 223021 | success | NULL | false | false | | 230931 | wh_publisher | 188 | 17 | 13631071 | 2010-12-14 | 00:00:00 | 2010-12-15 22:49:25 | 230931 | success | NULL | false | false | +--------+--------------+--------+-----------+----------+------------+------------+---------------------+--------------+---------+------------+------------+----------+ 2 rows in set (0.01 sec) 7)mysql> UPDATE dataAvailability SET STATUS ='success' WHERE id IN (13587091,13629681,13629671,13629691,13629701,13587121,13626071); Query OK, 0 rows affected (0.00 sec) Rows matched: 7 Changed: 0 Warnings: 0 ./lowgran-whsumm.sh -a 17 -d4 2>&1 | tee /tmp/Lowgran_publisher_Admax2499.log . . . . 'wh_position','wh_publisher'))) order by `dataSources`.`accountID`] 2010-12-15 23:21:06.978 (4) [main]: time=0.0030 2010-12-15 23:21:06.978 (4) [main]: Query executed in 0.003s 2010-12-15 23:21:06.979 (4) [main]: perfsum: SQL->[select `dataSources`.`accountID`,`dataSources`.`type`,`dataAvailability`.`status` from `dataAvailability` join `dataSources` on ((`dataSources`.`id`=`dataAvailability`.`dataSourceID`)) join `tsacommon`.`accounts` on ((`dataSources`.`accountID`=`tsacommon`.`accounts`.`id`)) where ((`tsacommon`.`accounts`.`id` in (17)) and (`dataAvailability`.`date`="2010-12-14") and (`dataSources`.`type` in ('wh_pixel','wh_client','wh_searchengine','wh_position','wh_publisher'))) order by `dataSources`.`accountID`] 2010-12-15 23:21:06.983 (4) [main]: time=0.0040 2010-12-15 23:21:06.983 (4) [main]: Query executed in 0.004s 2010-12-15 23:21:06.984 (4) [main]: perfsum: SQL->[select `dataSources`.`accountID`,`dataSources`.`type`,`dataAvailability`.`status` from `dataAvailability` join `dataSources` on ((`dataSources`.`id`=`dataAvailability`.`dataSourceID`)) join `tsacommon`.`accounts` on ((`dataSources`.`accountID`=`tsacommon`.`accounts`.`id`)) where ((`tsacommon`.`accounts`.`id` in (17)) and (`dataAvailability`.`date`="2010-12-14") and (`dataSources`.`type` in ('wh_pixel','wh_client','wh_searchengine','wh_position','wh_publisher'))) order by `dataSources`.`accountID`] 2010-12-15 23:21:06.989 (4) [main]: time=0.0050 2010-12-15 23:21:06.989 (4) [main]: Query executed in 0.005s Its keep on waiting for Right Media and Vibrant Media as theit status is "not started" 8)mysql> UPDATE dataAvailability SET STATUS = 'success' WHERE id IN (13626091,13626171,13626111); Query OK, 0 rows affected (0.02 sec) Rows matched: 3 Changed: 0 Warnings: 0 9) Now the low gran warehouse started to execute and runs successfully. 2010-12-15 23:22:10.193 (4) [P1T1]: perfsum: SQL->[insert into `dataAvailabilityHistory` (`override`,`dataSourceID`,`status`,`date`,`updated`) values ("false","8602","success","2010-12-14 00:00:00","2010-12-15 23:22:10")], genflags=yes 2010-12-15 23:22:10.195 (4) [P1T1]: time=0.0020 2010-12-15 23:22:10.195 (4) [P1T1]: Query executed in 0.002s, 1 row(s) affected 2010-12-15 23:22:10.195 (3) [P1T1]: Sending 'account done' JMS message for 17 log4j:WARN No appenders could be found for logger (org.jboss.remoting.transport.socket.MicroSocketClientInvoker). log4j:WARN Please initialize the log4j system properly. 2010-12-15 23:22:16.501 (4) [P1T1]: Returning Object to Pool 2010-12-15 23:22:16.502 (4) [P1T1]: Returning Object to Pool 2010-12-15 23:22:16.503 (4) [main]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2010-12-15 23:22:16.504 (3) [main]: ------------Warehouse Summarizer done 10 ) Admax > Data Availability : Status is Green.