Portal Problem

From: Nancy McCormick <nmccormick_at_sbti.com>
Date: Thu, 24 May 2001 11:34:52 -0700
Message-ID: <F001.0030DD0B.20010524110524@fatcity.com>

We recently installed the 9iAS and the Portal products on 2 Sun Solaris boxes (1 for the front end, 1 for the back end). For the first couple of weeks the Portal product was working smoothly. However last week the developers started encountering some errors. To my knowledge nothing has changed on the servers or the Oracle products. But I cannot guarantee that since once I installed the product and got the word they were functioning, I went on to other things. What follows is the information I received from the developers about the problems. Can anyone give me a clue as to where to start looking? I have checked for invalid objects on the database and everything appears valid. I also looked in Metalink and go no hits for any of these error messages. I'm not sure what the next step should be in troubleshooting this problem.

Thanks in advance,
Nancy

Starting Developer's message ===== We can RUN pages and portlets, we cannot EDIT or CREATE new portlets. If we try to create a new portlet we get what appears to be help text, but no wizard pages. If we try to edit an existing portlet, we get errors similar to the errors below, which are related to packages owned by Portal30. However we get the same errors when we sign on as Portal30 and try to edit a portlet, so it appears to be related to permissions on some other schema's tables that are referenced in the Portal30 package. The packages are in the database and are marked as valid, however since they are wrapped, we cannot determine what table(s) are missing the appropriate permissions.

This error occurs when signed on as a non-Portal30 user.
Box Background Color COMBOBOX LOV ERROR: LOV: "SYSTEM_COLORS" Parse Message: Query not found, unable to parse. Find Message: Security Violation for LOV SYSTEM_COLORS wwv_security.check_comp_privilege: Insufficient privileges.

These errors occur when signed on as the Portal30 user.
Thu, 24 May 2001 14:37:07 GMT

ORA-00942: table or view does not exist
ORA-06512: at "PORTAL30.WWV_DESCRIBE", line 194
ORA-06512: at "PORTAL30.WWV_UIFORM_BUILD", line 5814
ORA-06512: at line 8

DAD name: portal30
PROCEDURE : PORTAL30.wwv_uiform_build.show_right_frame URL :
http://server_ip_address:7777/pls/portal30/PORTAL30.wwv_uiform_build.show_ri ght_frame?p_wizard_mode=TABLE&p_module_id=1570228603&p_version=2&p_section=5 &p_save_version=3&p_mode=EDIT&p_step=&p_total_steps=3&p_last_reqstep=3&p_for mlayout_type=STRUCTURED_LAYOUT&p_type=form&p_owner=MY_HLW&p_table_name=HLW_C USTOMERS&p_orig_field_names=INSERT_TOP*!UPDATE_TOP*!DELETE_TOP*!QUERY_TOP*!R ESET_TOP*!*TOP_SECTION**!ID*!NAME*!PHONE_NUMBER*!EMAIL_ADDRESS*!ADDRESS_LINE 1*!CITY*!STATE*!POSTAL_CODE*!COUNTRY*!REGION_ID*!*BOTTOM_SECTION**!PREVIOUS* !NEXT&p_redirect_url=http%3A%2F%2F172.29.102.180%3A7777%2Fservlet%2Fpage%3F_ pageid%3D3%2C22%26_dad%3Dportal30%26_schema%3DPORTAL30%26_mode%3D3%26p_rende r%3DLIST%26p_otype%3DAPP%26p_octx%3DMY_HLW.CASEBOOK30_APPLICATION%26p_action %3D%26p_caller%3DPORTLET%26p_domain%3Dwwc%26p_sub_domain%3Dappexp%26p_rpth%3 D49_APPLICATIONEXPLORER_652602%26p_orderby%3D%26p_request%3D%26p_min_row%3D1 %26p_max_rows%3D49%26p_page_number%3D1

<FONT size=2>Thu, 24 May 2001 14:33:12 GMT

ORA-00942: table or view does not exist
ORA-06512: at "PORTAL30.WWV_DESCRIBE", line 194
ORA-06512: at "PORTAL30.WWV_UIFORM_BUILD", line 2778
ORA-06512: at "PORTAL30.WWV_UIFORM_BUILD", line 5647
ORA-06512: at line 8

DAD name: portal30
PROCEDURE : PORTAL30.wwv_uiform_build.show_header URL :
http://server_ip_address:7777/pls/portal30/PORTAL30.wwv_uiform_build.show_he ader?p_wizard_mode=TABLE&p_module_id=1564981795&p_version=2&p_section=5&p_sa ve_version=2&p_mode=EDIT&p_step=&p_total_steps=3&p_last_reqstep=3&p_redirect _url=http%3A%2F%2F172.29.102.180%3A7777%2Fservlet%2Fpage%3F_pageid%3D3%2C22% 26_dad%3Dportal30%26_schema%3DPORTAL30%26_mode%3D3%26p_render%3DLIST%26p_oty pe%3DAPP%26p_octx%3DMY_HLW.CASEBOOK30_APPLICATION%26p_action%3D%26p_caller%3 DPORTLET%26p_domain%3Dwwc%26p_sub_domain%3Dappexp%26p_rpth%3D49_APPLICATIONE XPLORER_652602%26p_orderby%3D%26p_request%3D%26p_min_row%3D1%26p_max_rows%3D 49%26p_page_number%3D1
</FONT>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nancy McCormick
  INET: nmccormick_at_sbti.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu May 24 2001 - 13:34:52 CDT