Component注册的问题！

mel61

我新建了一个Component，然后注册到PIA上，但是注册完成后报错
Error: Content reference xxxx was not created.
There is already a content reference with the same name or URL.
去Potal上的注册的folder看了，确实没有这个页面。
我怎样才能找到这个已存在的content reference？

mel61

解决了！原来是Application Designer配置了错误的服务器。不过还是学到些东西！
1) Run the below SQL to get the content reference name for your component

SELECT PORTAL_NAME,
PORTAL_OBJNAME AS CONTENT_REFERENCE,
PORTAL_LABEL,
PORTAL_URI_SEG1 AS MENU,
PORTAL_URI_SEG2 AS COMPONENT,
PORTAL_URI_SEG3 AS MARKET
FROM psprsmdefn
WHERE PORTAL_NAME = 'EMPLOYEE'
   AND PORTAL_URI_SEG2 = :1;

-- Replace :1 with the component name you are looking for.

2) From the query above - copy the value in the CONTENT_REFERENCE field and replace the ":1" variable and you will have the path to your component.

WITH portal_registry AS
  (SELECT RTRIM(REVERSE(sys_connect_by_path(REVERSE(portal_label),    ' >> ')),    ' >> ') path,
     LEVEL lvl
   FROM psprsmdefn
   WHERE portal_name = 'EMPLOYEE' START WITH PORTAL_OBJNAME = :1 CONNECT BY PRIOR portal_prntobjname = portal_objname)
SELECT path
FROM portal_registry
WHERE lvl =
  (SELECT MAX(lvl)
   FROM portal_registry);

So, the 1st query is to get the content reference for a component name that you know and then using Jim's query to find the path!

imake

发一个根据组件名找导航路径的SQL：
SELECT REPLACE(NAVIGATION, '', ' > ') "PIA Navigation",
        URL,
        MENU_NAME,
        COMPONENT_NAME,
        PORTAL_OBJNAME,
        PORTAL_PRNTOBJNAME,
        PORTAL_URI_SEG3,
        PORTAL_LABEL
FROM (
        SELECT SYS_CONNECT_BY_PATH(A.PORTAL_LABEL, '>>') NAVIGATION,
                '/EMPLOYEE/ERP/c/' || A.PORTAL_URI_SEG1 || '.' || A.PORTAL_URI_SEG2 || '.' || A.PORTAL_URI_SEG3 URL,
                A.PORTAL_URI_SEG1 MENU_NAME,
                A.PORTAL_URI_SEG2 COMPONENT_NAME,
                A.PORTAL_OBJNAME PORTAL_OBJNAME,
                A.PORTAL_PRNTOBJNAME PORTAL_PRNTOBJNAME,
                A.PORTAL_URI_SEG3 PORTAL_URI_SEG3,
                A.PORTAL_REFTYPE PORTAL_REFTYPE,
                A.PORTAL_LABEL PORTAL_LABEL
                FROM (SELECT DISTINCT A.PORTAL_NAME,
                A.PORTAL_LABEL,
                A.PORTAL_OBJNAME,
                A.PORTAL_PRNTOBJNAME,
                A.PORTAL_URI_SEG1,
                A.PORTAL_URI_SEG2,
                A.PORTAL_URI_SEG3,
                A.PORTAL_REFTYPE
        FROM PSPRSMDEFN A
        WHERE PORTAL_NAME = 'EMPLOYEE'
          AND PORTAL_OBJNAME <> PORTAL_PRNTOBJNAME
          AND NOT EXISTS (
                SELECT 'X'
                FROM PSPRSMSYSATTRVL
                WHERE PORTAL_NAME = A.PORTAL_NAME
                  AND PORTAL_REFTYPE = A.PORTAL_REFTYPE
                  AND PORTAL_OBJNAME = A.PORTAL_OBJNAME
                  AND PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV'
                  AND A.PORTAL_OBJNAME NOT IN (
                        'CO_NAVIGATION_COLLECTIONS', 'PORTAL_BASE_DATA'
                  )
          )
) A
WHERE PORTAL_URI_SEG2 = 'COMP_NAME' -- 修改这里！
START WITH A.PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT'

CONNECT BY PRIOR A.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME)