Other Technical Tips
QLS related_Optimum
This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-crea...
Wed, 11 Nov, 2020 at 10:11 AM
This is due to massive database structure changes across multiple version. (Upgrading database from below/ older than Version 2015.1.5.8 to current version...
Wed, 11 Nov, 2020 at 10:14 AM
When append Database but system show error message as below Solution: 1) Close QnE Optimum 2) Open "Regedit" 3) Go to HKEY_LOCAL_...
Wed, 11 Nov, 2020 at 10:16 AM
e.g. the database name now is GPS, require rename to become GBS. Solution: 1. Login the GPS database, then go to Database Utility -> Backup, backup ...
Wed, 11 Nov, 2020 at 10:22 AM
1. Connect to the Database using Please refer How to install Microsoft SQL Management Studio AND Please refer How to Connect to Database use Microsoft S...
Wed, 11 Nov, 2020 at 10:29 AM
To filter non – tally Transaction (Journal) 1. Connect to Database using Microsoft SQL Server Management Studio. Please refer How to install Microsoft ...
Wed, 11 Nov, 2020 at 10:38 AM
1. Open SQL Management studio and execute the following scripts. Please refer How to install Microsoft SQL Management Studio AND Please refer How to C...
Wed, 11 Nov, 2020 at 10:51 AM
(Optimum) Error Sequence contain more than one matching element Scenario: When you double click on the Receive payment, Credit note, it will prompt this...
Mon, 21 Dec, 2020 at 5:11 PM
To clear AR zero matching amount The script to filter out all the ARMatching is zero amount. This is one of the reasons that showing the error message “S...
Mon, 21 Dec, 2020 at 5:13 PM
If you find that database size is huge but no idea where the size is coming from, here is the script to find out. Run below script in SQL Management Stu...
Sun, 29 Nov, 2020 at 4:09 PM