Home » Developer & Programmer » Forms » frm-41214: unable to run report
frm-41214: unable to run report [message #271755] Tue, 02 October 2007 15:52 Go to next message
scorpiouno
Messages: 6
Registered: October 2007
Location: Sparta
Junior Member
i know that there are other threads that discuss this topic in quite some detail but i feel that the problem i am having is quite different from those. please read on and see if you can provide a solution.

when i test the form on the client(windows OS), which calls on reports according to parameters provided (there is a local reports server running) the form works fine and everything is as it should be.

however, when i move the fmb files to unix and run them from the fmx files generated after compilation, i can enter all the parameters and when i press the button that calls on the procedure to run the report specified in the parameters, it gives this error. i have tried looking at the code to see if there is any data type mismatch but could not find any such problem as suggested for ora-06502. i am provding part of the code used in our forms only as the rest is confidential. please provide any assistance you can asap.

before the frm 40735 comes up, there is a popup window that gives me the error frm-41214: unable to run report. is this the actual reason for the error?

when the 'compile' button is pressed, this is the procedure called using 'when-button-pressed' trigger.
runreport(:rep_setup.rep_id, :rep_setup.group_id, :rep_setup.rep_filename);
the first 2 parameters are declared as NUMBER and the third one as VARCHAR2

the data types for those three parameters from the property palette in forms builder are number, number and char in the respective order.

if it helps, the popup message that i get immediately on pressing the button is "frm-41214:unable to run report".

why is this error only when run in unix?

if you have more questions for me to help solve this, plz let me know.

[Updated on: Wed, 03 October 2007 13:32]

Report message to a moderator

Re: frm-40735: when-button-pressed trigger raised unhandled exception ora-06502 [message #271821 is a reply to message #271755] Wed, 03 October 2007 01:27 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you run the report connected to the same database, or did you use one while running it from Windows and another one while being on UNIX?

Did you use the same parameter values in both cases? ORA-06502 might mean that you, for example, tried to use ":rep_setup.rep_id = 1234" while report declares it as NUMBER(3).
Re: frm-40735: when-button-pressed trigger raised unhandled exception ora-06502 [message #271952 is a reply to message #271821] Wed, 03 October 2007 08:06 Go to previous messageGo to next message
scorpiouno
Messages: 6
Registered: October 2007
Location: Sparta
Junior Member
the number size hasnt been mentioned in the declaration of the number variable. so the size of that should not be an issue. i will check and see if the database being connected to is the same when run in windows and unix and get back on that. in the meanwhile, can you please explain how that will affect the performance of the report in case the databases being connected to are different?
Re: frm-40735: when-button-pressed trigger raised unhandled exception ora-06502 [message #271990 is a reply to message #271952] Wed, 03 October 2007 10:30 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In the meanwhile, I'll try to explain what I meant: there might be a report trigger (AFTER PARAMETER FORM, for example) which does some computing and raises an error because data affected isn't the same in those two databases.
Re: frm-40735: when-button-pressed trigger raised unhandled exception ora-06502 [message #272004 is a reply to message #271990] Wed, 03 October 2007 11:10 Go to previous messageGo to next message
scorpiouno
Messages: 6
Registered: October 2007
Location: Sparta
Junior Member
ok. well i just checked and both connect to the same database.

now, since the variables are decalred simply as "number" and not like "number(5)", can that affect the way the variables are passed in unix? can that be the reason for the error?

any other ideas?
Re: frm-41214 and frm-40735: when-button-pressed trigger raised unhandled exception ora-06502 [message #272033 is a reply to message #271755] Wed, 03 October 2007 13:07 Go to previous messageGo to next message
scorpiouno
Messages: 6
Registered: October 2007
Location: Sparta
Junior Member
before the frm 40735 comes up, there is a popup window that gives me the error frm-41214: unable to run report. is this the actual reason for the error? please help solve this.
Re: frm-41214 and frm-40735: when-button-pressed trigger raised unhandled exception ora-06502 [message #272438 is a reply to message #272033] Fri, 05 October 2007 01:09 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What version of Forms and Reports are you running? Is this the first report you have run? You say you recompile/regenerate the form on the server? Did you recompile/regenerate the report? Please post the code calling the report and use 'code' tags.

Davdi
Previous Topic: How to make .FMX form VISIBLE to Runtime Enviroment
Next Topic: count the number of column
Goto Forum:
  


Current Time: Fri Dec 09 23:31:54 CST 2016

Total time taken to generate the page: 0.09625 seconds