# audit_2025_05_26

timestamp: 2025-05-26T07:20:29.672Z
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-26T07:26:35.340Z
level: debug
metadata: {}
message:
Knex query: insert into "master"."subcastes" ("caste_id", "sub_caste_name") values ($1, $2) on conflict ("sub_caste_id") do update set "caste_id" = excluded."caste_id", "sub_caste_name" = excluded."sub_caste_name"


timestamp: 2025-05-26T07:26:35.859Z
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-26T07:27:15.143Z
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:27:15.203Z
level: debug
metadata: {}
message:
Knex query response: [{"subCasteId":"218e7d1a-bb3d-4790-b5f3-642e12d3b721","subCasteName":"OC A","casteId":"be8eb9d5-c094-4117-a215-52ec7ebd203e","casteName":"OC","isActive":true,"description":null}]


timestamp: 2025-05-26T07:27:22.456Z
level: debug
metadata: {}
message:
Knex query response: [{"subCasteId":"218e7d1a-bb3d-4790-b5f3-642e12d3b721","subCasteName":"OC A","casteId":"be8eb9d5-c094-4117-a215-52ec7ebd203e","casteName":"OC","isActive":true,"description":null},{"subCasteId":"4436009a-e6d2-43c0-bc58-e492a67bf9d6","subCasteName":"OC B","casteId":"be8eb9d5-c094-4117-a215-52ec7ebd203e","casteName":"OC","isActive":true,"description":null}]


timestamp: 2025-05-26T07:27:55.662Z
level: debug
metadata: {}
message:
Knex query: insert into "master"."subcastes" ("caste_id", "caste_name", "description", "is_active", "sub_caste_id", "sub_caste_name") values ($1, $2, $3, $4, $5, $6) on conflict ("sub_caste_id") do update set "caste_id" = excluded."caste_id", "caste_name" = excluded."caste_name", "description" = excluded."description", "is_active" = excluded."is_active", "sub_caste_id" = excluded."sub_caste_id", "sub_caste_name" = excluded."sub_caste_name"


timestamp: 2025-05-26T07:27:55.964Z
level: error
metadata: {}
message:
Knex query error: insert into "master"."subcastes" ("caste_id", "caste_name", "description", "is_active", "sub_caste_id", "sub_caste_name") values ($1, $2, $3, $4, $5, $6) on conflict ("sub_caste_id") do update set "caste_id" = excluded."caste_id", "caste_name" = excluded."caste_name", "description" = excluded."description", "is_active" = excluded."is_active", "sub_caste_id" = excluded."sub_caste_id", "sub_caste_name" = excluded."sub_caste_name" - column "caste_name" of relation "subcastes" does not exist


timestamp: 2025-05-26T07:31:19.663Z
level: debug
metadata: {}
message:
Knex query: insert into "master"."subcastes" ("caste_id", "caste_name", "description", "is_active", "sub_caste_id") values ($1, $2, $3, $4, $5) on conflict ("sub_caste_id") do update set "caste_id" = excluded."caste_id", "caste_name" = excluded."caste_name", "description" = excluded."description", "is_active" = excluded."is_active", "sub_caste_id" = excluded."sub_caste_id"


timestamp: 2025-05-26T07:31:19.730Z
level: error
metadata: {}
message:
Knex query error: insert into "master"."subcastes" ("caste_id", "caste_name", "description", "is_active", "sub_caste_id") values ($1, $2, $3, $4, $5) on conflict ("sub_caste_id") do update set "caste_id" = excluded."caste_id", "caste_name" = excluded."caste_name", "description" = excluded."description", "is_active" = excluded."is_active", "sub_caste_id" = excluded."sub_caste_id" - column "caste_name" of relation "subcastes" does not exist


timestamp: 2025-05-26T07:33:02.659Z
level: debug
metadata: {}
message:
Knex query: insert into "master"."subcastes" ("caste_id", "description", "is_active", "sub_caste_id", "sub_caste_name") values ($1, $2, $3, $4, $5) on conflict ("sub_caste_id") do update set "caste_id" = excluded."caste_id", "description" = excluded."description", "is_active" = excluded."is_active", "sub_caste_id" = excluded."sub_caste_id", "sub_caste_name" = excluded."sub_caste_name"


timestamp: 2025-05-26T07:33:03.231Z
level: debug
metadata: {}
message:
Knex query response: [{"subCasteId":"218e7d1a-bb3d-4790-b5f3-642e12d3b721","subCasteName":"OC A","casteId":"be8eb9d5-c094-4117-a215-52ec7ebd203e","casteName":"OC","isActive":true,"description":null},{"subCasteId":"4436009a-e6d2-43c0-bc58-e492a67bf9d6","subCasteName":"OC D","casteId":"be8eb9d5-c094-4117-a215-52ec7ebd203e","casteName":"OC","isActive":true,"description":null}]


timestamp: 2025-05-26T21:12:32.594Z
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-26T21:12:32.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-26T01:45:19.682Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-26T21:12:32.750Z
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-26T21:12:32.823Z
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-26T21:12:32.880Z
level: debug
metadata: {}
message:
Knex query response: [{"roleId":"68e06c11-0437-4b39-98b7-fec86c2a51c2","name":"super admin","code":"SUPERADMIN"}]


timestamp: 2025-05-26T21:12:32.890Z
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-26T21:12:32.942Z
level: debug
metadata: {}
message:
Knex query response: [{"accessprofileid":"0fc584a4-5073-444c-a70e-a9fb56401307","name":"SUPERADMIN"}]


timestamp: 2025-05-26T21:14:12.855Z
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-26T21:12:32.748Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-26T21:15:24.227Z
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-26T21:14:12.924Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-27T00:11:18.251Z
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 "user_type" in ($2, $3) and "is_active" = $4 limit $5


timestamp: 2025-05-27T00:11:18.313Z
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-26T21:15:24.308Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-27T00:11:21.365Z
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-27T00:11:18.378Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-27T03:48:04.041Z
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-27T00:11:21.432Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-27T05:13:22.440Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"56d824c3-783a-4910-9d22-4d0b9461df64","username":"user@mail.com","email":"user@mail.com","emailVerified":true,"passwordHash":"0b29258890e5394c7f94f8e00e2d","passwordSalt":{"iv":"412d27f21268bf7c4573e2a73771899e","tag":"f44591e18f74108e15d3329e60c69461"},"firstName":"User","lastName":"Name","phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-27T03:48:04.146Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


timestamp: 2025-05-27T06:29:23.044Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"56d824c3-783a-4910-9d22-4d0b9461df64","username":"user@mail.com","email":"user@mail.com","emailVerified":true,"passwordHash":"0b29258890e5394c7f94f8e00e2d","passwordSalt":{"iv":"412d27f21268bf7c4573e2a73771899e","tag":"f44591e18f74108e15d3329e60c69461"},"firstName":"User","lastName":"Name","phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-27T05:13:22.535Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


timestamp: 2025-05-27T06:30:36.777Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"56d824c3-783a-4910-9d22-4d0b9461df64","username":"user@mail.com","email":"user@mail.com","emailVerified":true,"passwordHash":"0b29258890e5394c7f94f8e00e2d","passwordSalt":{"iv":"412d27f21268bf7c4573e2a73771899e","tag":"f44591e18f74108e15d3329e60c69461"},"firstName":"User","lastName":"Name","phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-27T06:29:23.122Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


timestamp: 2025-05-27T06:43:16.448Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"56d824c3-783a-4910-9d22-4d0b9461df64","username":"user@mail.com","email":"user@mail.com","emailVerified":true,"passwordHash":"0b29258890e5394c7f94f8e00e2d","passwordSalt":{"iv":"412d27f21268bf7c4573e2a73771899e","tag":"f44591e18f74108e15d3329e60c69461"},"firstName":"User","lastName":"Name","phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-27T06:30:36.852Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


timestamp: 2025-05-27T06:44:55.788Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"56d824c3-783a-4910-9d22-4d0b9461df64","username":"user@mail.com","email":"user@mail.com","emailVerified":true,"passwordHash":"0b29258890e5394c7f94f8e00e2d","passwordSalt":{"iv":"412d27f21268bf7c4573e2a73771899e","tag":"f44591e18f74108e15d3329e60c69461"},"firstName":"User","lastName":"Name","phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-27T06:43:16.621Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


timestamp: 2025-05-27T06:44:58.092Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"56d824c3-783a-4910-9d22-4d0b9461df64","username":"user@mail.com","email":"user@mail.com","emailVerified":true,"passwordHash":"0b29258890e5394c7f94f8e00e2d","passwordSalt":{"iv":"412d27f21268bf7c4573e2a73771899e","tag":"f44591e18f74108e15d3329e60c69461"},"firstName":"User","lastName":"Name","phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-27T06:44:55.955Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


timestamp: 2025-05-27T06:46:28.237Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"56d824c3-783a-4910-9d22-4d0b9461df64","username":"user@mail.com","email":"user@mail.com","emailVerified":true,"passwordHash":"0b29258890e5394c7f94f8e00e2d","passwordSalt":{"iv":"412d27f21268bf7c4573e2a73771899e","tag":"f44591e18f74108e15d3329e60c69461"},"firstName":"User","lastName":"Name","phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-27T06:44:58.198Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"APPLICANT","isActive":true,"isSystem":true}


