EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB319567 : "Error in importing file. Check the file to import." Error When Importing Using Custom Data Connector in an SSL/HTTPS Web Server Environment


Community Admin

• Strategy


Error importing CSV, JSON, Excel format and FORMAT_JSON in MicroStrategy Web when using a custom data connector with a HTTPS connection.

SYMPTOM:  In Strategy Web 10.9 when using a custom data connector with a HTTPS connection and importing a CSV, JSON, Excel format or FORMAT_JSON file

ka04W000000OcMsQAK_0EM44000000QHMc.jpeg

the following error occurs:


TABLENAME={RawDataCsv};GENERICPARA={{"versionNo":"1.0","connectionName":"RawDataFiles",
"connectionData":{"file":"DATA_IMPORT_CSV2.csv"},"tableList":[{"tableName":"RawDataCsv"}]}};
Error in importing file. Check the file to import. [Get data failed. Error in importing files.
Please check the file to import. Error type: Data Import Error. No data was loaded. Node JS
command may exit unexpectedly.]

ka04W000000OcMsQAK_0EM44000000QHMm.jpeg

 
CAUSE: One possible cause is using an HTTPS URL in the custom data connector definition. In the following test, SSL was setup for the JSP environment: 

https://server.Strategy.com:8443/DataConnectorSample/index.html 
as seen in the screenshot below.

ka04W000000OcMsQAK_0EM44000000QHMw.jpeg

ACTION: This issue has been logged with Strategy. Contact Strategy Technical Support for an update on the issue.
WORKAROUND: Changing the URL to the non SSL URL 

http://server.Strategy.com:8080/DataConnectorSample/index.html 
will allow the data connector to work without error.

ka04W000000OcMsQAK_0EM44000000QHN1.jpeg


319567


Comment

0 comments

Details

Knowledge Article

Published:

January 29, 2018

Last Updated:

August 31, 2018