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. ***************** <!--StartFragment-->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 ===================== <!--StartFragment--><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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
