Activity #2821
openModule #2640: Pension Claim - Phase III
Module #2664: DA user claim Listing
Sub module #2859: Development & Unit testing
DB Logic
Added by Nisha Balakrishnan about 2 years ago. Updated about 2 years ago.
100%
Updated by Nisha Balakrishnan about 2 years ago
- Status changed from Rejected to New
Updated by Sreeshna T about 2 years ago
- % Done changed from 0 to 20
Explored to write procedures in oracle db.
Created new procedure "GET_TRACK_CLAIM_STATUS".
Updated by Nisha Balakrishnan about 2 years ago
- Parent task changed from #2664 to #2859
Updated by Nisha Balakrishnan about 2 years ago
- Tracker changed from Sub module to Activity
Updated by Sreeshna T about 2 years ago
- Status changed from New to Resolved
- % Done changed from 20 to 100
Completed the DB Logic.
created new package "PKG_OCS_FORM_10_D".
created new procedure "GET_TRACK_CLAIM_STATUS" inside this package.
Updated by Thara S Pillai about 2 years ago
Common standard JSON scheme to handle exceptions and logging errors that includes attributes for error codes, messages, and other relevant information. This will be part of every response from a service. The error code has a format ERR_<4 digit number>. The error codes may be mapped with messages in .property files. The technical details on errors/warnings will be logged in log files
"{
""data"": ""response data"" //relevant and read in client-side only when status attribute value is success
""status"": ""string"", // e.g., ""success"", ""error"", ""warning""
""errorCode"": ""string"", // A code representing the specific error. codes like ERR-<4 digit code>. Definition / mapping to message to do in server side property files.
""errorMessage"": ""string"", // A human-readable message describing the error.
""timestamp"": ""string"", // Timestamp of when the error occurred
""details"": ""object"", // Optional object to include additional details
""source"": ""string"", // Source of the error, e.g., ""database"", ""api"", ""validation""
""traceId"": ""string"", // Unique identifier for tracking the request
""userMessage"": ""string"", // A user-friendly message to be shown to the end user
""logLevel"": ""string"" // Log level e.g., ""INFO"", ""WARN"", ""ERROR""
}"
"{
""status"": ""error"",
""errorCode"": ""ERR_0001"",
""errorMessage"": ""Failed to retrieve data from the database."",
""timestamp"": ""2024-06-02T15:04:05Z"",
""details"": {
""query"": ""SELECT * FROM users WHERE id = 123"",
""parameters"": {
""id"": 123
}
},
""source"": ""database"",
""traceId"": ""abc123xyz"",
""userMessage"": ""An error occurred while fetching your data. Please try again later."",
""logLevel"": ""ERROR""
}"
"status: Indicates the result of the operation, such as ""success"", ""error"", or ""warning"".
errorCode: A specific code identifying the type of error, which can be used for both debugging and displaying a user-friendly error message.
errorMessage: A detailed message explaining what went wrong, intended primarily for developers or logs.
timestamp: The time when the error occurred, which helps in tracking and logging.
details: An optional object that can include any additional information relevant to the error, such as SQL queries, parameters, stack traces, etc.
source: Indicates where the error originated, such as ""database"", ""api"", or ""validation"", which helps in pinpointing the issue.
traceId: A unique identifier for the request or operation, useful for tracing the error through logs and across different services.
userMessage: A simplified and user-friendly message that can be displayed to the end user.
logLevel: The severity level of the error, which can help in filtering and prioritizing log entries."
Updated by Thara S Pillai about 2 years ago
- Status changed from Resolved to In Progress
- Only claims that are to be processed by the logged-in user's field office need to be listed in the claim list. The user ID and office of the logged-in DA user should be checked to ensure they are associated with the establishment of the user's primary member service.
- Handle exceptions and report through error attributes in JSON
Updated by Thara S Pillai about 2 years ago
the field C_OFFICE_ID to be checked with logged in da user's office ID
Updated by Sreeshna T about 2 years ago
- % Done changed from 100 to 80
Exception handling done.
Created a new procedure PENSION_LOG_ERROR. Called the procedure in GET_TRACK_CLAIM_STATUS.
Identified the table that storing user id and office id of da user.
Inserted office id value into CEN_OCS_FORM_TEMP table.
Need to check the condition C_OFFICE_ID with da user's office ID.
Updated by Sreeshna T about 2 years ago
- Status changed from In Progress to Resolved
Updated by Sreeshna T about 2 years ago
- % Done changed from 80 to 100
the field C_OFFICE_ID checked with logged in da user's office ID.