Major Issues faced in CSI in the department of Posts with their solution : Postal RADAR

Major Issues faced in CSI in the department of Posts with their solution

FAQ on Infrastructure issue (DB related/Sync) Major Issues faced in CSI in the department of Posts with their solution

FAQ on Infrastructure issue (DB related/Sync)

Major Issues faced in CSI in the department of Posts with their solution 

1) How to start DB?

Answer:

Follow below steps:

A. Open “C” drive.

B. Open "POSTALPOS_BO" folder OR Go to the path "C:\POSTALPOS_BO".

C. Double click on "Start_Database_Server.bat".

2) How to run HIGH synchronization manually?

Answer:

Follow below steps:

A. Open “C” drive.

B. Open "POSTALPOS_BO" folder OR Go to the path "C:\POSTALPOS_BO".

C. Double click on “Run_Mobilink_Client_HIGH.bat”.

D. A small pop-up window will be opened. The pop-up will be closed automatically once the sync is successfully executed.

E. In case of failure, at the button part of the pop-up window an error message will be shown as “Synchronization failed. To see the error, user can scroll up/down the scroll bar.

3) How to check last successful sync date and time?

Answer:

After logging into Postal Back Office, user can see the last sync date time at the top right corner of the screen.


4) How to run DAILY synchronization manually?

Answer:

Follow below steps:

A. Open “C” drive.

B. Open "POSTALPOS_BO" folder OR Go to the path "C:\POSTALPOS_BO".

C. Double click on “Run_Mobilink_Client_DAILY.bat”.

D. A small pop-up window will be opened. The pop-up will be closed automatically once the sync is successfully executed.

E. In case of failure, at the button part of the pop-up window an error message will be shown as “Synchronization failed. To see the error, user can scroll up/down the scroll bar.

5) DAILY synchronization failure with message ending with ‘Already in use’.

Answer:

When Daily sync is executed first time in a day, system will lock the process for that office and will show this error message on subsequent execution of Daily sync on same day.

6) What is to be done in case of “ASSERTION FAILURE” while starting DB?

Answer:

Log a ticket in Service Desk as a ‘Request’ and wait for assistance. In the ticket mention following:

A. Date and time when error was first noticed.

B. If any transaction has been done in the same day. If yes, date and time of the transaction.

C. Last TCB matched or not.

D. Last date of back up in C:\POSTALPOS_Backup.


7) What is to be done in case of “db srv16” while starting DB?

Answer:

Log a ticket in Service Desk as a ‘Request’ and wait for assistance. In the ticket mention following:

A. Date and time when error was first noticed.

B. If any transaction has been done in the same day. If yes, date and time of the transaction.

C. Last TCB matched or not.

D. Last date of back up in C:\POSTALPOS_Backup.

8) What is to be done in case of “missing transaction log” OR “cannot open transaction log file” while starting DB?

Answer:

Log a ticket in Service Desk as a ‘Request’ and wait for assistance. In the ticket mention following:

A. Date and time when error was first noticed.

B. If any transaction has been done in the same day. If yes, date and time of the transaction.

C. Last TCB matched or not.

D. Last date of back up in C:\POSTALPOS_Backup.

9) While starting High Sync manually if the following message is displayed in the sync window:

Server error: Message: ODBC: [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Attempt to insert duplicate key row in object 'IPVS_POS_BOOKING_INTERFACE' with unique index 'UK_IPVS_POS_BOOKING_INTERFACE' (ODBC State = 23000, Native error code = 2601). Table Name: IPVS_POS_BOOKING_INTERFACE ...

Answer:

Log a ticket in Service Desk as a ‘Request’ and wait for assistance.


10) While starting Sync manually if the message “DSN error” is displayed in the sync window:

Answer:

Follow below steps:

A. Open https://172.19.64.105:8080/pos/database_build

B. Download “DBissue.zip”.

C. Unzip “DBissue.zip” and open it.

D. Keep “DSN.bat” in “C:\POS” folder and double click on it.

E. Once execution is completed, run sync.

11) While starting Sync manually if the message “Winsock error (err code 10060)” is displayed in the sync window, then what is to be done?

Answer:

Check the network connectivity with Sify team. If Sify NSP1” network is fine, then run the sync manually after 30-40 mins.

12) In case of Winsock error (other than err code 10060), what is to be done?

Answer:

i) Check the Network with Sify team.

ii) If network is fine, then it might be OS issue. If so, then only follow below steps:

A. Copy 5 POS folders – “POS”, “POSTALPOS_BO”, “POSTALPOS_Backup”, “POS_EBILLER_BILL” and “POS_INSTALLER” and keep it safely.

B. Format and reinstall the OS.

C. Paste the copied 5 folders to “C” drive.

D. Open http://172.19.64.105:8080/pos/database_build

E. Download “DBissue.zip”.

F. Unzip “DBissue.zip” and open it.

G. Keep “InstallASE.bat” in “C:\POS_Installer\SqlAnywhere_16\SQLAnywhere” folder and double click on it.

H. Once execution is completed, start database and then run sync.


13) While opening Application in server if “db connection error” comes, then what is to be done?

Answer:

The following steps to be followed:

A. Open web browser and paste the URL, http://172.19.64.105:8080/pos/database_build

B. Download “PMT.zip” (click on it to download).

C. Unzip “PMT.zip” and open it.

D. Generate a “po_connection.db” file (run “start.bat” to generate “po_connection.db” file).

E. Copy the “po_connection.db” file and paste it in “C:\POS\Application\BO\build\db_con” and “C:\POS\Application\Counter\build\db_con” folders (replace the previous one).

14) While opening Application in client if “db connection error” comes, then what is to be done?

Answer:

If applications are opening from server machine, then follow below steps:

A. Copy the “po_connection.db” file available in “C:\POS\Application\BO\build\db_con” folder of server machine

B. Paste it in “C:\POS\Application\BO\build\db_con” and “C:\POS\Application\Counter\build\db_con” folders of client machine (replace the previous one).

OR

Simply replace the POS folder of the client machine with the POS folder of server machine. If still problem persists, follow below steps:

A. From client machine open command prompt.

B. Type the MS-DOS command Telnet <IP of server> 5555 and press Enter Key.

C. If command prompt window is not completely blank and giving some error, then check with SA for LAN settings.


15) What is to be done in case of server change due to motherboard failure?

Answer:

If backups (5 POS folders – “POS”, “POSTALPOS_BO”, “POSTALPOS_Backup”, “POS_EBILLER_BILL” and “POS_INSTALLER”) are available, then follow the below steps:

A. Paste the 5 POS folders in “C” drive.

B. Open http://172.19.64.105:8080/pos/database_build

C. Download “DBissue.zip”.

D. Unzip “DBissue.zip” and open it.

E. Keep “InstallASE.bat” in “C:\POS_Installer\SqlAnywhere_16\SQLAnywhere” folder and double click on it.

F. Once execution is completed, start database and then run sync.

If backups are not available, do Fresh installation with the help of System Admin.

16) What is to be done in case of the following:

a) Server crash

b) Server formatted without taking backup?

Answer:

Fresh installation to be done in such cases. Important:

Fresh installation to be done with the help of System Admin OR

Log a ticket in Service Desk as a ‘Request' and wait for assistance.

17) Errors “An unexpected DB error occurred. Please contact System Admin” while doing eMO transaction and “System failure. Please contact System Admin” while doing ePayment transactions.

Answer:

Log a ticket in Service Desk as a ‘Request' and wait for assistance.

COMMENTS

BLOGGER
Name

Achievements,5,Allowances,87,Amendments,3,Android Apk,3,Announcements,38,anomalies,3,Articles,30,ATM,1,Audio / Video,3,Awards,7,Awareness,3,Banking,44,Books,3,Branch Post Office,2,BSNL,35,Business,15,Cadre Restructuring,10,CAT,4,CBS,2,CBS-CTS,1,CCA,5,CCA MCQ,1,CCS Rules,12,CEA,8,CGHS,56,Clarifications,27,COD,1,Competitive Exams,15,Computer Guidelines,119,Corona / Covid-19,32,Court News,35,Customer Care,247,Defence,1,Deputation,2,Differently Abled,7,DOP News,167,DOP Orders,99,DOPT Orders,331,Drivers,5,Dte Orders,58,e-Services,29,Education,117,Elections,3,Employees News,868,Employment News,85,Entertainments,60,Events,48,Exam / Result,112,Exam / Syllabus,58,Exam News,17,Facts,3,FAQ,78,Finacle,14,Finmin Orders,8,For System Administrators,128,Forms,15,FR Quiz,5,Frauds,1,Gazette,2,GDS,43,GenEng,1,General Informations,167,General Knowledge,344,GFR,3,GK,7,GO,1,GOVT Orders,50,GPF,1,Greetings,17,Guidelines,19,Hardwares,9,HBA,9,Health Tips,38,Holiday Home,18,Holidays List,6,Honorarium / Incentives,10,Important Letters,3,Important Persons,2,Income Tax,56,Instructions,3,Interest Rate,14,Internet Tips,94,IPO,191,Judgement,19,KV Schools,13,Labour News,2,Latest Software Updates,76,LAW,15,Leave Rules,44,Letter to Dte,1,Lokpal and Lokayuktas,1,LTC,41,MA Rules,5,MACP,26,Mails,24,MCQ,1,MHA Orders,2,Miscellaneous,4,MMS,18,Mobile Tips,33,National Pension System (NPS),51,NEFT / RTGS,2,Network Trouble shooting,11,News,179,Notifications,13,OBC related,1,Operating Procedures,15,Pay & Allowances,2,Pay Commission,45,Pay Commission - 7th,34,Pay Fixation,7,Pension,144,Pensioners News,11,Persmin,35,Philately,27,PLI,1,PLI and RPLI,32,POGuide I,5,PointOfSale,4,POSB,57,POSB Clarifications,13,Postal Accounts & Finance,1,Postal Accouunts / PAO,1,Postal Exams,4,Postal Informations,150,Postal Manuals,3,Postal Savings Schemes,61,PostalHistory,2,Printer Trouble shooting,11,Printing Tips,15,Project Arrow,6,Promotions,10,Questions / Answers,51,Quiz,34,Railway,110,Rajya Sabha Q&A,1,Random,6,Recovery Tips,12,Recruitment Rules,6,Registry Tips,26,Registry Tools,11,Reimbursement,7,Reservation,2,Results,1,RICT,2,RMS,15,Rotational Transfer,2,RTI,18,Rulings,63,SanchayPost,111,SAP,1,Savings Scheme,18,SB Orders,310,SBCO,29,SBOrder2017,1,SBOrder2018,1,SBOrder2020,1,SBOrder2021,6,SBOrder2022,2,Security Guidelines,23,Security Tips,46,Seniority List,1,Software Tips,11,Softwares,24,Speed Post,1,Sports,5,SQL,49,Staffs and Welfare,200,State News,19,Stories,5,Students,4,Study Materials,186,Sukanya Samriddhi Account,7,Tax,5,Technology,29,Technology News,23,TET / TRB / TNPSC,14,Tips and Tricks,111,TN - தமிழ்நாடு,33,Tools,30,Training,32,Transfer / Postings,38,Trouble shooting,25,UnCategorized,4,Union News,90,Update,93,Useful Softwares,125,Utilities,64,Virus Solutions,23,Websites,53,Welfare,1,windows 7,12,Windows Server,10,Windows Tips,152,Windows Vista,5,
ltr
item
Postal RADAR: Major Issues faced in CSI in the department of Posts with their solution : Postal RADAR
Major Issues faced in CSI in the department of Posts with their solution : Postal RADAR
Major Issues faced in CSI in the department of Posts with their solution
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiERNX1LIKMyrzEZ68IaaVM2h2_a46hks13o4oi0g3aETBJkavc7ap1E9LR2OPIwDSNwAziAVI3gVrpt0bSYEixGibACADDNgyymaJZtJ-aYzvwhIy1KO1JO_PiXAvTCVdyGAWGbIuhbmc/w400-h300/faq+on+db+issues.png
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiERNX1LIKMyrzEZ68IaaVM2h2_a46hks13o4oi0g3aETBJkavc7ap1E9LR2OPIwDSNwAziAVI3gVrpt0bSYEixGibACADDNgyymaJZtJ-aYzvwhIy1KO1JO_PiXAvTCVdyGAWGbIuhbmc/s72-w400-c-h300/faq+on+db+issues.png
Postal RADAR
https://www.postalradar.com/2020/09/blog-post_20.html
https://www.postalradar.com/
https://www.postalradar.com/
https://www.postalradar.com/2020/09/blog-post_20.html
true
5719657340864375059
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content