Problems which may occur during month closing
1.Difficulty in INFANT data processing -:
This issue appears on closing day, Finance and Statics team will not be able to update the infant data. Here we have to check Middleware Database weather the subject month table created or not. If it has been created then we should drop the table and let them process again.
Middleware Database Connection
HOST=" + "SVHQMWS01" + ")(PORT=1521)))(CONNECT_DATA=(SID=middlewaredb)(SERVER=DEDICATED)));User Id=" + "starusr" + ";Password=" + "star123";
2..Many miss match data of RAPID and BW
Here missing may be COPA FLIGHT NUMBER blank, Data miss match of Rapid and BWP. We use Plot(Movement Control) as a source and generate full month flight data. Use Flight Schedule parser exe setup built in house to convert the raw data to FS.txt then
a. Load FS.txt to BWP DSO name ZDSO_FDY
b. Load FS.txt to CAT03 database using ROUTE program
c.Generate SECTOR and ROUTE respectively by selecting all tails on the ROUTE program
finally generate sector.txt and route.txt files and load to ZDSO_SEC and ZDSO_RUT respectively.