Googlemcc.sh script throws Number format exception

Steps:

1. Run googlemcc script for all the accounts

[TSAApp@aml-qa3-core1 bidmgr]$ ./googlemcc.sh --date 2015-03-16 -d 4

2. Check the debug log

Actual result:

Googlemcc.sh script throws Number format exception as searchEngineUsers has a null searchEngineIdentifier entry.

2015-03-18 14:59:26.836 (3) [main]: Debug Level set to 3
2015-03-18 14:59:26.838 (3) [main]: Licensing environment detected, loading configuration.
2015-03-18 14:59:26.839 (3) [main]: Loaded property: tsa.google.mcc.clientId=708478822263-srenocq0gcguusttt4aunqjdi2jnllcg.apps.googleusercontent.com
2015-03-18 14:59:26.839 (3) [main]: Loaded property: tsa.google.mcc.clientSecret=eGE8JpEDaEgVb26gQg_ePnaG
2015-03-18 14:59:26.839 (3) [main]: Loaded property: tsa.google.mcc.refreshToken=1/PPPmQLADSV-h2NEsY4vmLgBmiDtScaB01K55xhGOaHE
2015-03-18 14:59:26.839 (3) [main]: Loaded property: tsa.google.mcc.developerToken=ojCnjZaM6RD1h0yt_DOJZg
2015-03-18 14:59:26.839 (3) [main]: Loaded property: tsa.google.mcc.isReseller=true
2015-03-18 14:59:26.839 (3) [main]: Loaded property: tsa.google.mcc.userAgent=AdMaxLocal AdWords Software TSA QA
2015-03-18 14:59:26.840 (3) [main]: Loaded property: tsa.timezone=UTC
2015-03-18 14:59:26.847 (3) [main]: Debug Level set to 4
2015-03-18 14:59:26.927 (4) [main]: registered MBean [thesearchagency.db.util:type=MultiplexDatabasePool8583b976-f6df-4182-b947-d1237f3ad812] for class com.thesearchagency.db.util.MultiplexDatabasePool
2015-03-18 14:59:26.930 (3) [main]: =============== Starting Google MCC Report ================
2015-03-18 14:59:26.930 (3) [main]: ----------------Google MCC Report starting
2015-03-18 14:59:26.932 (4) [main]: no account, or instance for databaseInstance, skipping lookup...
2015-03-18 14:59:27.213 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
2015-03-18 14:59:27.214 (4) [main]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false&useServerPrepStmts=false&rewriteBatchedStatements=true]
2015-03-18 14:59:27.231 (4) [main]: spike: SQL->[select * from `searchEngineUsers` join `accounts` on ((`tsacommon`.`accounts`.`id`=`tsacommon`.`searchEngineUsers`.`accountID`)) where ((`enabled`="true") and (`tsacommon`.`accounts`.`isActive`="true") and (`tsacommon`.`searchEngineUsers`.`distributionID`="3")) order by `tsacommon`.`accounts`.`tier` asc,`tsacommon`.`accounts`.`priority` asc,`tsacommon`.`accounts`.`id` desc]
2015-03-18 14:59:27.286 (4) [main]: time=0.054
2015-03-18 14:59:27.286 (4) [main]: Query executed in 0.054s
2015-03-18 14:59:27.304 (3) [P1T1]: === Starting user #1382, 04f29fca-336c-4b11-926b-bbda8b4af59e_1 ===
2015-03-18 14:59:27.304 (3) [P1T1]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2015-03-16-U1382_9878703212.xml.gz
2015-03-18 14:59:27.314 (3) [P1T2]: === Starting user #1381, 4012562b-a342-468f-b727-fbceae1d89e3_1 ===
2015-03-18 14:59:27.314 (3) [P1T2]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2015-03-16-U1381_9128324853.xml.gz
2015-03-18 14:59:27.317 (3) [P1T3]: === Starting user #1380, 502988e4-ca69-4dd7-954e-3c9f0a62d225_1 ===
2015-03-18 14:59:27.317 (3) [P1T3]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2015-03-16-U1380_4826735183.xml.gz
2015-03-18 14:59:27.318 (3) [P1T4]: === Starting user #1379, 5d7e82c8-2cb4-4c55-9fec-bb290f3d9950_1 ===
2015-03-18 14:59:27.319 (3) [P1T4]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2015-03-16-U1379_5527848220.xml.gz
2015-03-18 14:59:27.320 (3) [P1T5]: === Starting user #1378, 850c10d5-d6e7-4724-af84-33681d99c308_1 ===
2015-03-18 14:59:27.320 (3) [P1T5]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2015-03-16-U1378_6037655502.xml.gz
2015-03-18 14:59:27.321 (3) [P1T6]: === Starting user #1377, f45486ea-6f67-4c2c-9018-08d298889648_1 ===
2015-03-18 14:59:27.321 (3) [P1T6]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2015-03-16-U1377_1120818618.xml.gz
2015-03-18 14:59:27.323 (3) [P1T7]: === Starting user #1376, 8b822161-df18-40e9-bc0b-c7ef53314b37_1 ===
2015-03-18 14:59:27.323 (3) [P1T7]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2015-03-16-U1376_6855174814.xml.gz
2015-03-18 14:59:27.337 (3) [P1T8]: === Starting user #1375, 45640e92-e952-42b7-9b9c-2a8be0f2bbe1_1 ===
2015-03-18 14:59:27.337 (3) [P1T8]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2015-03-16-U1375_2864139004.xml.gz
2015-03-18 14:59:27.341 (3) [P1T9]: === Starting user #1374, 1589fedd-0bbc-439a-8a29-b05808fb1087_1 ===
2015-03-18 14:59:27.341 (3) [P1T9]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2015-03-16-U1374_1421561781.xml.gz
2015-03-18 14:59:27.368 (3) [P1T10]: === Starting user #1373, 8ed9215c-9243-453d-a810-7eae3f634dac_1 ===
2015-03-18 14:59:27.369 (3) [P1T10]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2015-03-16-U1373_5654937128.xml.gz
.
.
.

2015-03-18 14:59:27.788 (4) [P1T1]: sesystem: SQL->[update `sesystem`.`searchEngineConnections` set `holder`="",`inUse`="false",`holderIdentifier`="",`timeStamp`="2015-03-18 14:59:27" where ((`sesystem`.`searchEngineConnections`.`distributionID`=3) and (`sesystem`.`searchEngineConnections`.`inUse`="true") and (`sesystem`.`searchEngineConnections`.`timeStamp`<="2015-03-18 14:54:27")) limit 1], genflags=no
2015-03-18 14:59:27.795 (4) [P1T1]: time=0.0070
2015-03-18 14:59:27.795 (4) [P1T1]: Query executed in 0.007s, 0 row(s) affected
2015-03-18 14:59:27.853 (3) [P1T1]: [oauth] Creating new OAuthService component
2015-03-18 14:59:27.854 (3) [P1T2]: [oauth] Creating new OAuthService component
2015-03-18 14:59:27.854 (3) [P1T4]: [oauth] Creating new OAuthService component
2015-03-18 14:59:27.854 (3) [P1T9]: [oauth] Creating new OAuthService component
2015-03-18 14:59:27.854 (3) [P1T7]: [oauth] Creating new OAuthService component
2015-03-18 14:59:27.854 (3) [P1T6]: [oauth] Creating new OAuthService component
2015-03-18 14:59:27.856 (3) [P1T8]: [oauth] Creating new OAuthService component
2015-03-18 14:59:27.857 (3) [P1T3]: [oauth] Creating new OAuthService component
2015-03-18 14:59:27.857 (3) [P1T5]: [oauth] Creating new OAuthService component
2015-03-18 14:59:27.860 (3) [P1T10]: [oauth] Creating new OAuthService component
2015-03-18 14:59:28.233 (2) [main]: Exception [handling search engine user - ignoring]:java.lang.NumberFormatException: For input string: "null"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Long.parseLong(Long.java:410)
at java.lang.Long.parseLong(Long.java:468)
at com.thesearchagency.searchengines.google.GoogleMCCReport.createWorker(GoogleMCCReport.java:168)
at com.thesearchagency.searchengines.SearchEngineUserDispatcher.call(SearchEngineUserDispatcher.java:125)
at com.thesearchagency.searchengines.google.GoogleMCCReport.run(GoogleMCCReport.java:191)
at com.thesearchagency.searchengines.google.GoogleMCCReport.main(GoogleMCCReport.java:228)

2015-03-18 14:59:28.234 (2) [main]: Exception [handling search engine user - ignoring]:java.lang.NumberFormatException: For input string: "null"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Long.parseLong(Long.java:410)
at java.lang.Long.parseLong(Long.java:468)
at com.thesearchagency.searchengines.google.GoogleMCCReport.createWorker(GoogleMCCReport.java:168)
at com.thesearchagency.searchengines.SearchEngineUserDispatcher.call(SearchEngineUserDispatcher.java:125)
at com.thesearchagency.searchengines.google.GoogleMCCReport.run(GoogleMCCReport.java:191)
at com.thesearchagency.searchengines.google.GoogleMCCReport.main(GoogleMCCReport.java:228)

2015-03-18 14:59:28,310 [P1T8] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Creating new OAuthServiceComponent
2015-03-18 14:59:28,310 [P1T3] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Creating new OAuthServiceComponent
2015-03-18 14:59:28,310 [P1T2] INFO c.t.s.o.core.OAuthServiceComponent - [oauth] Creating new OAuthServiceComponent