Hi Team,
We are using the WCC version 12.2.1.0 and having integration with Siebel system.
After performing the hardware scaleup activity in the environment getting the below error in logs and in UI of published url as there is no check-inprofile is listed while in server url we can see the checkin profile list.
kindly advise what may be the problem and how to solve it.
Why this condition is added in ((xsiebelContactIdentities LIKE '1-3UAP-3998')) the where clause.
Profile list: Server url screenshot's:
Published url screenshot's:
Error:
Error occurred while processing. Unable to return results. Unable to create the result set for query 'SELECT Revisions.dID, dDocTitle, dDocType, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, dExtension, dWebExtension, dInDate, dOutDate, dCreateDate, dPublishType, dRendition1, dRendition2, dFileSize AS VaultFileSize, DocMeta.*, RevClasses.*
FROM Revisions, DocMeta, Documents, RevClasses
WHERE Revisions.dID=DocMeta.dID And Revisions.dID=Documents.dID And Revisions.dDocName = RevClasses.dDocName And dIsPrimary = 1 And dReleaseState IN ('Y', 'U', 'I') AND (((xsiebelContactIdentities LIKE '1-3UAP-3998')) AND ((((dSecurityGroup LIKE 'PersonalSpaces') OR (dSecurityGroup LIKE 'Public') OR (dSecurityGroup LIKE 'SiebelDocuments')) AND \(UPPER(dDocAccount) LIKE UPPER('')) OR (UPPER(dDocAccount) IS NULL) OR (UPPER(dDocAccount) LIKE UPPER('PEWebCenter/PU%')) OR (UPPER(dDocAccount) LIKE UPPER('PUBLIC%')) OR (UPPER(dDocAccount) LIKE UPPER('WCILS%')) OR (UPPER(dDocAccount) LIKE UPPER('AUTHEN%')))))) ORDER BY dInDate Desc'. ORA-00904: "XSIEBELCONTACTIDENTITIES": invalid identifier
java.sql.SQLSyntaxErrorException: ORA-00904: "XSIEBELCONTACTIDENTITIES": invalid identifier. Encountered an exception while executing a query (Error Code: 'ORA-00904'). [ Details ]
An error has occurred. The stack trace below shows more information.
!csSearchUnableToReturnResults!csDbUnableToCreateResultSet,SELECT Revisions.dID\, dDocTitle\, dDocType\, dRevisionID\, dSecurityGroup\, dDocAuthor\, dDocAccount\, dRevLabel\, dFormat\, dOriginalName\, dExtension\, dWebExtension\, dInDate\, dOutDate\, dCreateDate\, dPublishType\, dRendition1\, dRendition2\, dFileSize AS VaultFileSize\, DocMeta.*\, RevClasses.*<br> FROM Revisions\, DocMeta\, Documents\, RevClasses<br> WHERE Revisions.dID=DocMeta.dID And Revisions.dID=Documents.dID And Revisions.dDocName = RevClasses.dDocName And dIsPrimary = 1 And dReleaseState IN ('Y'\, 'U'\, 'I') AND (((xsiebelContactIdentities LIKE '1-3UAP-3998')) AND ((((dSecurityGroup LIKE 'PersonalSpaces') OR (dSecurityGroup LIKE 'Public') OR (dSecurityGroup LIKE 'SiebelDocuments')) AND ((UPPER(dDocAccount) LIKE UPPER('')) OR (UPPER(dDocAccount) IS NULL) OR (UPPER(dDocAccount) LIKE UPPER('PEWebCenter/PU%')) OR (UPPER(dDocAccount) LIKE UPPER('PUBLIC%')) OR (UPPER(dDocAccount) LIKE UPPER('WCILS%')) OR (UPPER(dDocAccount) LIKE UPPER('AUTHEN%')))))) ORDER BY dInDate Desc!$ORA-00904: "XSIEBELCONTACTIDENTITIES": invalid identifier<br>!syJavaExceptionWrapper,java.sql.SQLSyntaxErrorException: ORA-00904: "XSIEBELCONTACTIDENTITIES": invalid identifier<br>!csJdbcGenericErrorWithCode,ORA-00904
intradoc.data.DataException: !csDbUnableToCreateResultSet,SELECT Revisions.dID\, dDocTitle\, dDocType\, dRevisionID\, dSecurityGroup\, dDocAuthor\, dDocAccount\, dRevLabel\, dFormat\, dOriginalName\, dExtension\, dWebExtension\, dInDate\, dOutDate\, dCreateDate\, dPublishType\, dRendition1\, dRendition2\, dFileSize AS VaultFileSize\, DocMeta.*\, RevClasses.*
FROM Revisions\, DocMeta\, Documents\, RevClasses
WHERE Revisions.dID=DocMeta.dID And Revisions.dID=Documents.dID And Revisions.dDocName = RevClasses.dDocName And dIsPrimary = 1 And dReleaseState IN ('Y'\, 'U'\, 'I') AND (((xsiebelContactIdentities LIKE '1-3UAP-3998')) AND ((((dSecurityGroup LIKE 'PersonalSpaces') OR (dSecurityGroup LIKE 'Public') OR (dSecurityGroup LIKE 'SiebelDocuments')) AND (UPPER(dDocAccount) LIKE UPPER('')) OR (UPPER(dDocAccount) IS NULL) OR (UPPER(dDocAccount) LIKE UPPER('PEWebCenter/PU%')) OR (UPPER(dDocAccount) LIKE UPPER('PUBLIC%')) OR (UPPER(dDocAccount) LIKE UPPER('WCILS%')) OR (UPPER(dDocAccount) LIKE UPPER('AUTHEN%')))))) ORDER BY dInDate Desc!$ORA-00904: "XSIEBELCONTACTIDENTITIES": invalid identifier
at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2729)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:927)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:866)
at intradoc.search.DatabaseSearchImplementor.doQuery(DatabaseSearchImplementor.java:84)
at intradoc.search.CommonSearchConnection.doQuery(CommonSearchConnection.java:158)
at intradoc.server.SearchManager.retrieveSearchInfoAsBinder(SearchManager.java:233)
at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:2004)
at intradoc.server.SearchService.doLocalSearch(SearchService.java:1472)
at intradoc.server.SearchService.getSearchResults(SearchService.java:706)
at sun.reflect.GeneratedMethodAccessor921.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)
at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310)
at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295)
at intradoc.server.Service.doCodeEx(Service.java:643)
at intradoc.server.Service.doCode(Service.java:598)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1760)
at intradoc.server.Service.doAction(Service.java:570)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1550)
at intradoc.server.Service.doActions(Service.java:565)
at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1482)
at intradoc.server.Service.executeActions(Service.java:551)
at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:760)
at intradoc.server.Service.doRequest(Service.java:2004)
at intradoc.server.ServiceManager.processCommand(ServiceManager.java:520)
at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:359)
at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1360)
at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1764)
at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:223)
at sun.reflect.GeneratedMethodAccessor873.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)
at idcservlet.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
at idcservlet.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:305)
at idcservlet.common.ClassHelperUtils.executeMethodWithArgs(ClassHelperUtils.java:278)
at idcservlet.ServletUtils.executeContentServerIntegrateMethodOnConfig(ServletUtils.java:2178)
at idcservlet.IdcFilter.doFilter(IdcFilter.java:441)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141)
at java.security.AccessController.doPrivileged(AccessController.java:732)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.wls.filter.SSOSessionSynchronizationFilter.doFilter(SSOSessionSynchronizationFilter.java:417)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141)
at java.security.AccessController.doPrivileged(AccessController.java:732)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3683)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3649)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2433)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2281)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2259)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1692)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1652)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
at weblogic.invocation.ComponentInvocationContextManager.\_runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "XSIEBELCONTACTIDENTITIES": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:31)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:823)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1263)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:7155)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:7280)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1538)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:462)
at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:499)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:898)
... 76 more
and: intradoc.common.ServiceException: !csJdbcGenericErrorWithCode,ORA-00904
at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2738)
... 77 more