• Type: Bug
• Resolution: Fixed
• Priority: Low
• Fix Version/s: 10.116.0
• Affects Version/s: 10.113.2
• Component/s: Import|Export
• Labels:

  • bulldog

1. Export User Attributes Report_KO500Error.xml

   18/Nov/2022 12:53 PM

   18 kB

   Francois Panaget

2. Export User Attributes Report_OK.xml

   18/Nov/2022 12:53 PM

   18 kB

   Francois Panaget

3. image-2022-11-18-13-08-27-722.png

   18/Nov/2022 12:08 PM

   66 kB

   Francois Panaget

4. image-2022-11-18-13-09-38-524.png

   18/Nov/2022 12:09 PM

   297 kB

   Francois Panaget

[JIRAALIGN-4579] Import: Users Excel Import may cause a silent error if the file format is incorrect

Josh Ellis (Inactive) made changes - 06/Sep/2023 3:48 PM

Labels

Original: JAVOM bulldog

New: bulldog

ja-sync-bot made changes - 06/Sep/2023 3:22 PM

Labels

Original: bulldog

New: JAVOM bulldog

backbone-sync-bot made changes - 25/May/2023 2:40 PM

Status

Original: Closed [ 6 ]

New: Closed [ 6 ]

mberezkyy (Inactive) made changes - 01/Feb/2023 11:11 AM

Resolution		New: Fixed [ 1 ]
Status	Original: Waiting for Release [ 12075 ]	New: Closed [ 6 ]

backbone-sync-bot made changes - 21/Dec/2022 9:57 AM

Status

Original: In Review [ 10051 ]

New: Waiting for Release [ 12075 ]

backbone-sync-bot made changes - 19/Dec/2022 2:52 PM

Fix Version/s

New: 10.116.0 [ 104124 ]

Francois Panaget made changes - 16/Dec/2022 4:19 PM

Remote Link

New: This issue links to "Page (Confluence)" [ 715604 ]

backbone-sync-bot made changes - 14/Dec/2022 9:54 AM

Status

Original: In Progress [ 3 ]

New: In Review [ 10051 ]

Francois Panaget made changes - 08/Dec/2022 2:13 PM

Description

Original: h3. Issue Summary When importing users using an excel .xml or .xls file, a 500 error may occur without notifying the user of the problem. The user only sees a blank/empty area (with a "spinning wheel") instead of the preview of the users’ data contained in the file. There is no notification that the system encounters a 500 error unless the user goes to the 'Network' tab or the console of the web browser developer tools. h3. Steps to Reproduce It may be necessary to engage with the customer to do the import, as it's not possible to replicate on a test instance.  # Go to the 'People' page  # Click on More Actions  # Click on Import User Record  # Browse and choose the .xml or .xls file you want to import  # Click on Import Items h3. Expected Results Visual information is provided to the user (in a form of popup) if the file format or the file is not correct. h3. Actual Results User experiences a blank/empty Data Preview page with or without a "spinning wheel". A 'silent' 500 Internal Server Error is thrown in the background which can be seen by going to the 'Network' tab or the console of the web browser developer tools: !image-2022-11-18-13-09-38-524.png|width=682,height=338! and !image-2022-11-18-13-08-27-722.png|width=754,height=101! Looking at the Spunk log we can see the error such as like: {noformat} { [-]    ASP_function: Error.asp    ErrorId: 2465    PageName: People    correlationid: TNsyiDBxfN5KBinpoUEt65FqN7x94lW0xCkDYbIkZbk=    customer_db: Alignsupport    error_aspcode:    error_aspdescription:    error_category: Microsoft VBScript runtime    error_column: -1    error_description: Object required: 'UsersHeaderRow(...)'    error_file: /AjaxFiles/AjaxUserImport.asp    error_line: 84    error_number: -2146827864    error_source:    log_type: exception    logfrom_location: Website-ASP    timestamp: 2022-11-18T05:47:13.404000-05:00    url: https://alignsupport.jiraalign.com:443/AjaxFiles/AjaxUserImport.asp?Type=1&FileName=Export_User_Attributes_Report_KO500Error%281%29.xml    urlverb: POST    user: 661802    version: 10.113.2.25772 } {noformat} h3. Workaround Currently, there is no known workaround for this behavior. A workaround will be added here when available When you edit the excel file make sure to not alter the first 4 rows of the template and to always save the file as Excel 2004 XML spreadsheet file format.

New: h3. Issue Summary When importing users using an excel .xml or .xls file, a 500 error may occur without notifying the user of the problem. The user only sees a blank/empty area (with a "spinning wheel") instead of the preview of the users’ data contained in the file. There is no notification that the system encounters a 500 error unless the user goes to the 'Network' tab or the console of the web browser developer tools. h3. Steps to Reproduce It may be necessary to engage with the customer to do the import, as it's not possible to replicate on a test instance.  # Go to the 'People' page  # Click on More Actions  # Click on Import User Record  # Browse and choose the .xml or .xls file you want to import  # Click on Import Items h3. Expected Results Visual information is provided to the user (in a form of a popup with a message) if the file format or the file is not correct. h3. Actual Results User experiences a blank/empty Data Preview page with or without a "spinning wheel". A 'silent' 500 Internal Server Error is thrown in the background which can be seen by going to the 'Network' tab or the console of the web browser developer tools: !image-2022-11-18-13-09-38-524.png|width=682,height=338! and !image-2022-11-18-13-08-27-722.png|width=754,height=101! Looking at the Spunk log we can see the error such as like: {noformat} { [-]    ASP_function: Error.asp    ErrorId: 2465    PageName: People    correlationid: TNsyiDBxfN5KBinpoUEt65FqN7x94lW0xCkDYbIkZbk=    customer_db: Alignsupport    error_aspcode:    error_aspdescription:    error_category: Microsoft VBScript runtime    error_column: -1    error_description: Object required: 'UsersHeaderRow(...)'    error_file: /AjaxFiles/AjaxUserImport.asp    error_line: 84    error_number: -2146827864    error_source:    log_type: exception    logfrom_location: Website-ASP    timestamp: 2022-11-18T05:47:13.404000-05:00    url: https://alignsupport.jiraalign.com:443/AjaxFiles/AjaxUserImport.asp?Type=1&FileName=Export_User_Attributes_Report_KO500Error%281%29.xml    urlverb: POST    user: 661802    version: 10.113.2.25772 } {noformat} h3. Workaround Currently, there is no known workaround for this behavior. A workaround will be added here when available When you edit the excel file make sure to not alter the first 4 rows of the template and to always save the file as Excel 2004 XML spreadsheet file format.

Francois Panaget made changes - 08/Dec/2022 2:07 PM

Description

Original: h3. Issue Summary When importing users using an excel .xml or .xls file, a 500 error may occur without notifying the user of the problem. The user only sees a blank/empty area (with a "spinning wheel") instead of the preview of the users’ data contained in the file. There is no notification that the system encounters a 500 error unless the user goes to the 'Network' tab or the console of the web browser developer tools. h3. Steps to Reproduce It may be necessary to engage with the customer to do the import, as it's not possible to replicate on a test instance.  # Go to the 'People' page  # Click on More Actions  # Click on Import User Record  # Browse and choose the .xml or .xls file you want to import  # Click on Import Items h3. Expected Results Visual information is provided to the user if the file format or the file is not correct. h3. Actual Results User experiences a blank/empty Data Preview page with or without a "spinning wheel". A 'silent' 500 Internal Server Error is thrown in the background which can be seen by going to the 'Network' tab or the console of the web browser developer tools: !image-2022-11-18-13-09-38-524.png|width=682,height=338! and !image-2022-11-18-13-08-27-722.png|width=754,height=101! Looking at the Spunk log we can see the error such as like: {noformat} { [-]    ASP_function: Error.asp    ErrorId: 2465    PageName: People    correlationid: TNsyiDBxfN5KBinpoUEt65FqN7x94lW0xCkDYbIkZbk=    customer_db: Alignsupport    error_aspcode:    error_aspdescription:    error_category: Microsoft VBScript runtime    error_column: -1    error_description: Object required: 'UsersHeaderRow(...)'    error_file: /AjaxFiles/AjaxUserImport.asp    error_line: 84    error_number: -2146827864    error_source:    log_type: exception    logfrom_location: Website-ASP    timestamp: 2022-11-18T05:47:13.404000-05:00    url: https://alignsupport.jiraalign.com:443/AjaxFiles/AjaxUserImport.asp?Type=1&FileName=Export_User_Attributes_Report_KO500Error%281%29.xml    urlverb: POST    user: 661802    version: 10.113.2.25772 } {noformat} h3. Workaround Currently, there is no known workaround for this behavior. A workaround will be added here when available When you edit the excel file make sure to not alter the first 4 rows of the template and to always save the file as Excel 2004 XML spreadsheet file format.

New: h3. Issue Summary When importing users using an excel .xml or .xls file, a 500 error may occur without notifying the user of the problem. The user only sees a blank/empty area (with a "spinning wheel") instead of the preview of the users’ data contained in the file. There is no notification that the system encounters a 500 error unless the user goes to the 'Network' tab or the console of the web browser developer tools. h3. Steps to Reproduce It may be necessary to engage with the customer to do the import, as it's not possible to replicate on a test instance.  # Go to the 'People' page  # Click on More Actions  # Click on Import User Record  # Browse and choose the .xml or .xls file you want to import  # Click on Import Items h3. Expected Results Visual information is provided to the user (in a form of popup) if the file format or the file is not correct. h3. Actual Results User experiences a blank/empty Data Preview page with or without a "spinning wheel". A 'silent' 500 Internal Server Error is thrown in the background which can be seen by going to the 'Network' tab or the console of the web browser developer tools: !image-2022-11-18-13-09-38-524.png|width=682,height=338! and !image-2022-11-18-13-08-27-722.png|width=754,height=101! Looking at the Spunk log we can see the error such as like: {noformat} { [-]    ASP_function: Error.asp    ErrorId: 2465    PageName: People    correlationid: TNsyiDBxfN5KBinpoUEt65FqN7x94lW0xCkDYbIkZbk=    customer_db: Alignsupport    error_aspcode:    error_aspdescription:    error_category: Microsoft VBScript runtime    error_column: -1    error_description: Object required: 'UsersHeaderRow(...)'    error_file: /AjaxFiles/AjaxUserImport.asp    error_line: 84    error_number: -2146827864    error_source:    log_type: exception    logfrom_location: Website-ASP    timestamp: 2022-11-18T05:47:13.404000-05:00    url: https://alignsupport.jiraalign.com:443/AjaxFiles/AjaxUserImport.asp?Type=1&FileName=Export_User_Attributes_Report_KO500Error%281%29.xml    urlverb: POST    user: 661802    version: 10.113.2.25772 } {noformat} h3. Workaround Currently, there is no known workaround for this behavior. A workaround will be added here when available When you edit the excel file make sure to not alter the first 4 rows of the template and to always save the file as Excel 2004 XML spreadsheet file format.

Load more older events