If you try to log into PITSS.CON in Windows and you are unable to log in (not being able to go beyond the login screen) despite the fact you entered the correct credentials and the correct database, you should check to see if the TNS Listener is currently running.

1. Test to see if you can ping your database by using the tnsping command in Command Prompt (cmd.exe).

clip_image002

If you receive the message “TNS-12541: TNS:no listener” or anything similar, then your database listener is currently stopped.

clip_image004

2. To turn on your TNS Listener, go to the Control Panel –> Administrative Tools –> Services

clip_image006

clip_image008

3. Locate the TNS Listener associated with your database as shown here. Once you find it, click “Start” where it says “Start the service”. Notice how the word “Started” isn’t currently stated for the TNS Listener.

clip_image010

When the TNS Listener has started, you should see the screen below:

clip_image012

4. Test to see if you can ping your database again using tnsping inside Command Prompt.

clip_image014

As you can see above, we were able to successfully reach the database!

5. You should now be able to log into PITSS.CON. If you reach the main menu after logging in as shown below, the TNS Listener is running and PITSS.CON can communicate with the database.

image

Depending on user permissions, you might receive possible errors when accessing a Forms application using Webutil such as:
“WUC-19: Unable to write to local file C:\Program Files (x86\Java\jre6\bin\jacob.dll”
If that is the case, it is recommended to dedicate a directory to where users would have the right to download to. After creating the directory, you will need to do the following:

  1. Copy d2kwut60.dll, jacob.dll, and JNIsharedstubs.dll into the directory
  2. On the server where you are accessing the Forms application from, open webutil.cfg in a text editor
  3. Copy the line “#install.syslib.location.client.1=webutil/syslib” and paste it below. HINT: This line is in the middle of the document.
  4. Uncomment the line you pasted
  5. Replace webutil/syslib with the full path to the directory where the 3 dlls will be located in.
  6. Save all changes in webutil.cfg

After that, you should be able to log into your Forms application without a problem.

If none of your WebLogic servers start up automatically (assuming that Node Manager is supposed to automatically start up the servers) and when you try to use nmConnect with your domain name, weblogic username, and weblogic password to try to reconnect the servers, but you receive the following error:

WLSTException: Error occurred while performing nmConnect : Cannot connect to Node Manager. Access to domain ‘FormsDomain’ for user ‘weblogic’ denied

You may need to change the username and password Node Manager uses to connect. You can do this by the following steps:

1. Log into your Administration Console
2. Once logged in, click on the FormsDomain link on the left side of the screen.
3. Go to the Security tab. Make sure to click “Lock & Edit” first!
4. On the bottom, click on “Advanced”.
5. Change the username and password for Node Manager to match what you use to log into your WebLogic servers.
6. Save all changes and then click “Activate Changes”.
7. Shut down all WebLogic servers.
8. Now you should be able to successfully use nmConnect within WLST.

FYI: If any WebLogic server enters a “FAILED_NOT_RESTARTABLE” state during Node Manager testing, you may need to restart your computer/server before proceeding.

When attempting to load forms and reports modules in PITSS.CON on a 10gR2 Developer Suite installation, the following error is received in the bottom status bar of PITSS.CON “Can not connect to database with forms -1”

This is because of a bug in Developer Suite 10gR2. Patchset “p4694221_10122” must be applied to Dev Suite 10gR2. Patchset is located in the PITSS.CON Installer within the folder “Oracle Patches”.

Steps to apply patch:

  1. Shutdown OC4J
  2. Extract the patch (p4694221_10122)
  3. Go to the “files/bin” folder inside the extracted patch folder.
  4. Copy the 3 dll files into your dev suite’s “%oracle_home%/bin”
  5. Start OC4J and Login to PITSS.CON

The Issue:

The issue was that PITSS.CON added the following code:

rp2rro.rp2rro_Add_parameter(PL_ID,’USERID’, TEXT_PARAMETER,get_application_property(username) /get_application_property(password) ||   db_connect_string);

The customer did not know why this was added, so they removed this. After that, when the developer boxes tried to run reports, they were prompted for a login every time. The above is required so that a cookie can be passed in between reports and IE, of which lets the report be run without re-authenticating the user.

If you are using your Forms application and your application crashes anytime you are clicking a button or doing an operation involving an ALERT, sending a MESSAGE, or clicking SUBMIT, you may be encountering an Oracle bug. In order to fix this bug, you will need to apply Oracle Patch (OPatch) 12433970 to fix the problem.
Steps to fix bug:
1. Download patch 12433970 from My Oracle Support. NOTE: Four patches will appear. Download the one involving your version of Oracle Forms whether it is 10g, 11.1.1.3, 11.1.1.4, or 11.1.2 (11gR2).
2. Extract the patch in a directory on your PC/server.
3. Shut down your WebLogic servers and OPMNCTL.
4. Open up command prompt (or your SSH terminal) and navigate to where you extracted the patch.
5. Inside the command prompt, set ORACLE_HOME to %MIDDLEWARE_HOME%\as_1 (Example: set ORACLE_HOME=C:\Oracle\Middleware\as_1) (in Unix, use: export ORACLE_HOME=$MIDDLEWARE_HOME/as_1)
6. Inside the command prompt, set PATH=%PATH%;%MW_HOME%\oracle_common\OPatch (in Unix, use: export PATH=$PATH:$MW_HOME/oracle_common/OPatch)
7. Run “opatch apply 12433970”. Press the ‘y’ key when asked if the system is ready for patching.
8. Start your WebLogic servers and OPMNCTL.
Forms should no longer freeze when using ALERT, MESSAGE, or SUBMIT.

 

NOTE: For 11gR1 Forms Installations (11.1.1.2, 11.1.1.3, 11.1.1.4), installing Forms Patchset 11.1.1.6 and 11.1.1.7 will resolve the issue as well.

NOTE: For 11gR2 Forms Installations (11.1.2.0), installing Forms Patchset 11.1.2.1 will resolve the issue as well.

Source: Oracle Support note 1171063.1

In Linux installations of PITSS.CON, there have been reports when developers have tried to load forms, menus, or libraries into PITSS.CON, they encounter the following error:
“Can not open context – Operation Failed!”

Can not open context Forms Load Error

In order to overcome the context error, you will need to make sure that:

  • VNC Server is running in the server. Most RHEL (Red Hat Enterprise Linux) and OEL (Oracle Enterprise Linux) operating systems come with VNC Server which provide access to a GUI. Run the command “vncserver” and it will be listening on a certain address (example: hostname/IP_address:1).
  • In all .env files associated with PITSS.CON, make sure the DISPLAY variable is set to the same value set in vncserver (see step above for more information). Example: export DISPLAY=hostname:1.0
  • LD_LIBRARY_PATH and LD_PRELOAD are set in the PITSS.CON related .env files.
  • NLS_LANG is not set in any of the PITSS.CON related .env files.

After applying any of the options above, restart your browser, log back into PITSS.CON, and you should be able to load modules using Module Handling.

NOTE: New installations of PITSS.CON are not recommended in Linux. PITSS.CON should be installed in a Windows environment.

Troy, Michigan. January 9, 2012 – PITSS, the Global Leader in Oracle Forms and Reports Modernization will begin the new year with the unveiling of it’s redesigned website to emphasize on enhanced Software and Solution offerings.

PITSS continued to improve its Software & Services to Upgrade, Migrate and Analyze legacy Oracle Forms and Reports applications. The PITSS.CON software upgrades any size of application to the latest Oracle Forms version on average in only 3-4 days. PITSS.CON also accelerates the Migration of Forms to ADF (Oracle’s Application Development Framework), Forms to APEX or Forms to Java by providing a tool guided Re-Engineering process to optimize and adapt new software architectures.

As Oracle has just released the new Forms 11g Release 2 including several new features and platform certifications (e.g. 64bit Windows support), PITSS addresses these new enhancements with the new PITSS.CON Release. These new functional enhancements are accompanied by new Fusion Middleware Infrastructure Services/Solutions to provide a one-stop consulting experience for our customers. Please visit the new website for more details.

Martin Disterheft, President of PITSS America says “…the new website enables the company to more effectively communicate and share the growing product and service offerings. The redesigned, more interactive website and a greater emphasis on social media will play an essential role in this years expansion plans for PITSS America. The new site structure for example enables PITSS America to provide its offerings in different languages to support the growing business opportunities to South America …”.

About Pitss America

PITSS America LLC, based in Troy, Michigan, is the leading software supplier to modernize Oracle Forms and Reports applications. The company deploys its innovative Oracle development tool PITSS.CON to help its customers analyze, upgrade (to Forms 11g), migrate (to ADF, APEX…) and maintain their Oracle Forms and Reports applications. As a company, PITSS is an Oracle Gold Partner. Visit us at http://www.pitss.com.

PITSS America’s Oracle Development Platform Tool Earns
High Marks for Automation and Performance

Troy, Michigan. July 14, 2009—PITSS America, an Oracle Forms and Reports specialist
firm, is saving companies years of man hours with their leading flagship product
PITSS.converter. The tool assists with lifecycle management for legacy Oracle Forms
 and Reports Applications.

If a business is not currently using 10g Release 2 of Oracle Forms and Reports, they are
running on unsupported technology. Unsupported software means they are not getting
the support from Oracle as well as the critical security patches required for many
businesses and governmental entities. In addition older Forms and Reports versions are
not “certified” to work with the latest Database Releases.

On the market for more than 10 years, PITSS.converter has a proven track record with
Oracle Forms and Reports customers. PITSS.converter uses a comprehensive set of
functions to perform cost effective and efficient changes on custom Oracle Forms and
Reports applications and automates the upgrade/migration process up to 100% –
reducing time to benefit to an absolute minimum. The unique PITSS.converter repository
provides an ideal platform to re-engineer Oracle Forms and Report applications to meet
the requirements of today’s state of the art software applications architectures.

According to PITSS America President Martin Disterheft, “At first our customers can’t
believe that we can help them so quickly. A job that could take years of man hours to
upgrade can be done in 5 days. What’s more, by upgrading their applications we can
eliminate any security vulnerabilities to their business.”

“In our case, the PITSS technology saved us significant time and money for our
migration from Oracle Forms 6i to 10g. The whole conversion took only about three days
versus the eight months we had estimated to do a manual migration. If you’re an Oracle
shop, PITSS is definitely the way to go.”
Shri Potdar, Director of Technology Mediware Information Systems

About PITSS AMERICA:
PITSS America LLC, based in Troy, Michigan, is a leading supplier of complete solutions
for managing Oracle Forms and Report applications. The company deploys its
innovative PITSS converter software to help customers analyze, migrate, and maintain
their Oracle Forms applications. PITSS is an Oracle Certified Advantage Partner and
has made its name internationally through successful modernization projects of legacy
Oracle Forms and Report applications. For more information or to speak with sales a
professional call 1-248-740-0935 or visit www.pitssamerica.com.