[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1853
  • Last Modified:

Forms compilation Errors under Linux

Hello,

I have a main form called Tbdoctrk.fmb.
This forms compiles and runs perfectly through Oracle 9i iDS.

When transfering the fmb file under Linux, and attempting to recompile using the f90genm.sh utility, I get the following compilation errors:

FRM-18108: Failed to load the following objects.

....
....
FRM-30436: Parent window not specified for canvas.View Canvas H_TOOLBAR
FRM-30041: Position of item places it off of canvas.
Item: BUTTON_HELP
Block: VARIABLE
Form: TBDOCTRK

FRM: Unable to adjust form for output.
====

I noticed that most of the object that failed to load (1 data block object, 1 canvas and a number of property classes and visual attributes) are contained in a file called TOOLBAR.fmb.

The TOOLBAR.fmb file compiles without errors under Linux/WIndows + is located in the same folder as the Tbdoctrk.fmb file.

1) How can I resolve this issue ?

PT

PS: I tried renaming the fmb files to upper/lower case without success.
0
ptreves
Asked:
ptreves
  • 8
  • 6
  • 3
1 Solution
 
Helena Markováprogrammer-analystCommented:
It seems to me that it is a problem with subclassing. Aren't the objects in TOOLBAR.fmb subclassed from an object library, too ? Maybe this library is missing in Linux.
Also there can be problems with max number of files which can be opened.
0
 
makhanCommented:
I think ur screen resolution might be a problem.

Check out that u have same density at both the platforms
ie. 800x600 or 1024x768

Also the font's differnece may also be an issue.

Regards


0
 
ptrevesAuthor Commented:
Hello,

Thanks for your feedback.............
Under the Linux Server Application Control, I can adjust the width/height of my screen. 1) Wil this do the trick ?

2) How can I find out what my screen density settings are on a Linux Enterprise 3 (ES) server running Forms/Reports Services 10g ?
3) How can I find out what my font settings are on a Linux Enterprise 3 (ES) server running Forms/Reports Services 10g ?


PT
 
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
ptrevesAuthor Commented:
Hello,

My main form Tbdoctrk.fmb calls the Pre-bord.fmb and in turn calls upto 4 different Reports. I noticed that the missing objects at compile time are contained in a TOOLBAR.fmb file, but I don't know how the link is made between the main form called Tbdoctrk and the TOOLBAR.fmb file.

On iDS Windows XP Pro, under Forms Builder, Tbdoctrk.fmb, compiles fine without errors. Under Linux iAS, I get the compilation errors mentionned.

1) How can I check my Object reference files ?
2) How can I go about resolving this issue ?

PT
0
 
Helena Markováprogrammer-analystCommented:
1) You can see Subclass Information property in a property palette.
Also check an Object groups in a developer navigator. Here is a description of it:
An object group is a container for a group of objects. You define an object group when you want to package related objects so you can copy or subclass them in another module.
Object groups provide a way to bundle objects into higher-level building blocks that can be used in other parts of an application and in subsequent development projects.
For example, you might build an appointment scheduler in a form and then decide to make it available from other forms in your applications. The scheduler would probably be built from several types of objects, including a window and canvas, blocks, and items that display dates and appointments, and triggers that contain the logic for scheduling and other functionality. If you packaged these objects into an object group, you could then copy them to any number of other forms in one simple operation.

You can create object groups in form and menu modules. Once you create an object group, you can add and remove objects to it as desired.
0
 
ptrevesAuthor Commented:
Hello,

The big puzzle is that the Tbdoctrk form compiles without errors on iDS Windows, but not on iAS Linux ???

PT
0
 
ptrevesAuthor Commented:
Hello,

Could this have anything to do with the setting of the LD_LIBRARY_PATH environment variable under Linux ?

PT
0
 
ptrevesAuthor Commented:
Hello again,

Looking at the Tbdoctrk.fmb, Pre_bord.fmb and the Toolbar.fmb file, none of them contain OBJECT_GROUPS and/or LIBRARY_GROUPS. The Tbdoctrk.fmb calls the Pre_bord.fmb form through a Program Unit, as such:

-----
      CALL_FORM('H:\TEMP\Pre_bord_test',HIDE,NO_REPLACE, NO_QUERY_ONLY,pl_id);
-----

In either of the Tbdoctrk and the Pre_bord Forms do  I find a reference to the TOOLBAR.fmb file.

Any suggestions ?

PT
0
 
ptrevesAuthor Commented:
Hello,

Should I set environment variables from Forms/Reports Services 10g in my initial .bash_profile file.
I realise that when I try to compile for the first time the environment variables FORMS90_PATH are not set .

Any suggestions ...

PT

0
 
Helena Markováprogrammer-analystCommented:
I would set all environment variables in Linux, too (LD_LIBRARY_PATH etc.).
I think that this is problem - it is hardcoded path ! -
CALL_FORM('H:\TEMP\Pre_bord_test',HIDE,NO_REPLACE, NO_QUERY_ONLY,pl_id);

it ought to look like this:
CALL_FORM('Pre_bord_test',HIDE,NO_REPLACE, NO_QUERY_ONLY,pl_id);
0
 
ptrevesAuthor Commented:
Hello,

Running more test under Forms/Reports Services 10g, I noticed that only one Parameter Form Field appears over the web (ie, on a Web Browser) client window.

The parameter form field / BoilerPlate called PF_SURVEYOR / P_SURVEYOR, is of type Number and length 10. It has tbe 'Restrict ...' check box checked + it gets its values from a select query :

select surveynumber, surveyor
from surveyor;

1) Why is only this Parameter Form Field Appearing through the Web ?

I tried increasing the Web Cache through the Application Server Control interface, but that did not change anything.

PT

PS: Maybe I should look at the Web Settings (Contains HTML Tags / Additional Attributes (HTML)) under the Report Builder Property paletter ??

PS2: The same Parameter Form appears normally under Oracle 9i iDS under Windows XP Pro.
0
 
Helena Markováprogrammer-analystCommented:
1) it must be some configuration problem on Application Server
If it is working on Oracle 9i iDS on Windows XP Pro then the problem seems to be specific for 10g or Linux. I think that it would be better to ask Oracle Support for help.
0
 
makhanCommented:
Hi!
** Suggestion **

Can u check with the values hardcoded in your field.

It may be that the select clause would throw an error bec. of table not available or 0 rows fetched.
 
select surveynumber, surveyor
from surveyor;
0
 
Helena Markováprogrammer-analystCommented:
bug 3831282:XML REPORT HANGS IN 10GAS ON UNIX

Problem description:
-------------------

A report is saved in xml format with extension xml.

A reports server is configured with jvmOptions as follows:

./rwserver.sh server=test2 jvmOptions="-server -Xms512m -Xmx512m -Xss128k"&


Running this report on 10gAS on Linux, it hangs..

There is no problem on MS Windows, only on Linux and Solaris (and other UNIX most likely).

There is no problem in 9iAS or 9iDS.

There is no problem in 10gDS.

The problem only occurs in 10gAS.

On Linux, the report hangs / no response.

On Solaris, rwEng-0 crashes.

Opening the report in the builder and saving it in rdf format, the problem is gone..

Keywords:
--------

XML

hang

crash

jvmOptions

Testcase location:
-----------------

dept.xml

Testcase step-by-step instructions:
----------------------------------

Configure a reports server with jvmOptions as follows:

./rwserver.sh server=test2 jvmOptions="-server -Xms512m -Xmx512m -Xss128k"&


Run dept.xml on 10gAS on Linux against this reports server as follows:

report=dept.xml&

destype=cache&desformat=PDF&

server=test2&

userid=scott/tiger@db


The report will never finish.

Looking at the showjobs page and going into detail:

Processing: dept.xml

Job status: Opening the report. Please wait.

Please wait while your job is processed. Otherwise, you may return to the job list by clicking on the link below.

After several minutes, there will still be no reports output, but information as follows:

No Response from Application Web Server

There was no response from the application web server for the page you requested.

Please notify the site's webmaster and try your request again later.

As stated before, this problem does *not* occur when:

Using MS Windows instead of Linux/Solaris

Using 9iAS, 9iDS or 10gDS instead of 10gAS

Using a reports server without jvmOptions: ./rwserver.sh server=test1&

Using the .rdf format instead of .xml

As stated before:

On Linux, the report hangs / no response

On Solaris, rwEng-0 crashes

Generic/Port-specific findings:
----------------------------------

Did you test with the latest version?

Yes..

Rep? Platform Client Client Ver. RDBMS Ver.

---- ----------------- ------------- ----------- ----------

N MS Windows 10gAS/reports 9.0.4 base 9.0.1.5.1

N Linux RedHat 3 10gDS/reports 9.0.4 patch 1 9.0.1.5.1

Y Linux RedHat 3 10gAS/reports 9.0.4 base 9.0.1.5.1

Available workarounds:
---------------------

Use .rdf format.

Related bugs:
------------

Did you search for duplicate bugs?

Yes - found none.
0
 
makhanCommented:
I don't think the above post is relevant to the point in discussion.
0
 
Helena Markováprogrammer-analystCommented:
Yes, you are right, I have posted it here by mistake.
0
 
ptrevesAuthor Commented:
Hello,

I was finally able to compile my form under Unix.
I reinstalled the FOrms/Reports Services 10g on my linux box with JVM 1.4.2.2 instead of the JVM 1.3.1 that I was using before.

I also copied the Tbdoctrk.fmb and the Toolbar.fmb file to the local $ORACLE_HOME/bin folder and did the compilation using ./f90genm.sh

PT
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 8
  • 6
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now