Grok error filter json

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":""}

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 {}
}
1 Like

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]>}

Hello @Roshan1

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

[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

Hello

please find above sample code.

Also,, we noticed the Data Filter cannot be created

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

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.

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