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

Last updated on MAY 12, 2014

Applies to:

Oracle WebCenter Portal - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

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:

  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: weblogic] [ecid: 004r0w8sbAR3V8eLLaXBie0006NA0002mu,0:1]
[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.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms