faq.md

Frequently Asked Question

Ques: How to enable SQL Server connectivity via TCP/IP port for Microsoft SQL Server ?

Ans: Utility supports connection to MS SQL Server via TCP/IP port only. It does not support connecting through named instance like PC-NAME\SQLEXPRESS. This setting can be enabled using below steps:

1. Launch Computer Management (just type it in Windows Search bar)
2. Open: Services and Applications > SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER > TCP/IP
3. Right Click and Enable it
4. Double Click (or right click and open Properties) to open TCP/IP Properties window
5. Goto IP Addresses tab > IPAll > and set
   • TCP Dynamic Ports = (blank) erase value from it
   • TCP Port = 1433
     
6. Restart SQL Server: Task Manager > Services > MSSQLSERVER > right click > Restart
   

Ques: I am getting an error as below, how can I resolve it

Error from database() at
SyntaxError: Bad control character in string literal in JSON at position xx

Ans: This error occurs when config.json file JSON structure breaks while modifying values in it. In such scenario, overwrite existing config.json file by re-extracting it from utility project zip file.

Ques: MySQL gives error Loading local data is disabled; this must be enabled on both the client and server sides

Ans: MySQL by default disables loading of local files. To enable it run below command

SET GLOBAL local_infile=1;

If running after this query you end up with message as below

1227 (42000): Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation

then only option left is to change loadmethod to insert as your database administrator does not allow you to enable local_infile due to security concerns.

Ques: I am getting error as below. How to resolve it ?

Error from tally.postTallyXML() at
AggregateError [ECONNREFUSED]:
    at internalConnectMultiple (node:net:1117:18)
    at afterConnectMultiple (node:net:1684:7)
    at TCPConnectWrap.callbackTrampoline (node:internal/async_hooks:130:17)
ECONNREFUSED

Ques: I cannot see utility command-line (black colour) window pop-up upon running utility

Ans: Please ensure below things which can cause this

1. Ensure you have Node.JS installed
2. In the utility folder check if a folder named node_modules exists. If it does not shows up for you, then you should again download utility properly from project GitHub page via 7z file link provided.

Ans: This error occurs when utility is unable to communicate with Tally. Ensure below things:

• Tally must be running
• Ensure XML port of Tally is enabled and is properly set in config.json > tally > port

Ques: I am getting error as below. How to resolve it ?

Error from tally.importData() at
Cannot detect First/Last voucher date from company

Ans: This error occurs when no company in Tally is selected or active. It even occurs when you specify incorrect company name in config.json > tally > company

Ques: I get following error for PostgreSQL connection. What could be the issue

Error from database.executePostgres() at 
error: no pg_hba.conf entry for host "0.0.0.0", user "postgres", database "tallydb", no encryption

Ans: You need to set ssl to true in config.json > database. Also ensure, that your user and database is added in hostssl line in pg_hba.conf

Ques: I get an error like "Received an invalid column length from the bcp client for colid"

Ans: This error is generated by SQL Server bulk load driver. All the textual columns have max length set in database-structure file. When any rows has textual data where this length of the text exceeds, this this error is triggered. Generally error will specify column number in front of colid which can be identified by going through the column named in database structure or CSV file. Unfortunately culprit row is not displayed, which one has to manually identify by importing data into Excel via Power Query.