2 Replies Latest reply: Dec 6, 2012 4:25 AM by 976903 RSS

    Unable to access WLS_FORMS for Work and asset management via weblogic

    976903
      **Hi All,**

      **I am in the process of installing Oracle WAM 10.3.4 on Windows x86 64bit, Oracle 11.2.0.1 database Java 1.6.0_23.**

      **I have already installed everything and have started the WLS_FORMS server from weblogic console. However when I am trying to access the forms website - I am just getting 404.**

      **Weblogic installed in : C:\SPL\Oracle\middleware\wlserver1034**
      **Instance in : C:\SPL\Oracle\middleware\wam_inst1**
      **server in : C:\SPL\Oracle\middleware\CCHDEV1**

      **here is my config.properties for WAM:**

      root_path=C:/SPL/WAMCCH/synergencchdev1/sia/
      app_server=http://ldelara-ph.splwg.com:9001/cchdev1/
      help_default_page=webhelp/wwhelp/wwhimpl/js/html/wwhelp.htm?context=Overview&topic=uo_whatsnew
      mail_server=mail.server.com
      asp_url=http://ldelara-ph.splwg.com:8001/
      init_integration_table=true
      chart_xml_path=C:/SPL/WAMCCH/synergencchdev1/sia/charts/data
      max_chart_records=20000
      forms_servlet=frmservlet?config=wam
      forms_server=http://ldelara-ph.splwg.com:9001/forms/
      forms_report_service_name=RptSvr_LDELARA-PH_wam_inst1
      forms_report_server_url=http://ldelara-ph.splwg.com:8888/reports/rwservlet
      forms_tnsname=cchdev1
      report_cgicmd_key=report_cgicmd_key1
      debug_session_level=INFO
      debug_session_filter=synergen
      debug_session_method_filter=
      application=synergen
      datasource=synergen
      default_locale=en-us
      charset_to_use=UTF-8
      file_prefix=documents
      log_requests=false
      move_requests_to_history=false
      home_page_url=Home?tgt=Main
      logon_page_url=Logon?tgt=Main
      logon_error_url=Logon?tgt=Failure
      logoff_page_url=Logon?tgt=Main
      ssoMode=false
      event_queue_module=EventQueue
      event_queue_page=Results
      default_username=synergenguest
      queue_retries=1
      auto_logon_expire=30
      max_user_windows=3
      db_proxy_session_helper_class=synergen.db.OracleAsDbProxySessionHelper
      sia_integration_url=http://ldelara-ph.splwg.com:9001/cchdev1/synergen/
      repair_revoked_metadata_age_in_days = 30

      WLS_FORMS.out
      the JEE version.>
      *************** Starting SIA Application Server ***************
      Configuring log4j...
      configuration file to be used = C:\SPL\WAMCCH\synergen\CCHDEVwaminst\sia\WEB-INF\classes\wam-log4j.properties
      Finished configuring log4j...
      ************* Started loading config properties *************
      Listing config properties
      forms_report_server_url=http://ldelara-ph.splwg.com:9001/reports/rwservlet
      forms_tnsname=WLS_FORMS
      asp_url=http://ldelara-ph.splwg.com:9001/
      log_requests=false
      forms_servlet=frmservlet?config=wam
      default_locale=en-us
      root_path=C:/SPL/WAMCCH/synergen/CCHDEVwaminst/sia/
      logon_error_url=Logon?tgt=Failure
      file_prefix=documents
      queue_retries=1
      help_default_page=webhelp/wwhelp/wwhimpl/js/html/wwhelp.htm?context=Overview&topic=uo_whatsnew
      debug_session_method_filter=
      db_proxy_session_helper_class=synergen.db.OracleAsDbProxySessionHelper
      ssoMode=false
      home_page_url=Home?tgt=Main
      auto_logon_expire=30
      report_cgicmd_key=report_cgicmd_key1
      forms_server=http://ldelara-ph.splwg.com:9001/forms/
      init_integration_table=true
      logon_page_url=Logon?tgt=Main
      app_server=http://ldelara-ph.splwg.com:9001/wam_inst1/
      repair_revoked_metadata_age_in_days=30
      default_username=synergenguest
      forms_report_service_name=RptSvr_LDELARA-PH_wam_inst1
      application=synergen
      event_queue_page=Results
      charset_to_use=UTF-8
      event_queue_module=EventQueue
      move_requests_to_history=false
      debug_session_filter=synergen
      datasource=synergen
      logoff_page_url=Logon?tgt=Main
      mail_server=mail.server.com
      sia_integration_url=http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/
      debug_session_level=INFO
      chart_xml_path=C:/SPL/WAMCCH/synergen/CCHDEVwaminst/sia/charts/data/
      max_user_windows=3
      max_chart_records=20000

      Setting derived paths
      xmlPath = C:/SPL/WAMCCH/synergen/CCHDEVwaminst/sia/xml/
      logPath = C:/SPL/WAMCCH/synergen/CCHDEVwaminst/sia/logs/
      debugPath = C:/SPL/WAMCCH/synergen/CCHDEVwaminst/sia/debug/
      Chart Directory = C:/SPL/WAMCCH/synergen/CCHDEVwaminst/sia/charts/
      Documents Path = C:/SPL/WAMCCH/synergen/CCHDEVwaminst/sia/documents/
      Temporary Documents Path = C:/SPL/WAMCCH/synergen/CCHDEVwaminst/sia/tempdocs/
      Loading converted properties
      ************* Completed loading config properties *************
      Database Connection Factory Settings
      Accessing MetaData from Database
      Database jdbc:oracle:thin:@ldelara-ph.splwg.com:1521:CCHDEV
      JDBC Driver Oracle JDBC driver/11.2.0.2.0
      Database Name/Version: Oracle/Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      Installation Parameters
      12.06.12.15:47:54.661 root
      [INFO] SQL Executed: select key_name, key_value from SA_INSTALLATION_PARAMETERS where key_name in ('PHONE_NUMBER_FORMAT', 'SCHEDULING TOTAL EST HRS DISP', 'ENABLE PASSWORD RESET')

      12.06.12.15:47:55.124 root
      Starting DatePrefereneces.initDatePreferences

      12.06.12.15:47:55.125 root
      [INFO] SQL Executed: select username, java_long_date_mask, oracle_long_date_mask, long_date_delimiter, java_short_date_mask, oracle_short_date_mask, short_date_delimiter, java_time_mask, oracle_time_mask, time_delimiter, skin, show_component_desc, short_date_mask_no from sv_preference where username in ('DEFAULT', 'DEFAULT')

      12.06.12.15:47:55.283 root
      Created session 13547800752830 at Thu Dec 06 15:47:55 SGT 2012

      12.06.12.15:47:55.283 root
      Session 13547800752830 is currently using username SYNERGENGUEST

      Enable password reset parameter is false
      12.06.12.15:47:55.371 db.DatabaseConnect
      [INFO] SQL Executed:select key_value from sa_installation_parameters where key_name = 'CHART THUMBNAIL GENERATION'

      Scheduling Total/Estimate Display is ON
      12.06.12.15:47:55.373 db.DatabaseConnect
      [INFO] SQL Executed:select key_name from sa_installation_parameters where key_value in ('SERVICE PACK', 'SERVICE PACK1', 'MAJOR RELEASE')and last_update_date in (select max(last_update_date) from sa_installation_parameters where key_value in ('SERVICE PACK', 'SERVICE PACK1', 'MAJOR RELEASE'))

      Product Version from Installation Parameters is 1.9.0.3.0
      SA_INTERNET_INTEGRATION initialization
      Deleting integration records for http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/
      12.06.12.15:47:55.374 db.DatabaseConnect
      [INFO] SQL Executed:delete from sa_internet_integration where sia_url='http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/'

      SIA URL = http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/
      Forms Server URL = http://ldelara-ph.splwg.com:9001/forms/
      Home Page URL = http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/Home?tgt=Main
      Event Queue Administration URL = http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/EventQueue?tgt=Results
      Event Queue Servlet URL = http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/EventServlet
      SIA Application Version = v1.9.0.3.201106221519
      SIA URL = http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/
      Timestamp = Thu Dec 06 15:47:55 SGT 2012
      Deleting all integration records
      12.06.12.15:47:55.382 db.DatabaseConnect
      [INFO] SQL Executed:delete from sa_internet_integration

      12.06.12.15:47:55.384 db.DatabaseConnect
      [INFO] SQL Executed:insert into sa_internet_integration (home_page_url, event_queue_admin_url, process_queue_url, sia_version, sia_url, forms_server_url, timestamp) select ?, ?, ?, ?, ?, ?, ? from dual where 0 = (select count(*) from sa_internet_integration where forms_server_url = ? and sia_url = ?)

      Completed initialization of integration table for http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/
      12.06.12.15:47:55.396 root
      Created session 13547800753961 at Thu Dec 06 15:47:55 SGT 2012

      12.06.12.15:47:55.396 root
      Session 13547800753961 is currently using username SYNERGENGUEST

      12.06.12.15:47:55.397 db.DatabaseConnect
      [INFO] SQL Executed:select sia_url from sa_internet_integration where timestamp in (select max(timestamp) from sa_internet_integration)

      12.06.12.15:47:55.398 net.EventManager
      Current server is "http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/".

      12.06.12.15:47:55.398 net.EventManager
      Primary server is "http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/".

      XT_EVENT_QUEUE Cleanup
      12.06.12.15:47:55.399 db.DatabaseConnect
      [INFO] SQL Executed:select status, status_date, status_message from xt_event_queue where status in ('processing')

      Initializing ApplicationMapData
      12.06.12.15:47:55.476 db.DatabaseConnect
      [INFO] SQL Executed:SELECT lower(r.primekey_name_1), lower(r.primekey_name_2), lower(r.primekey_name_3), lower(r.primekey_name_4), r.architecture_ind, r.form_name, r.sia_module, r.form_function FROM SA_FORM_NAMES r order by r.form_name

      Loading Named Query Cache...
      12.06.12.15:47:55.578 util.AbstractGeneralCache
      Initializing the NamedQueryInfoCache.

      Begin loading Table Metadata Cache...
      12.06.12.15:47:55.585 db.TableMetaDataCache
      Initializing the TableMetaData cache.

      Loaded metadata for 316 tables/views in 2156 milliseconds.
      Initializing Field MetaData Cache
      12.06.12.15:47:57.745 util.AbstractGeneralCache
      Initializing the FieldMetaDataCache cache.

      Loading Labels/Words Cache
      Strict English translations: false
      12.06.12.15:47:57.753 db.DatabaseConnect
      [INFO] SQL Executed:select field_name, locale_code, is_db_field, label, short_label, extended_label, hint from xt_application_labels

      Initializing UDF Attributes Cache
      12.06.12.15:47:57.758 util.AbstractGeneralCache
      Initializing the UdfAttributesCache cache.

      Begin loading Group Element Metadata Cache...
      12.06.12.15:47:57.766 util.AbstractGeneralCache
      Initializing the MetaDataGroupElementCache.

      12.06.12.15:47:57.942 util.AbstractGeneralCache
      No corresponding METADATA_GROUP_ELEMENT metadata was found for the XT_RESP_PAGE_RESTRICTIONS column name RESTRICT_INSERT.

      12.06.12.15:47:57.942 util.AbstractGeneralCache
      No corresponding METADATA_GROUP_ELEMENT metadata was found for the XT_RESP_PAGE_RESTRICTIONS column name RESTRICT_UPDATE.

      12.06.12.15:47:57.942 util.AbstractGeneralCache
      No corresponding METADATA_GROUP_ELEMENT metadata was found for the XT_RESP_PAGE_RESTRICTIONS column name RESTRICT_DELETE.

      12.06.12.15:47:58.515 util.AbstractGeneralCache
      No corresponding METADATA_GROUP_ELEMENT metadata was found for the SA_USER_PROFILE column name CUSTOMER_ID.

      12.06.12.15:47:58.743 util.AbstractGeneralCache
      No corresponding METADATA_GROUP_ELEMENT metadata was found for the SA_SERVICE_REQUEST column name ESTIMATE_TOTAL.

      Loaded metadata for 258 metadata groups in 1071 milliseconds.

      *************** Completed SIA Application Startup ***************

      12.06.12.15:47:58.848 root
      Event Servlet checking primary SIA server before attempting event queue processing

      12.06.12.15:47:58.848 root
      Created session 13547800788482 at Thu Dec 06 15:47:58 SGT 2012

      12.06.12.15:47:58.848 root
      Session 13547800788482 is currently using username SYNERGENGUEST

      12.06.12.15:47:58.848 db.DatabaseConnect
      [INFO] SQL Executed:select sia_url from sa_internet_integration where timestamp in (select max(timestamp) from sa_internet_integration)

      12.06.12.15:47:58.849 net.EventManager
      Current server is "http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/".

      12.06.12.15:47:58.849 net.EventManager
      Primary server is "http://ldelara-ph.splwg.com:9001/wam_inst1/synergen/".

      12.06.12.15:47:58.850 root
      Processing 'pending' event queue records

      12.06.12.15:47:58.850 root
      Created session 13547800788503 at Thu Dec 06 15:47:58 SGT 2012

      12.06.12.15:47:58.851 root
      Session 13547800788503 is currently using username SYNERGENGUEST

      12.06.12.15:47:58.852 db.DatabaseConnect
      [INFO] SQL Executed:select event_seq_no, event_type, event_title, status, status_date, status_message, event_interval, next_event_date, originator, recipients_to, recipients_cc, recipients_bcc, message_subject, content_type, request_xml, content, content_url, last_retry, read_receipt_ind, importance_ind, attachment_filename, last_update_date, last_update_user, created_date, created_by from xt_event_queue where status in ('pending')

      Starting FileClerk...
      FileClerk complete. 0 files deleted in 56.0 milliseconds.


      <12 6, 12 3:48:01 PM SGT> <Notice> <Log Management> <BEA-170027> <The Server has established connection with the Domain level Diagnostic Service successfully.>
      <12 6, 12 3:48:01 PM SGT> <Notice> <Cluster> <BEA-000197> <Listening for announcements from cluster using unicast cluster messaging>
      <12 6, 12 3:48:01 PM SGT> <Notice> <Cluster> <BEA-000133> <Waiting to synchronize with other running members of cluster_forms.>
      <12 6, 12 3:48:31 PM SGT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to ADMIN>
      <12 6, 12 3:48:31 PM SGT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RESUMING>
      <12 6, 12 3:48:31 PM SGT> <Notice> <Cluster> <BEA-000162> <Starting "async" replication service with remote cluster address "null">
      <12 6, 12 3:48:31 PM SGT> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on 10.186.252.165:9001 for protocols iiop, t3, CLUSTER-BROADCAST, ldap, snmp, http.>
      <12 6, 12 3:48:31 PM SGT> <Notice> <WebLogicServer> <BEA-000330> <Started WebLogic Managed Server "WLS_FORMS" for domain "ClassicDomain" running in Production Mode>
      <12 6, 12 3:48:32 PM SGT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING>
      <12 6, 12 3:48:32 PM SGT> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>

      Any suggestions how I can fix this? I am lost as there are no errors on WLS_FORMS.out