Posts

Showing posts from August, 2009

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...

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 di...

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 Direc...

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.