# audit_2025_05_25

timestamp: 2025-05-25T07:06:44.008Z
level: debug
metadata: {}
message:
Knex query response: {"command":"SELECT","rowCount":1,"oid":null,"rows":[{"?column?":1}],"fields":[{"name":"?column?","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"}],"_Parsers":[null],"_Types":{"_types":{"arrayParser":{},"builtins":{"BOOL":16,"BYTEA":17,"CHAR":18,"INT8":20,"INT2":21,"INT4":23,"REGPROC":24,"TEXT":25,"OID":26,"TID":27,"XID":28,"CID":29,"JSON":114,"XML":142,"PG_NODE_TREE":194,"SMGR":210,"PATH":602,"POLYGON":604,"CIDR":650,"FLOAT4":700,"FLOAT8":701,"ABSTIME":702,"RELTIME":703,"TINTERVAL":704,"CIRCLE":718,"MACADDR8":774,"MONEY":790,"MACADDR":829,"INET":869,"ACLITEM":1033,"BPCHAR":1042,"VARCHAR":1043,"DATE":1082,"TIME":1083,"TIMESTAMP":1114,"TIMESTAMPTZ":1184,"INTERVAL":1186,"TIMETZ":1266,"BIT":1560,"VARBIT":1562,"NUMERIC":1700,"REFCURSOR":1790,"REGPROCEDURE":2202,"REGOPER":2203,"REGOPERATOR":2204,"REGCLASS":2205,"REGTYPE":2206,"UUID":2950,"TXID_SNAPSHOT":2970,"PG_LSN":3220,"PG_NDISTINCT":3361,"PG_DEPENDENCIES":3402,"TSVECTOR":3614,"TSQUERY":3615,"GTSVECTOR":3642,"REGCONFIG":3734,"REGDICTIONARY":3769,"JSONB":3802,"REGNAMESPACE":4089,"REGROLE":4096}},"text":{},"binary":{}},"RowCtor":null,"rowAsArray":false,"_PrebuiltEmptyResultObject":{"?column?":null}}


timestamp: 2025-05-25T07:15:29.404Z
level: debug
metadata: {}
message:
Knex query: select "state_id", "state_name", "state_code", "is_union_territory", "country_name", "country_code" from "master"."states" where "is_active" = $1 order by "state_name" asc


timestamp: 2025-05-25T07:15:29.507Z
level: debug
metadata: {}
message:
Knex query response: [{"stateId":29,"stateName":"Andaman and Nicobar Islands","stateCode":"AN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":3,"stateName":"Assam","stateCode":"AS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":4,"stateName":"Bihar","stateCode":"BR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":30,"stateName":"Chandigarh","stateCode":"CH","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":31,"stateName":"Dadra and Nagar Haveli and Daman and Diu","stateCode":"DN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":32,"stateName":"Delhi","stateCode":"DL","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":6,"stateName":"Goa","stateCode":"GA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":7,"stateName":"Gujarat","stateCode":"GJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":8,"stateName":"Haryana","stateCode":"HR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":9,"stateName":"Himachal Pradesh","stateCode":"HP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":33,"stateName":"Jammu and Kashmir","stateCode":"JK","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":10,"stateName":"Jharkhand","stateCode":"JH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":11,"stateName":"Karnataka","stateCode":"KA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":12,"stateName":"Kerala","stateCode":"KL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":34,"stateName":"Ladakh","stateCode":"LA","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":35,"stateName":"Lakshadweep","stateCode":"LD","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":13,"stateName":"Madhya Pradesh","stateCode":"MP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":14,"stateName":"Maharashtra","stateCode":"MH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":15,"stateName":"Manipur","stateCode":"MN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":16,"stateName":"Meghalaya","stateCode":"ML","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":17,"stateName":"Mizoram","stateCode":"MZ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":18,"stateName":"Nagaland","stateCode":"NL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":19,"stateName":"Odisha","stateCode":"OD","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":36,"stateName":"Puducherry","stateCode":"PY","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":20,"stateName":"Punjab","stateCode":"PB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":21,"stateName":"Rajasthan","stateCode":"RJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":22,"stateName":"Sikkim","stateCode":"SK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":23,"stateName":"Tamil Nadu","stateCode":"TN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":24,"stateName":"Telangana","stateCode":"TS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":25,"stateName":"Tripura","stateCode":"TR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":27,"stateName":"Uttarakhand","stateCode":"UK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":26,"stateName":"Uttar Pradesh","stateCode":"UP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":28,"stateName":"West Bengal","stateCode":"WB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-25T07:15:29.519Z
level: debug
metadata: {}
message:
Knex query: select "accessprofileid" from "core"."useraccessprofile" inner join "core"."access_profiles" on "access_profiles"."profile_id" = "useraccessprofile"."accessprofileid" where "userid" = $1


timestamp: 2025-05-25T07:15:29.690Z
level: debug
metadata: {}
message:
Knex query: select "applicationid" as "application_id", "app"."name" as "app_name", "app"."description" as "app_description", "app"."displayname" as "app_display_name", "app"."iconpath" as "app_icon_path", "app"."urlsubpath" as "app_url_sub_path" from "core"."accessprofileapp" inner join "core"."app" on "app"."id" = "accessprofileapp"."applicationid" where "accessprofileid" in ($1) and "app"."isactive" = $2


timestamp: 2025-05-25T07:15:29.746Z
level: debug
metadata: {}
message:
Knex query response: [{"applicationId":1,"appName":"EVerify","appDescription":"e verify application","appDisplayName":"E Verify","appIconPath":"casesApp","appUrlSubPath":"/everify"}]


timestamp: 2025-05-25T07:15:29.752Z
level: debug
metadata: {}
message:
Knex query: 
                        WITH RECURSIVE MenuHierarchy AS (
                    SELECT
                        id,
                        name,
                        displayname,
                        parentmenuid,
                        displayorder,
                        app_id,
                        path,
                        iconmarkup,
                        menuitemtype_enum as menuItemType,
                        0 AS level
                       
                    FROM core.menubar
                    WHERE (parentmenuid IS NULL OR parentmenuid = 0) AND app_id = $1

                    UNION ALL

                    SELECT
                        m.id,
                        m.name,
                        m.displayname,
                        m.parentmenuid,
                        m.displayorder,
                        m.app_id,
                        m.path,
                        m.iconmarkup,
                        m.menuitemtype_enum as menuItemType,
                        mh.level + 1
                          
                    FROM core.menubar m
                    INNER JOIN MenuHierarchy mh ON m.parentmenuid = mh.id
                    WHERE m.isactive = true AND m.app_id = $2
                    )
                    SELECT *
                    FROM MenuHierarchy
                    ORDER BY id, level;
                        


timestamp: 2025-05-25T07:15:29.801Z
level: debug
metadata: {}
message:
Knex query response: {"command":"SELECT","rowCount":7,"oid":null,"rows":[{"id":1,"name":"Dashboard","displayname":"Dashboard","parentmenuid":null,"displayorder":1,"app_id":1,"path":"/everify/dashboard","iconmarkup":"","menuitemtype":1,"level":0},{"id":2,"name":"master","displayname":"Masters","parentmenuid":null,"displayorder":2,"app_id":1,"path":null,"iconmarkup":"","menuitemtype":2,"level":0},{"id":3,"name":"appolice","displayname":"AP Police","parentmenuid":null,"displayorder":3,"app_id":1,"path":null,"iconmarkup":"","menuitemtype":2,"level":0},{"id":4,"name":"states","displayname":"States","parentmenuid":2,"displayorder":3,"app_id":1,"path":"/everify/master/states","iconmarkup":"","menuitemtype":1,"level":1},{"id":5,"name":"village","displayname":"Village","parentmenuid":2,"displayorder":3,"app_id":1,"path":"/everify/master/villages","iconmarkup":"","menuitemtype":1,"level":1},{"id":6,"name":"district","displayname":"District","parentmenuid":2,"displayorder":3,"app_id":1,"path":"/everify/master/districts","iconmarkup":"","menuitemtype":1,"level":1},{"id":7,"name":"mandal","displayname":"Manadal","parentmenuid":2,"displayorder":3,"app_id":1,"path":"/everify/master/mandals","iconmarkup":"","menuitemtype":1,"level":1}],"fields":[{"name":"id","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"name","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":104,"format":"text"},{"name":"displayname","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":104,"format":"text"},{"name":"parentmenuid","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"displayorder","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"app_id","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"path","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":-1,"format":"text"},{"name":"iconmarkup","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":2004,"format":"text"},{"name":"menuitemtype","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"level","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"}],"_Parsers":[null,null,null,null,null,null,null,null,null,null],"_Types":{"_types":{"arrayParser":{},"builtins":{"BOOL":16,"BYTEA":17,"CHAR":18,"INT8":20,"INT2":21,"INT4":23,"REGPROC":24,"TEXT":25,"OID":26,"TID":27,"XID":28,"CID":29,"JSON":114,"XML":142,"PG_NODE_TREE":194,"SMGR":210,"PATH":602,"POLYGON":604,"CIDR":650,"FLOAT4":700,"FLOAT8":701,"ABSTIME":702,"RELTIME":703,"TINTERVAL":704,"CIRCLE":718,"MACADDR8":774,"MONEY":790,"MACADDR":829,"INET":869,"ACLITEM":1033,"BPCHAR":1042,"VARCHAR":1043,"DATE":1082,"TIME":1083,"TIMESTAMP":1114,"TIMESTAMPTZ":1184,"INTERVAL":1186,"TIMETZ":1266,"BIT":1560,"VARBIT":1562,"NUMERIC":1700,"REFCURSOR":1790,"REGPROCEDURE":2202,"REGOPER":2203,"REGOPERATOR":2204,"REGCLASS":2205,"REGTYPE":2206,"UUID":2950,"TXID_SNAPSHOT":2970,"PG_LSN":3220,"PG_NDISTINCT":3361,"PG_DEPENDENCIES":3402,"TSVECTOR":3614,"TSQUERY":3615,"GTSVECTOR":3642,"REGCONFIG":3734,"REGDICTIONARY":3769,"JSONB":3802,"REGNAMESPACE":4089,"REGROLE":4096}},"text":{},"binary":{}},"RowCtor":null,"rowAsArray":false,"_PrebuiltEmptyResultObject":{"id":null,"name":null,"displayname":null,"parentmenuid":null,"displayorder":null,"app_id":null,"path":null,"iconmarkup":null,"menuitemtype":null,"level":null}}


timestamp: 2025-05-25T07:45:43.508Z
level: debug
metadata: {}
message:
Knex query: insert into "master"."states" ("state_code", "state_name") values ($1, $2) on conflict ("state_id") do update set "state_code" = excluded."state_code", "state_name" = excluded."state_name"


timestamp: 2025-05-25T07:45:43.569Z
level: debug
metadata: {}
message:
Knex query response: {"command":"INSERT","rowCount":1,"oid":0,"rows":[],"fields":[],"_Types":{"_types":{"arrayParser":{},"builtins":{"BOOL":16,"BYTEA":17,"CHAR":18,"INT8":20,"INT2":21,"INT4":23,"REGPROC":24,"TEXT":25,"OID":26,"TID":27,"XID":28,"CID":29,"JSON":114,"XML":142,"PG_NODE_TREE":194,"SMGR":210,"PATH":602,"POLYGON":604,"CIDR":650,"FLOAT4":700,"FLOAT8":701,"ABSTIME":702,"RELTIME":703,"TINTERVAL":704,"CIRCLE":718,"MACADDR8":774,"MONEY":790,"MACADDR":829,"INET":869,"ACLITEM":1033,"BPCHAR":1042,"VARCHAR":1043,"DATE":1082,"TIME":1083,"TIMESTAMP":1114,"TIMESTAMPTZ":1184,"INTERVAL":1186,"TIMETZ":1266,"BIT":1560,"VARBIT":1562,"NUMERIC":1700,"REFCURSOR":1790,"REGPROCEDURE":2202,"REGOPER":2203,"REGOPERATOR":2204,"REGCLASS":2205,"REGTYPE":2206,"UUID":2950,"TXID_SNAPSHOT":2970,"PG_LSN":3220,"PG_NDISTINCT":3361,"PG_DEPENDENCIES":3402,"TSVECTOR":3614,"TSQUERY":3615,"GTSVECTOR":3642,"REGCONFIG":3734,"REGDICTIONARY":3769,"JSONB":3802,"REGNAMESPACE":4089,"REGROLE":4096}},"text":{},"binary":{}},"RowCtor":null,"rowAsArray":false,"_PrebuiltEmptyResultObject":null}


timestamp: 2025-05-25T07:46:59.672Z
level: debug
metadata: {}
message:
Knex query response: [{"stateId":29,"stateName":"Andaman and Nicobar Islands","stateCode":"AN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":3,"stateName":"Assam","stateCode":"AS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":4,"stateName":"Bihar","stateCode":"BR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":30,"stateName":"Chandigarh","stateCode":"CH","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":31,"stateName":"Dadra and Nagar Haveli and Daman and Diu","stateCode":"DN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":32,"stateName":"Delhi","stateCode":"DL","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":6,"stateName":"Goa","stateCode":"GA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":7,"stateName":"Gujarat","stateCode":"GJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":8,"stateName":"Haryana","stateCode":"HR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":9,"stateName":"Himachal Pradesh","stateCode":"HP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":33,"stateName":"Jammu and Kashmir","stateCode":"JK","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":10,"stateName":"Jharkhand","stateCode":"JH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":11,"stateName":"Karnataka","stateCode":"KA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":12,"stateName":"Kerala","stateCode":"KL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":34,"stateName":"Ladakh","stateCode":"LA","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":35,"stateName":"Lakshadweep","stateCode":"LD","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":13,"stateName":"Madhya Pradesh","stateCode":"MP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":14,"stateName":"Maharashtra","stateCode":"MH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":15,"stateName":"Manipur","stateCode":"MN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":16,"stateName":"Meghalaya","stateCode":"ML","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":17,"stateName":"Mizoram","stateCode":"MZ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":18,"stateName":"Nagaland","stateCode":"NL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":19,"stateName":"Odisha","stateCode":"OD","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":36,"stateName":"Puducherry","stateCode":"PY","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":20,"stateName":"Punjab","stateCode":"PB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":21,"stateName":"Rajasthan","stateCode":"RJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":37,"stateName":"Sample","stateCode":"SA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":22,"stateName":"Sikkim","stateCode":"SK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":23,"stateName":"Tamil Nadu","stateCode":"TN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":24,"stateName":"Telangana","stateCode":"TS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":25,"stateName":"Tripura","stateCode":"TR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":27,"stateName":"Uttarakhand","stateCode":"UK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":26,"stateName":"Uttar Pradesh","stateCode":"UP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":28,"stateName":"West Bengal","stateCode":"WB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-25T07:47:08.972Z
level: debug
metadata: {}
message:
Knex query response: [{"stateId":29,"stateName":"Andaman and Nicobar Islands","stateCode":"AN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":3,"stateName":"Assam","stateCode":"AS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":4,"stateName":"Bihar","stateCode":"BR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":30,"stateName":"Chandigarh","stateCode":"CH","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":31,"stateName":"Dadra and Nagar Haveli and Daman and Diu","stateCode":"DN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":32,"stateName":"Delhi","stateCode":"DL","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":6,"stateName":"Goa","stateCode":"GA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":7,"stateName":"Gujarat","stateCode":"GJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":8,"stateName":"Haryana","stateCode":"HR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":9,"stateName":"Himachal Pradesh","stateCode":"HP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":33,"stateName":"Jammu and Kashmir","stateCode":"JK","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":10,"stateName":"Jharkhand","stateCode":"JH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":11,"stateName":"Karnataka","stateCode":"KA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":12,"stateName":"Kerala","stateCode":"KL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":34,"stateName":"Ladakh","stateCode":"LA","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":35,"stateName":"Lakshadweep","stateCode":"LD","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":13,"stateName":"Madhya Pradesh","stateCode":"MP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":14,"stateName":"Maharashtra","stateCode":"MH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":15,"stateName":"Manipur","stateCode":"MN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":16,"stateName":"Meghalaya","stateCode":"ML","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":17,"stateName":"Mizoram","stateCode":"MZ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":18,"stateName":"Nagaland","stateCode":"NL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":19,"stateName":"Odisha","stateCode":"OD","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":36,"stateName":"Puducherry","stateCode":"PY","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":20,"stateName":"Punjab","stateCode":"PB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":21,"stateName":"Rajasthan","stateCode":"RJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":37,"stateName":"Sample","stateCode":"SA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":38,"stateName":"Sample2","stateCode":"SAA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":22,"stateName":"Sikkim","stateCode":"SK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":23,"stateName":"Tamil Nadu","stateCode":"TN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":24,"stateName":"Telangana","stateCode":"TS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":25,"stateName":"Tripura","stateCode":"TR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":27,"stateName":"Uttarakhand","stateCode":"UK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":26,"stateName":"Uttar Pradesh","stateCode":"UP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":28,"stateName":"West Bengal","stateCode":"WB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-25T07:47:32.851Z
level: debug
metadata: {}
message:
Knex query: insert into "master"."states" ("country_code", "country_name", "is_union_territory", "state_code", "state_id", "state_name") values ($1, $2, $3, $4, $5, $6) on conflict ("state_id") do update set "country_code" = excluded."country_code", "country_name" = excluded."country_name", "is_union_territory" = excluded."is_union_territory", "state_code" = excluded."state_code", "state_id" = excluded."state_id", "state_name" = excluded."state_name"


timestamp: 2025-05-25T07:47:33.184Z
level: debug
metadata: {}
message:
Knex query response: [{"stateId":29,"stateName":"Andaman and Nicobar Islands","stateCode":"AN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":3,"stateName":"Assam","stateCode":"AS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":4,"stateName":"Bihar","stateCode":"BR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":30,"stateName":"Chandigarh","stateCode":"CH","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":31,"stateName":"Dadra and Nagar Haveli and Daman and Diu","stateCode":"DN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":32,"stateName":"Delhi","stateCode":"DL","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":6,"stateName":"Goa","stateCode":"GA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":7,"stateName":"Gujarat","stateCode":"GJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":8,"stateName":"Haryana","stateCode":"HR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":9,"stateName":"Himachal Pradesh","stateCode":"HP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":33,"stateName":"Jammu and Kashmir","stateCode":"JK","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":10,"stateName":"Jharkhand","stateCode":"JH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":11,"stateName":"Karnataka","stateCode":"KA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":12,"stateName":"Kerala","stateCode":"KL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":34,"stateName":"Ladakh","stateCode":"LA","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":35,"stateName":"Lakshadweep","stateCode":"LD","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":13,"stateName":"Madhya Pradesh","stateCode":"MP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":14,"stateName":"Maharashtra","stateCode":"MH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":15,"stateName":"Manipur","stateCode":"MN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":16,"stateName":"Meghalaya","stateCode":"ML","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":17,"stateName":"Mizoram","stateCode":"MZ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":18,"stateName":"Nagaland","stateCode":"NL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":19,"stateName":"Odisha","stateCode":"OD","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":36,"stateName":"Puducherry","stateCode":"PY","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":20,"stateName":"Punjab","stateCode":"PB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":21,"stateName":"Rajasthan","stateCode":"RJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":37,"stateName":"Sample","stateCode":"SA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":38,"stateName":"Sample 1","stateCode":"SAA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":22,"stateName":"Sikkim","stateCode":"SK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":23,"stateName":"Tamil Nadu","stateCode":"TN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":24,"stateName":"Telangana","stateCode":"TS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":25,"stateName":"Tripura","stateCode":"TR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":27,"stateName":"Uttarakhand","stateCode":"UK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":26,"stateName":"Uttar Pradesh","stateCode":"UP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":28,"stateName":"West Bengal","stateCode":"WB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-25T07:47:57.295Z
level: debug
metadata: {}
message:
Knex query response: [{"stateId":29,"stateName":"Andaman and Nicobar Islands","stateCode":"AN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":3,"stateName":"Assam","stateCode":"AS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":4,"stateName":"Bihar","stateCode":"BR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":30,"stateName":"Chandigarh","stateCode":"CH","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":31,"stateName":"Dadra and Nagar Haveli and Daman and Diu","stateCode":"DN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":32,"stateName":"Delhi","stateCode":"DL","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":6,"stateName":"Goa","stateCode":"GA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":7,"stateName":"Gujarat","stateCode":"GJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":8,"stateName":"Haryana","stateCode":"HR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":9,"stateName":"Himachal Pradesh","stateCode":"HP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":33,"stateName":"Jammu and Kashmir","stateCode":"JK","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":10,"stateName":"Jharkhand","stateCode":"JH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":11,"stateName":"Karnataka","stateCode":"KA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":12,"stateName":"Kerala","stateCode":"KL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":34,"stateName":"Ladakh","stateCode":"LA","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":35,"stateName":"Lakshadweep","stateCode":"LD","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":13,"stateName":"Madhya Pradesh","stateCode":"MP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":14,"stateName":"Maharashtra","stateCode":"MH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":15,"stateName":"Manipur","stateCode":"MN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":16,"stateName":"Meghalaya","stateCode":"ML","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":17,"stateName":"Mizoram","stateCode":"MZ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":18,"stateName":"Nagaland","stateCode":"NL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":19,"stateName":"Odisha","stateCode":"OD","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":36,"stateName":"Puducherry","stateCode":"PY","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":20,"stateName":"Punjab","stateCode":"PB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":21,"stateName":"Rajasthan","stateCode":"RJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":37,"stateName":"Sample","stateCode":"SA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":38,"stateName":"Sample 12","stateCode":"SAA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":22,"stateName":"Sikkim","stateCode":"SK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":23,"stateName":"Tamil Nadu","stateCode":"TN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":24,"stateName":"Telangana","stateCode":"TS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":25,"stateName":"Tripura","stateCode":"TR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":27,"stateName":"Uttarakhand","stateCode":"UK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":26,"stateName":"Uttar Pradesh","stateCode":"UP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":28,"stateName":"West Bengal","stateCode":"WB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-25T08:24:02.638Z
level: debug
metadata: {}
message:
Knex query response: [{"stateId":29,"stateName":"Andaman and Nicobar Islands","stateCode":"AN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":3,"stateName":"Assam","stateCode":"AS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":4,"stateName":"Bihar","stateCode":"BR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":30,"stateName":"Chandigarh","stateCode":"CH","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":31,"stateName":"Dadra and Nagar Haveli and Daman and Diu","stateCode":"DN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":32,"stateName":"Delhi","stateCode":"DL","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":6,"stateName":"Goa","stateCode":"GA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":7,"stateName":"Gujarat","stateCode":"GJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":8,"stateName":"Haryana","stateCode":"HR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":9,"stateName":"Himachal Pradesh","stateCode":"HP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":33,"stateName":"Jammu and Kashmir","stateCode":"JK","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":10,"stateName":"Jharkhand","stateCode":"JH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":11,"stateName":"Karnataka","stateCode":"KA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":12,"stateName":"Kerala","stateCode":"KL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":34,"stateName":"Ladakh","stateCode":"LA","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":35,"stateName":"Lakshadweep","stateCode":"LD","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":13,"stateName":"Madhya Pradesh","stateCode":"MP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":14,"stateName":"Maharashtra","stateCode":"MH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":15,"stateName":"Manipur","stateCode":"MN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":16,"stateName":"Meghalaya","stateCode":"ML","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":17,"stateName":"Mizoram","stateCode":"MZ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":18,"stateName":"Nagaland","stateCode":"NL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":19,"stateName":"Odisha","stateCode":"OD","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":20,"stateName":"Punjab","stateCode":"PB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":21,"stateName":"Rajasthan","stateCode":"RJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":36,"stateName":"Sample","stateCode":"","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":22,"stateName":"Sikkim","stateCode":"SK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":23,"stateName":"Tamil Nadu","stateCode":"TN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":24,"stateName":"Telangana","stateCode":"TS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":25,"stateName":"Tripura","stateCode":"TR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":27,"stateName":"Uttarakhand","stateCode":"UK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":26,"stateName":"Uttar Pradesh","stateCode":"UP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":28,"stateName":"West Bengal","stateCode":"WB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-25T08:28:29.054Z
level: debug
metadata: {}
message:
Knex query response: [{"stateId":29,"stateName":"Andaman and Nicobar Islands","stateCode":"AN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":3,"stateName":"Assam","stateCode":"AS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":4,"stateName":"Bihar","stateCode":"BR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":30,"stateName":"Chandigarh","stateCode":"CH","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":31,"stateName":"Dadra and Nagar Haveli and Daman and Diu","stateCode":"DN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":32,"stateName":"Delhi","stateCode":"DL","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":6,"stateName":"Goa","stateCode":"GA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":7,"stateName":"Gujarat","stateCode":"GJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":8,"stateName":"Haryana","stateCode":"HR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":9,"stateName":"Himachal Pradesh","stateCode":"HP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":33,"stateName":"Jammu and Kashmir","stateCode":"JK","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":10,"stateName":"Jharkhand","stateCode":"JH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":11,"stateName":"Karnataka","stateCode":"KA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":12,"stateName":"Kerala","stateCode":"KL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":34,"stateName":"Ladakh","stateCode":"LA","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":35,"stateName":"Lakshadweep","stateCode":"LD","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":13,"stateName":"Madhya Pradesh","stateCode":"MP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":14,"stateName":"Maharashtra","stateCode":"MH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":15,"stateName":"Manipur","stateCode":"MN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":16,"stateName":"Meghalaya","stateCode":"ML","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":17,"stateName":"Mizoram","stateCode":"MZ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":18,"stateName":"Nagaland","stateCode":"NL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":19,"stateName":"Odisha","stateCode":"OD","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":20,"stateName":"Punjab","stateCode":"PB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":21,"stateName":"Rajasthan","stateCode":"RJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":22,"stateName":"Sikkim","stateCode":"SK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":23,"stateName":"Tamil Nadu","stateCode":"TN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":24,"stateName":"Telangana","stateCode":"TS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":25,"stateName":"Tripura","stateCode":"TR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":27,"stateName":"Uttarakhand","stateCode":"UK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":26,"stateName":"Uttar Pradesh","stateCode":"UP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":28,"stateName":"West Bengal","stateCode":"WB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-25T08:29:25.666Z
level: error
metadata: {}
message:
Knex query error: insert into "master"."states" ("state_code", "state_name") values ($1, $2) on conflict ("state_id") do update set "state_code" = excluded."state_code", "state_name" = excluded."state_name" - duplicate key value violates unique constraint "states_state_code_key"


timestamp: 2025-05-25T08:30:59.485Z
level: debug
metadata: {}
message:
Knex query response: [{"stateId":29,"stateName":"Andaman and Nicobar Islands","stateCode":"AN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":3,"stateName":"Assam","stateCode":"AS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":4,"stateName":"Bihar","stateCode":"BR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":30,"stateName":"Chandigarh","stateCode":"CH","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":31,"stateName":"Dadra and Nagar Haveli and Daman and Diu","stateCode":"DN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":32,"stateName":"Delhi","stateCode":"DL","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":6,"stateName":"Goa","stateCode":"GA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":7,"stateName":"Gujarat","stateCode":"GJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":8,"stateName":"Haryana","stateCode":"HR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":9,"stateName":"Himachal Pradesh","stateCode":"HP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":33,"stateName":"Jammu and Kashmir","stateCode":"JK","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":10,"stateName":"Jharkhand","stateCode":"JH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":11,"stateName":"Karnataka","stateCode":"KA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":12,"stateName":"Kerala","stateCode":"KL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":34,"stateName":"Ladakh","stateCode":"LA","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":35,"stateName":"Lakshadweep","stateCode":"LD","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":13,"stateName":"Madhya Pradesh","stateCode":"MP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":14,"stateName":"Maharashtra","stateCode":"MH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":15,"stateName":"Manipur","stateCode":"MN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":16,"stateName":"Meghalaya","stateCode":"ML","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":17,"stateName":"Mizoram","stateCode":"MZ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":18,"stateName":"Nagaland","stateCode":"NL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":19,"stateName":"Odisha","stateCode":"OD","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":20,"stateName":"Punjab","stateCode":"PB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":21,"stateName":"Rajasthan","stateCode":"RJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":38,"stateName":"Sample1","stateCode":"","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":22,"stateName":"Sikkim","stateCode":"SK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":23,"stateName":"Tamil Nadu","stateCode":"TN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":24,"stateName":"Telangana","stateCode":"TS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":25,"stateName":"Tripura","stateCode":"TR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":27,"stateName":"Uttarakhand","stateCode":"UK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":26,"stateName":"Uttar Pradesh","stateCode":"UP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":28,"stateName":"West Bengal","stateCode":"WB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-25T08:42:22.620Z
level: debug
metadata: {}
message:
Knex query response: {"command":"SELECT","rowCount":7,"oid":null,"rows":[{"id":1,"name":"Dashboard","displayname":"Dashboard","parentmenuid":null,"displayorder":1,"app_id":1,"path":"/everify/dashboard","iconmarkup":"","menuitemtype":1,"level":0},{"id":2,"name":"master","displayname":"Masters","parentmenuid":null,"displayorder":2,"app_id":1,"path":null,"iconmarkup":"","menuitemtype":2,"level":0},{"id":3,"name":"appolice","displayname":"AP Police","parentmenuid":null,"displayorder":3,"app_id":1,"path":null,"iconmarkup":"","menuitemtype":2,"level":0},{"id":4,"name":"states","displayname":"States","parentmenuid":2,"displayorder":1,"app_id":1,"path":"/everify/master/states","iconmarkup":"","menuitemtype":1,"level":1},{"id":5,"name":"village","displayname":"Village","parentmenuid":2,"displayorder":4,"app_id":1,"path":"/everify/master/villages","iconmarkup":"","menuitemtype":1,"level":1},{"id":6,"name":"district","displayname":"District","parentmenuid":2,"displayorder":2,"app_id":1,"path":"/everify/master/districts","iconmarkup":"","menuitemtype":1,"level":1},{"id":7,"name":"mandal","displayname":"Manadal","parentmenuid":2,"displayorder":3,"app_id":1,"path":"/everify/master/mandals","iconmarkup":"","menuitemtype":1,"level":1}],"fields":[{"name":"id","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"name","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":104,"format":"text"},{"name":"displayname","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":104,"format":"text"},{"name":"parentmenuid","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"displayorder","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"app_id","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"path","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":-1,"format":"text"},{"name":"iconmarkup","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":2004,"format":"text"},{"name":"menuitemtype","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"level","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"}],"_Parsers":[null,null,null,null,null,null,null,null,null,null],"_Types":{"_types":{"arrayParser":{},"builtins":{"BOOL":16,"BYTEA":17,"CHAR":18,"INT8":20,"INT2":21,"INT4":23,"REGPROC":24,"TEXT":25,"OID":26,"TID":27,"XID":28,"CID":29,"JSON":114,"XML":142,"PG_NODE_TREE":194,"SMGR":210,"PATH":602,"POLYGON":604,"CIDR":650,"FLOAT4":700,"FLOAT8":701,"ABSTIME":702,"RELTIME":703,"TINTERVAL":704,"CIRCLE":718,"MACADDR8":774,"MONEY":790,"MACADDR":829,"INET":869,"ACLITEM":1033,"BPCHAR":1042,"VARCHAR":1043,"DATE":1082,"TIME":1083,"TIMESTAMP":1114,"TIMESTAMPTZ":1184,"INTERVAL":1186,"TIMETZ":1266,"BIT":1560,"VARBIT":1562,"NUMERIC":1700,"REFCURSOR":1790,"REGPROCEDURE":2202,"REGOPER":2203,"REGOPERATOR":2204,"REGCLASS":2205,"REGTYPE":2206,"UUID":2950,"TXID_SNAPSHOT":2970,"PG_LSN":3220,"PG_NDISTINCT":3361,"PG_DEPENDENCIES":3402,"TSVECTOR":3614,"TSQUERY":3615,"GTSVECTOR":3642,"REGCONFIG":3734,"REGDICTIONARY":3769,"JSONB":3802,"REGNAMESPACE":4089,"REGROLE":4096}},"text":{},"binary":{}},"RowCtor":null,"rowAsArray":false,"_PrebuiltEmptyResultObject":{"id":null,"name":null,"displayname":null,"parentmenuid":null,"displayorder":null,"app_id":null,"path":null,"iconmarkup":null,"menuitemtype":null,"level":null}}


timestamp: 2025-05-25T09:11:03.505Z
level: debug
metadata: {}
message:
Knex query: select "district_id", "district_name", "state_id", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "is_active", "created_at", "updated_at", "created_by", "updated_by", "country_name", "country_code", "country_id" from "master"."districts" inner join "master"."states" on "state_id" = "state_id" where "is_active" = $1 order by "district_name" asc


timestamp: 2025-05-25T09:11:03.566Z
level: error
metadata: {}
message:
Knex query error: select "district_id", "district_name", "state_id", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "is_active", "created_at", "updated_at", "created_by", "updated_by", "country_name", "country_code", "country_id" from "master"."districts" inner join "master"."states" on "state_id" = "state_id" where "is_active" = $1 order by "district_name" asc - column reference "state_id" is ambiguous


timestamp: 2025-05-25T09:11:46.088Z
level: debug
metadata: {}
message:
Knex query: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "is_active", "created_at", "updated_at", "created_by", "updated_by", "country_name", "country_code", "country_id" from "master"."districts" inner join "master"."states" on "states"."state_id" = "state_id" where "is_active" = $1 order by "district_name" asc


timestamp: 2025-05-25T09:11:46.148Z
level: error
metadata: {}
message:
Knex query error: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "is_active", "created_at", "updated_at", "created_by", "updated_by", "country_name", "country_code", "country_id" from "master"."districts" inner join "master"."states" on "states"."state_id" = "state_id" where "is_active" = $1 order by "district_name" asc - column reference "state_id" is ambiguous


timestamp: 2025-05-25T09:12:16.456Z
level: debug
metadata: {}
message:
Knex query: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "is_active", "created_at", "updated_at", "created_by", "updated_by", "country_name", "country_code", "country_id" from "master"."districts" inner join "master"."states" on "states"."state_id" = "districts"."state_id" where "is_active" = $1 order by "district_name" asc


timestamp: 2025-05-25T09:12:16.517Z
level: error
metadata: {}
message:
Knex query error: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "is_active", "created_at", "updated_at", "created_by", "updated_by", "country_name", "country_code", "country_id" from "master"."districts" inner join "master"."states" on "states"."state_id" = "districts"."state_id" where "is_active" = $1 order by "district_name" asc - column reference "is_active" is ambiguous


timestamp: 2025-05-25T09:12:52.763Z
level: debug
metadata: {}
message:
Knex query: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "districts"."is_active", "country_name", "country_code", "country_id" from "master"."districts" inner join "master"."states" on "states"."state_id" = "districts"."state_id" where "is_active" = $1 order by "district_name" asc


timestamp: 2025-05-25T09:12:52.821Z
level: error
metadata: {}
message:
Knex query error: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "districts"."is_active", "country_name", "country_code", "country_id" from "master"."districts" inner join "master"."states" on "states"."state_id" = "districts"."state_id" where "is_active" = $1 order by "district_name" asc - column "country_id" does not exist


timestamp: 2025-05-25T09:13:16.521Z
level: debug
metadata: {}
message:
Knex query: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "districts"."is_active", "country_name", "country_code" from "master"."districts" inner join "master"."states" on "states"."state_id" = "districts"."state_id" where "is_active" = $1 order by "district_name" asc


timestamp: 2025-05-25T09:13:16.576Z
level: error
metadata: {}
message:
Knex query error: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "districts"."is_active", "country_name", "country_code" from "master"."districts" inner join "master"."states" on "states"."state_id" = "districts"."state_id" where "is_active" = $1 order by "district_name" asc - column reference "is_active" is ambiguous


timestamp: 2025-05-25T09:13:36.217Z
level: debug
metadata: {}
message:
Knex query: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "districts"."is_active", "country_name", "country_code" from "master"."districts" inner join "master"."states" on "states"."state_id" = "districts"."state_id" where "districts"."is_active" = $1 order by "district_name" asc


timestamp: 2025-05-25T09:13:36.273Z
level: debug
metadata: {}
message:
Knex query response: [{"districtId":1,"districtName":"Capital City District","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"CCD01","headquarters":"Metropolis Central","population":"1250000","areaSqKm":"1500.75","latitude":"34.052235","longitude":"-118.243683","formationDate":"1950-04-10T07:00:00.000Z","websiteUrl":"http://capitalcitydistrict.example.gov","notes":"The primary administrative and commercial hub of its state. Hosts major governmental offices.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":2,"districtName":"Northern Pines District","stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","districtCode":"NPD02","headquarters":"Pinewood Town","population":"320000","areaSqKm":"4875.50","latitude":"45.523064","longitude":"-122.676483","formationDate":"1978-07-01T07:00:00.000Z","websiteUrl":"http://northernpines.example.gov","notes":"Known for its extensive forests, timber industry, and national parks. Popular tourist destination for hiking and camping.","isActive":true,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-25T17:28:50.588Z
level: debug
metadata: {}
message:
Knex query: select "user_id", "username", "email", "email_verified", "password_hash", "password_salt", "first_name", "last_name", "phone_number", "phone_verified", "last_login", "last_login_ip", "failed_login_attempts", "timezone", "locale", "user_type", "is_active", "is_system" from "identity"."users" where "username" = $1 and "is_active" = $2 limit $3


timestamp: 2025-05-25T17:28:50.660Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"1c702878-d657-4393-b551-22e8879c8025","username":"admin","email":"admin@mail.com","emailVerified":true,"passwordHash":"664bb692f30c9bc71ade","passwordSalt":{"iv":"6fb399fc5f8d9fa567fee517f1e363c6","tag":"24bbcc859702605c80773975918d2560"},"firstName":"admin","lastName":null,"phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-25T01:52:37.614Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-25T17:28:50.760Z
level: debug
metadata: {}
message:
Knex query: update "identity"."users" set "failed_login_attempts" = $1, "last_login" = $2, "last_login_ip" = $3 where "user_id" = $4


timestamp: 2025-05-25T17:28:50.842Z
level: debug
metadata: {}
message:
Knex query: select "user_roles"."role_id", "roles"."name", "roles"."code" from "core"."user_roles" inner join "core"."roles" on "roles"."role_id" = "user_roles"."role_id" where "user_roles"."user_id" = $1 and "user_roles"."is_active" = $2 and "core"."roles"."is_active" = $3


timestamp: 2025-05-25T17:28:50.903Z
level: debug
metadata: {}
message:
Knex query response: [{"roleId":"68e06c11-0437-4b39-98b7-fec86c2a51c2","name":"super admin","code":"SUPERADMIN"}]


timestamp: 2025-05-25T17:28:50.916Z
level: debug
metadata: {}
message:
Knex query: select "useraccessprofile"."accessprofileid", "access_profiles"."name" from "core"."useraccessprofile" inner join "core"."access_profiles" on "access_profiles"."profile_id" = "useraccessprofile"."accessprofileid" where "useraccessprofile"."userid" = $1 and "access_profiles"."is_active" = $2


timestamp: 2025-05-25T17:28:50.984Z
level: debug
metadata: {}
message:
Knex query response: [{"accessprofileid":"0fc584a4-5073-444c-a70e-a9fb56401307","name":"SUPERADMIN"}]


timestamp: 2025-05-25T17:28:58.986Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"1c702878-d657-4393-b551-22e8879c8025","username":"admin","email":"admin@mail.com","emailVerified":true,"passwordHash":"664bb692f30c9bc71ade","passwordSalt":{"iv":"6fb399fc5f8d9fa567fee517f1e363c6","tag":"24bbcc859702605c80773975918d2560"},"firstName":"admin","lastName":null,"phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-25T17:28:50.752Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-25T17:31:41.545Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"1c702878-d657-4393-b551-22e8879c8025","username":"admin","email":"admin@mail.com","emailVerified":true,"passwordHash":"664bb692f30c9bc71ade","passwordSalt":{"iv":"6fb399fc5f8d9fa567fee517f1e363c6","tag":"24bbcc859702605c80773975918d2560"},"firstName":"admin","lastName":null,"phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-25T17:28:59.097Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-25T17:31:41.632Z
level: debug
metadata: {}
message:
Knex query: update "identity"."users" set "failed_login_attempts" = "failed_login_attempts" + $1 where "user_id" = $2


timestamp: 2025-05-25T17:31:41.793Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"1c702878-d657-4393-b551-22e8879c8025","username":"admin","email":"admin@mail.com","emailVerified":true,"passwordHash":"664bb692f30c9bc71ade","passwordSalt":{"iv":"6fb399fc5f8d9fa567fee517f1e363c6","tag":"24bbcc859702605c80773975918d2560"},"firstName":"admin","lastName":null,"phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-25T17:28:59.097Z","lastLoginIp":"::1","failedLoginAttempts":1,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-25T17:31:41.993Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"1c702878-d657-4393-b551-22e8879c8025","username":"admin","email":"admin@mail.com","emailVerified":true,"passwordHash":"664bb692f30c9bc71ade","passwordSalt":{"iv":"6fb399fc5f8d9fa567fee517f1e363c6","tag":"24bbcc859702605c80773975918d2560"},"firstName":"admin","lastName":null,"phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-25T17:28:59.097Z","lastLoginIp":"::1","failedLoginAttempts":2,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-25T17:31:42.210Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"1c702878-d657-4393-b551-22e8879c8025","username":"admin","email":"admin@mail.com","emailVerified":true,"passwordHash":"664bb692f30c9bc71ade","passwordSalt":{"iv":"6fb399fc5f8d9fa567fee517f1e363c6","tag":"24bbcc859702605c80773975918d2560"},"firstName":"admin","lastName":null,"phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-25T17:28:59.097Z","lastLoginIp":"::1","failedLoginAttempts":3,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-25T17:31:59.603Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"1c702878-d657-4393-b551-22e8879c8025","username":"admin","email":"admin@mail.com","emailVerified":true,"passwordHash":"664bb692f30c9bc71ade","passwordSalt":{"iv":"6fb399fc5f8d9fa567fee517f1e363c6","tag":"24bbcc859702605c80773975918d2560"},"firstName":"admin","lastName":null,"phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-25T17:28:59.097Z","lastLoginIp":"::1","failedLoginAttempts":4,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-25T21:57:11.041Z
level: error
metadata: {}
message:
Knex query error: select "state_id", "state_name", "state_code", "is_union_territory", "country_name", "country_code" from "master"."states" where "is_active" = $1 order by "state_name" asc - Connection terminated unexpectedly


timestamp: 2025-05-26T01:20:45.529Z
level: error
metadata: {}
message:
Knex query error: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "districts"."is_active", "country_name", "country_code" from "master"."districts" inner join "master"."states" on "states"."state_id" = "districts"."state_id" where "districts"."is_active" = $1 order by "district_name" asc - Connection terminated unexpectedly


timestamp: 2025-05-26T01:45:19.602Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"1c702878-d657-4393-b551-22e8879c8025","username":"admin","email":"admin@mail.com","emailVerified":true,"passwordHash":"664bb692f30c9bc71ade","passwordSalt":{"iv":"6fb399fc5f8d9fa567fee517f1e363c6","tag":"24bbcc859702605c80773975918d2560"},"firstName":"admin","lastName":null,"phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-25T17:31:59.658Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-26T02:26:25.099Z
level: debug
metadata: {}
message:
Knex query: insert into "master"."districts" ("district_code", "district_name", "state_id") values ($1, $2, $3) on conflict ("district_id") do update set "district_code" = excluded."district_code", "district_name" = excluded."district_name", "state_id" = excluded."state_id"


timestamp: 2025-05-26T02:26:25.952Z
level: debug
metadata: {}
message:
Knex query response: [{"districtId":1,"districtName":"Capital City District","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"CCD01","headquarters":"Metropolis Central","population":"1250000","areaSqKm":"1500.75","latitude":"34.052235","longitude":"-118.243683","formationDate":"1950-04-10T07:00:00.000Z","websiteUrl":"http://capitalcitydistrict.example.gov","notes":"The primary administrative and commercial hub of its state. Hosts major governmental offices.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":2,"districtName":"Northern Pines District","stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","districtCode":"NPD02","headquarters":"Pinewood Town","population":"320000","areaSqKm":"4875.50","latitude":"45.523064","longitude":"-122.676483","formationDate":"1978-07-01T07:00:00.000Z","websiteUrl":"http://northernpines.example.gov","notes":"Known for its extensive forests, timber industry, and national parks. Popular tourist destination for hiking and camping.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":3,"districtName":"Sample","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"Sample","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-26T02:26:38.100Z
level: debug
metadata: {}
message:
Knex query response: [{"districtId":1,"districtName":"Capital City District","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"CCD01","headquarters":"Metropolis Central","population":"1250000","areaSqKm":"1500.75","latitude":"34.052235","longitude":"-118.243683","formationDate":"1950-04-10T07:00:00.000Z","websiteUrl":"http://capitalcitydistrict.example.gov","notes":"The primary administrative and commercial hub of its state. Hosts major governmental offices.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":2,"districtName":"Northern Pines District","stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","districtCode":"NPD02","headquarters":"Pinewood Town","population":"320000","areaSqKm":"4875.50","latitude":"45.523064","longitude":"-122.676483","formationDate":"1978-07-01T07:00:00.000Z","websiteUrl":"http://northernpines.example.gov","notes":"Known for its extensive forests, timber industry, and national parks. Popular tourist destination for hiking and camping.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":3,"districtName":"Sample","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"Sample","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":4,"districtName":"Test","stateId":4,"stateName":"Bihar","stateCode":"BR","districtCode":"Test2","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-26T02:26:52.480Z
level: debug
metadata: {}
message:
Knex query: insert into "master"."districts" ("area_sq_km", "country_code", "country_name", "district_code", "district_id", "district_name", "formation_date", "headquarters", "is_active", "latitude", "longitude", "notes", "population", "state_code", "state_id", "state_name", "website_url") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17) on conflict ("district_id") do update set "area_sq_km" = excluded."area_sq_km", "country_code" = excluded."country_code", "country_name" = excluded."country_name", "district_code" = excluded."district_code", "district_id" = excluded."district_id", "district_name" = excluded."district_name", "formation_date" = excluded."formation_date", "headquarters" = excluded."headquarters", "is_active" = excluded."is_active", "latitude" = excluded."latitude", "longitude" = excluded."longitude", "notes" = excluded."notes", "population" = excluded."population", "state_code" = excluded."state_code", "state_id" = excluded."state_id", "state_name" = excluded."state_name", "website_url" = excluded."website_url"


timestamp: 2025-05-26T02:26:52.573Z
level: error
metadata: {}
message:
Knex query error: insert into "master"."districts" ("area_sq_km", "country_code", "country_name", "district_code", "district_id", "district_name", "formation_date", "headquarters", "is_active", "latitude", "longitude", "notes", "population", "state_code", "state_id", "state_name", "website_url") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17) on conflict ("district_id") do update set "area_sq_km" = excluded."area_sq_km", "country_code" = excluded."country_code", "country_name" = excluded."country_name", "district_code" = excluded."district_code", "district_id" = excluded."district_id", "district_name" = excluded."district_name", "formation_date" = excluded."formation_date", "headquarters" = excluded."headquarters", "is_active" = excluded."is_active", "latitude" = excluded."latitude", "longitude" = excluded."longitude", "notes" = excluded."notes", "population" = excluded."population", "state_code" = excluded."state_code", "state_id" = excluded."state_id", "state_name" = excluded."state_name", "website_url" = excluded."website_url" - column "country_code" of relation "districts" does not exist


timestamp: 2025-05-26T02:31:46.878Z
level: debug
metadata: {}
message:
Knex query: insert into "master"."districts" ("area_sq_km", "district_code", "district_id", "district_name", "formation_date", "headquarters", "is_active", "latitude", "longitude", "notes", "population", "state_id", "state_name", "website_url") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) on conflict ("district_id") do update set "area_sq_km" = excluded."area_sq_km", "district_code" = excluded."district_code", "district_id" = excluded."district_id", "district_name" = excluded."district_name", "formation_date" = excluded."formation_date", "headquarters" = excluded."headquarters", "is_active" = excluded."is_active", "latitude" = excluded."latitude", "longitude" = excluded."longitude", "notes" = excluded."notes", "population" = excluded."population", "state_id" = excluded."state_id", "state_name" = excluded."state_name", "website_url" = excluded."website_url"


timestamp: 2025-05-26T02:31:46.943Z
level: error
metadata: {}
message:
Knex query error: insert into "master"."districts" ("area_sq_km", "district_code", "district_id", "district_name", "formation_date", "headquarters", "is_active", "latitude", "longitude", "notes", "population", "state_id", "state_name", "website_url") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) on conflict ("district_id") do update set "area_sq_km" = excluded."area_sq_km", "district_code" = excluded."district_code", "district_id" = excluded."district_id", "district_name" = excluded."district_name", "formation_date" = excluded."formation_date", "headquarters" = excluded."headquarters", "is_active" = excluded."is_active", "latitude" = excluded."latitude", "longitude" = excluded."longitude", "notes" = excluded."notes", "population" = excluded."population", "state_id" = excluded."state_id", "state_name" = excluded."state_name", "website_url" = excluded."website_url" - column "state_name" of relation "districts" does not exist


timestamp: 2025-05-26T02:32:26.839Z
level: debug
metadata: {}
message:
Knex query response: [{"districtId":1,"districtName":"Capital City District","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"CCD01","headquarters":"Metropolis Central","population":"1250000","areaSqKm":"1500.75","latitude":"34.052235","longitude":"-118.243683","formationDate":"1950-04-10T07:00:00.000Z","websiteUrl":"http://capitalcitydistrict.example.gov","notes":"The primary administrative and commercial hub of its state. Hosts major governmental offices.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":2,"districtName":"Northern Pines District","stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","districtCode":"NPD02","headquarters":"Pinewood Town","population":"320000","areaSqKm":"4875.50","latitude":"45.523064","longitude":"-122.676483","formationDate":"1978-07-01T07:00:00.000Z","websiteUrl":"http://northernpines.example.gov","notes":"Known for its extensive forests, timber industry, and national parks. Popular tourist destination for hiking and camping.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":3,"districtName":"Sample","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"Sample","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":4,"districtName":"Test","stateId":4,"stateName":"Bihar","stateCode":"BR","districtCode":"Test2","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":5,"districtName":"testadd","stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","districtCode":"test","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-26T02:32:35.277Z
level: debug
metadata: {}
message:
Knex query: insert into "master"."districts" ("area_sq_km", "district_code", "district_id", "district_name", "formation_date", "headquarters", "is_active", "latitude", "longitude", "notes", "population", "state_id", "website_url") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) on conflict ("district_id") do update set "area_sq_km" = excluded."area_sq_km", "district_code" = excluded."district_code", "district_id" = excluded."district_id", "district_name" = excluded."district_name", "formation_date" = excluded."formation_date", "headquarters" = excluded."headquarters", "is_active" = excluded."is_active", "latitude" = excluded."latitude", "longitude" = excluded."longitude", "notes" = excluded."notes", "population" = excluded."population", "state_id" = excluded."state_id", "website_url" = excluded."website_url"


timestamp: 2025-05-26T02:32:35.570Z
level: debug
metadata: {}
message:
Knex query response: [{"districtId":1,"districtName":"Capital City District","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"CCD01","headquarters":"Metropolis Central","population":"1250000","areaSqKm":"1500.75","latitude":"34.052235","longitude":"-118.243683","formationDate":"1950-04-10T07:00:00.000Z","websiteUrl":"http://capitalcitydistrict.example.gov","notes":"The primary administrative and commercial hub of its state. Hosts major governmental offices.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":2,"districtName":"Northern Pines District","stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","districtCode":"NPD02","headquarters":"Pinewood Town","population":"320000","areaSqKm":"4875.50","latitude":"45.523064","longitude":"-122.676483","formationDate":"1978-07-01T07:00:00.000Z","websiteUrl":"http://northernpines.example.gov","notes":"Known for its extensive forests, timber industry, and national parks. Popular tourist destination for hiking and camping.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":3,"districtName":"Sample","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"Sample","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":4,"districtName":"Test","stateId":4,"stateName":"Bihar","stateCode":"BR","districtCode":"Test2","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":5,"districtName":"testadd","stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","districtCode":"test2","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-05-26T02:32:42.430Z
level: debug
metadata: {}
message:
Knex query response: [{"districtId":1,"districtName":"Capital City District","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"CCD01","headquarters":"Metropolis Central","population":"1250000","areaSqKm":"1500.75","latitude":"34.052235","longitude":"-118.243683","formationDate":"1950-04-10T07:00:00.000Z","websiteUrl":"http://capitalcitydistrict.example.gov","notes":"The primary administrative and commercial hub of its state. Hosts major governmental offices.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":2,"districtName":"Northern Pines District","stateId":2,"stateName":"Arunachal Pradesh","stateCode":"AR","districtCode":"NPD02","headquarters":"Pinewood Town","population":"320000","areaSqKm":"4875.50","latitude":"45.523064","longitude":"-122.676483","formationDate":"1978-07-01T07:00:00.000Z","websiteUrl":"http://northernpines.example.gov","notes":"Known for its extensive forests, timber industry, and national parks. Popular tourist destination for hiking and camping.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":3,"districtName":"Sample","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"Sample","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":4,"districtName":"Test","stateId":4,"stateName":"Bihar","stateCode":"BR","districtCode":"Test2","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":5,"districtName":"testadd","stateId":14,"stateName":"Maharashtra","stateCode":"MH","districtCode":"test2","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"}]


# audit_2025_05_26

timestamp: 2025-05-26T07:13:15.463Z
level: debug
metadata: {}
message:
Knex query: select "sub_caste_id", "sub_caste_name", "subcastes"."caste_id", "caste_name", "subcastes"."is_active", "subcastes"."description" from "master"."subcastes" inner join "master"."castes" on "castes"."caste_id" = "subcastes"."caste_id" where "subcastes"."is_active" = $1 order by "sub_caste_name" asc


timestamp: 2025-05-26T07:13:15.635Z
level: debug
metadata: {}
message:
Knex query: select "caste_id", "caste_name", "is_active", "description" from "master"."castes" where "is_active" = $1 order by "caste_name" asc


timestamp: 2025-05-26T07:19:13.827Z
level: debug
metadata: {}
message:
Knex query response: [{"casteId":"be8eb9d5-c094-4117-a215-52ec7ebd203e","casteName":"OC","isActive":true,"description":null}]


