FAQ & Troubleshooting Tips

Upload Tool - FAQ and Troubleshooting Tips

Frequently Asked Questions

General

1. Can I upload Excel files using Upload Tool

2. Can I use my Yahoo / Gmail / Google Apps / Facebook user credentials to upload data using Upload Tool?

3. How to increase / decrease the batch size for upload?

4. Can I allow the shared user to upload the data into my table?

Uploading data from Local (In-house) databases

1. Can I use my Windows authentication to connect to SQL Server database and fetch records to upload into Zoho Reports?

2. Can Upload tool be used to upload data from remotely hosted databases (SQL Server, Oracle, MySQL, Sybase, PostgreSQL, DB2 and DB2-AS/400) into Zoho Reports?

3. How to connect to a database in a particular SQL Server Instance and upload the data into Zoho Reports Online Reporting Database?

4. Is it possible to fetch data from multiple database using Upload Tool?

5. Is it mandatory to follow similar column names in Zoho Reports table as available in my local database?

6. How to upload data with different date format from the in-house/local databases into Zoho Reports?

Troubleshooting Tips

General

Problem 1: I get "The host did not accept the connection within timeout of 15000 ms" while trying to upload data using Upload Tool. How to solve it?

Problem 2: I get an error message as ‘out of memory’ while trying to upload the file. How can I solve this error?

Problem 3: I get "Error!!! Sorry, you cannot upload files that exceed 50MB in size" while uploading data using Upload Tool. How to overcome this?

Problem 4: I get an error message as "Another import is in progress in this table started by the user 'User name' at 'time of import'." How to overcome this?

Problem 5: I get a message as "ZOHO_MATCHING_COLUMNS is not present in the request parameters list". How to solve it?

Problem 6: I get "Error!!! Column "Column_Name" is present in match columns but not in selected columns" while uploading data. How to overcome this?

Problem 7: I get error /ZohoReports/UploadTool/bin/UploadFromDB.sh: line 15: java: command not found. 

Problem 8: I get an error message as "Maximum Concurrent User Tickets Limit Exceeded". How to solve this?

Uploading data from Local (In-house) databases

Problem 1: I get "Could not Find File '(unknown)' error while trying to import data from MSACCESS 2007 to Zoho Reports. How to overcome this?

Problem 2: While uploading data from MySQL database, I got the error "Value '0000-00-00' cannot be represented as java.sql.Date". How can I overcome this error?