Data Migration & Data Corruption – FAQ
Some of the commonly asked questions about data migration and data corruption are answered here.
Data Migration
How do I migrate a group company that is created in Tally 7.2 to TallyPrime?
A group company created in Tally 7.2 cannot be migrated to TallyPrime. It is suggested to migrate the individual companies to TallyPrime, and then group them once again in TallyPrime to create a group company. However, it is advised to take a backup of the data before migrating.
We had done some customisation in Tally 7.2, I would like to know whether the same customisation will work in TallyPrime?
Customisation done in Tally 7.2 will not work in TallyPrime. You need to migrate the customized programs to a format that is compatible with TallyPrime. To migrate the program files (.tcp files) follow the steps given below:
- On installing TallyPrime in the existing folder the .tcp will automatically get converted to a format compatible with TallyPrime.
Or
Start TallyAdmin tool. - Click File Format Conversion.
- Select TCP (Tally Compliant Format).
- In the Source File(s) specify the path and filenames.
- Click Convert.
The specified file is converted to new format compatible with TallyPrime, and the original file is retained as backup with .bak extension.
Or
In case the customized programs have an extension .txt, it is suggested to mention the correct path in Load selected TDL files on startup in TDL Configuration screen.
TallyPrime displays the error message 'Unable to reach Tally 9 server! Post request failed!' while migrating data from Tally 5.4/ 6.3/ 7.2. Suggest a solution.
Do the following before commencing data migration:
- Ensure that tally9.exe and tally72migration.exe are available in the same folder.
- Close all other applications that are open before commencing migration.
- Go to File menu in Internet Explorer and uncheck the option Work offline.
- Scan for virus on the system.
- In case the data size is too large it is advisable to use a system with higher configurations.
- Disable real time protection on your anti-virus software.
After migrating the data from Tally 7.2 to Tally.ERP 9, and then to TallyPrime, the stock is showing incorrect values.
To resolve this problem, in the stock item alteration screen, select the costing method as FIFO Perpetual, also match the Unit of measure and Godown.
Bad unit name while migrating data from Tally 5.4/ 6.3/ 7.2
Reason
This error occurs when the Unit Symbol is altered to numeric/alphanumeric. For example, Nos to Nos1 or Kgs to KgsA (Gateway of Tally > Alter > Units).
Solution
Follow the steps given below to resolve this issue.
- Create a new company in Tally 5.4/6.3/7.2 (for the same financial year and with features similar to that of the migrating company).
- Export the Masters and Vouchers, and import them to the newly created company.
- Migrate the newly created company data to Tally.ERP 9 and then to TallyPrime.
Exiting Tally, Error in TDL, could not draw list of select company too high or too wide
Reason
This error might occur during data migration.
Solution
Increase the screen resolution by following the steps given below:
- Right click the desktop.
- Select Properties.
- In the Display Properties window, click Settings tab.
- Increase the Screen resolution to 1366 x 768.
Data Corruption
Unable to open the company in this release of TallyPrime.
If you have migrated your data to TallyPrime, you cannot open the same data using an earlier release of Tally. Therefore, it is recommended that before migrating your data, take a backup or copy of your data and open the backed-up data in the earlier release, if needed.
Cause
This error occurs when data from a higher release of TallyPrime is loaded in a lower release.
Solution
Load the data in the same release of TallyPrime that was used earlier. We recommend that you download the latest release of TallyPrime, install it in a new folder, reactivate, and restore the data backup.
tstate.tsf error code 32
Cause
This error appears while splitting company data when a third-party software is used for data backup, and .tsf files are saved by this third-party application for backup.
Solution
Add the .tsf files in the exclusion list of the data backup software.
Note: Contact your system administrator to add files to exclusion list.
File Damaged or Repair Required.
Upgrade to TallyPrime and repair your data to resolve this issue.
The data may display Repair Required, as shown below:
Press Enter on the data > click Yes, to Repair. The data will be repaired.
Solution
Backup the current company data and repair.
Converting data from Tally 4.5 to TallyPrime
Data from Tally 4.5 has to be migrated to Tally 7.2, then to Tally.ERP 9, and then to TallyPrime. The tools required to convert data from 4.5 to 7.2 are available on the Tally website.
Procedure for converting data from Tally 4.5 to TallyPrime involves the following steps:
- Converting the data of Tally 4.5 to Tally 7.2 compatible data, using Tally 4.5 to Tally 7.2 data conversion utility.
- Migrating the Tally 7.2 compatible data to Tally.ERP 9, using Tally 7.2 data migration utility.
Convert data from Tally 4.5 to Tally 7.2
- Download Tally 4.5 data converter utility.
- Run the Convert45to72.exe and extract the files (WCVTALLY.EXE, TW45250.DLL, and CNVTALLY.DAT) to Tally 4.5 application folder.
- Double-click the file WCVTALLLY.EXE (the icon will be identical to Tally Icon). The Company Info screen appears. (You can also execute this file from the command prompt click Start > Run > type C:<Tally 4.5 directory name>WCVTally.EXE C:<Data path>)).
- Select the company to be migrated.
- Click Yes in conversion confirmation message.
Note: The Conversion utility will run in black and white only (even if you have a colour monitor).
Migrate Tally 7.2 compatible data to TallyPrime Data
- Install Tally.ERP 9 and TallyPrime.
- Download the tally72migrate.exe from Tally website, copy it to the Tally.ERP 9 application folder.
- Double-click the tally72migrate.exe. The utility will launch the Tally Data Migration Tool and Tally.ERP 9.
- Select Migrate Data in the Migration Company screen.
- Specify the directory where Tally 7.2 compatible data (Tally 4.5 converted data) is located in the field Directory.
- Select the company to be migrated from the List of Companies.
- Click Yes in the message displayed to start migration. The status of migration from Tally 7.2 to Tally.ERP 9 is shown in the Migration Messages pane.
- Press any key in the Migration Completed Check Statistics message. A Congratulation message appears confirming completion of data migration.
Note: If any error occurs during migration, it gets logged into migration.err file, which is automatically generated in Tally.ERP 9 application folder.
The migrated company is by default saved in the directory which was specified in the directory field (refer point 5 above). The migrated data folder is prefixed with a 0 and appears as a 5-digit number. For example, if the company folder number before migration was 0099, after migration it would be 00099.
- Now your migrated data is ready to be migrated to TallyPrime.
Note: If you want to migrate Tally 4.5 data to Tally 9, the process is same. Instead of installing Tally.ERP 9, install Tally 9 and follow the above process.
- Copy the data folder migrated to Tally.ERP 9 to TallyPrime data folder. Migrate the data to TallyPrime.
Cannot Understand Bad Formula
Cause
While migrating data from 6.3 or earlier releases, this error may occur when you enter strings other than numerals in the Value Basis field under Additional Accounting Entries in the Voucher Type Class screen.
Solution
Open the company where this error occurs, and correct the data entered in the Value Basis field in the Voucher Type Class screen.
This will fix all the XML import errors that occur while importing, migrating, or synchronizing data.
Bad FROM Address
Cause
When the E-mail from mentioned is wrong.
Solution
Verify the email id entered in E-mail from field, ensure it is correct and then proceed with emailing.
Data Structures in TallyPrime
The table below shows the list of files which are part of the database structure used in TallyPrime, along with a brief description or function of the respective data file.
Data Files for |
File Contents/Function |
|
Tally 5.4/6.3/7.2 |
Tally 9/Tally.ERP 9/TallyPrime |
|
Company.500 |
Company.900 |
Contains Company Profile along with Statutory Information related to the respective company |
CmpSave.500 |
CmpSave.900 |
Is the Backup copy of Company.900 |
Manager.500 |
Manager.900 |
Consists of master level information such as Groups, Ledgers, Item Masters, etc. |
Tr01263.500 |
TranMgr.900 |
Stores the transactions entered. In earlier versions of Tally, there was a transaction file created for every month. Due to data structural changes made in TallyPrime, only one file is created which is available across financial years. |
Tr01264.500 |
||
Tr01265.500 |
||
Tr01266.500 |
||
TrnLots.500 |
LinkMgr.900 |
Contains the detailed information on bill references, order numbers, batch numbers and tracking numbers. In earlier versions of Tally individual files were created for bill references, order numbers, batch numbers and tracking numbers. |
TrnOrds.500 |
||
TrnRefs.500 |
||
TrnTNos.500 |
||
MsgRead.TSM |
TACCESS.TSF |
Used for controlling access to the database. |
Exclusv.TSM |
TEXCL.TSF |
Used when database is accessed for administrative functions. |
MsgKeep.TSM |
TSTATE.TSF |
Tracks the state of database and ensures that data is safely written to the respective files. |
|
TMESSAGE.TSF |
Used for two-stage writing ensuring consistency and persistence. |
Error: Record Insertion Failure in Database
Query
Record Insertion Failure in database error occurred while loading a company/saving a voucher in TallyPrime. How to avoid this in future?
Solution
When this error is displayed, it is suggested that you follow the steps given below:
- Backup your data.
- Press Alt+F1 (Help) > Settings > Startup > set Load companies on startup to No.
- Perform a simple repair by pressing Ctrl+Alt+R.
Alternatively, you can press Alt+F1 (Help) > Troubleshooting > Repair. - In case the problem persists, it is suggested to perform a Zero command rewrite.
- We suggest an upgrade to latest release.
- In case the problem persists contact Tally Support.
No space on disk
Cause
This message is displayed while repairing the data.
Solution
While repairing the data, check if there is sufficient space in the hard disk or any external drive where the data is located.
Note:
The minimum free space required while repairing the data should be double the size of the data. For example: If the data size is 4 MB, then the free space available should be at least 8 MB.
It is recommended to repair the company data stored in a local disk, rather than the data stored in an external drive.
Accessing Data from External Drives is Slow
Accessing TallyPrime data from external drivers is very slow because there might be differences between the USB ports.
The USB ports USB 3.0 is 10 times (572 megabytes per second) the speed of USB 2.0 (57 megabytes per second). However, in order to get better speed, plug your USB 3.0 device into a USB 3.0 port. If the port is 2.0, and the device 3.0, than the speed will go down from 572 MBps, to 57MBps (and vice versa). This means USB 2.0 and USB 3.0 are compatible with each other, but you will just get slower speed when you are using a combination of them, and not just 3.0.
The speed of USB 3.0 also provides more power to devices that require higher amount of power to operate. It can provide 50% more power than USB 2.0 does through the cable itself. USB 3.0 reduces the time required for data transmission. Hence, the data processing becomes faster compared to the USB 2.0, and may differ from one to another i.e. USB 2.0 and 3.0, in terms of power and speed.
For more information on USB 3.0 visit https://www.usbgear.com/
Error - Data path specified for more than one Tally.ini
Query
How to handle the error - Data path specified for more than one Tally.ini, displayed on clicking the tally72migration tool?
Solution 1
The error may be due to multiple data paths in the file, Tally.ini. Steps to remove additional data paths:
- Go to Tally application folder.
- Open the file, Tally.ini (file type is Configuration settings).
- Delete the second data path/location of data files, if any (not the primary data path).
- Save the Tally.ini file.
Solution 2
Change the settings for Default Companies in the file, Tally.ini. Steps to change the settings:
- Go to the Tally application folder.
- Open the file, Tally.ini.
- Set Default Companies to No.
- Save the Tally.ini file.
- Load the migration tool again.
The files in my data folder are getting deleted automatically. How can I solve this issue?
Cause
- A system process is deleting data files.
- Virus.
- Manual deletion by a user.
Solution
The solution for this issue is to enable system audit, which will help the system admin to identify the reason for deletion.
- Open Control Panel in the system, and navigate to Administrative Tools.
- Open the Local Security Policy.
- Expand Local Policies appearing on the left side > click Audit Policy.
- Double click the Audit object access which appears on the right side.
- Enable Success and Failure as shown below.
- Click OK to save the changes.
- Right-click the TallyPrime data folder. Select Properties. Go to Security tab and click Advanced as shown below:
- Go to Auditing tab, and click Continue as shown below:
- Click Add.
- Click Select a principal.
- Type Everyone > click Check names. You will see that the word Everyone will get underlined.
- Click OK.
- Auditing entry for data screen opens. Click Show advanced permissions.
- Select the options as shown below:
With this configuration, all the users will be disallowed from deleting the data files.
Further, to find out the reason for deletion of any data file, right click on My computer. Click Manage. Expand Event Viewer appearing on the left side. Select Windows Logs > under Windows Logs select Security as shown below:
You can keep the cursor on the bottom part of the screen and press Ctrl+F. In the Find window that opens, paste the data path for which you have enabled audit and click on Find Next as shown below:
The search result will display the details of deletion.
Remove caching from shared data folder
To ensure data is not shared with client systems in offline mode, you can disable caching of shared folders.
- Right-click the data folder and select Properties.
- Navigate to the Sharing tab, and click Advanced Sharing in the data Properties window as shown below:
- Click Caching in the Advanced Sharing window as shown below:
- Select the option No files or programs from the shared folder are available offline in the Offline Settings window as shown below:
- Click OK to accept the settings.
Deductee Type 'Association of Person' does not exist!
Cause
This message appears if you try to split the company data when TallyPrime is in Educational Mode.
Solution
Configure your existing license or reactivate your license.
Client without ODBC
This error might be displayed even after configuring the port number for ODBC, in the About page of TallyPrime.
Cause
The port number specified may already be in use.
Solution
- Press Alt+F1 (Help) > About > select Client/Server and ODBC Services and press Enter.
- Enter a different Port number.
- Press Enter to restart TallyPrime.
Diskette one is damaged. Continue an attempt recovery: YES/NO.
Cause
This error occurs when the backup process is not completed properly, leading to a partial or incomplete backup file, or when the disk (external drive) containing the backup file is corrupted. Further, due to limited space on the external drive, only a part of the backup may be saved on the file.
Solution
Click Yes in the error message to recover data. In case the recovery process is not successful,
- Restore an earlier backup file and re-enter any missing data.
- Contact Tally Solutions with the data. In case the data is recoverable, the recovered data will be sent to you.
Data Source Name not found
For computer in which the operating system installed is Windows XP or a higher version:
- Right-click the TallyPrime icon, and select Run as administrator.
- The Select Company screen appears. Select the required company from which you want to extract the data. The About page displays the Client/Server with ODBC Services. If the port number is not configured, you can configure it by following the steps given below:
Data corruption due to Malware
Malware slows down your computer and corrupts the data. Such data cannot be recovered. If you have the system backup, you can restore it, and check if it can be used.
Data not displayed in one system in a shared environment
In one particular system data is not getting shared/displayed. The system could be a laptop which has not been configured to the same domain. If there is mismatch between the domain, the data won’t get shared. To resolve this:
Cannot Create more than 9999 Companies
Cause
This particular error may occur, if you do not have full access to the Tally Data folder or the device is write protected.
Solution
Ensure that the Data folder is shared for full access, or the device on which you wish to create the Company is NOT "write protected".
In case the error persists, send an email to support@tallysolutions.com.
Retrieving Data Loss
It is suggested to restore the earlier data backup and continue working. In case the backup restored is up to an older date, the data until the current date needs to be updated manually. In case you do not have a backup, we recommend that you start taking a backup every day.
Checking Bad Sectors on Hard Disk
Checking for bad sectors on hard disk helps you identify sections of hard disk that are not being utilised for storing data, and is wasted. Proper data on hard disk space usage will help you manage your data better and system to perform read write functions effectively.
- Open command prompt.
- Enter chkdsk on the command prompt screen.
- Check the amount of space (KB) in bad sectors.
- De-fragment the hard disk based on the results in the report, if required.
Note: Ensure system backup is created before performing de-fragmentation.
Erase Directory to Overwrite the Content on Backup Medium
Cause
This message is related to the medium on which the backup is taken. The prompt is Tally’s unique way of ensuring that the user has already checked and wants the Tally backup to overwrite all the information available on the medium (such as floppy, zip diskette, and so on).
Solution
Select Yes if you wish to overwrite the available information.
Erase Directory
Cause
This error appears during data backup process if the destination hard disk or drive is affected with virus.
Solution
Scan the hard disk or drive and check.