eMO Redirection error converting data type varchar to numeric

eMO Redirection error and Solution

CSI has been implemented in trail basis and it will be implement all the post offices in all over India. The eMOs could not be redirected in eMO Module which is booked in CSI Module. It shows an error

Error converting data type varchar to numeric

Solution

1. Download attached Script which is provided by CEPT.
2. Take Backup of eMO database.
3. Execute the Script Using MM Script Tool at Once.

Download

If above attached query generate error like "Length of the data to decrypt is invalid", Download the below attached query & execute the same using MM Script Tool.

Download