SanchayPost- SO to HO Data Transfer

How to reset the sequence number to 1 at SO?
Use the option ‘DBAnalyzer >> DBUtilities >> SO - HO Data Transfer’ before doing day-end on the day data transfer is to be commenced. Select only the schemes for which data transfer is planned to be commenced.
Files with sequence number 1 will be generated during day end for the initialised schemes. This option has to be executed only once at a SO for any scheme.
This should not be done if transfer of data from SO to HO has already been performed for this SO through Sanchay Post.
2.How to reset the sequence number to 1 at HO for a SO?
Use the option ‘DBAnalyzer >> DBUtilities >> HO - SO Data Transfer’ before doing day end on the day data transfer is to be commenced. Use this option for the SO for which data transfer from HO is planned to be commenced.
Files with sequence number 1 will be generated during day end for the initialised SO, if any data is available. This option has to be executed only once for a SO.
3.What are the preparatory steps for commencement of SO to HO data transfer?

The following points are to be ensured:a. POCode at HO & SO should be the same. If not, at SO use DBAnalyzer to change code.b. Include HO name in SOs (Using PO Name & Address Form) in a separate row.c. Designate the nodes for ‘Day end’. Files are generated in the node in which day end is performed.d. Check whether the fields ‘Name’ / ‘City’ / ‘Pincode’ are not blank for the schemes in which data transfer is to be commenced.e. Rectify the discrepancies listed in DBAnalyzer.
4.
Files for data transfer are not generated at SO in the designated system and folder and cannot be regenerated.
Wait for ‘day-end completed successfully’ message. If this is not done files will not be generated and cannot be regenerated also. File creation for HO is the last task performed during day end and if the day end process is ended abruptly due to user intervention or otherwise, file creation for SO will not happen. If Files are not generated at SO for some schemes then check ‘Initialisation >> PO Name & Address’ form and ensure that the scheme is selected in ‘Set Scheme Computerisation Status’ option.
5.
Files generated at SO are without extension and hence cannot be imported at HO
HO name and code to be initialized in SO. Include HO name in SOs (Using PO Name & Address Form) in a separate row.
6.
'Data does not belong to [soname]’ message displayed while importing data.
Select the file again and retry
Logout and login to SOSB module and retry
Ask SO to re-generate the file & resend.
If this problem persists, it could be due to OS mismatch (XP / Vista / Windows 2003). Re-generate file in a different system at SO or import the file in a different system at HO.
7.
RD bulk posting data not transferred.
RD bulk data gets transferred only if Bulk posting is done before generation of the file (before day-end).

FTP CONFIGURATION ( FOR SO TO HO DATA TRANSFER )

FTP SERVER CONFIGURATION
Ø Computer connect with existing server (through LAN cable)
Ø O.S. Windows 2000 Server with IE 6 & SP4 or Windows 2003
Ø Internal (or) external Dialup modem (both end HO and SO)
Ø Parallel phone connection from existing phone (both end HO and SO)

AT HO :

1. Install windows 2000 server and 2003 server and create active directory. Give server name and domain like XXXftpserver, XXXftpdomain. Give ip number (give running number in your HO domain and not to give your existing HO server IP number)
2. Install modem driver and check diagnostics.3. Go to control panel add and remove programs windows components wizard IIS enable all services (ftp transfer protocol ftp service)
4. a. Start -+ Program – Admin Tools – Internet Service Manager
b. Click Domain Name – It Shows Server Name
c. Right click the server name – select ‘new’ – select ‘ftp site’ – give name – give IP address (your computer).
d. Give TCP Port – 21 (always)
e. Give path – D:\SBFTP\Received (Create directory)
f. Give permission – read and write – click finish.
(By default created ftp site will be stopped)
g. Right click newly created FTP site – property – check IP address and TCP port and give connections ‘unlimited’.

5. a. Select admin tools – routers and remote access
b. Right click server name – configure routing and remote services – click manual selection.
c. Select server name – ports – right click – select property – click selected modem – configure – make tick in ‘inbound only and inbound and out bound’.
d. Give phone number of this server.

6. a. Select admin tools – select active directory users and computers.
b. Create a new user (like XXXftp, YYYftp…) and give the password same in user name.
c. Right click created new user – select ‘dialin’ tab – make tick in ‘allow access’ – select ‘member of’ tab – make the user in domain user and give administrator rights to that user.
d. Create a network user as available in existing server and give Administratory rights (this domain) to that user.
7. Check the IIS and RRAS running correctly.
8. a. Install MSSQL 2000 client connectivity only (not to install full setup)
b. Click client connectivity – give the server name (existing old server name) alias
9. Install Bridge and Plugin. ( or Copy SB Plugis 2.5.3 Version )

AT SOS :
1. Install modem and create a dialup connection with username, password, and phone number created at HO level same as HO.
2. Install bridge and Plugin ( or Copy SB Plugis 2.5.3 Version ) and configure the FTP.

(Please delete old ‘PATCH’ database and create new thro ‘SB Plugin’ software)

SQL Backup & database Maintenance Plan

For Taking SQL backup
Backup Database ( Single Database )

Start -> programes -> Microsoft SQL Server -> Enterprise Manager ->
Server -> Database -> ( Select Database) All Task -> Backup Database -> Add -> Give Backup Path & filename -> Ok ->
----------------------------------------------------------
Restore Database ( Single Database Eg. Database Name as xxx )
Start -> programes -> Microsoft SQL Server -> Enterprise Manager -> Server -> Database ->
(Due to Security Problem it is not explained here)
Ok
----------------------------------------------------------
Database Maintenance Plan (Database Backup)
Management -> Database Maintenance Plan ->
New Maintenance Plan -> Select Databases
( All or user or Selected )
Next -> Next -> Next ->
Specify the database Backup Plan (Apply Tick )
Specify the Transaction log Backup Plan (Remove Tick)
Change the Job Time
Specify the DB Backup Disk Directory
Option : Use This Directory
( eg. E:\BACKUP for Local Backup
(eg file://CLIENT/BACKUP for Network Backup )
Next -> Next -> Next -> Next -> Plan Name
( eg. SERVER DAILY 16.00 HRS )
Finish

The Schedule has Starts in the correct time if the system is in ON condition

Database Maintenance Plan ( Transaction log File Backup )

Management -> Database Maintenance Plan ->
New Maintenance Plan -> Select Databases
( All or user or Selected )
Next -> Next -> Next ->

Specify the database Backup Plan (Remove Tick )
Specify the Transaction log Backup Plan (Apply Tick)

Change the Job Time
Specify the DB Backup Disk Directory
Option : Use This Directory
( eg. E:\BACKUP OR file://CLIENT/BACKUP)

Next -> Next -> Next -> Next -> Plan Name
( eg. SERVER DAILY 16.00 HRS )
Finish

Steps Followed in the New Server Installation

1. WINDOWS 2003 -SERVER INSTALLATION
2.SQL –2000 / 2005 ( DATABASE SERVER INSTALLATION )
3.PREREQUISITIES INSTALLATION
SQL2000 - SP4
SQl2005 - SP1
WINDOWS 2003 SERVER SP2
DOTNET 2.0, 2.1, 3.0, 3.5 ( any one version )
MABRY BARCODE (eMO)
4. Meghdoot software installation
> Server Component and client Application
> Share the server folder
eg. PointofSale , Treasury, Subaccounts, Speednet
5. run the software for Database creation

6. Sanchaypost software installation
( POST folder creation)
7. run the software for Database creation
8. Database restoration ( all databases one by one )
9. Copy the MDB files in to concerned server folder
10. DCL user updation ( for SP only)

Check the correctness of Database restoration

RPLI software needs WAN connection

RPLI software needs WAN connection
Adobe Reader is must to view reports
Popup blocker should be turned off.
IE > Tools > Popup Blocker > Turn Off Popup Blocker
Choose low level security or enable all Java Scripts etc.
IE > Internet Options > Security >
Open indiapostpli.gov.in > RPLI login link
or
http://10.1.96.41:7778/forms/frmservlet?config=rpli directly
This would prompt to install ActiveX control OracleJinitiator for the first time
Install the Control. The Login screen will come. Thats all.

If you have problem even after the above steps

ping your default gateway IP, that is your router IP.
Check your modem, Line lights are ON or not.
ping 10.1.0.17 > NIC Server IP
ping 10.1.96.42 > RPLI SERVER IP

If you have problem in NIC or RPLI Server IP wait for some time it may be correct automatically or contact your local NIC.