Creating List Via Importing Excel File, Internal Error Screen Displays (Doc ID 1668104.1)

Last updated on MARCH 11, 2019

Applies to:

Symptoms

When creating a list service using option,i.e create from Excel file with duplicate values in the first row,it returns:

  'An unexpected error occurred"

That is an expected behavior, the first row is taken as the column names when creating a list from a spreadsheet and it should not have duplicate values. However an "unhandled Exception" message is not appropriate for final users.

How to Reproduce:

Note: The Portal Space name used in the following example represents a fictitious sample.   Any similarity to an actual Portal Space Name is purely coincidental and not intended in any manner.  

1. Create a space. Example: "listtesting.
2. Enable the Lists service by going to managing pages.
3. Try to create a list using an excel sheet.
    Excel consists of the below values:
    11 11 11
    22 33 44
4. It fails with error message 'An unexpected error occurred".
5. Change the values as this:
    11 22 33
    22 22 22
6. List is created.
   
   

WC_Spaces diagonstic log shows the below error message.

[WC_Spaces] [INCIDENT_ERROR] [WCS-14001] [oracle.webcenter.list.model] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>]
[APP: webcenter#11.1.1.4.0] [DSID: 0000Jtubct63V8eLLaXBie1HW^v000000O] [URI: /webcenter/faces/oracle/webcenter/page/scopedMD/s8bba98ff_4cbb_40b8_beee_296c916a23ed/businessRolePages/ListsMainView.jspx] An unexpected error occurred.[[
 oracle.webcenter.di.spreadsheet.model.exception.SpreadsheetException:oracle.webcenter.list.model.LSRuntimeException: An unexpected error occurred.
 A column with the name (11.0) already exists.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.