Creating List Via Importing Excel File, Internal Error Screen Displays
(Doc ID 1668104.1)
Last updated on MARCH 11, 2019
Applies to:Oracle WebCenter Portal - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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.
- Create a space. Example: "listtesting.
- Enable the Lists service by going to managing pages.
- Try to create a list using an excel sheet.
Excel consists of the below values:
11 11 11
22 33 44
- It fails with error message 'An unexpected error occurred".
- Change the values as this:
11 22 33
22 22 22
- 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#18.104.22.168.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document