Project

General

Profile

Actions

Data Services #1575

open

PMS Execution for 2023 Year

Added by Venkata Suryateja Thripuraribhotla 3 months ago. Updated about 2 months ago.

Status:
In Progress
Priority:
High
Start date:
06/01/2025
Due date:
% Done:

90%

Estimated time:
Deployed In:
Production Environment
Category:
Database

Description

We have been asked by RDA to execute PMS process and prepare the HDM files for the survey year 2023.


Files

Final Network data.pdf (860 KB) Final Network data.pdf Venkata Suryateja Thripuraribhotla, 20/02/2025 12:36 PM
Actions #1

Updated by Venkata Suryateja Thripuraribhotla 3 months ago

Road summary has been executed for the Roads in Stage (Satra), now we need to execute sectioning process.

Actions #2

Updated by Venkata Suryateja Thripuraribhotla 3 months ago

  • Start date changed from 15/01/2025 to 06/01/2025
Actions #3

Updated by Venkata Suryateja Thripuraribhotla 3 months ago

  • Deployed In changed from Demo Environment to Production Environment

We are trying to execute sectioning process in Production, but unable to execute sectioning and no error or alert is displayed.

Actions #4

Updated by Venkata Suryateja Thripuraribhotla 3 months ago

Sectioning process in production for one province took around 8 hours of time to complete. HDM preparation has been done within 15-20 mins.

Actions #5

Updated by Venkata Suryateja Thripuraribhotla 2 months ago

  • Status changed from New to In Progress
Actions #6

Updated by Venkata Suryateja Thripuraribhotla 2 months ago

PMS execution has been initiated in client stage. Working around to find the root cause of the delay for PMS process execution.

Actions #7

Updated by Venkata Suryateja Thripuraribhotla 2 months ago

As per the suggestion from madam, Demo database has been copied to client stage and will reinitiate the process to find whether the issue is with the database or with the instance of the application.

Actions #8

Updated by Venkata Suryateja Thripuraribhotla 2 months ago

PMS in client stage is unsuccessful due to db connectivity issues in the server. Also the process executed in parallel in our demo server also failed due to Server storage issue.

Actions #9

Updated by Venkata Suryateja Thripuraribhotla 2 months ago

Road Summary process has been initiated in stage and demo servers on 11/02/2025 to get the road summary with accurate data.

Actions #10

Updated by Venkata Suryateja Thripuraribhotla about 2 months ago

Worked on Data correction of Road Summary base tables data for 2023 year on 18/02/2025.

Actions #11

Updated by Venkata Suryateja Thripuraribhotla about 2 months ago

Date : 19/02/2025.
Data correction of base data tables has been made in demo database and removed duplicate data from the system.
Prepared network data for all the base tables from 2021 and 2017.

Actions #12

Updated by Venkata Suryateja Thripuraribhotla about 2 months ago

PMS process has been completed in Geodemo server and the files are shared to RDA. The same has been executed in production by copying Roadsummary from demo to production server.

Actions #13

Updated by Venkata Suryateja Thripuraribhotla about 2 months ago

  • % Done changed from 50 to 90
Actions

Also available in: Atom PDF