Grok error filter json

Roshan1 · June 16, 2022, 7:10am

Hello Team,

can you please help me with error below?

Error:

[WARN ] 2022-06-16 11:02:33.814 [[main]-pipeline-manager] grok - ECS v8 support is a preview of the unreleased ECS v8, and uses the v1 patterns. When Version 8 of the Elastic Common Schema becomes available, this plugin will need to be updated
[INFO ] 2022-06-16 11:02:33.852 [Ruby-0-Thread-10: :1] elasticsearch - Using a default mapping template {:es_version=>8, :ecs_compatibility=>:v8}
[ERROR] 2022-06-16 11:02:33.934 [[main]-pipeline-manager] javapipeline - Pipeline error {:pipeline_id=>"main", :exception=>#<Grok::PatternError: pattern %{Hibernate:hibernate} not defined>, :backtrace=>["/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/jls-grok-0.11.5/lib/grok-pure.rb:123:in `block in compile'", "org/jruby/RubyKernel.java:1442:in `loop'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/jls-grok-0.11.5/lib/grok-pure.rb:93:in `compile'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-grok-4.4.1/lib/logstash/filters/grok.rb:282:in `block in register'", "org/jruby/RubyArray.java:1821:in `each'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-grok-4.4.1/lib/logstash/filters/grok.rb:276:in `block in register'", "org/jruby/RubyHash.java:1415:in `each'", "/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-filter-grok-4.4.1/lib/logstash/filters/grok.rb:271:in `register'", "org/logstash/config/ir/compiler/AbstractFilterDelegatorExt.java:75:in `register'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:232:in `block in register_plugins'", "org/jruby/RubyArray.java:1821:in `each'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:231:in `register_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:594:in `maybe_setup_out_plugins'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:244:in `start_workers'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:189:in `run'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:141:in `block in start'"], "pipeline.sources"=>["/etc/logstash/conf.d/jsonreadnew.conf"], :thread=>"#<Thread:0x4a85dd06 run>"}

input {
        file {
                start_position => "beginning"
                path => "/data/KONG1/catalina.out"
                sincedb_path => "/dev/null"
        }
}
filter {
        json {
                source => "message"
        }
}

filter {
        grok {
                match => {"log" => "%{Hibernate:hibernate} - - [%{TIMESTAMP_ISO8601:timestamp}"}
        }
}

output {
        elasticsearch {
                hosts => "https://es1.innov.mt:9200"
                index => "demo-json"
        ssl => true
                ssl_certificate_verification => false
                cacert => "/etc/kibana/innov_mt.crt"
                user => "mfslog"
                password => "Yaxtubular6"
        }
        stdout {}
}

Sample file:
Hibernate: select usermaster0_.USER_ID as user_id1_178_0_, usermaster0_.ACTIVATED_DATE as activated_date2_178_0_, usermaster0_.MM_APP_LAST_UPDATE_DATE as mm_app_last_update3_178_0_, usermaster0_.MM_APP_VERSION as mm_app_version4_178_0_, usermaster0_.CHANNEL_TYPE as channel_type5_178_0_, usermaster0_.COMU_EMAIL as comu_email6_178_0_, usermaster0_.CONTACT_EMAIL_ID as contact_email_id7_178_0_, usermaster0_.CONTACT_MSISDN as contact_msisdn8_178_0_, usermaster0_.CONTRACT_END_DATE as contract_end_date9_178_0_, usermaster0_.CONTRACT_START_DATE as contract_start_da10_178_0_, usermaster0_.CREATED_BY as created_by11_178_0_, usermaster0_.DESIGNATION as designation12_178_0_, usermaster0_.DEVICE_ID as device_id13_178_0_, usermaster0_.DEVICE_ID_FLAG as device_id_flag14_178_0_, usermaster0_.DOB as dob15_178_0_, usermaster0_.DOC_NAME as doc_name16_178_0_, usermaster0_.EMAIL_ID as email_id17_178_0_, usermaster0_.ENTITY_TYPE as entity_type18_178_0_, usermaster0_.ERP_CODE as erp_code19_178_0_, usermaster0_.FACE_ACCURACY as face_accuracy20_178_0_, usermaster0_.FATHER_NAME as father_name21_178_0_, usermaster0_.FCM_TOKEN as fcm_token22_178_0_, usermaster0_.FIRST_CASHIN_PENDING as first_cashin_pend23_178_0_, usermaster0_.FIRST_NAME as first_name24_178_0_, usermaster0_.GENDER as gender25_178_0_, usermaster0_.HIER_ID as hier_id26_178_0_, usermaster0_.MONTHLY_INCOME as monthly_income27_178_0_, usermaster0_.IS_FREE_ACCOUNT as is_free_account28_178_0_, usermaster0_.IS_MIGRATED as is_migrated29_178_0_, usermaster0_.IS_POSTPAID as is_postpaid30_178_0_, usermaster0_.JOB_NAME as job_name31_178_0_, usermaster0_.JOB_STARTED as job_started32_178_0_, usermaster0_.KYC_VERIFIED as kyc_verified33_178_0_, usermaster0_.LABEL_ID as label_id34_178_0_, usermaster0_.LANGUAGE_ID as language_id35_178_0_, usermaster0_.LAST_NAME as last_name36_178_0_, usermaster0_.LAST_FINANCIAL_TXN_DATE as last_financial_tx37_178_0_, usermaster0_.LATITUDE as latitude38_178_0_, usermaster0_.LIMIT_FLAG as limit_flag39_178_0_, usermaster0_.LONGITUDE as longitude40_178_0_, usermaster0_.MARITAL_STATUS as marital_status41_178_0_, usermaster0_.MSISDN as msisdn42_178_0_, usermaster0_.NATIONALITY_ID as nationality_id43_178_0_, usermaster0_.NOTIFICATION_SERVICE_TYPE as notification_serv44_178_0_, usermaster0_.OFFICIAL_EMAIL_ID as official_email_id45_178_0_, usermaster0_.PARENT_ID as parent_id46_178_0_, usermaster0_.POW as pow47_178_0_, usermaster0_.PROFILE_ID as profile_id48_178_0_, usermaster0_.PROFILE_PICTURE_ID as profile_picture_i49_178_0_, usermaster0_.PROMO_FLAG_REQUIRED as promo_flag_requir50_178_0_, usermaster0_.QUALIFICATION as qualification51_178_0_, usermaster0_.REASON as reason52_178_0_, usermaster0_.REFERRED_BY as referred_by53_178_0_, usermaster0_.REGISTERED_DATE as registered_date54_178_0_, usermaster0_.SALUTE as salute55_178_0_, usermaster0_.SOFT_DELETE as soft_delete56_178_0_, usermaster0_.SRC_OF_FUND as src_of_fund57_178_0_, usermaster0_.USER_STATUS as user_status58_178_0_ from MFS_USER_MASTER usermaster0_ where usermaster0_.USER_ID=?
^[[30m2022-06-15T16:37:15,819^[[m ^[[30mTRACE ^[[m[^[[1;34mhttp-nio-8989-exec-3^[[m] ^[[1;33mo.z.l.DefaultHttpLogWriter^[[m: {"origin":"remote","type":"request","correlation":"863a95fe70df8921","protocol":"HTTP/1.1","remote":"10.242.1.98","method":"GET","uri":"http://10.242.1.110:8989/mwallet/v1/wallets/balance/L1506305696","headers":{"accept-encoding":["gzip"],"apikey":["ME/eIRf113{,Es3+"],"authorization":["XXX"],"authtoken":["k+8L2WYQXYgbTgpk8EkduH+ml5ZYtKPvdD1JY9E72AnrBVFaScmrP+gwjKloFyUqdItpjWRLMGKYaJI0lJIiFF0BANpy0WUcZTzAp98HwE78QdEQkFt3IP/SMy/LLbLTayT615MdhgWftWQHv5Zp+xy6xqrIcNfDatWWzSmEctNXuSh502NkZT3XIIIz9YP26+rmm2nv4BzBPGIlVndSb103hQnxxbNGJ8Ng66QecqTwaEoVUPaqwoMdXDAx6utOKQJNjqCP3Fh3+65+Ih9XwyPQcBd+Y1J9t6kaCo45xbFCR6gl5g95/0wxnI5kJHhJn+bpVderq8/RcVTKGr1NCKwbefnaLclKj5nPbY48x4ay7AusfUrH94gXlujBz9bOSn5ba2tQKNItRvk57S1yTGlx6432kavk0sW3iyCit43rcfFu5FYhQRvVTo5WDaHd877Shi/DuAeR/gCgJc88aNfO+lTZV+kjqrr1U9fSgO7u0TDF98TPMw=="],"channel":["AMA"],"connection":["keep-alive"],"content-type":["application/json"],"host":["10.242.1.110:8989"],"user-agent":["okhttp/4.9.3"],"x-auth-token":["eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjEwMDQsMTMwMDQsMTMwMjIsOTAxMyw5MDUxLDkwNjQsOTA2NiwxMzAwNiwxMTAwMSwxMDE2LDEzMDEwLDEzMDQ1LDkwNjMsMTAyNSw5MDQ0LDkwNjUsOTAxMCwxMDAwLDEwMDgsMTAyNCwxMDM5LDEwMjAsOTA2NyIsInN1YiI6IkwxNTA2MzA1Njk2IiwiaWF0IjoxNjU1Mjk2NjIyLCJleHAiOjE2NTc0NTY2MjJ9.zjkU_RlCfWe3LdaCeU0PwWW5WUUAPLVIBw4_Jyp-8go"],"x-entity":["5"],"x-forwarded-for":["196.20.217.215"],"x-forwarded-host":["app.mytmoney.mu"],"x-forwarded-path":["/mwallet/v1/wallets/balance/L1506305696"],"x-forwarded-port":["8083"],"x-forwarded-proto":["http"],"x-msisdn":["59255800"],"x-notificationservice":["fcm"],"x-real-ip":["196.20.217.215"],"x-userid":["L1506305696"]},"body":""}

sudhagar_ramesh · June 16, 2022, 11:01am

Hello @Roshan1

The error clearly tells that there is issue with your defined Grok Pattern.

As I understand, you are trying to have two fields named hibernate and timestamp in the provided sample file. isn't it?

if that is the case this grok pattern is working fine.

%{GREEDYDATA:hibernate}\n%{GREEDYDATA:hibernate}%{TIMESTAMP_ISO8601:timestamp}

Modified Code:

input {
        file {
                start_position => "beginning"
                path => "/data/KONG1/catalina.out"
                sincedb_path => "/dev/null"
        }
}
filter {
        json {
                source => "message"
        }
}

filter {
        grok {
                match => {"message" => "%{GREEDYDATA:hibernate}\n%{GREEDYDATA:hibernate}%{TIMESTAMP_ISO8601:timestamp}"}
        }
}

output {
        elasticsearch {
                hosts => "https://es1.innov.mt:9200"
                index => "demo-json"
        ssl => true
                ssl_certificate_verification => false
                cacert => "/etc/kibana/innov_mt.crt"
                user => "mfslog"
                password => "Yaxtubular6"
        }
        stdout {}
}

Roshan1 · June 21, 2022, 6:41am

Hi

i see errors in logfile:
at [Source: (byte)"[DEBUG] 2022-06-15 16:06:25.656 (TokenService.java:98) 100366459810826 -http-nio-8989-exec-7 - Concurrent section removal , ACA, eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDAsMTIwNDUsMTAwMCwxMDE4LDkwMjEsMTAwMDUsMTAxNCw3MDAzLDYwMDEsNzAwMiwxMzAxOSw5MDI1LDYwMDAsMTAyNiw5MDA3LDMwMDEsMTAyNCwxMjAwNyw5MDY4LDEyMDQ4LDEyMDI0LDE2MDAxLDExMDAwLDEwMzQsMTIwNDQsMTIwNDcsOTA0MiwxMDAxLDEyMDQzLDEzMDExLDEwMDAzLDkwNjksMTcwMDQsMTMwNjMsMTMwMDAsOTA0NiwxMzAzMSw5MDAwLDYwMDMsOTA1MiwxMDIzLDEwMDA2LDUwMDAsMTAzMCwxMjA1MSwyMD"[truncated 1064 bytes]; line: 1, column: 8]>}
[WARN ] 2022-06-21 10:40:45.739 [[main]>worker3] json - Error parsing json {:source=>"message", :raw=>"[INFO ] 2022-06-15 16:05:45.176 (LoyaltyAccumulator.java:43) 100366459770501 -http-nio-8989-exec-4 - Skipping Point Accumulation since service ID doesn't exists", :exception=>#<LogStash::Json::ParserError: Unrecognized token 'INFO': was expecting 'null', 'true', 'false' or NaN
at [Source: (byte)"[INFO ] 2022-06-15 16:05:45.176 (LoyaltyAccumulator.java:43) 100366459770501 -http-nio-8989-exec-4 - Skipping Point Accumulation since service ID doesn't exists"; line: 1, column: 7]>}
[WARN ] 2022-06-21 10:40:45.750 [[main]>worker3] json - Error parsing json {:source=>"message", :raw=>"[INFO ] 2022-06-15 16:05:45.176 (FailedTransactionEvents.java:45) 100366459770501 -http-nio-8989-exec-4 - Inside FailedTransactionEvents", :exception=>#<LogStash::Json::ParserError: Unrecognized token 'INFO': was expecting 'null', 'true', 'false' or NaN
at [Source: (byte)"[INFO ] 2022-06-15 16:05:45.176 (FailedTransactionEvents.java:45) 100366459770501 -http-nio-8989-exec-4 - Inside FailedTransactionEvents"; line: 1, column: 7]>}
[WARN ] 2022-06-21 10:40:45.750 [[main]>worker5] json - Error parsing json {:source=>"message", :raw=>"[DEBUG] 2022-06-15 16:06:25.657 (TokenService.java:98) 100366459810826 -http-nio-8989-exec-7 - Concurrent section removal , ACA, eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDAsMTIwNDUsMTAwMCwxMDE4LDkwMjEsMTAwMDUsMTAxNCw3MDAzLDYwMDEsNzAwMiwxMzAxOSw5MDI1LDYwMDAsMTAyNiw5MDA3LDMwMDEsMTAyNCwxMjAwNyw5MDY4LDEyMDQ4LDEyMDI0LDE2MDAxLDExMDAwLDEwMzQsMTIwNDQsMTIwNDcsOTA0MiwxMDAxLDEyMDQzLDEzMDExLDEwMDAzLDkwNjksMTcwMDQsMTMwNjMsMTMwMDAsOTA0NiwxMzAzMSw5MDAwLDYwMDMsOTA1MiwxMDIzLDEwMDA2LDUwMDAsMTAzMCwxMjA1MSwyMDAyLDEzMDI3LDEzMDM5LDEwMjEsMTYwMDIsMTIwMDAsOTAwNCw5MDA5LDEzMDEwLDcwMDEsOTA0MSwxMDEyLDEwMTcsMTAwMTEsOTAyNywxMzA1OSwxMjAwMiw5MDMxLDE2MDA1LDkwMDUsMTMwMTQsMTMwMTcsMTMwMjAsOTA1NiwxMDExLDEwMDMsMTYwMDQsMTIwNDYsMTMwMzcsOTAwMSwxMzAwNSwxMzAxNiw5MDEwLDEyMDQ5LDE3MDA1LDEwMDQsOTA1NCwxMzAyMSwxMDAwMSwxNzAwMyw5MDM3LDEyMDIyLDEyMDIzLDkwMzYsOTAzNSw2MDAyLDkwMTcsOTAyNiwxMDMzLDEwMzEsMTMwMTUsMjAwMCwxMzAwMSwzMDAwLDEzMDA2LDMwMDMsMTIwNTQsOTAzNCwxMzAxOCw5MDQ4LDUwMDEsMTAxOSw5MDI4LDkwMzMsOTAzOCwxMjAyNSwxMDA3LDEzMDMyLDkwMTMsMTMwMDcsMTAyNSwxMjA1Myw5MDAzLDEwMDYsMTAwOSwxMzAyNSwxNjAwMCwxMDAwMiwxMDEwLDEwMDAwLDkwMzIsMTMwMzgsMjAwMSw1MDAyLDEzMDY0LDEwMDE5LDEwMTUsMTYwMDYsOTA0NCwxMDAxOCwxMDIwLDEwMTMsMTMwMjgsMzAwMiwxMzAyOSw3MDAwLDE3MDAwLDE3MDAxLDEyMDUyLDEzMDI2LDEzMDMwLDkwNDUsOTA0OSwxMzA2MiwxMDE2LDEyMDA2LDkwNDMsMTMwNDEsMTEwMDEsOTA1NSwxMzAyMiw5MDM5LDEwMzIsMTYwMDMsMTcwMDIsOTAwMiwxMDA4LDEwMjcsMTAyMiwxMDAxNSwxMzA0MiwxMzAwNCIsInN1YiI6IjEwMDA2OTU1IiwiaWF0IjoxNjU1Mjk0MTg4LCJleHAiOjE2NTc0NTQxODh9.tIpTuRFyDxax9HHMGRovSTjyn8TfIGRiEF4kqQJWaU||10006955", :exception=>#<LogStash::Json::ParserError: Unrecognized token 'DEBUG': was expecting ('true', 'false' or 'null')
at [Source: (byte[])"[DEBUG] 2022-06-15 16:06:25.657 (TokenService.java:98) 100366459810826 -http-nio-8989-exec-7 - Concurrent section removal , ACA, eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDAsMTIwNDUsMTAwMCwxMDE4LDkwMjEsMTAwMDUsMTAxNCw3MDAzLDYwMDEsNzAwMiwxMzAxOSw5MDI1LDYwMDAsMTAyNiw5MDA3LDMwMDEsMTAyNCwxMjAwNyw5MDY4LDEyMDQ4LDEyMDI0LDE2MDAxLDExMDAwLDEwMzQsMTIwNDQsMTIwNDcsOTA0MiwxMDAxLDEyMDQzLDEzMDExLDEwMDAzLDkwNjksMTcwMDQsMTMwNjMsMTMwMDAsOTA0NiwxMzAzMSw5MDAwLDYwMDMsOTA1MiwxMDIzLDEwMDA2LDUwMDAsMTAzMCwxMjA1MSwyMD"[truncated 1012 bytes]; line: 1, column: 8]>}
[WARN ] 2022-06-21 10:40:45.750 [[main]>worker3] json - Error parsing json {:source=>"message", :raw=>"[INFO ] 2022-06-15 16:05:45.176 (TokenValidateInterceptor.java:398) 100366459770501 -http-nio-8989-exec-4 - Request Execution Time : 18 ms", :exception=>#<LogStash::Json::ParserError: Unrecognized token 'INFO': was expecting 'null', 'true', 'false' or NaN
at [Source: (byte[])"[INFO ] 2022-06-15 16:05:45.176 (TokenValidateInterceptor.java:398) 100366459770501 -http-nio-8989-exec-4 - Request Execution Time : 18 ms"; line: 1, column: 7]>}
[WARN ] 2022-06-21 10:40:45.750 [[main]>worker5] json - Error parsing json {:source=>"message", :raw=>"[DEBUG] 2022-06-15 16:06:25.658 (TokenService.java:98) 100366459810826 -http-nio-8989-exec-7 - Concurrent section removal , ACA, eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDAsMTIwNDUsMTAwMCwxMDE4LDkwMjEsMTAwMDUsMTAxNCw3MDAzLDYwMDEsNzAwMiwxMzAxOSw5MDI1LDYwMDAsMTAyNiw5MDA3LDMwMDEsMTAyNCwxMjAwNyw5MDY4LDEyMDQ4LDEyMDI0LDE2MDAxLDExMDAwLDEwMzQsMTIwNDQsMTIwNDcsOTA0MiwxMDAxLDEyMDQzLDEzMDExLDEwMDAzLDkwNjksMTcwMDQsMTMwNjMsMTMwMDAsOTA0NiwxMzAzMSw5MDAwLDYwMDMsOTA1MiwxMDIzLDEwMDA2LDUwMDAsMTAzMCwxMjA1MSwyMDAyLDEzMDI3LDEzMDM5LDEwMjEsMTYwMDIsMTIwMDAsOTAwNCw5MDA5LDEzMDEwLDcwMDEsOTA0MSwxMDEyLDEwMTcsMTAwMTEsOTAyNywxMzA1OSwxMjAwMiw5MDMxLDE2MDA1LDkwMDUsMTMwMTQsMTMwMTcsMTMwMjAsOTA1NiwxMDExLDEwMDMsMTYwMDQsMTIwNDYsMTMwMzcsOTAwMSwxMzAwNSwxMzAxNiw5MDEwLDEyMDQ5LDE3MDA1LDEwMDQsOTA1NCwxMzAyMSwxMDAwMSwxNzAwMyw5MDM3LDEyMDIyLDEyMDIzLDkwMzYsOTAzNSw2MDAyLDkwMTcsOTAyNiwxMDMzLDEwMzEsMTMwMTUsMjAwMCwxMzAwMSwzMDAwLDEzMDA2LDMwMDMsMTIwNTQsOTAzNCwxMzAxOCw5MDQ4LDUwMDEsMTAxOSw5MDI4LDkwMzMsOTAzOCwxMjAyNSwxMDA3LDEzMDMyLDkwMTMsMTMwMDcsMTAyNSwxMjA1Myw5MDAzLDEwMDYsMTAwOSwxMzAyNSwxNjAwMCwxMDAwMiwxMDEwLDEwMDAwLDkwMzIsMTMwMzgsMjAwMSw1MDAyLDEzMDY0LDEwMDE5LDEwMTUsMTYwMDYsOTA0NCwxMDAxOCwxMDIwLDEwMTMsMTMwMjgsMzAwMiwxMzAyOSw3MDAwLDE3MDAwLDE3MDAxLDEyMDUyLDEzMDI2LDEzMDMwLDkwNDUsOTA0OSwxMzA2MiwxMDE2LDEyMDA2LDkwNDMsMTMwNDEsMTEwMDEsOTA1NSwxMzAyMiw5MDM5LDEwMzIsMTYwMDMsMTcwMDIsOTAwMiwxMDA4LDEwMjcsMTAyMiwxMDAxNSwxMzA0MiwxMzAwNCIsInN1YiI6IjEwMDA2OTU1IiwiaWF0IjoxNjU1Mjk0MTg4LCJleHAiOjE2NTc0NTQxODh9.tIpTuRFyDxax9HHMGRovSTjyn8TfIGRiEF4kqQJWaU||1655294208703_9e0eeb3b-69a0-485b-a2d3-2365ea61b0be||10006955", :exception=>#<LogStash::Json::ParserError: Unrecognized token 'DEBUG': was expecting ('true', 'false' or 'null')
at [Source: (byte[])"[DEBUG] 2022-06-15 16:06:25.658 (TokenService.java:98) 100366459810826 -http-nio-8989-exec-7 - Concurrent section removal , ACA, eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDAsMTIwNDUsMTAwMCwxMDE4LDkwMjEsMTAwMDUsMTAxNCw3MDAzLDYwMDEsNzAwMiwxMzAxOSw5MDI1LDYwMDAsMTAyNiw5MDA3LDMwMDEsMTAyNCwxMjAwNyw5MDY4LDEyMDQ4LDEyMDI0LDE2MDAxLDExMDAwLDEwMzQsMTIwNDQsMTIwNDcsOTA0MiwxMDAxLDEyMDQzLDEzMDExLDEwMDAzLDkwNjksMTcwMDQsMTMwNjMsMTMwMDAsOTA0NiwxMzAzMSw5MDAwLDYwMDMsOTA1MiwxMDIzLDEwMDA2LDUwMDAsMTAzMCwxMjA1MSwyMD"[truncated 1064 bytes]; line: 1, column: 8]>}
[WARN ] 2022-06-21 10:40:45.751 [[main]>worker5] json - Error parsing json {:source=>"message", :raw=>"[DEBUG] 2022-06-15 16:06:25.659 (SqlStatementLogger.java:128) 100366459810826 -http-nio-8989-exec-7 - select profilemas0.PROFILE_ID as profile_id1_110_0, profilemas0_.CHANNEL_TYPE_ID as channel_type_id2_110_0_, profilemas0_.CREATED_USER as created_user3_110_0_, profilemas0_.CREATED_DATE as created_date4_110_0_, profilemas0_.CREDIT_LIMIT as credit_limit5_110_0_, profilemas0_.ENTITY as entity6_110_0_, profilemas0_.MAX_WALLET_BALANCE as max_wallet_balance7_110_0_, profilemas0_.MIN_WALLET_BALANCE as min_wallet_balance8_110_0_, profilemas0_.PROFILE_NAME as profile_name9_110_0_, profilemas0_.STATUS as status10_110_0_ from MFS_PROFILE_MASTER profilemas0_ where profilemas0_.PROFILE_ID=?", :exception=>#<LogStash::Json::ParserError: Unrecognized token 'DEBUG': was expecting ('true', 'false' or 'null')
at [Source: (byte)"[DEBUG] 2022-06-15 16:06:25.659 (SqlStatementLogger.java:128) 100366459810826 -http-nio-8989-exec-7 - select profilemas0_.PROFILE_ID as profile_id1_110_0_, profilemas0_.CHANNEL_TYPE_ID as channel_type_id2_110_0_, profilemas0_.CREATED_USER as created_user3_110_0_, profilemas0_.CREATED_DATE as created_date4_110_0_, profilemas0_.CREDIT_LIMIT as credit_limit5_110_0_, profilemas0_.ENTITY as entity6_110_0_, profilemas0_.MAX_WALLET_BALANCE as max_wallet_balance7_110_0_, profilemas0_.MIN_WALLET_BALANCE "[truncated 189 bytes]; line: 1, column: 8]>}
[ERROR] 2022-06-21 10:40:45.748 [[main]>worker6] javapipeline - Pipeline worker error, the pipeline will be stopped {:pipeline_id=>"main", :error=>"(NoMethodError) undefined method `pop' for nil:NilClass", :exception=>Java::OrgJrubyExceptions::NoMethodError, :backtrace=>["usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.amazing_print_minus_1_dot_4_dot_0.lib.amazing_print.inspector.awesome(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/amazing_print-1.4.0/lib/amazing_print/inspector.rb:93)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.amazing_print_minus_1_dot_4_dot_0.lib.amazing_print.core_ext.kernel.ai(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/amazing_print-1.4.0/lib/amazing_print/core_ext/kernel.rb:11)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_codec_minus_rubydebug_minus_3_dot_1_dot_0.lib.logstash.codecs.rubydebug.encode_default(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-codec-rubydebug-3.1.0/lib/logstash/codecs/rubydebug.rb:38)", "org.jruby.RubyMethod.call(org/jruby/RubyMethod.java:119)", "usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.logstash_minus_codec_minus_rubydebug_minus_3_dot_1_dot_0.lib.logstash.codecs.rubydebug.encode(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-codec-rubydebug-3.1.0/lib/logstash/codecs/rubydebug.rb:34)", "usr.share.logstash.logstash_minus_core.lib.logstash.codecs.base.multi_encode(/usr/share/logstash/logstash-core/lib/logstash/codecs/base.rb:64)", "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1821)", "usr.share.logstash.logstash_minus_core.lib.logstash.codecs.base.multi_encode(/usr/share/logstash/logstash-core/lib/logstash/codecs/base.rb:64)", "usr.share.logstash.logstash_minus_core.lib.logstash.codecs.delegator.multi_encode(/usr/share/logstash/logstash-core/lib/logstash/codecs/delegator.rb:55)", "org.logstash.instrument.metrics.AbstractSimpleMetricExt.time(org/logstash/instrument/metrics/AbstractSimpleMetricExt.java:65)", "org.logstash.instrument.metrics.AbstractNamespacedMetricExt.time(org/logstash/instrument/metrics/AbstractNamespacedMetricExt.java:64)", "usr.share.logstash.logstash_minus_core.lib.logstash.codecs.delegator.multi_encode(/usr/share/logstash/logstash-core/lib/logstash/codecs/delegator.rb:54)", "usr.share.logstash.logstash_minus_core.lib.logstash.outputs.base.multi_receive(/usr/share/logstash/logstash-core/lib/logstash/outputs/base.rb:103)", "org.logstash.config.ir.compiler.OutputStrategyExt$AbstractOutputStrategyExt.multi_receive(org/logstash/config/ir/compiler/OutputStrategyExt.java:143)", "org.logstash.config.ir.compiler.AbstractOutputDelegatorExt.multi_receive(org/logstash/config/ir/compiler/AbstractOutputDelegatorExt.java:121)", "usr.share.logstash.logstash_minus_core.lib.logstash.java_pipeline.start_workers(/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:299)"], :thread=>"#<Thread:0x121fc8ef sleep>"}
[WARN ] 2022-06-21 10:40:45.741 [[main]>worker1] json - Error parsing json {:source=>"message", :raw=>"[DEBUG] 2022-06-15 16:06:52.089 (TokenValidateInterceptor.java:300) 100366459837428 -http-nio-8989-exec-1 - Decrypted token : eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjEwMzksOTA2NSwxMDI0LDkwNjMsMTAyNSwxMDIwLDkwMTMsOTA2NywxMTAwMSw5MDUxLDEzMDA2LDEzMDIyLDEwMTYsMTAwMCwxMzAwNCwxMDA0LDkwNjYsMTMwMTAsMTMwNDUsMTAwOCw5MDQ0LDkwMTAsOTA2NCIsInN1YiI6IkwxOTc5NTkyNjExIiwiaWF0IjoxNjU1Mjk0NjYyLCJleHAiOjE2NTc0NTQ2NjJ9.4NzKHFOniVCI-rGpzyUZT00_oyC1fo4yX5B7WIe6hls||1655294810858_ebc2ad1c-a370-4cd6-a415-423d064c38fb", :exception=>#<LogStash::Json::ParserError: Unrecognized token 'DEBUG': was expecting ('true', 'false' or 'null')
at [Source: (byte)"[DEBUG] 2022-06-15 16:06:52.089 (TokenValidateInterceptor.java:300) 100366459837428 -http-nio-8989-exec-1 - Decrypted token : eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjEwMzksOTA2NSwxMDI0LDkwNjMsMTAyNSwxMDIwLDkwMTMsOTA2NywxMTAwMSw5MDUxLDEzMDA2LDEzMDIyLDEwMTYsMTAwMCwxMzAwNCwxMDA0LDkwNjYsMTMwMTAsMTMwNDUsMTAwOCw5MDQ0LDkwMTAsOTA2NCIsInN1YiI6IkwxOTc5NTkyNjExIiwiaWF0IjoxNjU1Mjk0NjYyLCJleHAiOjE2NTc0NTQ2NjJ9.4NzKHFOniVCI-rGpzyUZT00_oyC1fo4yX5B7WIe6hls||1655294810858_ebc2ad1c-a370-4cd6-a415-423d064c38fb"; line: 1, column: 8]>}
[WARN ] 2022-06-21 10:40:45.741 [[main]>worker7] json - Error parsing json {:source=>"message", :raw=>"[DEBUG] 2022-06-15 16:06:52.650 (LogFormatUtils.java:91) 100366459837986 -http-nio-8989-exec-7 - Read "application/json;charset=UTF-8" to [com.sixdee.wallet.core.beans.Merchant@1845a544]", :exception=>#<LogStash::Json::ParserError: Unrecognized token 'DEBUG': was expecting ('true', 'false' or 'null')
at [Source: (byte)"[DEBUG] 2022-06-15 16:06:52.650 (LogFormatUtils.java:91) 100366459837986 -http-nio-8989-exec-7 - Read "application/json;charset=UTF-8" to [com.sixdee.wallet.core.beans.Merchant@1845a544]"; line: 1, column: 8]>}
[WARN ] 2022-06-21 10:40:45.741 [[main]>worker2] json - Error parsing json {:source=>"message", :raw=>"[INFO ] 2022-06-15 16:06:12.284 (NotificationBuilder.java:72) 100366459797617 -http-nio-8989-exec-2 - Skipping Notification since service ID not exists", :exception=>#<LogStash::Json::ParserError: Unrecognized token 'INFO': was expecting 'null', 'true', 'false' or NaN
at [Source: (byte)"[INFO ] 2022-06-15 16:06:12.284 (NotificationBuilder.java:72) 100366459797617 -http-nio-8989-exec-2 - Skipping Notification since service ID not exists"; line: 1, column: 7]>}
[WARN ] 2022-06-21 10:40:45.750 [[main]>worker3] json - Error parsing json {:source=>"message", :raw=>"[DEBUG] 2022-06-15 16:05:45.176 (FrameworkServlet.java:1131) -http-nio-8989-exec-4 - Completed 200 OK", :exception=>#<LogStash::Json::ParserError: Unrecognized token 'DEBUG': was expecting ('true', 'false' or 'null')
at [Source: (byte)"[DEBUG] 2022-06-15 16:05:45.176 (FrameworkServlet.java:1131) -http-nio-8989-exec-4 - Completed 200 OK"; line: 1, column: 8]>}

sudhagar_ramesh · June 21, 2022, 8:23am

Hello @Roshan1

Could you share the input file's few sample lines.

Roshan1 · June 21, 2022, 9:37am

[DEBUG] 2022-06-15 15:57:44.011 (LogFormatUtils.java:91)  -http-nio-8989-exec-6 - GET "/mwallet/v1/rate/merchant/getRating/122115", parameters={}
[DEBUG] 2022-06-15 15:57:44.013 (TokenValidateInterceptor.java:327) 100366459289349 -http-nio-8989-exec-1 - AuthenticationFilter is passing request down the filter chain
[DEBUG] 2022-06-15 15:57:44.014 (SqlStatementLogger.java:128) 100366459289349 -http-nio-8989-exec-1 - select cdrmaster0_.TRANSACTION_ID as transaction_id1_21_0_, cdrmaster0_.ACCOUNT_NUMBER as account_number2_21_0_, cdrmaster0_.BANK_BIC as bank_bic3_21_0_, cdrmaster0_.BANK_ID as bank_id92_21_0_, cdrmaster0_.BONUS as bonus11_21_0_, cdrmaster0_.CHANNEL_ID as channel_id13_21_0_, cdrmaster0_.COMMISSION_BENEF as commission_benef93_21_0_, cdrmaster0_.COMMISSION as commission15_21_0_, cdrmaster0_.COUPON_CODE as coupon_code16_21_0_, cdrmaster0_.COUPON_CODE_AMOUNT as coupon_code_amoun17_21_0_, cdrmaster0_.DATE_INDEX as date_index94_21_0_, cdrmaster0_.DEST_BAL_AFTER as dest_bal_after18_21_0_, cdrmaster0_.DEST_BAL_BEFORE as dest_bal_before19_21_0_, cdrmaster0_.DEST_BUSINESS_CATEGORY as dest_business_cat20_21_0_, cdrmaster0_.DEST_BUSINESS_NAME as dest_business_nam21_21_0_, cdrmaster0_.DEST_BUSINESS_TYPE as dest_business_typ22_21_0_, cdrmaster0_.DEST_ENTITY_TYPE as dest_entity_type29_21_0_, cdrmaster0_.DEST_ERP_CODE as dest_erp_code30_21_0_, cdrmaster0_.DEST_FULL_NAME as dest_full_name31_21_0_, cdrmaster0_.DEST_ID_NUMBER as dest_id_number32_21_0_, cdrmaster0_.DEST_ID_TYPE as dest_id_type33_21_0_, cdrmaster0_.DEST_LEVEL as dest_level95_21_0_, cdrmaster0_.DEST_LOCATION as dest_location34_21_0_, cdrmaster0_.DEST_MSISDN as dest_msisdn35_21_0_, cdrmaster0_.DEST_PARENT_ID as dest_parent_id96_21_0_, cdrmaster0_.DEST_PROFILE_ID as dest_profile_id36_21_0_, cdrmaster0_.DEST_PROFILE_PIC as dest_profile_pic97_21_0_, cdrmaster0_.DEST_USER_ID as dest_user_id37_21_0_, cdrmaster0_.DEST_WALLET_TYPE_ID as dest_wallet_type_38_21_0_, cdrmaster0_.DURATION as duration39_21_0_, cdrmaster0_.EXT_ERROR_CODE as ext_error_code40_21_0_, cdrmaster0_.EXT_ERROR_SYSTEM_ID as ext_error_system_41_21_0_, cdrmaster0_.EXT_MESSAGE as ext_message42_21_0_, cdrmaster0_.EXT_TRANSACTION_ID as ext_transaction_i44_21_0_, cdrmaster0_.SERVICE_FEE as service_fee45_21_0_, cdrmaster0_.SERVICE_FEE_BENEF as service_fee_benef98_21_0_, cdrmaster0_.IDENTIFIER as identifier99_21_0_, cdrmaster0_.LOYALITY_PACK as loyality_pack46_21_0_, cdrmaster0_.LOYALITY_POINTS as loyality_points48_21_0_, cdrmaster0_.MASTER_SERVICE_ID as master_service_i100_21_0_, cdrmaster0_.MOP_ID as mop_id101_21_0_, cdrmaster0_.ORDER_ID as order_id49_21_0_, cdrmaster0_.ORIG_BAL_AFTER as orig_bal_after50_21_0_, cdrmaster0_.ORIG_BAL_BEFORE as orig_bal_before51_21_0_, cdrmaster0_.ORIG_BUSINESS_CATEGORY as orig_business_cat52_21_0_, cdrmaster0_.ORIG_BUSINESS_NAME as orig_business_nam53_21_0_, cdrmaster0_.ORIG_BUSINESS_TYPE as orig_business_typ54_21_0_, cdrmaster0_.ORIG_ENTITY_TYPE as orig_entity_type61_21_0_, cdrmaster0_.ORIG_ERP_CODE as orig_erp_code62_21_0_, cdrmaster0_.ORIG_FULL_NAME as orig_full_name63_21_0_, cdrmaster0_.ORIG_ID_NUMBER as orig_id_number64_21_0_, cdrmaster0_.ORIG_ID_TYPE as orig_id_type65_21_0_, cdrmaster0_.ORIG_LEVEL as orig_level102_21_0_, cdrmaster0_.ORIG_LOCATION as orig_location66_21_0_, cdrmaster0_.ORIG_MSISDN as orig_msisdn67_21_0_, cdrmaster0_.ORIG_PARENT_ID as orig_parent_id68_21_0_, cdrmaster0_.ORIG_PROFILE_ID as orig_profile_id69_21_0_, cdrmaster0_.ORIG_PROFILE_PIC as orig_profile_pic103_21_0_, cdrmaster0_.ORIG_USER_ID as orig_user_id70_21_0_, cdrmaster0_.ORIG_WALLET_TYPE_ID as orig_wallet_type_71_21_0_, cdrmaster0_.OTHER_BAL_AFTER as other_bal_after104_21_0_, cdrmaster0_.OTHER_BAL_BEFORE as other_bal_before105_21_0_, cdrmaster0_.OTHER_ERP_CODE as other_erp_code106_21_0_, cdrmaster0_.OTHER_FULL_NAME as other_full_name107_21_0_, cdrmaster0_.OTHER_USER_ID as other_user_id108_21_0_, cdrmaster0_.OTHER_WALLET_TYPE_ID as other_wallet_typ109_21_0_, cdrmaster0_.POS_ID as pos_id110_21_0_, cdrmaster0_.RECEIVER_BONUS as receiver_bonus72_21_0_, cdrmaster0_.REFERENCE_NO as reference_no73_21_0_, cdrmaster0_.REFERRED_BY as referred_by74_21_0_, cdrmaster0_.REMARKS as remarks75_21_0_, cdrmaster0_.REQUEST_ID as request_id76_21_0_, cdrmaster0_.RF_1 as RF_77_21_0_, cdrmaster0_.RF_2 as RF_78_21_0_, cdrmaster0_.RF_3 as RF_79_21_0_, cdrmaster0_.RF_4 as RF_80_21_0_, cdrmaster0_.RF_5 as RF_81_21_0_, cdrmaster0_.SERVICE_ID as service_id82_21_0_, cdrmaster0_.STATUS_CODE as status_code84_21_0_, cdrmaster0_.STATUS_TYPE as status_type85_21_0_, cdrmaster0_.SYS_BAL_AFTER as sys_bal_after86_21_0_, cdrmaster0_.SYS_BAL_BEFORE as sys_bal_before87_21_0_, cdrmaster0_.SYS_WALLET_TYPE_ID as sys_wallet_type_i88_21_0_, cdrmaster0_.TAX as tax89_21_0_, cdrmaster0_.TO_ACCOUNT_NUMBER as to_account_numbe111_21_0_, cdrmaster0_.TO_BANK_ID as to_bank_id112_21_0_, cdrmaster0_.TRANSACTION_AMOUNT as transaction_amoun90_21_0_, cdrmaster0_.TRANSACTION_DATE as transaction_date91_21_0_ from MFS_CDR_MASTER cdrmaster0_ where cdrmaster0_.TRANSACTION_ID=?
[DEBUG] 2022-06-15 15:57:44.014 (AbstractHandlerMapping.java:415)  -http-nio-8989-exec-6 - Mapped to com.sixdee.wallet.core.controller.MerchantRatingController#viewMerchantRating(String)
[DEBUG] 2022-06-15 15:57:44.016 (TokenValidateInterceptor.java:291) 100366459289357 -http-nio-8989-exec-6 - Authentication Session Token : eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDksMTAwMCwxMzA2Myw5MDU2LDkwMzcsOTAwOSw5MDM2LDEzMDY0LDkwMDIsOTAxMCw5MDIxLDkwMzgsMTYwMDYsMTYwMDUsOTA0NCw5MDY4LDE2MDA0LDEwMDgsMTMwNTksOTA0MSwxMDIwLDEwMTQsMTAzMSwxMzAxMCwxMDMwLDEzMDExLDkwNDUsMTMwMjAsOTA0OCwxNjAwMiw5MDAzLDkwNDIsOTA0Myw5MDM5LDkwNjksOTAwNSwxNjAwMCw5MDU0LDkwMTMsOTA1NSw5MDA0LDEwMTcsMTYwMDMsMTAwOSw5MDA3Iiwic3ViIjoiMTIyMTE1IiwiaWF0IjoxNjU1Mjk0MjA0LCJleHAiOjE2NTc0NTQyMDR9.MZIHmKeH6pddin4jspcO0xFiTgEnyZn9NNZR6YsFTug User Id : 122115 Msisdn : 55667788
[DEBUG] 2022-06-15 15:57:44.017 (TokenValidateInterceptor.java:294) 100366459289357 -http-nio-8989-exec-6 - Authentication  Token : k+8L2WYQXYgbTgpk8EkduH+ml5ZYtKPvdD1JY9E72AnrBVFaScmrP2xkqjYMN4v+UHnERX+bw7Bd+7h35RPo3aSTQ2gl2P0SSYmGMUC4eGE4PIFv88TbIyfftpG45GRy4Xbt6ZT9wLqaL0mc71rZPP++opJYoboWJHgIk7AoBE9eM+ov9QdCzjvkPR+Q1j2D7XJ0+8Wp/9RN6k6iw1bGRjamxXypIct8+FOfxaUScaMYTEvtzDxzmoLhhIqhxJIZvEe3GXpEBgunvTuKQg04tIJ39Lp/dYU12Hj3Nhau6WYUGE4Goz3wraeBsD/vin43ZU5V0zFAww99PCx+jhcCABTaJIQwaSTuumdbOffostVWYhYuP+gsnzsrMBcF0i6oea2dLBNXFETEeFsI81TMI0GX+0/0NbvMamiQk1UK8zfz7Wbtg2dhQXpfq+89NM1wbRrvyB4/oR4iy7XjeGe8NAMDJnTLchFqd0d5HNQWSmHHXYB7YFYZqjKS6XBguzDZkP/+HesZcIvobxYb5L1Vg8EyhZStOoU1IhAgLKCYwBXi0xbrGBSXKK5gZgr4gGi2397GJySUhRnqI0Reg8qYKuS3GBNV/TydM342TyNmQAnCmBI38Av3CMoktscMadPfb65Ai7vuo8LSG04/uo8ggaC+ooaSa+ngbjpNHFicDg5LrgRBMkmwTOyOyHt8HXM3 User Id : 122115 Msisdn : 55667788
[DEBUG] 2022-06-15 15:57:44.017 (TokenValidateInterceptor.java:300) 100366459289357 -http-nio-8989-exec-6 - Decrypted token : eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDksMTAwMCwxMzA2Myw5MDU2LDkwMzcsOTAwOSw5MDM2LDEzMDY0LDkwMDIsOTAxMCw5MDIxLDkwMzgsMTYwMDYsMTYwMDUsOTA0NCw5MDY4LDE2MDA0LDEwMDgsMTMwNTksOTA0MSwxMDIwLDEwMTQsMTAzMSwxMzAxMCwxMDMwLDEzMDExLDkwNDUsMTMwMjAsOTA0OCwxNjAwMiw5MDAzLDkwNDIsOTA0Myw5MDM5LDkwNjksOTAwNSwxNjAwMCw5MDU0LDkwMTMsOTA1NSw5MDA0LDEwMTcsMTYwMDMsMTAwOSw5MDA3Iiwic3ViIjoiMTIyMTE1IiwiaWF0IjoxNjU1Mjk0MjA0LCJleHAiOjE2NTc0NTQyMDR9.MZIHmKeH6pddin4jspcO0xFiTgEnyZn9NNZR6YsFTug||1655294261537_66bc60c6-e432-497f-b849-6aea51f9afdf
[DEBUG] 2022-06-15 15:57:44.020 (TokenValidateInterceptor.java:327) 100366459289357 -http-nio-8989-exec-6 - AuthenticationFilter is passing request down the filter chain
[DEBUG] 2022-06-15 15:57:44.021 (SqlStatementLogger.java:128) 100366459289357 -http-nio-8989-exec-6 - select merchantra0_.USER_ID as user_id1_79_0_, merchantra0_.RATING as rating2_79_0_, merchantra0_.VOTES as votes3_79_0_ from MFS_MERCHANT_RATING merchantra0_ where merchantra0_.USER_ID=?
[INFO ] 2022-06-15 15:57:44.023 (MerchantRatingServiceImpl.java:70) 100366459289357 -http-nio-8989-exec-6 - Rating not available for user : 122115
[DEBUG] 2022-06-15 15:57:44.023 (AbstractMessageConverterMethodProcessor.java:255) 100366459289357 -http-nio-8989-exec-6 - Using 'application/json', given [*/*] and supported [application/json]
[DEBUG] 2022-06-15 15:57:44.023 (LogFormatUtils.java:91) 100366459289357 -http-nio-8989-exec-6 - Writing [com.sixdee.wallet.account.domain.MerchantRatingEntity@5c4b082]
[INFO ] 2022-06-15 15:57:44.024 (CdrBuilder.java:54) 100366459289357 -http-nio-8989-exec-6 - Skipping CDR since service ID not exists
[INFO ] 2022-06-15 15:57:44.024 (CdrSystemIncomeBuilder.java:56) 100366459289357 -http-nio-8989-exec-6 - Skipping INC CDR since service ID not exists
[INFO ] 2022-06-15 15:57:44.024 (CdrSystemExpenseBuilder.java:56) 100366459289357 -http-nio-8989-exec-6 - Skipping EXP CDR since service ID not exists
[INFO ] 2022-06-15 15:57:44.024 (CdrSystemCollectionBuilder.java:56) 100366459289357 -http-nio-8989-exec-6 - Skipping SYS COLLECTION CDR since service ID not exists
[INFO ] 2022-06-15 15:57:44.024 (CdrSystemCFBuilder.java:56) 100366459289357 -http-nio-8989-exec-6 - Skipping CF CDR since service ID not exists
[INFO ] 2022-06-15 15:57:44.024 (NotificationBuilder.java:72) 100366459289357 -http-nio-8989-exec-6 - Skipping Notification since service ID not exists
[DEBUG] 2022-06-15 15:57:44.027 (ManageUsage.java:148) 100366459289357 -http-nio-8989-exec-6 - Skipping Usage. Service 0, Is User null false, StatusCode null, StatusType Null
[INFO ] 2022-06-15 15:57:44.027 (LoyaltyAccumulator.java:43) 100366459289357 -http-nio-8989-exec-6 - Skipping Point Accumulation since service ID doesn't exists
[INFO ] 2022-06-15 15:57:44.027 (FailedTransactionEvents.java:45) 100366459289357 -http-nio-8989-exec-6 - Inside FailedTransactionEvents
[INFO ] 2022-06-15 15:57:44.027 (TokenValidateInterceptor.java:398) 100366459289357 -http-nio-8989-exec-6 - Request Execution Time : 13 ms
[DEBUG] 2022-06-15 15:57:44.027 (FrameworkServlet.java:1131)  -http-nio-8989-exec-6 - Completed 200 OK
[TRACE] 2022-06-15 15:57:44.028 (DefaultHttpLogWriter.java:84)  -http-nio-8989-exec-6 - {"origin":"local","type":"response","correlation":"b9fea89028fc0c8f","duration":18,"protocol":"HTTP/1.1","status":200,"headers":{"Cache-Control":["no-cache, no-store, max-age=0, must-revalidate"],"Connection":["keep-alive"],"Content-Type":["application/json"],"Date":["Wed, 15 Jun 2022 11:57:44 GMT"],"Expires":["0"],"Keep-Alive":["timeout=20"],"Pragma":["no-cache"],"RCF":["/v1/rate/merchant/getRating/122115"],"Set-Cookie":["JSESSIONID=6B0DE3E972801EFD9648E608E1C16ECD; Path=/mwallet; HttpOnly"],"Transfer-Encoding":["chunked"],"Vary":["Origin","Access-Control-Request-Method","Access-Control-Request-Headers","Origin","Access-Control-Request-Method","Access-Control-Request-Headers","Origin","Access-Control-Request-Method","Access-Control-Request-Headers"],"X-Content-Type-Options":["nosniff"],"X-Frame-Options":["DENY"],"X-TransctionId":["100366459289357"],"X-XSS-Protection":["1; mode=block"]},"body":{"userId":"122115","rating":0.0,"votes":0}}
[DEBUG] 2022-06-15 15:57:44.032 (SqlStatementLogger.java:128) 100366459289349 -http-nio-8989-exec-1 - select statuscode0_.STATUS_CODE as status_code1_147_0_, statuscode0_.CREATED_DATE as created_date2_147_0_, statuscode0_.CREATED_USER as created_user3_147_0_, statuscode0_.STATUS_DESC as status_desc4_147_0_, statuscode0_.STATUS_TYPE as status_type5_147_0_ from MFS_STATUS_CODES statuscode0_ where statuscode0_.STATUS_CODE=?
[DEBUG] 2022-06-15 15:57:44.042 (SqlStatementLogger.java:128) 100366459289349 -http-nio-8989-exec-1 - select usermaster0_.USER_ID as user_id1_178_, usermaster0_.ACTIVATED_DATE as activated_date2_178_, usermaster0_.MM_APP_LAST_UPDATE_DATE as mm_app_last_update3_178_, usermaster0_.MM_APP_VERSION as mm_app_version4_178_, usermaster0_.CHANNEL_TYPE as channel_type5_178_, usermaster0_.COMU_EMAIL as comu_email6_178_, usermaster0_.CONTACT_EMAIL_ID as contact_email_id7_178_, usermaster0_.CONTACT_MSISDN as contact_msisdn8_178_, usermaster0_.CONTRACT_END_DATE as contract_end_date9_178_, usermaster0_.CONTRACT_START_DATE as contract_start_da10_178_, usermaster0_.CREATED_BY as created_by11_178_, usermaster0_.DESIGNATION as designation12_178_, usermaster0_.DEVICE_ID as device_id13_178_, usermaster0_.DEVICE_ID_FLAG as device_id_flag14_178_, usermaster0_.DOB as dob15_178_, usermaster0_.DOC_NAME as doc_name16_178_, usermaster0_.EMAIL_ID as email_id17_178_, usermaster0_.ENTITY_TYPE as entity_type18_178_, usermaster0_.ERP_CODE as erp_code19_178_, usermaster0_.FACE_ACCURACY as face_accuracy20_178_, usermaster0_.FATHER_NAME as father_name21_178_, usermaster0_.FCM_TOKEN as fcm_token22_178_, usermaster0_.FIRST_CASHIN_PENDING as first_cashin_pend23_178_, usermaster0_.FIRST_NAME as first_name24_178_, usermaster0_.GENDER as gender25_178_, usermaster0_.HIER_ID as hier_id26_178_, usermaster0_.MONTHLY_INCOME as monthly_income27_178_, usermaster0_.IS_FREE_ACCOUNT as is_free_account28_178_, usermaster0_.IS_MIGRATED as is_migrated29_178_, usermaster0_.IS_POSTPAID as is_postpaid30_178_, usermaster0_.JOB_NAME as job_name31_178_, usermaster0_.JOB_STARTED as job_started32_178_, usermaster0_.KYC_VERIFIED as kyc_verified33_178_, usermaster0_.LABEL_ID as label_id34_178_, usermaster0_.LANGUAGE_ID as language_id35_178_, usermaster0_.LAST_NAME as last_name36_178_, usermaster0_.LAST_FINANCIAL_TXN_DATE as last_financial_tx37_178_, usermaster0_.LATITUDE as latitude38_178_, usermaster0_.LIMIT_FLAG as limit_flag39_178_, usermaster0_.LONGITUDE as longitude40_178_, usermaster0_.MARITAL_STATUS as marital_status41_178_, usermaster0_.MSISDN as msisdn42_178_, usermaster0_.NATIONALITY_ID as nationality_id43_178_, usermaster0_.NOTIFICATION_SERVICE_TYPE as notification_serv44_178_, usermaster0_.OFFICIAL_EMAIL_ID as official_email_id45_178_, usermaster0_.PARENT_ID as parent_id46_178_, usermaster0_.POW as pow47_178_, usermaster0_.PROFILE_ID as profile_id48_178_, usermaster0_.PROFILE_PICTURE_ID as profile_picture_i49_178_, usermaster0_.PROMO_FLAG_REQUIRED as promo_flag_requir50_178_, usermaster0_.QUALIFICATION as qualification51_178_, usermaster0_.REASON as reason52_178_, usermaster0_.REFERRED_BY as referred_by53_178_, usermaster0_.REGISTERED_DATE as registered_date54_178_, usermaster0_.SALUTE as salute55_178_, usermaster0_.SOFT_DELETE as soft_delete56_178_, usermaster0_.SRC_OF_FUND as src_of_fund57_178_, usermaster0_.USER_STATUS as user_status58_178_ from MFS_USER_MASTER usermaster0_ where usermaster0_.USER_ID=?
[DEBUG] 2022-06-15 15:57:44.073 (SqlStatementLogger.java:128) 100366459289349 -http-nio-8989-exec-1 - select settlement0_.TRANSACTION_ID as transaction_id1_137_0_, settlement0_.BAL_AFTER as bal_after2_137_0_, settlement0_.BAL_BEFORE as bal_before3_137_0_, settlement0_.CHANNEL_ID as channel_id4_137_0_, settlement0_.CHANNEL_NAME as channel_name5_137_0_, settlement0_.CHANNEL_TYPE as channel_type6_137_0_, settlement0_.CHANNEL_TYPE_ID as channel_type_id7_137_0_, settlement0_.DATE_INDEX as date_index8_137_0_, settlement0_.ENTITY_TYPE as entity_type9_137_0_, settlement0_.FULL_NAME as full_name10_137_0_, settlement0_.IDENTIFIER as identifier11_137_0_, settlement0_.MSISDN as msisdn12_137_0_, settlement0_.OTHER_PROFILE_PIC as other_profile_pic13_137_0_, settlement0_.OTHER_USER_ID as other_user_id14_137_0_, settlement0_.OTHER_USER_NAME as other_user_name15_137_0_, settlement0_.REMARKS as remarks16_137_0_, settlement0_.REQUEST_ID as request_id17_137_0_, settlement0_.SERVICE_ID as service_id18_137_0_, settlement0_.SERVICE_NAME as service_name19_137_0_, settlement0_.TRANSACTION_AMOUNT as transaction_amoun20_137_0_, settlement0_.TRANSACTION_DATE as transaction_date21_137_0_, settlement0_.TRANSACTION_TYPE as transaction_type22_137_0_, settlement0_.USER_ID as user_id23_137_0_, settlement0_.WALLET_TYPE_ID as wallet_type_id24_137_0_ from MFS_SETTLEMENT settlement0_ where settlement0_.TRANSACTION_ID=?
[DEBUG] 2022-06-15 15:57:44.090 (AbstractMessageConverterMethodProcessor.java:255) 100366459289349 -http-nio-8989-exec-1 - Using 'application/json', given [*/*] and supported [application/json]
[DEBUG] 2022-06-15 15:57:44.090 (LogFormatUtils.java:91) 100366459289349 -http-nio-8989-exec-1 - Writing [com.sixdee.wallet.reports.beans.Transaction@52c19428]
[INFO ] 2022-06-15 15:57:44.091 (CdrBuilder.java:54) 100366459289349 -http-nio-8989-exec-1 - Skipping CDR since service ID not exists
[INFO ] 2022-06-15 15:57:44.091 (CdrSystemIncomeBuilder.java:56) 100366459289349 -http-nio-8989-exec-1 - Skipping INC CDR since service ID not exists
[INFO ] 2022-06-15 15:57:44.091 (CdrSystemExpenseBuilder.java:56) 100366459289349 -http-nio-8989-exec-1 - Skipping EXP CDR since service ID not exists
[INFO ] 2022-06-15 15:57:44.091 (CdrSystemCollectionBuilder.java:56) 100366459289349 -http-nio-8989-exec-1 - Skipping SYS COLLECTION CDR since service ID not exists
[INFO ] 2022-06-15 15:57:44.091 (CdrSystemCFBuilder.java:56) 100366459289349 -http-nio-8989-exec-1 - Skipping CF CDR since service ID not exists
[INFO ] 2022-06-15 15:57:44.091 (NotificationBuilder.java:72) 100366459289349 -http-nio-8989-exec-1 - Skipping Notification since service ID not exists
[DEBUG] 2022-06-15 15:57:44.093 (ManageUsage.java:148) 100366459289349 -http-nio-8989-exec-1 - Skipping Usage. Service 0, Is User null false, StatusCode null, StatusType Null
[INFO ] 2022-06-15 15:57:44.093 (LoyaltyAccumulator.java:43) 100366459289349 -http-nio-8989-exec-1 - Skipping Point Accumulation since service ID doesn't exists
[INFO ] 2022-06-15 15:57:44.094 (FailedTransactionEvents.java:45) 100366459289349 -http-nio-8989-exec-1 - Inside FailedTransactionEvents
[INFO ] 2022-06-15 15:57:44.094 (TokenValidateInterceptor.java:398) 100366459289349 -http-nio-8989-exec-1 - Request Execution Time : 88 ms
[DEBUG] 2022-06-15 15:57:44.094 (FrameworkServlet.java:1131)  -http-nio-8989-exec-1 - Completed 200 OK
[TRACE] 2022-06-15 15:57:44.095 (DefaultHttpLogWriter.java:84)  -http-nio-8989-exec-1 - {"origin":"local","type":"response","correlation":"a9e8451e89086035","duration":89,"protocol":"HTTP/1.1","status":200,"headers":{"Cache-Control":["no-cache, no-store, max-age=0, must-revalidate"],"Connection":["keep-alive"],"Content-Type":["application/json"],"Date":["Wed, 15 Jun 2022 11:57:44 GMT"],"Expires":["0"],"Keep-Alive":["timeout=20"],"Pragma":["no-cache"],"RCF":["/v1/transactioninfo/view"],"Set-Cookie":["JSESSIONID=8029916ED6EC91781F5CCF75A204D369; Path=/mwallet; HttpOnly"],"Transfer-Encoding":["chunked"],"Vary":["Origin","Access-Control-Request-Method","Access-Control-Request-Headers","Origin","Access-Control-Request-Method","Access-Control-Request-Headers","Origin","Access-Control-Request-Method","Access-Control-Request-Headers"],"X-Content-Type-Options":["nosniff"],"X-Frame-Options":["DENY"],"X-TransctionId":["100366459289349"],"X-XSS-Protection":["1; mode=block"]},"body":"{\"id\":\"100366183887114\",\"txnDate\":\"2022-06-12 11:27:41\",\"channelId\":7,\"serviceId\":32,\"txnAmount\":50.0,\"fee\":0.0,\"commission\":0.0,\"bonus\":0.0,\"receiverBonus\":0.0,\"tax\":0.0,\"origUserId\":\"122115\",\"origMsisdn\":\"55667788\",\"origEntity\":1,\"origLevel\":0,\"origWalletType\":4,\"origBlsBefore\":4500.0,\"origBlsAfter\":4550.0,\"origProfileId\":16009,\"origFullName\":\"Test Miller M\",\"origErpCode\":null,\"origLocation\":\"7\",\"origBusinessName\":null,\"origProfilePic\":\"100366183462295\",\"origBusinessType\":0,\"origBusinessCategory\":0,\"origIdType\":1,\"origIdNumber\":\"987987\",\"origParentId\":\"1000\",\"posId\":null,\"mopId\":null,\"destUserId\":null,\"destMsisdn\":null,\"destEntity\":0,\"destLevel\":0,\"destWalletType\":0,\"destBlsBefore\":0.0,\"destBlsAfter\":0.0,\"destProfileId\":0,\"destFullName\":null,\"destErpCode\":null,\"destLocation\":null,\"destBusinessName\":null,\"destBusinessType\":0,\"destBusinessCategory\":0,\"destIdType\":0,\"destIdNumber\":null,\"destProfilePic\":null,\"destParentId\":null,\"otherUserId\":null,\"otherFullName\":null,\"otherWalletTypeId\":0,\"otherBalBefore\":0.0,\"otherBalAfter\":0.0,\"otherErpCode\":null,\"sysWalletTypeId\":0,\"sysBalBefore\":0.0,\"sysBalAfter\":0.0,\"requestId\":\"100366183887114\",\"orderId\":null,\"extTxnId\":null,\"extErrorCode\":null,\"extErrorSystem\":\"0\",\"extMessage\":null,\"bankBic\":null,\"bankName\":\"\",\"accountNumber\":null,\"loyaltyPoints\":0,\"loyaltyPack\":null,\"referredBy\":null,\"coupon\":null,\"couponAmount\":0.0,\"remarks\":\"cashback\",\"referenceNo\":null,\"duration\":82,\"statusType\":\"Success\",\"statusCode\":\"1049\",\"rf1\":null,\"rf2\":null,\"rf..."}
[TRACE] 2022-06-15 15:57:49.919 (DefaultHttpLogWriter.java:79)  -http-nio-8989-exec-7 - {"origin":"remote","type":"request","correlation":"eef7b4667f935c30","protocol":"HTTP/1.1","remote":"10.242.1.98","method":"GET","uri":"http://10.242.1.110:8989/mwallet/v1/profilepic/view/1000/null","headers":{"accept-encoding":["gzip"],"apikey":["ME/eIRf113{,Es3+"],"authorization":["XXX"],"authtoken":["k+8L2WYQXYgbTgpk8EkduH+ml5ZYtKPvdD1JY9E72AnrBVFaScmrP2xkqjYMN4v+UHnERX+bw7Bd+7h35RPo3aSTQ2gl2P0SSYmGMUC4eGE4PIFv88TbIyfftpG45GRy4Xbt6ZT9wLqaL0mc71rZPP++opJYoboWJHgIk7AoBE9eM+ov9QdCzjvkPR+Q1j2D7XJ0+8Wp/9RN6k6iw1bGRjamxXypIct8+FOfxaUScaMYTEvtzDxzmoLhhIqhxJIZvEe3GXpEBgunvTuKQg04tIJ39Lp/dYU12Hj3Nhau6WYUGE4Goz3wraeBsD/vin43ZU5V0zFAww99PCx+jhcCABTaJIQwaSTuumdbOffostVWYhYuP+gsnzsrMBcF0i6oea2dLBNXFETEeFsI81TMI0GX+0/0NbvMamiQk1UK8zfz7Wbtg2dhQXpfq+89NM1wbRrvyB4/oR4iy7XjeGe8NAMDJnTLchFqd0d5HNQWSmHHXYB7YFYZqjKS6XBguzDZkP/+HesZcIvobxYb5L1Vg8EyhZStOoU1IhAgLKCYwBXi0xbrGBSXKK5gZgr4gGi2397GJySUhRnqI0Reg8qYKuS3GBNV/TydM342TyNmQAnCmBI38Av3CMoktscMadPfJq1dSCz2v9tV0l06q9Twa7VxrMs1Yvzr7JuXASSeTWJeGKmL3VFgMyikecz286ZQ"],"channel":["ACA"],"connection":["keep-alive"],"host":["10.242.1.110:8989"],"user-agent":["okhttp/4.9.3"],"x-auth-token":["eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDksMTAwMCwxMzA2Myw5MDU2LDkwMzcsOTAwOSw5MDM2LDEzMDY0LDkwMDIsOTAxMCw5MDIxLDkwMzgsMTYwMDYsMTYwMDUsOTA0NCw5MDY4LDE2MDA0LDEwMDgsMTMwNTksOTA0MSwxMDIwLDEwMTQsMTAzMSwxMzAxMCwxMDMwLDEzMDExLDkwNDUsMTMwMjAsOTA0OCwxNjAwMiw5MDAzLDkwNDIsOTA0Myw5MDM5LDkwNjksOTAwNSwxNjAwMCw5MDU0LDkwMTMsOTA1NSw5MDA0LDEwMTcsMTYwMDMsMTAwOSw5MDA3Iiwic3ViIjoiMTIyMTE1IiwiaWF0IjoxNjU1Mjk0MjA0LCJleHAiOjE2NTc0NTQyMDR9.MZIHmKeH6pddin4jspcO0xFiTgEnyZn9NNZR6YsFTug"],"x-entity":["1"],"x-forwarded-for":["103.148.21.69"],"x-forwarded-host":["app.mytmoney.mu"],"x-forwarded-path":["/mwallet/v1/profilepic/view/1000/null"],"x-forwarded-port":["8083"],"x-forwarded-proto":["http"],"x-msisdn":["55667788"],"x-real-ip":["103.148.21.69"],"x-userid":["122115"]}}
[DEBUG] 2022-06-15 15:57:49.919 (LogFormatUtils.java:91)  -http-nio-8989-exec-7 - GET "/mwallet/v1/profilepic/view/1000/null", parameters={}
[DEBUG] 2022-06-15 15:57:49.921 (AbstractHandlerMapping.java:415)  -http-nio-8989-exec-7 - Mapped to com.sixdee.wallet.account.controller.ProfilePicController#view(String, String)
[DEBUG] 2022-06-15 15:57:49.924 (SqlStatementLogger.java:128) 100366459295264 -http-nio-8989-exec-7 - SELECT PROFILE_PICTURE_ID,DOC_NAME FROM MFS_USER_MASTER WHERE USER_ID = ?
[DEBUG] 2022-06-15 15:57:49.955 (AbstractMessageConverterMethodProcessor.java:255) 100366459295264 -http-nio-8989-exec-7 - Using 'application/json', given [*/*] and supported [application/json]
[DEBUG] 2022-06-15 15:57:49.955 (AbstractMessageConverterMethodProcessor.java:285) 100366459295264 -http-nio-8989-exec-7 - Nothing to write: null body
[INFO ] 2022-06-15 15:57:49.956 (CdrBuilder.java:54) 100366459295264 -http-nio-8989-exec-7 - Skipping CDR since service ID not exists
[INFO ] 2022-06-15 15:57:49.956 (CdrSystemIncomeBuilder.java:56) 100366459295264 -http-nio-8989-exec-7 - Skipping INC CDR since service ID not exists
[INFO ] 2022-06-15 15:57:49.956 (CdrSystemExpenseBuilder.java:56) 100366459295264 -http-nio-8989-exec-7 - Skipping EXP CDR since service ID not exists
[INFO ] 2022-06-15 15:57:49.957 (CdrSystemCollectionBuilder.java:56) 100366459295264 -http-nio-8989-exec-7 - Skipping SYS COLLECTION CDR since service ID not exists
[INFO ] 2022-06-15 15:57:49.957 (CdrSystemCFBuilder.java:56) 100366459295264 -http-nio-8989-exec-7 - Skipping CF CDR since service ID not exists
[INFO ] 2022-06-15 15:57:49.957 (NotificationBuilder.java:72) 100366459295264 -http-nio-8989-exec-7 - Skipping Notification since service ID not exists
[DEBUG] 2022-06-15 15:57:49.960 (ManageUsage.java:148) 100366459295264 -http-nio-8989-exec-7 - Skipping Usage. Service 0, Is User null false, StatusCode null, StatusType Null
[INFO ] 2022-06-15 15:57:49.961 (LoyaltyAccumulator.java:43) 100366459295264 -http-nio-8989-exec-7 - Skipping Point Accumulation since service ID doesn't exists
[INFO ] 2022-06-15 15:57:49.961 (FailedTransactionEvents.java:45) 100366459295264 -http-nio-8989-exec-7 - Inside FailedTransactionEvents
[INFO ] 2022-06-15 15:57:49.961 (TokenValidateInterceptor.java:398) 100366459295264 -http-nio-8989-exec-7 - Request Execution Time : 40 ms
[DEBUG] 2022-06-15 15:57:49.962 (FrameworkServlet.java:1131)  -http-nio-8989-exec-7 - Completed 200 OK
[TRACE] 2022-06-15 15:57:49.963 (DefaultHttpLogWriter.java:84)  -http-nio-8989-exec-7 - {"origin":"local","type":"response","correlation":"eef7b4667f935c30","duration":44,"protocol":"HTTP/1.1","status":200,"headers":{"Accept-Ranges":["bytes"],"Cache-Control":["no-cache, no-store, max-age=0, must-revalidate"],"Connection":["keep-alive"],"Date":["Wed, 15 Jun 2022 11:57:49 GMT"],"Expires":["0"],"Keep-Alive":["timeout=20"],"Pragma":["no-cache"],"RCF":["/v1/profilepic/view/1000/null"],"Transfer-Encoding":["chunked"],"Vary":["Origin","Access-Control-Request-Method","Access-Control-Request-Headers","Origin","Access-Control-Request-Method","Access-Control-Request-Headers","Origin","Access-Control-Request-Method","Access-Control-Request-Headers"],"X-Content-Type-Options":["nosniff"],"X-Frame-Options":["DENY"],"X-TransctionId":["100366459295264"],"X-XSS-Protection":["1; mode=block"]}}
[TRACE] 2022-06-15 15:57:56.702 (DefaultHttpLogWriter.java:79)  -http-nio-8989-exec-4 - {"origin":"remote","type":"request","correlation":"fef0482769f19109","protocol":"HTTP/1.1","remote":"10.242.1.98","method":"GET","uri":"http://10.242.1.110:8989/mwallet/v1/wallets/balance/122115","headers":{"accept-encoding":["gzip"],"apikey":["ME/eIRf113{,Es3+"],"authorization":["XXX"],"authtoken":["k+8L2WYQXYgbTgpk8EkduH+ml5ZYtKPvdD1JY9E72AnrBVFaScmrP2xkqjYMN4v+UHnERX+bw7Bd+7h35RPo3aSTQ2gl2P0SSYmGMUC4eGE4PIFv88TbIyfftpG45GRy4Xbt6ZT9wLqaL0mc71rZPP++opJYoboWJHgIk7AoBE9eM+ov9QdCzjvkPR+Q1j2D7XJ0+8Wp/9RN6k6iw1bGRjamxXypIct8+FOfxaUScaMYTEvtzDxzmoLhhIqhxJIZvEe3GXpEBgunvTuKQg04tIJ39Lp/dYU12Hj3Nhau6WYUGE4Goz3wraeBsD/vin43ZU5V0zFAww99PCx+jhcCABTaJIQwaSTuumdbOffostVWYhYuP+gsnzsrMBcF0i6oea2dLBNXFETEeFsI81TMI0GX+0/0NbvMamiQk1UK8zfz7Wbtg2dhQXpfq+89NM1wbRrvyB4/oR4iy7XjeGe8NAMDJnTLchFqd0d5HNQWSmHHXYB7YFYZqjKS6XBguzDZkP/+HesZcIvobxYb5L1Vg8EyhZStOoU1IhAgLKCYwBXi0xbrGBSXKK5gZgr4gGi2397GJySUhRnqI0Reg8qYKuS3GBNV/TydM342TyNmQAnCmBI38Av3CCw+gTEAspzYILiRmFdc0IF5iCS7YZ1VntFd70GgM9svONuAZBcaEMKQgH1mYd1eiN4GurRP5u4o"],"channel":["ACA"],"connection":["keep-alive"],"content-type":["application/json"],"host":["10.242.1.110:8989"],"user-agent":["okhttp/4.9.3"],"x-auth-token":["eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDksMTAwMCwxMzA2Myw5MDU2LDkwMzcsOTAwOSw5MDM2LDEzMDY0LDkwMDIsOTAxMCw5MDIxLDkwMzgsMTYwMDYsMTYwMDUsOTA0NCw5MDY4LDE2MDA0LDEwMDgsMTMwNTksOTA0MSwxMDIwLDEwMTQsMTAzMSwxMzAxMCwxMDMwLDEzMDExLDkwNDUsMTMwMjAsOTA0OCwxNjAwMiw5MDAzLDkwNDIsOTA0Myw5MDM5LDkwNjksOTAwNSwxNjAwMCw5MDU0LDkwMTMsOTA1NSw5MDA0LDEwMTcsMTYwMDMsMTAwOSw5MDA3Iiwic3ViIjoiMTIyMTE1IiwiaWF0IjoxNjU1Mjk0MjA0LCJleHAiOjE2NTc0NTQyMDR9.MZIHmKeH6pddin4jspcO0xFiTgEnyZn9NNZR6YsFTug"],"x-entity":["1"],"x-forwarded-for":["103.148.21.69"],"x-forwarded-host":["app.mytmoney.mu"],"x-forwarded-path":["/mwallet/v1/wallets/balance/122115"],"x-forwarded-port":["8083"],"x-forwarded-proto":["http"],"x-msisdn":["55667788"],"x-notificationservice":["fcm"],"x-real-ip":["103.148.21.69"],"x-userid":["122115"]},"body":""}
[DEBUG] 2022-06-15 15:57:56.702 (LogFormatUtils.java:91)  -http-nio-8989-exec-4 - GET "/mwallet/v1/wallets/balance/122115", parameters={}
[DEBUG] 2022-06-15 15:57:56.704 (AbstractHandlerMapping.java:415)  -http-nio-8989-exec-4 - Mapped to com.sixdee.wallet.account.controller.WalletManagementController#getWalletBalance(String)
[DEBUG] 2022-06-15 15:57:56.707 (TokenValidateInterceptor.java:291) 100366459302047 -http-nio-8989-exec-4 - Authentication Session Token : eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDksMTAwMCwxMzA2Myw5MDU2LDkwMzcsOTAwOSw5MDM2LDEzMDY0LDkwMDIsOTAxMCw5MDIxLDkwMzgsMTYwMDYsMTYwMDUsOTA0NCw5MDY4LDE2MDA0LDEwMDgsMTMwNTksOTA0MSwxMDIwLDEwMTQsMTAzMSwxMzAxMCwxMDMwLDEzMDExLDkwNDUsMTMwMjAsOTA0OCwxNjAwMiw5MDAzLDkwNDIsOTA0Myw5MDM5LDkwNjksOTAwNSwxNjAwMCw5MDU0LDkwMTMsOTA1NSw5MDA0LDEwMTcsMTYwMDMsMTAwOSw5MDA3Iiwic3ViIjoiMTIyMTE1IiwiaWF0IjoxNjU1Mjk0MjA0LCJleHAiOjE2NTc0NTQyMDR9.MZIHmKeH6pddin4jspcO0xFiTgEnyZn9NNZR6YsFTug User Id : 122115 Msisdn : 55667788
[DEBUG] 2022-06-15 15:57:56.707 (TokenValidateInterceptor.java:294) 100366459302047 -http-nio-8989-exec-4 - Authentication  Token : k+8L2WYQXYgbTgpk8EkduH+ml5ZYtKPvdD1JY9E72AnrBVFaScmrP2xkqjYMN4v+UHnERX+bw7Bd+7h35RPo3aSTQ2gl2P0SSYmGMUC4eGE4PIFv88TbIyfftpG45GRy4Xbt6ZT9wLqaL0mc71rZPP++opJYoboWJHgIk7AoBE9eM+ov9QdCzjvkPR+Q1j2D7XJ0+8Wp/9RN6k6iw1bGRjamxXypIct8+FOfxaUScaMYTEvtzDxzmoLhhIqhxJIZvEe3GXpEBgunvTuKQg04tIJ39Lp/dYU12Hj3Nhau6WYUGE4Goz3wraeBsD/vin43ZU5V0zFAww99PCx+jhcCABTaJIQwaSTuumdbOffostVWYhYuP+gsnzsrMBcF0i6oea2dLBNXFETEeFsI81TMI0GX+0/0NbvMamiQk1UK8zfz7Wbtg2dhQXpfq+89NM1wbRrvyB4/oR4iy7XjeGe8NAMDJnTLchFqd0d5HNQWSmHHXYB7YFYZqjKS6XBguzDZkP/+HesZcIvobxYb5L1Vg8EyhZStOoU1IhAgLKCYwBXi0xbrGBSXKK5gZgr4gGi2397GJySUhRnqI0Reg8qYKuS3GBNV/TydM342TyNmQAnCmBI38Av3CCw+gTEAspzYILiRmFdc0IF5iCS7YZ1VntFd70GgM9svONuAZBcaEMKQgH1mYd1eiN4GurRP5u4o User Id : 122115 Msisdn : 55667788
[DEBUG] 2022-06-15 15:57:56.708 (TokenValidateInterceptor.java:300) 100366459302047 -http-nio-8989-exec-4 - Decrypted token : eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDksMTAwMCwxMzA2Myw5MDU2LDkwMzcsOTAwOSw5MDM2LDEzMDY0LDkwMDIsOTAxMCw5MDIxLDkwMzgsMTYwMDYsMTYwMDUsOTA0NCw5MDY4LDE2MDA0LDEwMDgsMTMwNTksOTA0MSwxMDIwLDEwMTQsMTAzMSwxMzAxMCwxMDMwLDEzMDExLDkwNDUsMTMwMjAsOTA0OCwxNjAwMiw5MDAzLDkwNDIsOTA0Myw5MDM5LDkwNjksOTAwNSwxNjAwMCw5MDU0LDkwMTMsOTA1NSw5MDA0LDEwMTcsMTYwMDMsMTAwOSw5MDA3Iiwic3ViIjoiMTIyMTE1IiwiaWF0IjoxNjU1Mjk0MjA0LCJleHAiOjE2NTc0NTQyMDR9.MZIHmKeH6pddin4jspcO0xFiTgEnyZn9NNZR6YsFTug||1655294273283_63867d5c-11cf-4269-a534-becd39603139
[DEBUG] 2022-06-15 15:57:56.711 (TokenValidateInterceptor.java:327) 100366459302047 -http-nio-8989-exec-4 - AuthenticationFilter is passing request down the filter chain
[INFO ] 2022-06-15 15:57:56.711 (WalletMgmntServiceImpl.java:80) 100366459302047 -http-nio-8989-exec-4 - Fetching balance for user 122115...
[DEBUG] 2022-06-15 15:57:56.713 (SqlStatementLogger.java:128) 100366459302047 -http-nio-8989-exec-4 - SELECT * FROM MFS_WALLET_MASTER WHERE USER_ID = ?
[DEBUG] 2022-06-15 15:57:56.715 (AbstractMessageConverterMethodProcessor.java:255) 100366459302047 -http-nio-8989-exec-4 - Using 'application/json', given [*/*] and supported [application/json]
[TRACE] 2022-06-15 15:57:56.715 (DefaultHttpLogWriter.java:79)  -http-nio-8989-exec-9 - {"origin":"remote","type":"request","correlation":"ad3c46748a998f6a","protocol":"HTTP/1.1","remote":"10.242.1.98","method":"GET","uri":"http://10.242.1.110:8989/mwallet/v1/bannerMgmnt/type/1","headers":{"accept-encoding":["gzip"],"apikey":["ME/eIRf113{,Es3+"],"authorization":["XXX"],"authtoken":["k+8L2WYQXYgbTgpk8EkduH+ml5ZYtKPvdD1JY9E72AnrBVFaScmrP2xkqjYMN4v+UHnERX+bw7Bd+7h35RPo3aSTQ2gl2P0SSYmGMUC4eGE4PIFv88TbIyfftpG45GRy4Xbt6ZT9wLqaL0mc71rZPP++opJYoboWJHgIk7AoBE9eM+ov9QdCzjvkPR+Q1j2D7XJ0+8Wp/9RN6k6iw1bGRjamxXypIct8+FOfxaUScaMYTEvtzDxzmoLhhIqhxJIZvEe3GXpEBgunvTuKQg04tIJ39Lp/dYU12Hj3Nhau6WYUGE4Goz3wraeBsD/vin43ZU5V0zFAww99PCx+jhcCABTaJIQwaSTuumdbOffostVWYhYuP+gsnzsrMBcF0i6oea2dLBNXFETEeFsI81TMI0GX+0/0NbvMamiQk1UK8zfz7Wbtg2dhQXpfq+89NM1wbRrvyB4/oR4iy7XjeGe8NAMDJnTLchFqd0d5HNQWSmHHXYB7YFYZqjKS6XBguzDZkP/+HesZcIvobxYb5L1Vg8EyhZStOoU1IhAgLKCYwBXi0xbrGBSXKK5gZgr4gGi2397GJySUhRnqI0Reg8qYKuS3GBNV/TydM342TyNmQAnCmBI38Av3CCw+gTEAspzYJNf9tb/ytnBHolcQJXfYK4JOChRMxJy12Wls8U5fLGjD0rwXk11JUVpNCEmZYYkb"],"channel":["ACA"],"connection":["keep-alive"],"content-type":["application/json"],"host":["10.242.1.110:8989"],"user-agent":["okhttp/4.9.3"],"x-auth-token":["eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDksMTAwMCwxMzA2Myw5MDU2LDkwMzcsOTAwOSw5MDM2LDEzMDY0LDkwMDIsOTAxMCw5MDIxLDkwMzgsMTYwMDYsMTYwMDUsOTA0NCw5MDY4LDE2MDA0LDEwMDgsMTMwNTksOTA0MSwxMDIwLDEwMTQsMTAzMSwxMzAxMCwxMDMwLDEzMDExLDkwNDUsMTMwMjAsOTA0OCwxNjAwMiw5MDAzLDkwNDIsOTA0Myw5MDM5LDkwNjksOTAwNSwxNjAwMCw5MDU0LDkwMTMsOTA1NSw5MDA0LDEwMTcsMTYwMDMsMTAwOSw5MDA3Iiwic3ViIjoiMTIyMTE1IiwiaWF0IjoxNjU1Mjk0MjA0LCJleHAiOjE2NTc0NTQyMDR9.MZIHmKeH6pddin4jspcO0xFiTgEnyZn9NNZR6YsFTug"],"x-entity":["1"],"x-forwarded-for":["103.148.21.69"],"x-forwarded-host":["app.mytmoney.mu"],"x-forwarded-path":["/mwallet/v1/bannerMgmnt/type/1"],"x-forwarded-port":["8083"],"x-forwarded-proto":["http"],"x-msisdn":["55667788"],"x-notificationservice":["fcm"],"x-real-ip":["103.148.21.69"],"x-userid":["122115"]},"body":""}
[DEBUG] 2022-06-15 15:57:56.715 (LogFormatUtils.java:91) 100366459302047 -http-nio-8989-exec-4 - Writing [com.sixdee.wallet.account.beans.WalletBalance@7723245d]
[INFO ] 2022-06-15 15:57:56.716 (CdrBuilder.java:54) 100366459302047 -http-nio-8989-exec-4 - Skipping CDR since service ID not exists
[DEBUG] 2022-06-15 15:57:56.716 (LogFormatUtils.java:91)  -http-nio-8989-exec-9 - GET "/mwallet/v1/bannerMgmnt/type/1", parameters={}
[INFO ] 2022-06-15 15:57:56.716 (CdrSystemIncomeBuilder.java:56) 100366459302047 -http-nio-8989-exec-4 - Skipping INC CDR since service ID not exists
[INFO ] 2022-06-15 15:57:56.716 (CdrSystemExpenseBuilder.java:56) 100366459302047 -http-nio-8989-exec-4 - Skipping EXP CDR since service ID not exists
[INFO ] 2022-06-15 15:57:56.717 (CdrSystemCollectionBuilder.java:56) 100366459302047 -http-nio-8989-exec-4 - Skipping SYS COLLECTION CDR since service ID not exists
[INFO ] 2022-06-15 15:57:56.717 (CdrSystemCFBuilder.java:56) 100366459302047 -http-nio-8989-exec-4 - Skipping CF CDR since service ID not exists
[INFO ] 2022-06-15 15:57:56.717 (NotificationBuilder.java:72) 100366459302047 -http-nio-8989-exec-4 - Skipping Notification since service ID not exists

Roshan1 · June 21, 2022, 9:38am

Hello

please find above sample code.

Also,, we noticed the Data Filter cannot be created

Roshan1 · June 21, 2022, 9:44am

AsOTA0OCwxNjAwMiw5MDAzLDkwNDIsOTA0Myw5MDM5LDkwNjksOTAwNSwxNjAwMCw5MDU0LDkwMTMsOTA1NSw5MDA0LDEwMTcsMTYwMDMsMTAwOSw5MDA3Iiwic3ViIjoiMTIyMTE1IiwiaWF0IjoxNjU1Mjk0MjA0LCJleHAiOjE2NTc0NTQyMDR9.MZIHmKeH6pddin4jspcO0xFiTgEnyZn9NNZR6YsFTug User Id : 122115 Msisdn : 55667788
[DEBUG] 2022-06-15 15:57:56.707 (TokenValidateInterceptor.java:294) 100366459302047 -http-nio-8989-exec-4 - Authentication  Token : k+8L2WYQXYgbTgpk8EkduH+ml5ZYtKPvdD1JY9E72AnrBVFaScmrP2xkqjYMN4v+UHnERX+bw7Bd+7h35RPo3aSTQ2gl2P0SSYmGMUC4eGE4PIFv88TbIyfftpG45GRy4Xbt6ZT9wLqaL0mc71rZPP++opJYoboWJHgIk7AoBE9eM+ov9QdCzjvkPR+Q1j2D7XJ0+8Wp/9RN6k6iw1bGRjamxXypIct8+FOfxaUScaMYTEvtzDxzmoLhhIqhxJIZvEe3GXpEBgunvTuKQg04tIJ39Lp/dYU12Hj3Nhau6WYUGE4Goz3wraeBsD/vin43ZU5V0zFAww99PCx+jhcCABTaJIQwaSTuumdbOffostVWYhYuP+gsnzsrMBcF0i6oea2dLBNXFETEeFsI81TMI0GX+0/0NbvMamiQk1UK8zfz7Wbtg2dhQXpfq+89NM1wbRrvyB4/oR4iy7XjeGe8NAMDJnTLchFqd0d5HNQWSmHHXYB7YFYZqjKS6XBguzDZkP/+HesZcIvobxYb5L1Vg8EyhZStOoU1IhAgLKCYwBXi0xbrGBSXKK5gZgr4gGi2397GJySUhRnqI0Reg8qYKuS3GBNV/TydM342TyNmQAnCmBI38Av3CCw+gTEAspzYILiRmFdc0IF5iCS7YZ1VntFd70GgM9svONuAZBcaEMKQgH1mYd1eiN4GurRP5u4o User Id : 122115 Msisdn : 55667788
[DEBUG] 2022-06-15 15:57:56.708 (TokenValidateInterceptor.java:300) 100366459302047 -http-nio-8989-exec-4 - Decrypted token : eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDksMTAwMCwxMzA2Myw5MDU2LDkwMzcsOTAwOSw5MDM2LDEzMDY0LDkwMDIsOTAxMCw5MDIxLDkwMzgsMTYwMDYsMTYwMDUsOTA0NCw5MDY4LDE2MDA0LDEwMDgsMTMwNTksOTA0MSwxMDIwLDEwMTQsMTAzMSwxMzAxMCwxMDMwLDEzMDExLDkwNDUsMTMwMjAsOTA0OCwxNjAwMiw5MDAzLDkwNDIsOTA0Myw5MDM5LDkwNjksOTAwNSwxNjAwMCw5MDU0LDkwMTMsOTA1NSw5MDA0LDEwMTcsMTYwMDMsMTAwOSw5MDA3Iiwic3ViIjoiMTIyMTE1IiwiaWF0IjoxNjU1Mjk0MjA0LCJleHAiOjE2NTc0NTQyMDR9.MZIHmKeH6pddin4jspcO0xFiTgEnyZn9NNZR6YsFTug||1655294273283_63867d5c-11cf-4269-a534-becd39603139
[DEBUG] 2022-06-15 15:57:56.711 (TokenValidateInterceptor.java:327) 100366459302047 -http-nio-8989-exec-4 - AuthenticationFilter is passing request down the filter chain
[INFO ] 2022-06-15 15:57:56.711 (WalletMgmntServiceImpl.java:80) 100366459302047 -http-nio-8989-exec-4 - Fetching balance for user 122115...
[DEBUG] 2022-06-15 15:57:56.713 (SqlStatementLogger.java:128) 100366459302047 -http-nio-8989-exec-4 - SELECT * FROM MFS_WALLET_MASTER WHERE USER_ID = ?
[DEBUG] 2022-06-15 15:57:56.715 (AbstractMessageConverterMethodProcessor.java:255) 100366459302047 -http-nio-8989-exec-4 - Using 'application/json', given [*/*] and supported [application/json]
[TRACE] 2022-06-15 15:57:56.715 (DefaultHttpLogWriter.java:79)  -http-nio-8989-exec-9 - {"origin":"remote","type":"request","correlation":"ad3c46748a998f6a","protocol":"HTTP/1.1","remote":"10.242.1.98","method":"GET","uri":"http://10.242.1.110:8989/mwallet/v1/bannerMgmnt/type/1","headers":{"accept-encoding":["gzip"],"apikey":["ME/eIRf113{,Es3+"],"authorization":["XXX"],"authtoken":["k+8L2WYQXYgbTgpk8EkduH+ml5ZYtKPvdD1JY9E72AnrBVFaScmrP2xkqjYMN4v+UHnERX+bw7Bd+7h35RPo3aSTQ2gl2P0SSYmGMUC4eGE4PIFv88TbIyfftpG45GRy4Xbt6ZT9wLqaL0mc71rZPP++opJYoboWJHgIk7AoBE9eM+ov9QdCzjvkPR+Q1j2D7XJ0+8Wp/9RN6k6iw1bGRjamxXypIct8+FOfxaUScaMYTEvtzDxzmoLhhIqhxJIZvEe3GXpEBgunvTuKQg04tIJ39Lp/dYU12Hj3Nhau6WYUGE4Goz3wraeBsD/vin43ZU5V0zFAww99PCx+jhcCABTaJIQwaSTuumdbOffostVWYhYuP+gsnzsrMBcF0i6oea2dLBNXFETEeFsI81TMI0GX+0/0NbvMamiQk1UK8zfz7Wbtg2dhQXpfq+89NM1wbRrvyB4/oR4iy7XjeGe8NAMDJnTLchFqd0d5HNQWSmHHXYB7YFYZqjKS6XBguzDZkP/+HesZcIvobxYb5L1Vg8EyhZStOoU1IhAgLKCYwBXi0xbrGBSXKK5gZgr4gGi2397GJySUhRnqI0Reg8qYKuS3GBNV/TydM342TyNmQAnCmBI38Av3CCw+gTEAspzYJNf9tb/ytnBHolcQJXfYK4JOChRMxJy12Wls8U5fLGjD0rwXk11JUVpNCEmZYYkb"],"channel":["ACA"],"connection":["keep-alive"],"content-type":["application/json"],"host":["10.242.1.110:8989"],"user-agent":["okhttp/4.9.3"],"x-auth-token":["eyJhbGciOiJIUzI1NiJ9.eyJBdXRob3JpdGllcyI6IjkwNDksMTAwMCwxMzA2Myw5MDU2LDkwMzcsOTAwOSw5MDM2LDEzMDY0LDkwMDIsOTAxMCw5MDIxLDkwMzgsMTYwMDYsMTYwMDUsOTA0NCw5MDY4LDE2MDA0LDEwMDgsMTMwNTksOTA0MSwxMDIwLDEwMTQsMTAzMSwxMzAxMCwxMDMwLDEzMDExLDkwNDUsMTMwMjAsOTA0OCwxNjAwMiw5MDAzLDkwNDIsOTA0Myw5MDM5LDkwNjksOTAwNSwxNjAwMCw5MDU0LDkwMTMsOTA1NSw5MDA0LDEwMTcsMTYwMDMsMTAwOSw5MDA3Iiwic3ViIjoiMTIyMTE1IiwiaWF0IjoxNjU1Mjk0MjA0LCJleHAiOjE2NTc0NTQyMDR9.MZIHmKeH6pddin4jspcO0xFiTgEnyZn9NNZR6YsFTug"],"x-entity":["1"],"x-forwarded-for":["103.148.21.69"],"x-forwarded-host":["app.mytmoney.mu"],"x-forwarded-path":["/mwallet/v1/bannerMgmnt/type/1"],"x-forwarded-port":["8083"],"x-forwarded-proto":["http"],"x-msisdn":["55667788"],"x-notificationservice":["fcm"],"x-real-ip":["103.148.21.69"],"x-userid":["122115"]},"body":""}
[DEBUG] 2022-06-15 15:57:56.715 (LogFormatUtils.java:91) 100366459302047 -http-nio-8989-exec-4 - Writing [com.sixdee.wallet.account.beans.WalletBalance@7723245d]
[INFO ] 2022-06-15 15:57:56.716 (CdrBuilder.java:54) 100366459302047 -http-nio-8989-exec-4 - Skipping CDR since service ID not exists

sudhagar_ramesh · June 22, 2022, 8:16am

Hello @Roshan1

For this issue, please raise a different case.

However the hint is that, it expects an index pattern but the entered one doesn't match.

system · July 20, 2022, 8:17am

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.