Unable To View Content Info If 'author' Is Not An User In The System (Doc ID 1455425.1)

Last updated on SEPTEMBER 28, 2023

Applies to:

Symptoms

On : 11.1.1.5.0 version, Content Server

When attempting to click the content information button for a content item who's author does not exist as a user in the system, the action fails and
the following error occurs.

ERROR
-----------------------

>systemdatabase/7 04.16 09:32:49.531 IdcServer-55 (start) SELECT * FROM UserExtendedAttributes WHERE UPPER(dUserName)=UPPER('Leon_im')
>systemdatabase/6 04.16 09:32:49.532 IdcServer-55 1.61 ms. SELECT * FROM UserExtendedAttributes WHERE UPPER(dUserName)=UPPER('Leon_im')[Executed. Returned row(s): false]
>services/3 04.16 09:32:49.533 IdcServer-55 !csUserEventMessage,<user>,<domain>!$ intradoc.common.ServiceException: !csInvalidInt,Employee Number
 services/3 04.16 09:32:49.533 IdcServer-55 *ScriptStack DOC_INFO
 services/3 04.16 09:32:49.533 IdcServer-55 3:getUserMailAddress,dID=1201,dDocName=CIG_001201
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorageImplementor.validateUserField(UserStorageImplementor.java:1485)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorageImplementor.copyUserValueEx(UserStorageImplementor.java:1373)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorageImplementor.storeUserDatabaseProfileData(UserStorageImplementor.java:1034)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorage.storeUserDatabaseProfileData(UserStorage.java:209)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorage.retrieveUserDatabaseProfileDataFull(UserStorage.java:114)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorage.retrieveUserDatabaseProfileData(UserStorage.java:84)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.Service.computeUserMailAddress(Service.java:3178)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.Service.getUserMailAddress(Service.java:3166)
 services/3 04.16 09:32:49.533 IdcServer-55 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 services/3 04.16 09:32:49.533 IdcServer-55 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 services/3 04.16 09:32:49.533 IdcServer-55 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 services/3 04.16 09:32:49.533 IdcServer-55 at java.lang.reflect.Method.invoke(Method.java:597)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.Service.doCodeEx(Service.java:551)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.Service.doCode(Service.java:506)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1643)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.Service.doAction(Service.java:477)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1458)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.Service.doActions(Service.java:473)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1391)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.Service.executeActions(Service.java:458)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:737)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.Service.doRequest(Service.java:1890)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.ServiceManager.processCommand(ServiceManager.java:435)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1346)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1715)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:222)
 services/3 04.16 09:32:49.533 IdcServer-55 at sun.reflect.GeneratedMethodAccessor166.invoke(Unknown Source)
 services/3 04.16 09:32:49.533 IdcServer-55 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 services/3 04.16 09:32:49.533 IdcServer-55 at java.lang.reflect.Method.invoke(Method.java:597)
 services/3 04.16 09:32:49.533 IdcServer-55 at idcservlet.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:88)
 services/3 04.16 09:32:49.533 IdcServer-55 at idcservlet.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:305)
 services/3 04.16 09:32:49.533 IdcServer-55 at idcservlet.common.ClassHelperUtils.executeMethodWithArgs(ClassHelperUtils.java:278)
 services/3 04.16 09:32:49.533 IdcServer-55 at idcservlet.ServletUtils.executeContentServerIntegrateMethodOnConfig(ServletUtils.java:1600)
 services/3 04.16 09:32:49.533 IdcServer-55 at idcservlet.IdcFilter.doFilter(IdcFilter.java:352)
 services/3 04.16 09:32:49.533 IdcServer-55 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
 services/3 04.16 09:32:49.533 IdcServer-55 ... 25 more
 services/3 04.16 09:32:49.533 IdcServer-55 Caused by: java.lang.Exception: !csIntegerInvalidChars
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorageImplementor.validateUserField(UserStorageImplementor.java:1476)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorageImplementor.copyUserValueEx(UserStorageImplementor.java:1373)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorageImplementor.storeUserDatabaseProfileData(UserStorageImplementor.java:1034)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorage.storeUserDatabaseProfileData(UserStorage.java:209)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorage.retrieveUserDatabaseProfileDataFull(UserStorage.java:114)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.UserStorage.retrieveUserDatabaseProfileData(UserStorage.java:84)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.Service.computeUserMailAddress(Service.java:3178)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.server.Service.getUserMailAddress(Service.java:3166)
 services/3 04.16 09:32:49.533 IdcServer-55 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 services/3 04.16 09:32:49.533 IdcServer-55 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 services/3 04.16 09:32:49.533 IdcServer-55 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 services/3 04.16 09:32:49.533 IdcServer-55 at java.lang.reflect.Method.invoke(Method.java:597)
 services/3 04.16 09:32:49.533 IdcServer-55 at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
 services/3 04.16 09:32:49.533 IdcServer-55 ... 51 more


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use Archiver or batchloader to load content into 11g system
2. Content that is authored by a user who is not in the system, ie a user who has left the company, click its doc info button


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get information about particular documents

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.