Written by I found error when my consultant try to run web report from BEx. Browser always running on BEx Analysis like this
http://epq:50000/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?TEMPLATE=ZXXX
I compared from EPD and EPQ, it different. All these iViews are found in the portal at
Portal Content > Content Provided by SAP > Platform AddOns > Business Intelligence > iViews
on EPD
BEx Web pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex
BEx Web pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex3x
BEx Web (RRI) pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.rritransaction
on EPQ
BEx Launcher pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex
BEx Launcher (Format SAP BW 3.x) pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex3x
BEx Launcher (Transactions for RRI) pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.rritransaction
I try to fix it untill I got new error. I can not browse Portal Content > Content Provided by SAP > Platform AddOns > Business Intelligence > iViews
it show error
“9:54:49 AM Error com.sap.ip.bi.bex_broadcaster pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews”
content from file defaultTrace on /usr/sap/EPQ/JC00/j2ee/cluster/server0/log show error :
PcdRuntimeException: Did not find attribute name to attribute number 70000
com.sapportals.portal.pcd.pl.PlRuntimeException: Did not find attribute name to attribute number 70000
at com.sapportals.portal.pcd.pl.AttributeValuesTable.readAttributeValue(AttributeValuesTable.java:468)
at com.sapportals.portal.pcd.pl.AttributeValuesTable.selectSubtreeObjectsAttributeValues(AttributeValuesTable.java:577)
Solution !!!!!
see notes
SAP Note 886596 – iViews are not displayed because of corrupt attribute values
SAP Note 1003198 – J2EE: Incorrect data with Oracle10g JDBC lower than 10.2.0.4
SAP Note 1086644 – Checking database consistency for the PCD
STEP:
1. load file “com.sap.portal.pcd.supporttools.sda” from https://sapmats-de.sap-ag.de/download/download.cgi?id=SE27CCGSNYUUXDZO1
6KTQLO3GUBUZJ58MECTQHI4H04DHKKL3G
2. ftp “com.sap.portal.pcd.supporttools.sda” to server and deploy the SDA from Software Deployment Manager (SDM).
epqadm >setenv DISPLAY xx.xx.xx.xx:00
epqadm > cd /usr/sap/EPQ/JC00/SDM/program
epqadm > ./RemoteGui.sh
deploy
3. pcdTools folder created on /usr/sap/EPQ/JC00/j2ee
epqadm > cd /usr/sap/EPQ/JC00/j2ee/pcdTools
epqadm > chmod u+x *
epqadm > ./PcdCheckTool.sh
4. on P C D C h e c k T o o l
Starting up
Copying required jars…
Copylibs ok
Starting Console…
Connecting to database…
Connected
************************************************************************
* P C D C h e c k T o o l *
************************************************************************
(c) SAP AG, 2007
Type “help” for a list of available commands
command >add check
Command execution took 3 ms
command >check
Building object index
…………………………………………………………………………………….09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
09.09.2011 14:13:27 Error: An object was found where the path could not be determined; likely reason: database inconsistencies
No parent-less objects found
No object-less attributes found
No object-less relation attributes found
35 attribute-less values found
2 name-less attributes found
Command execution took 32267 ms
# this file generated on /usr/sap/EPQ/JC00/j2ee/pcdTools/logs
command >clean ConsistencyCheckResult1315552509819.csv
The total number of rows affected could not be determined (JDBC limitation)
No commit requested, changes were not commited
Command execution took 1784 ms
command >clean ConsistencyCheckResult1315552375997.csv commit
The total number of rows affected could not be determined (JDBC limitation)
Changes were commited
Command execution took 832 ms
command >clean ConsistencyCheckResult1315552375997.csv commit force
The total number of rows affected could not be determined (JDBC limitation)
Changes were commited
Command execution took 761 ms
command >
Result :
on EPD
BEx Web pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex
BEx Web pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex3x
BEx Web (RRI) pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.rritransaction
on EPQ
BEx Web pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex
BEx Web pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.bex3x
BEx Web (RRI) pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/iViews/com.sap.ip.bi.rritransaction
Then we can run BEx web on EPQ normally.
Share on Facebook