Failure while importing users in Spotfire Analyst. Error: Error parsing the uploaded document: Incorrect number of columns in line #XXXXX: expected 5, was 6
book
Article ID: KB0074736
calendar_today
Updated On:
Description
You may come across below error while importing users in TIBCO Spotfire Analyst using Administration Manager :
Error message: Could not import users.
UserDirectoryServiceException at Spotfire.Dxp.Services:
Error parsing the uploaded document: Incorrect number of columns in line #288: expected 5, was 6 (HRESULT: 80131509)
Stack Trace:
at Spotfire.Dxp.Services.WebServiceBase`1.InvokeService[T](ServiceMethod`1 serviceMethod, ExceptionFactoryMethod exceptionFactoryMethod, String customMethodNameForLogging)
at Spotfire.Dxp.Services.UserDirectory.UserDirectoryService.ImportUsers(ImportUsersFlags flags, String attachmentId)
at Spotfire.Dxp.Forms.Application.Administration.AdministrationForm.<>c__DisplayClass54_0.<importUsersButton_Click>b__0()
at Spotfire.Dxp.Framework.ApplicationModel.Progress.<>c__DisplayClass21_0.<Start>b__0()
at Spotfire.Dxp.Framework.ApplicationModel.MonitorableProgress.Start[T](Func`1 action)
at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()
Cause:
This is due to a syntactical error in the text file format used for importing users in Spotfire.
Below is the file format to bulk import the users:
User name;Domain name;password; display name;emailExample:
----------- Test ; SPOTFIRE ;Test123; Test ; Test@mydomain.com
Test1 ; SPOTFIRE ; spotfire123;Test1 ; Test1@mydomain.com
------------In above file format, if you put extra semicolon ( ; ) like below at the end of any line by mistake, it throws error for that particular line number while importing users:
Incorrect number of columns in line #XX: expected 5, was 6Erroneous example:
------------ Test ; SPOTFIRE ;Test123; Test ; Test@mydomain.com
;------------
Resolution
Remove the extra semicolon ( ; ) from mentioned line number in error message to resolve this error and re-import the users.
Issue/Introduction
Failure while importing users in Spotfire Analyst. Error: Error parsing the uploaded document: Incorrect number of columns in line #XXXXX: expected 5, was 6.
Additional Information
- How to add/import users and groups in bulk to Spotfire, using Administration Manager in Spotfire Analyst.
Feedback
thumb_up
Yes
thumb_down
No