E-PORTAL: Portal Pagelet Synchronization Fails Successful But SQL Error When Expanding The Menu Content (Doc ID 1980645.1)

Last updated on APRIL 07, 2017

Applies to:

PeopleSoft Enterprise PRTL Interaction Hub - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT
---------------
PeopleTools 8.54 implementation.  Portal is integrating with Content Provider HCM database using Unified Navigation. When importing the pagelets for the HCM menu, which is just the HCM menu root, the menu doesn't expand even if the import of the pagelet is successful.
 
ERROR
---------------
On the Content Provider environment, the following error message can be seen:

Return: 8602 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'UNIQUE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s)

  Statement: SELECT UNIQUE(WEBPROFILENAME) FROM PSWEBPROFPROP

  Original Statement: SELECT UNIQUE(WEBPROFILENAME) FROM PSWEBPROFPROP ;

Now on the PA side, the following:

PSAPPSRV.2620 (1245) [2014-12-10T10:10:02.323 ciber_kludwig@VA1CDSCNPTS01 (CHROME 39.0.2171.71; WIN7) ICScript](0) Method: GetWebProfConfigCustProp. SamFetch Failed

ACTUAL BEHAVIOR
---------------
menu doesn't expand even if the import of the pagelet is successful.
 
EXPECTED BEHAVIOR
---------------
menu should expand after importing the pagelet

 
STEPS
---------------
1) Go to Portal Administration > Unified navigation workcenter
2) Go to unified navigation setup > Select remote content
3) go to configure drop down menu and enter
HRMS
EMPLOYEE
HCM Menu
HRMS:PORTAL_ROOT_OBJECT
Select a Folder
PORTAL_ROOT_OBJECT

4) Import the pagelets for the HRMS node, import is successful
5) Try to expand the newly created HCM root foolder
6) Please list the documentation you have reviewed and describe the troubleshooting steps, if any, you have taken.
Checked all unified navigation and integration broker network settings as well as logs on the app server. Reviewed documentation on how to setup unified navigation and verified settings are correct.
 
IMPACT
---------------
User is not able to navigate menu through the unified navigation.

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