Skip to content

Instantly share code, notes, and snippets.

View tanmay-bhattacharjee's full-sized avatar

tanmay-bhattacharjee

View GitHub Profile
APP_DM|INFO |2019-06-26 10:23:00.032|||vm-sprintcvp2.synapse.com|APP_LOG|Daily device subscription scheduler job executed at :: 2019-06-26T10:23:00.005+0000
APP_DM|INFO |2019-06-26 10:23:00.033|||vm-sprintcvp2.synapse.com|APP_LOG|Daily device subscription Query - SELECT * FROM device_subscription ds INNER JOIN device_profile dp ON ds.imei = dp.imei WHERE ds.created_timestamp BETWEEN TO_DATE('2019-06-25 00:00:00','YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2019-06-26 00:00:00','YYYY-MM-DD HH24:MI:SS' ) AND dp.device_group = 'Production'
APP_DM|INFO |2019-06-26 10:23:00.049|||vm-sprintcvp2.synapse.com|APP_LOG|Daily device subscription Job Exit Status : COMPLETED
APP_DM|INFO |2019-06-26 10:23:00.064|||vm-sprintcvp2.synapse.com|APP_LOG|Next job scheduled @ 2019-06-26T10:24:00.000+0000
APP_DM|INFO |2019-06-26 10:23:10.679|A6DF22CCDCCC4512BD60D587DDFB400C|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|Request received for User-Agent :: NXM
APP_DM|INFO |2019-06-26 10:23:10.680|A6DF22CCDCCC4512BD60D587DDFB400C|172.18.14.70
APP_DM|INFO |2019-06-25 14:22:54.560|DF111C1DADD847DEBA76FD9925494E71|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|Request received for User-Agent :: NXM
APP_DM|INFO |2019-06-25 14:22:54.561|DF111C1DADD847DEBA76FD9925494E71|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|Reset Info for IMEI :: 100000000000004
APP_DM|INFO |2019-06-25 14:22:54.562|DF111C1DADD847DEBA76FD9925494E71|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|Profile updated successfully for IMEI :: 100000000000004
APP_DM|INFO |2019-06-25 14:22:54.565|DF111C1DADD847DEBA76FD9925494E71|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|Making a call to KM to notifiy Device profile update/delete
APP_DM|INFO |2019-06-25 14:22:54.567|DF111C1DADD847DEBA76FD9925494E71|172.18.14.70|vm-sprintcvp2.synapse.com|HTTP_REQ|POST|http://172.16.19.97:8082/km/v1.1/profileUpdate|{"imei":"100000000000004","iccid":"8129238392442433100004","operation":"Update","prov_status":"Provisioned"}|{Accept=text/plain, application/json, application/*+json, */*, Content-Type=applic
APP_DM|INFO |2019-06-24 09:52:53.364|EC2A18200B894F9D9073C7486DEC4FA4|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|Request received for User-Agent :: NXM
APP_DM|INFO |2019-06-24 09:52:53.365|EC2A18200B894F9D9073C7486DEC4FA4|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|IMEI :: 100000000000002 , Warranty VIN :: 12345678901234568
APP_DM|ERROR|2019-06-24 09:52:53.368|EC2A18200B894F9D9073C7486DEC4FA4|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|Exception while intercepting HTTP request
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.NullPointerException
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982) ~[spring-webmvc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) ~[spring-webmvc-4.3.11.RELEASE.jar:4.3.11.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) ~[tomcat-embed-core-8.5.20.jar:
2019-06-24T09:24:00,847 ERROR [SimpleAsyncTaskExecutor-2] [AbstractStep] -Encountered an error executing step smallCsvSlaveStep in job fileReadJob
java.lang.NullPointerException: null
at com.logger.SupressLogger.logError(SupressLogger.java:15) ~[nxm-dm.jar:0.0.1]
at com.sprint.nxm.dm.service.impl.FeedValidationServiceImpl.getStoredObdDeviceDetails(FeedValidationServiceImpl.java:275) ~[nxm-dm.jar:0.0.1]
at com.sprint.nxm.dm.service.impl.FeedValidationServiceImpl.validateImeiIccid(FeedValidationServiceImpl.java:113) ~[nxm-dm.jar:0.0.1]
at com.sprint.nxm.dm.service.impl.FeedValidationServiceImpl.validateRecord(FeedValidationServiceImpl.java:66) ~[nxm-dm.jar:0.0.1]
at com.sprint.nxm.dm.batch.processor.FileItemProcessor.process(FileItemProcessor.java:30) ~[nxm-dm.jar:0.0.1]
at com.sprint.nxm.dm.batch.processor.FileItemProcessor.process(FileItemProcessor.java:13) ~[nxm-dm.jar:0.0.1]
at org.springframework.batch.core.step.item.SimpleChunkProcessor.doProcess(SimpleChunkProcessor.java:126) ~[spring-batch-core-3
[vsb@VM-SPrintCVP1 ~]$ mysql -u nxmqa -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.16 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
APP_OAUTH|INFO |2019-06-11 09:49:24.242|4ED24001441E42C9B2B3531D6D4F05B3|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|Authorize first request - AuthRequest [cid=sdkjs2323sds932kjs2323sdssdkjs2323sds932kjs2323sds12345567790105, vin=3D4PG6FVXAT11AA05, imei=null, clientChKey=iu324we54fbgiZ, nonce=ree32rw43g]
APP_OAUTH|INFO |2019-06-11 09:49:24.245|4ED24001441E42C9B2B3531D6D4F05B3|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|Creating server challenge key for IMEI :: 100000000000268
APP_OAUTH|INFO |2019-06-11 09:49:24.248|4ED24001441E42C9B2B3531D6D4F05B3|172.18.14.70|vm-sprintcvp2.synapse.com|HTTP_REQ|POST|http://172.16.19.130:8082/nxm-oauth/auth1|{ "cid": "sdkjs2323sds932kjs2323sdssdkjs2323sds932kjs2323sds12345567790105", "vin": "3D4PG6FVXAT11AA05", "client_ch_key": "iu324we54fbgiZ", "nonce": "ree32rw43g"}|{authorization=Basic MTAwMDAwMDAwMDAwMjY4Og==, content-length=186, host=172.16.19.130:8082, connection=keep-alive, content-type=application/json, user-agent=nxm, accept=application/json}
APP_OAUTH|INFO |201
@tanmay-bhattacharjee
tanmay-bhattacharjee / OAuth_Regression_10_06_2019_CVP-4396
Created June 10, 2019 13:51
OAuth_Regression_10_06_2019_CVP-4396
++++++++++++++++++++++++TU First Bootstrap++++++++++++++++++++++++++++++
=============== TU First Bootstrap ===============
APP_OAUTH|INFO |2019-06-10 10:13:17.849|4E77162040C04DB48C0AC96CEACAECCD|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|Authorize first request - AuthRequest [cid=sdkjs2323sds932kjs2323sdssdkjs2323sds932kjs2323sds12345567790105, vin=3D4PG6FVXAT11AA05, imei=null, clientChKey=iu324we54fbgiZ, nonce=ree32rw43g]
APP_OAUTH|INFO |2019-06-10 10:13:17.853|4E77162040C04DB48C0AC96CEACAECCD|172.18.14.70|vm-sprintcvp2.synapse.com|APP_LOG|Creating server challenge key for IMEI :: 100000000000269
APP_OAUTH|INFO |2019-06-10 10:13:17.856|4E77162040C04DB48C0AC96CEACAECCD|172.18.14.70|vm-sprintcvp2.synapse.com|HTTP_REQ|POST|http://172.16.19.130:8082/nxm-oauth/auth1|{ "cid": "sdkjs2323sds932kjs2323sdssdkjs2323sds932kjs2323sds12345567790105", "vin": "3D4PG6FVXAT11AA05", "client_ch_key": "iu324we54fbgiZ", "nonce": "ree32rw43g"}|{authorization=Basic MTAwMDAwMDAwMDAwMjY5Og==, content-length=186, host=172.16.19
@tanmay-bhattacharjee
tanmay-bhattacharjee / 16.1.2 Release Candidate Build
Created June 3, 2019 10:00
16.1.2 Release Candidate Build
Microsoft Visual Studio Enterprise 2019
Version 16.1.2 [29001.49.d16.1]
VisualStudio.16.Release.Int/16.1.2+29001.49.d16.1
Microsoft .NET Framework
Version 4.7.03056
Installed Version: Enterprise
Application Insights Tools for Visual Studio Package 9.1.00429.1
Application Insights Tools for Visual Studio
@tanmay-bhattacharjee
tanmay-bhattacharjee / XVS_Market_Preview
Last active May 31, 2019 07:58
XVS_Market_Preview
Microsoft Visual Studio Enterprise 2019 Preview
Version 16.2.0 Preview 1.0
VisualStudio.16.Preview/16.2.0-pre.1.0+28917.182
Microsoft .NET Framework
Version 4.7.03056
Installed Version: Enterprise
Azure App Service Tools v3.0.0 16.1.429.50124
Azure App Service Tools v3.0.0
@tanmay-bhattacharjee
tanmay-bhattacharjee / 758592_Verification_Market_Stable
Created May 31, 2019 07:09
758592_Verification_Market_Stable
Microsoft Visual Studio Enterprise 2019
Version 16.1.1
VisualStudio.16.Release/16.1.1+28922.388
Microsoft .NET Framework
Version 4.7.03056
Installed Version: Enterprise
Azure App Service Tools v3.0.0 16.1.429.50124
Azure App Service Tools v3.0.0