Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forms troubleshooting conversion from 10g to 12c

MileKJul 4 2017 — edited Aug 3 2017

I am running out of options and I hope somebody can help/advise.

We are doing forms upgrade from 10.1.2.0.2 to 12.2.1.2.0.

We are going fresh install, convert forms and deploy to new server route.

Oracle forms  server 12.2.1.2.0 appears OK since I can successfully run anything from default section from formsweb.cfg (message "Installed successfully").

One of developers converted forms however when I try to run that section forms appears loading (JAVA security etc) but then screen (internet explorer) goes blank (white).

Problem is I cannot see any single error anywhere so I can check where it fails.

Nothing from $DOMAIN_HOME/servers/WLS_FORMS/logs shows any error sign and I enabled serverURL=/forms/lservlet/debug (debug messages in formsapp-diagnostic.log).

I even run form directly  with &record=forms&tracegroup=0-199 got output files in $DOMAIN_HOME/system_components/FORMS/forms1/trace tried to convert to meaningfull .txt. with java oracle.forms.diagnostics.Xlate datafile=a.trc outputfile=myfile.txt outputclass=WriteOutTEXT but I am getting next error (not sure how to fix this):

Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String index out of range: -1

        at java.lang.String.substring(String.java:1967)

        at oracle.forms.diagnostics.FormsInfo.interpret(Unknown Source)

        at oracle.forms.diagnostics.FormsInfo.process(Unknown Source)

        at oracle.forms.diagnostics.ReadDataFile.readEvent(Unknown Source)

        at oracle.forms.diagnostics.Xlate.process(Unknown Source)

        at oracle.forms.diagnostics.Xlate.main(Unknown Source)

How can I enable server to get some feedback when forms is loaded?

Details:

Oracle forms  server 12.2.1.2.0 on Oracle Linux Server release 7.3 (4.1.12-94.3.6.el7uek.x86_64)

Previous, forms were running on windows server 2003R2 and conversion was done on windows 7. Could this be issue?

myenv.env

# default.env - default Forms environment file, Linux version

#

# This file is used to set the Forms runtime environment parameters.

# If a parameter is not defined here, the value used will be that defined

# in the environment in which the WLS Managed Server was started.

#

# NOTES

#    Configuration assistant will replace all the macro's with

#    the actual values.

#

ORACLE_HOME=/u01/app/oracle/product/12.2.1

FORMS_INSTANCE=/u01/app/oracle/product/12.2.1/user_projects/domains/afms/config/fmwconfig/components/FORMS/instances/forms1

#

#

# TNS Entry to locate the database

#

TNS_ADMIN=/u01/app/oracle/product/12.2.1/user_projects/domains/afms/config/fmwconfig

#

#

# Search path for Forms applications (.fmx files, PL/SQL libraries)

#

FORMS_PATH=/u01/afms:/u01/app/oracle/product/12.2.1/forms:/u01/app/oracle/product/12.2.1/user_projects/domains/afms/config/fmwconfig/components/FORMS/instances/forms1

#

#

# Disable/modify this variable if users need to be able to run Forms

# applications residing in a different location.

#

FORMS_MODULE_PATH=$FORMS_PATH

#

#

# Webutil config file path

#

WEBUTIL_CONFIG=/u01/app/oracle/product/12.2.1/user_projects/domains/afms/config/fmwconfig/components/FORMS/instances/forms1/server/webutil.cfg

#

#

# Disable/remove this variable if end-users need access to the query-where

# functionality which potentially allows them to enter arbitrary SQL

# statements when in enter-query mode.

#

FORMS_RESTRICT_ENTER_QUERY=TRUE

#

#

# Java class path

#   This is required for the Forms debugger

#   You can append your own Java code here)

#

#   frmsrv.jar, frmconfig.jar ldapjclnt11.jar,jps-manifest.jar,

#   dms.jar,ojdl.jar, javax.management.j2ee.jar are required for

#   the password expiry feature to work.

#

CLASSPATH=;/u01/afms/forms/java/frmall.jar;$DOMAIN_HOME/servers/WLS_FORMS/tmp/_WL_user/formsapp_12.2.1/pgdzbo/war/WEB-INF/lib/frmsrv.jar;/u01/afms/jlib/repository.jar;/u01/afms/jlib/ldapjclnt10.jar;/u01/afms/jlib/debugger.jar;/u01/afms/jlib/ewt3.jar;/u01/afms/jlib/share.jar;/u01/afms/jlib/utj.jar;/u01/afms/jlib/zrclient.jar;/u01/afms/reports/jlib/rwrun.jar;/u01/afms/forms/java/frmwebutil.jar

#

#

# The PATH setting is required in order to pick up the JVM.

# Since PATH is being set, it needs to also include

# %ORACLE_HOME%/bin so relevant files are correctly found.

#

PATH=/u01/app/oracle/product/12.2.1/bin:/u01/app/oracle/product/12.2.1/oracle_common/jdk/bin:/u01/app/oracle/jdk1.8.0_131/jre/bin:

#

#

# Settings for Forms tracing and logging

# -----------------------------------------------

# Note: By default tracing and logging directory is

# $DH/system_components/FORMS/<forms_instance_name>/trace

# To change the trace directory this entry has to be uncommented and set to

# desired directory for tracing and logging

#

#

#FORMS_TRACE_DIR=%DOMAIN_HOME%/system_component/FORMS/%FORMS_INSTANCE_NAME%/trace

#

#

# Settings for Javascript events

# -----------------------------------------------

# Note: If this variable is set to false then the triggers and

# built-ins associated with javascript events are disabled

#

#

#FORMS_ALLOW_JAVASCRIPT_EVENTS=

#

#

#

# System settings

# ---------------

# You should not normally need to modify these settings

#

#

# Path for shared library objects

#   This is highly platform (if not machine) specific

LD_LIBRARY_PATH=/u01/app/oracle/product/12.2.1/lib:/u01/app/oracle/product/12.2.1/oracle_common/jdk/jre/lib/amd64:/u01/app/oracle/product/12.2.1/oracle_common/jdk/jre/lib/amd64/server:/u01/app/oracle/product/12.2.1/oracle_common/jdk/jre/lib/amd64/native_threads

#

#

# Setting to take care of signal-chaining facility offered by JVM 1.5

# Without this Forms/Reports integration could have issues on Unix/Linux

#

LD_PRELOAD=/u01/app/oracle/product/12.2.1/oracle_common/jdk/jre/lib/amd64/libjsig.so

NLS_LANG=AMERICAN_AMERICA.TH8TISASCII

NLS_DATE_FORMAT=DD-MM-RRRR

NLS_NUMERIC_CHARACTERS=.,

NLS_CALENDAR=Gregorian

NLS_DATE_LANGUAGE=American

afmsReportServer=AfmsRepsrv

ENVID=afms

FORMS_TIMEOUT=30

FORMS=/u01/afms

formsweb.cfg

# formsweb.cfg defines parameter values used by the FormsServlet (frmservlet)

# This section defines the Default settings.  Any of them may be overridden in the

# following Named Configuration sections.  If they are not overridden, then the

# values here will be used.

# The default settings comprise two types of parameters: System parameters,

# which cannot be overridden in the URL, and User Parameters, which can.

# Parameters which are not marked as System parameters are User parameters.

# SYSTEM PARAMETERS

# -----------------

# These have fixed names and give information required by the Forms

# Servlet in order to function.  They cannot be specified in the URL query

# string.  But they can be overridden in a named configuration (see below).

# Some parameters specify file names: if the full path is not given,

# they are assumed to be in the same directory as this file.  If a path

# is given, then it should be a physical path, not a URL.

# USER PARAMETERS

# ---------------

# These match variables (e.g. %form%) in the baseHTML file. Their values

# may be overridden by specifying them in the URL query string

# (e.g. "http://myhost.example.com/forms/frmservlet?form=myform&width=700")

# or by overriding them in a specific, named configuration (see below)

[default]

# System parameter: default base HTML file

baseHTML=base.htm

# System parameter: base HTML file for use with Sun's Java Plug-In

baseHTMLjpi=basejpi.htm

# System parameter: delimiter for parameters in the base HTML files

HTMLdelimiter=%

# System parameter: file setting environment variables for the Forms runtime processes

envFile=default.env

# System parameter: Forms runtime arguments

serverArgs=%escapeparams% module=%form% userid=%userid% debug=%debug% host=%host% port=%port% %otherparams%

# Forms runtime argument: whether to escape certain special characters

# in values extracted from the URL for other runtime arguments

escapeparams=true

# Forms runtime argument: which form module to run

form=test.fmx

# Forms runtime argument: database connection details

userid=

# Forms runtime argument: whether to run in debug mode

debug=no

# Forms runtime argument: host for debugging

# For internal use. Do not change null value.

host=

# Forms runtime argument: port for debugging

# For internal use. Do not change null value.

port=

# Forms runtime argument: BIDI digitSubstitution

digitSubstitution=context

# Other Forms runtime arguments: grouped together as one parameter.

# These settings support running and debugging a form from the Builder:

otherparams=obr=%obr% record=%record% tracegroup=%tracegroup% log=%log% term=%term% ssoProxyConnect=%ssoProxyConnect%

# Sub argument for otherparams

obr=no

# Sub argument for otherparams

record=

# Sub argument for otherparams

tracegroup=

# Sub argument for otherparams

log=

# Sub argument for otherparams

term=

# HTML page title

pageTitle=Oracle Fusion Middleware Forms Services

# HTML attributes for the BODY tag

HTMLbodyAttrs=

# HTML to add before the form

HTMLbeforeForm=

# HTML to add after the form

HTMLafterForm=

# Forms applet parameter: URL path to Forms ListenerServlet

serverURL=/forms/lservlet

# Forms applet parameter

codebase=/forms/java

# Forms applet parameter

imageBase=codebase

# Forms applet parameter: location for media files

mediaBase=codebase

# Forms applet parameter

width=750

# Forms applet parameter

height=600

# Forms applet parameter

separateFrame=false

# Forms applet parameter

splashScreen=

# Forms applet parameter

allowAlertClipboard=true

# Forms applet parameter

disableValidateClipboard=false

# Forms applet parameter

highContrast=false

# Forms applet parameter

background=

# Forms applet parameter

lookAndFeel=Oracle

# Forms applet parameter

colorScheme=swan

# Forms applet parameter to configure custom color scheme

customColorScheme=

# Forms applet parameter

logo=

# Forms applet parameter, valid range [0-3]

guiMode=0

# Forms applet parameter

restrictedURLparams=pageTitle,HTMLbodyAttrs,HTMLbeforeForm,HTMLafterForm,log

# Forms applet parameter

formsMessageListener=

# Forms applet parameter

recordFileName=

# Forms applet parameter

serverApp=

# Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)

archive=frmall.jar

# Number of times client should retry if a network failure occurs.  You should

# only change this after reading the documentation.

networkRetries=0

#

# More information regarding jpi and java_version settings can be found here:

# http://docs.oracle.com/javase/8/docs/technotes/guides/jweb/applet/using_tags.html

#

# Page displayed to users to allow them to download Oracle's Java Plugin.

# This is typically used for non-Microsoft Internet Explorer clients.

jpi_download_page= http://www.oracle.com/technetwork/java/javase/downloads

# Parameter to identify the Java Plugin

jpi_classid=clsid:8AD9C840-044E-11D1-B3E9-00805F499D93

#

# Parameter related to the version of the Java Plugin and a desired download location

#jpi_codebase=http://example.com/somewhere/jre-8u40-windows-i586.exeVersion=1,8,0,40

#

# Parameter related to the version of the Java Plugin

jpi_mimetype=application/x-java-applet

#

# Parameter used to specify which Plugin version to use

java_version=1.7+

#

# Applet parameter for Oracle's Java Plugin.

legacy_lifecycle=false

# Single Sign-On OID configuration parameter: indicates whether we allow

# dynamic resource creation if the resource is not yet created in the OID.

ssoDynamicResourceCreate=true

# Single Sign-On parameter: URL to redirect to if ssoDynamicResourceCreate=false

ssoErrorUrl=

# Single Sign-On parameter: Cancel URL for the dynamic resource creation DAS page.

ssoCancelUrl=

# Single Sign-On parameter: indicates whether the url is protected in which

# case mod_osso will be given control for authentication or continue in

# the FormsServlet if not. It is false by default. Set it to true in an

# application-specific section to enable Single Sign-On for that application.

ssoMode=false

# Single Sign-On parameter: indicates whether session should operate in proxy

# user support or not. Specify ssoProxyConnect=yes to enable for particular application.

ssoProxyConnect=no

# Single Sign-On parameter: indicates whether session should be logged out

# while exiting

ssoLogOut=false

# Single Sign-On parameter: Redirect URL to which the browser should be

ssoLogOutRedirect=

# Single Sign-On parameter: parameter to hold the name of query parameter on OAM Logout

# URL that holds the landing URL.

logoutTargetURLParamname=

# The parameter allow_debug determines whether debugging is permitted.

# Administrators should set allow_debug to "true" if servlet

# debugging is required, or to provide access to the Forms Trace Xlate utility.

# Otherwise these activities will not be allowed (for security reasons).

allow_debug=false

# Parameter which determines whether new Forms sessions are allowed.

# This is also read by the Forms EM Overview page to show the

# current Forms status.

allowNewConnections=true

# EndUserMonitoring

# EndUserMonitoringEnabled parameter

# Indicates whether EUM/Chronos integration is enabled

EndUserMonitoringEnabled=false

# EndUserMonitoringURL

# indicates where to record EUM/Chronos data

EndUserMonitoringURL=

# Config for javascript integration

applet_name=

enableJavascriptEvent=true

# Config variable that will indicate if heartbeat will

# be blocked when a javascript call is a blocking call.

# The default value if false, i.e heart beat will not be

# blocked for any javascript calls.

JavaScriptBlocksHeartBeat=false

# idleTimeout indicates how many seconds to wait

# before sending a message to the server indicating client-inactivity. Null

# or 0 means this functionality is disabled and there will be no client-idle

# notification.

idleTimeout=

#Setting separate_jvm=true is required for audio support

separate_jvm=false

# Example Named Configuration Section

# Example 1: configuration to run forms in a separate browser window with

# "generic" look and feel (include "config=sepwin" in the URL)

# You may define your own specific, named configurations (sets of parameters)

# by adding special sections as illustrated in the following examples.

# Note that you need only specify the parameters you want to change.  The

# default values (defined above) will be used for all other parameters.

# Use of a specific configuration can be requested by including the text

# "config=<your_config_name>" in the query string of the URL used to run

# a form.  For example, to use the sepwin configuration, your could issue

# a URL like "http://myhost.example.com/forms/frmservlet?config=sepwin".

[sepwin]

separateFrame=True

lookandfeel=Generic

# Example Named Configuration Section

# Example 2: configuration running the Forms ListenerServlet in debug mode

# (debug messages will be written to the servlet engine's log file).

[debug]

serverURL=/forms/lservlet/debug

# Sample configuration for deploying WebUtil. Note that WebUtil is

# only installed with the Forms Builder and is also available for download

# from OTN.

[webutil]

WebUtilArchive=frmwebutil.jar,jacob.jar

WebUtilLogging=off

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

baseHTML=webutilbase.htm

baseHTMLjpi=webutiljpi.htm

archive=frmall.jar

lookAndFeel=oracle

[jnlp]

basejnlp=base.jnlp

baseHTMLjpi=basejpi_jnlp.htm

[webutil_jnlp]

WebUtilLogging=off

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

basejnlp=webutil.jnlp

baseHTMLjpi=basejpi_jnlp.htm

lookAndFeel=oracle

[webstart]

basejnlp=base.jnlp

webstart=enabled

[webutil_webstart]

WebUtilLogging=off

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

basejnlp=webutil.jnlp

webstart=enabled

[standaloneapp]

# Note: baseSAAfile must end with .txt

baseSAAfile=basesaa.txt

# fsalcheck parameter specifies whether to perform checksum comparison

# of Forms stand-alone app launcher or not. When it is enabled, it triggers

# the comparison at server. The checksum of FSAL at client machine will be

# compared with the checksum of FSAL archived at the server repository.

fsalcheck=true

[webutil_standaloneapp]

# Note: baseSAAfile must end with .txt

WebUtilArchive=frmwebutil.jar,jacob.jar

WebUtilLogging=off

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

baseSAAfile=webutilsaa.txt

fsalcheck=true

[afms]

# Forms applet parameter: URL path to Forms ListenerServlet

serverURL=/forms/lservlet/debug

workingDirectory=/u01/afms/

form=AFM000.fmx

width=100%

height=100%

WebUtilArchive=frmwebutil.jar,jacob.jar

WebUtilLogging=on

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

baseHTML=webutilbase.htm

baseHTMLjpi=webutiljpi.htm

archive=frmall.jar

lookAndFeel=oracle

envFile=myenv.env

splashScreen=no

This post has been answered by Dan Andro-Oracle on Jul 5 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2017
Added on Jul 4 2017
4 comments
1,412 views