Hi Experts,
We had a very strange issue in our portal. Top level navigation had disappeared for few of our portal users. Rest of the users were able to perform their activities normally with no issues. When we tried to find the trace of exceptions from backend we got the following error trace.
#1.#00145E48CBB00096000000660017C030000476D27F094873#1256546353366#com.sap.portal.prt.request#sap.com/irj#com.sap.portal.prt
.request#35000315#147633##INBLR45V45EP1_EP1_17414950#35000315#0984f1f0c20b11de8e2700145e48cbb0#Thread[PRT-Async 8,5,PRT-Async
]##0#0#Error#1#/System/Server#Java###Exception in PortalRequestManager.dispatchRequest without timeout
[EXCEPTION]
#1#PcdRuntimeException: SQLException is not transient, error code = 1, sql state = 23000 ORA-00001: unique constraint (SAPEP1DB.SYS_C005523) violated And the below one shows the problem in navigation which has followed immediately after the above error: #1.#00145E48CBB00098000000280017C030000476D227A097A5#1256544886888#com.sap.portal.portal#sap.com/irj#com.sap.portal.portal#3 5000315#147407##INBLR45V45EP1_EP1_17414950#35000315#9f6f3a80c20711deac7f00145e48cbb0#Thread[PRT-Async 16,5,PRT-Async]##0#0#Er ror#1#/System/Server#Java###Exception ID:01:44_26/10/09_2177_17414950 [EXCEPTION] #1#com.sapportals.portal.prt.component.PortalComponentException: Error in service call of Portal Component
Component : pcd:portal_content/portal_home/com.xxx.defaultDesktop/frameworkPages/com.xxx.frameworkpage/com.sap.portal.topLeve
lNavigationiView
Component class : com.sapportals.portal.prt.component.CachablePortalComponent
Can anyone suggest, what was the cause of the issue and how we can avoid this kind of issue to happen in future? Does this issue come due to some PCD changes?
Thanks and Best Regards,
Shreya