Can I Delete Diagnostic Reports On Library

Posted By admin  On 16.09.21

Mar 12, 2018 View and export diagnostic logs by using the PowerShell Out-GridView cmdlet. APPLIES TO: 2013 2016 2019 SharePoint in Microsoft 365. You can troubleshoot problems in the farm by using data from the Unified Logging Service (ULS) logs in SharePoint Server. The ULS logs can collect data at varying levels depending on the logging settings. Find information on health conditions, wellness issues, and more in easy-to-read language on MedlinePlus, the up-to-date, trusted health information site from the NIH and the National Library of Medicine.

8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

After a clean start of the Forms and Reports Services, the in-process reports server should start automatically on the first attempt to run a report. In practice, this does not seem to happen. There are a number of ways to kick the in-process reports server into touch. The 'startserver' URL can be used to start the in-process reports server. Tweets by @WaldenULibrary. Skip to the start of the twitter timeline. COVID-19 Information Portal. Timely news feeds, maps, and other resources from trusted sources. Community-driven and powered by EBSCO. Library system alerts & upcoming maintenance.

Home » Articles » 12c » Here

Configuration of Forms and Reports Services 12c is similar to 11gR2, but many of the files are in different locations. The paths may vary a little between Forms 12c versions, so be prepared to search for file locations if they don't match.

This article is a collection of useful notes on a variety of topics related to configuration of Oracle Forms and Reports Services 12c.

Related articles.

Installation

This site contains a number of articles describing the installation of WebLogic Server 11g and Oracle Forms and Reports Services 12c on Linux and Windows. You can find them here.

Library

Configuration Utility

If you choose a software-only installation, you can initiate the configuration steps using the following command.

This is also useful if your configuration phase fails and you want to rerun it after making the necessary changes to fix the issues.

Environment Variable Settings

The basic WebLogic environment variable settings are described in the installation guides, but the following list accounts for most of the scenarios you are likely to come across on the server, including forms compilation from the command line. Remember to adjust the paths to suit your installation. The paths below assume you've installed using the same paths I used in my installation guides. Also, remember to adjust the FORMS_PATH and TWO_TASK variables as required.

I tend to use FR_HOME and FR_INST in place of ORACLE_HOME and ORACLE_INSTANCE as I think they are more descriptive. It's worth setting both as many documents don't follow my preference.

A number of the sections below assume these environment variables have been set.

Configuration Files

Many of the 12c Forms and Reports Services configuration files are the same as those in 11gR2, but their locations differ. It is often easier to find things by searching below the $MW_HOME and $DOMAIN_HOME, as shown below.

The files I tend to visit the most are listed below.

A fuller list of configuration files can be seen here.

A couple of the important files are described below.

formsweb.cfg

The 'formsweb.cfg' file is one of the most important configuration files as it allows you to define multiple configurations, or environments, within a single software installation.

Typically, each separate environment will have it's own section in the 'formsweb.cfg' file, where environment-specific settings are placed. You only need to specify a value in a Named Configuration if it differs from that in the default configuration. For example, a named configuration might be simple, like the following.

The 'archive' entry includes the 'my_icons.jar', which assumes you have placed you icons in this JAR file and the JAR file is placed in the '$FR_HOME/forms/java' directory.

A very useful entry is the 'envFile' parameter, that can associate an environment file with a named configuration. This allows each named configuration run with a unique set of environment variables, including the FORMS_PATH variable amongst others. Any custom environment files should be derived from the 'default.env' file, described below.

Changes to this file to not require a restart of any components. The changes can be done directly to the file, or through Enterprise Manager.

default.env

The 'default.env' file defines the forms runtime parameters for a specific environment. All custom environment files should be derived from this file.

Environment variables specified in an '.env' file override existing environment settings. If an environment variable is not defined in the '.env' files, the value from the session that started the server process will be used.

Changes to these '.env' files do not require a restart of any components. The changes can be done directly to the file, or through Enterprise Manager.

It's is worth explicitly setting the NLS_LANG environment variable in the '.env' file to match the NLS details of the database the forms connect to, thereby removing any implicit character conversions.

Compiling Forms

Forms, menus and libraries are compiled using the frmcmp.sh or frmcmp_batch.sh scripts. You can find these in the '$FR_INST/bin/' directory. Running the command without any parameters displays the usage information. Some examples of the basic syntax are shown below.

Remember, frmcmp.sh requires and X Server, so you will need to SSH tunnel (ssh -X oracle@server) or set your DISPLAY environment variable (export DISPLAY=mypc:0.0).

You can easily script the compilation of all your forms-related objects, as shown by the following script.

Compiling Forms From a Non-Oracle User

In Forms 11g and 12c using SUDO is the recommended way to compile forms as a non-Oracle user.

As the root user, edit the '/etc/sudoers' file with the following entry (as a single line).

You can now run the compile commands from the user 'myuser' by using the 'sudo -u oracle' prefix. All environment variables discussed above must be set for this to work. An example is shown below.

The TWO_TASK environment variable does not work correctly using this method, so you should use the 'username/password@service' method for database authentication.

Forms Builder

If you are running on RHEL7/OL7, you will need to create the following symbolic link as the root user. This is not necessary on RHEL6/OL6.

Can I Delete Diagnostic Reports On Library

If you have set the environment variables described above, using the X Server based Forms builder should be as simple as issuing the frmbld command.

Compiling Reports

Reports are compiled using the rwconverter.sh script. You can find this in the '$FR_INST/config/reports/bin/' directory. Running the command without any parameters displays the GUI screen. An example of the command line syntax is shown below.

Reports Builder

If you have set the environment variables described above, using the X Server based Reports builder should be as simple as running the rwbuilder command.

Can I Delete Diagnostic Reports On Library

Webutil Configuration

If you have any problems with this configuration, please check out this note.

The basic configuration is described below.

  • Download the zipped 'jacob.jar' (v1.18-M2) file from https://sourceforge.net/projects/jacob-project/files/jacob-project/1.18-M2/.
  • Unzip the contents of the file.
  • Copy the 'jacob.jar' to the '$FR_HOME/forms/java' directory.
  • Copy the 'jacob-1.18-M2-x86.dll' to the '$FR_HOME/forms/webutil/win32' directory.
  • Copy the 'jacob-1.18-M2-x64.dll' to the '$FR_HOME/forms/webutil/win64' directory.
  • Edit the '$FR_HOME/forms/java/extensions.jnlp' file, making the following change.
  • Sign the 'jacob.jar' file. (See below)
  • Add '$FR_HOME/forms/java/frmall.jar' to the CLASSPATH entry in the 'default.env' file. This should be done with Enterprise Manager, but it works fine if you manually edit the file. If you use custom environment files, you should add it to those also.
  • Add 'frmwebutil.jar' and 'jacob.jar' to the 'WebUtilArchive' entry in the 'formsweb.cfg' file for any configurations that require it, for example.
  • After making changes, restart the WLS_FORMS managed server and the OHS.

Additional configuration is possible by editing the '$FR_INST/config/FormsComponent/forms/server/webutil.cfg' file.

Jar File Security Warning Hangs

Unsigned or self-signed jar files cause a browser security warning dialog to appear.

On some clients the behavior of this dialog is rather erratic, sometimes hanging and preventing you from taking the appropriate action. This seems to relate to two MOS notes.

The solution is to alter the order of the Jar files set by the 'archive' and/or 'WebUtilArchive' entries in the 'formsweb.cfg' file. In the case of the 'jacob.far' file, if you have it listed in the 'archive' parameter, you will probably need to make the following change.

If you have instead listed it in the 'WebUtilArchive' parameter, you will probably need to make the following change.

Cardi

You should not need to restart any services for this to take effect.

Sign JAR Files

Edit the '$FR_INST/bin/sign_webutil.sh' file, setting the appropriate values. If you want to generate a new certificate and keystore you must enter the following information, adjusted as desired.

If you created a keystore for securing your managed servers, you can reuse that by editing the following settings to match the details of your existing keystore.

Make sure line 84 has the correct path to the 'keytool' utility. I had to make the following change to the line.

Make sure line 108 has the correct path to the 'jarsigner' utility. I had to make the following change to the line.

Issue to the following command to sign the specified JAR file. In this case it is the jacob.jar file. If you are using a self-signed certificate this will result in a warning, and since return text is not blank the script will say the signing failed, but it didn't.

If you attempt to re-sign a JAR file that is already signed, it will contain multiple signatures in the 'META-INF' directory, which will probably result in the following error.

To fix this, unpack the JAR, remove the signatures from the 'META-INF' directory and re-pack the JAR. The following example shows how this can be done for the 'jacob.jar' file.

Once you've stripped the signatures from the JAR file you will need to resign it.

I've combined this method, along with the signing of the JAR file into following script, which I save as 'resign_jars.sh'.

This will strip and resign any JAR file passed as a parameter to the 'sign_jar' function.

REP-52262: Diagnostic output is disabled.

Reports 11.1.2.1 turns off the diagnostics output by default. If you need to turn it on, do the following.

Edit the '$DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_11.1.2/configuration/rwservlet.properties' file as follows.

Restart WLS_REPORTS server.

Once you have finished testing, you will probably want to remove the new entry and restart the WLS_REPORTS server.

In-Process Reports Server not Starting Properly

After a clean start of the Forms and Reports Services, the in-process reports server should start automatically on the first attempt to run a report. In practice, this does not seem to happen. There are a number of ways to kick the in-process reports server into touch.

The 'startserver' URL can be used to start the in-process reports server. Adding the following commands to the end of your startup script will start make sure it starts as expected.

If you have enabled the diagnostics pages (discussed earlier), any call to a diagnostics page will start the in-process reports server. Adding the following commands to the end of your startup script will start make sure it starts as expected.

You can also start the process using the Reports application page in Oracle Enterprise Manager. Either use the 'Monitoring > Start Reports Application' option or the 'Administration > Start In-process Reports Server' option.

Key Mappings

The shortcut keys used by Forms can be altered by editing the key mapping resource file for your specific language. The default US/English language uses one of the following resource files, depending on the character set being used.

Can i delete diagnostic reports on library software

A description of key mappings can be found here.

Reports Fonts

Can I Delete Diagnostic Reports On Library Management

The fonts available for the Reports server are defined in the following files.

The fonts referenced in these configuration files must be present in the following directory.

After making any changes, restart the Forms and Reports Services.

SSL Configuration

SSL configuration of Forms and Reports Services can seem a little tricky as there are a number of different elements to consider, including:

  • The AdminServer, WLS_FORMS and WLS_REPORTS managed servers. Explained here.
  • The JAR files used by the Forms and Reports Services. Explained here.
  • The Oracle HTTP Server (OHS). See below.

Can I Delete Diagnostic Reports On Library Services

To configure the Oracle HTTP Server (OHS), do the following steps, which assume you have already configured the managed servers for SSL using a keystore as described here.

Create a new wallet.

Load the contents of the previously created keystore into the new wallet.

Edit the '$DOMAIN_HOME/config/fmwconfig/components/OHS/instances/ohs1/ssl.conf' file, altering the path to the wallet as shown below.

Restart the Oracle HTTP Server.

The Oracle HTTP Server is now using the certificate in the wallet to support HTTPS traffic.

For more information see:

Hope this helps. Regards Tim...

Get the most out of Google Scholar with some helpful tips on searches, email alerts, citation export, and more.

Finding recent papers

Your search results are normally sorted by relevance, not by date. To find newer articles, try the following options in the left sidebar:

  1. click 'Since Year' to show only recently published papers, sorted by relevance;
  2. click 'Sort by date' to show just the new additions, sorted by date;
  3. click the envelope icon to have new results periodically delivered by email.

Locating the full text of an article

Abstracts are freely available for most of the articles. Alas, reading the entire article may require a subscription. Here're a few things to try:

  1. click a library link, e.g., 'FindIt@Harvard', to the right of the search result;
  2. click a link labeled [PDF] to the right of the search result;
  3. click 'All versions' under the search result and check out the alternative sources;
  4. click 'Related articles' or 'Cited by' under the search result to explore similar articles.

If you're affiliated with a university, but don't see links such as 'FindIt@Harvard', please check with your local library about the best way to access their online subscriptions. You may need to do search from a computer on campus, or to configure your browser to use a library proxy.

Getting better answers

  • If you're new to the subject, it may be helpful to pick up the terminology from secondary sources. E.g., a Wikipedia article for 'overweight' might suggest a Scholar search for 'pediatric hyperalimentation'.

  • If the search results are too specific for your needs, check out what they're citing in their 'References' sections. Referenced works are often more general in nature.

  • Similarly, if the search results are too basic for you, click 'Cited by' to see newer papers that referenced them. These newer papers will often be more specific.

  • Explore! There's rarely a single answer to a research question. Click 'Related articles' or 'Cited by' to see closely related work, or search for author's name and see what else they have written.