Monday 4 June 2012

Batch File for automatic Running of Clients

We are receiving Daily e-mail from Divisional office or Regional office Regarding epayment Client not called offices"  Here is a batch file for automatic running of Various Clients



Type the code in a text file and save the notepad as extension .bat. You can put this batch file either in Task sheduler or Start up

eg:


@ echo off
start /d "C:\Program Files\ePayment Client" ePaymentClient.exe





EMO DATABASE -HOW TO REPAIR CONSISTENCY ERROR IN DB

Problem in Printing eMO (Database Corrupted)

 While
printing the eMOS, an error occurs. The
screen shot is shown.
The error shows

Attempt to fetch logical page in database eMO belongs to object eMO
Inward not to object eMO Offices

While checking the databases. The database is not in suspect state. While checking the Check db it shows There are some consistancy errors.. Then I tried to repair the database with query. This worked for me

The query for corrupted database(Not for Suspected database) with minimum data loss is given below

DBCC checkdb(‘yourDBname’)
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER

while While reporting the matter with PTC mysore They give a solution. While running the exl file It completed with on error. While consulting the matter with ptc they replied thatIt can occur to some reasons like, network issue and excess size of log files. Please check for network connectivity. if everything is fine please try to shrink the database and check. While clearing the log file and restarting the server the query worked.


COURTESY:SAPARAVUR