R Net communication 4.0-String or Binary data would be truncated error solution.

After COD we have faced many Issues in Postman , Despatch, Treasury and Sub accounts. Now days in many Sub offices are dealing CODs without any Issues.

In Some offices while running R Net Communication it shows an error message as String or binary data would be truncated. The Statement has been terminated.

It may problem with COD Article Message data. Some times articles were booked without Prescribed format in Addressee Name / Addressee address.  Those Messages are received at in Delivery Office by R Net Communication RXD Folder.

But R Net Communication was not able to Unzip/Unload the Received data due to Incorrect format/Syntax.

So not able to upload and It shows an error message as String or binary data would be truncated.

SOLUTION:

 Download the latest R Net communication.exe and  will copy it in the folder path.

                                                      DOWNLOAD

R NET COMMUNICATION MODULE-COMMON PROBLEMS NOTICED AND SOLUTION

   In some of the sub offices, R Net module   stops automatically.  Then data will not be transmitted to central server.     Remove the Rnet communication module from the Auto start.  For this select the option RUN from start menu of windows and type  MSCONFIG  and unckeck  Rnetcommunication.exe from startup option.  Then add a scheduled task to run the R net commincation.exe using the option Accessories--->system tools--->Task scheduler(in win 7) /scheduled tasks(in win XP)   option.  While adding the scheduled task do not select the option,  When I logon. Select the option Daily and give a time to run the R net communication .exe.  The time should be  the time  after 10 or 15 minutes when the server and client system started.  Suppose server and client starts at 9 O clock, then give the time as 09:10. 

  In the case of some sub offices, booking details are updated in site. But Delivery details are not updated in site. In this case check the following.

a) Check whether Non delivery code is given correctly in My office->environment of postman module.   Non delivery code in the case of delivery office will be  00

b) check whether communication module path given is correct or not.

  In some of the offices it is noticed that even though the communication module is running Data is not transmitted to central server.  In that case please check whether   trxcheck.log file is there in C:\Program Files\RegisterNet Communication\TXD  folder.  If present, delete this file. Data will be transmitted to Central server.

An office will reflect in R Net enabled office list on a particular day , only when  booking of RL  is done on that day. The delivery data will be updated in the site correctly and that office will reflect in Delivery MIS.