Reports Help

Upload Tool - FAQ and Troubleshooting Tips

Frequently Asked Questions

General

1. Can I upload Excel files using Upload Tool

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

3. 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 SkyDesk 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 SkyDesk Reports?

3. How to connect to a database in a particular SQL Server Instance and upload the data into SkyDesk 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 SkyDesk Reports table as available in my local database?

6. How to upload data with different date format from the in-house/local databases into SkyDesk 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 "SKYDESK_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 /SkyDeskReports/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 CSV file

Problem 1: The length of the column names are not more than 100 characters, but receiving the message:  "Sorry, Column name should not exceed 100 characters". 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 SkyDesk 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?

Top