| rep-0110:unable to open file [message #317042] |
Tue, 29 April 2008 05:14  |
orarep
Messages: 44
Registered: September 2007 |
Member |
|
|
hi
i have a form which have forms_ddl('create or replace view .....') and then i send on parameter and call the report based on these views but i am getting the following error
REP-0110 : unable to open file
REP-1070 : Error while opening and saving a document
what i did to try to solve the prob:
i check the parameter name,type and width in report builder and at form done the same and they are ok.
re-run the report but no progress.
ple4ae help regarding my prob
regards
orarep
|
|
|
| Re: rep-0110:unable to open file [message #317060 is a reply to message #317042 ] |
Tue, 29 April 2008 06:36  |
Littlefoot
Messages: 5640
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
| Oracle | REP-0110: Unable to open '<filename>'.
Cause: Oracle Reports tried to open the file shown and couldn't. The possible causes of this error include the following:
Case 1: The file was not found under the specified name in the specified location.
Case 2: You lacked the necessary privileges to open the file.
Case 3: A system error made it impossible to open the file.
Action: You can take the following actions to correct this error:
If Case 1: Make sure the file is stored in the specified directory under the specified name. If it is not, change the directory and/or filename as appropriate.
If Case 2: Make sure that you have the privileges necessary to open the file. If you don't, change your privileges accordingly.
If Case 3: Consult your operating system documentation or contact your system administrator.
|
| Oracle | REP-1070: Error while opening or saving a document.
Cause: An error occurred while opening or saving a document.
Action: Check to make sure that you have proper access privileges for the document.
|
|
|
|
| Re: rep-0110:unable to open file [message #317273 is a reply to message #317060 ] |
Wed, 30 April 2008 05:50 |
orarep
Messages: 44
Registered: September 2007 |
Member |
|
|
hello littlefoot
i have checked the following and found correct
1. name of the fille correct
2. path is correct
3. i have the privillage as i connecta s DBA
As far as system error is concerned i don't know and if it is there so how should i know? i have talked about the views i made so what you think, there might be something because of the views or what u can advice me to check back at database or somewhere esle to now about the possible system error.
thank u sir
regards
orarep
|
|
|
| Re: rep-0110:unable to open file [message #317275 is a reply to message #317273 ] |
Wed, 30 April 2008 05:58 |
Littlefoot
Messages: 5640
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
As far as I can tell, this error has nothing to do with a view creation.
What do you mean by
Which path are you, actually, talking about?
| Quote: | 3. i have the privillage as i connecta s DBA
|
It isn't about Oracle privileges, but operating system level privileges. Is you OS user allowed to write into this directory?
|
|
|
| Re: rep-0110:unable to open file [message #317443 is a reply to message #317275 ] |
Thu, 01 May 2008 06:47 |
orarep
Messages: 44
Registered: September 2007 |
Member |
|
|
hi
by path i mean the directory and file path of my .rdf file, form where it read the file, so that is correct.
secodly i have the administrator rights in win xp
is it can be due to some virus or trojan.
thanks for reply
orarep
|
|
|
| Re: rep-0110:unable to open file [message #317446 is a reply to message #317443 ] |
Thu, 01 May 2008 07:10 |
Littlefoot
Messages: 5640
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
If you are an administrator, I guess that operating system privileges are out of question.
As of correct path: are you are sure that directory which contains your reports is contained in the REPORTS_PATH? Another idea: does this path contain "space" (for example, "c:\my reports"); if so, try to rename directory so that it doesn't contain space characters ("c:\my_reports").
|
|
|
| Re: rep-0110:unable to open file [message #317449 is a reply to message #317446 ] |
Thu, 01 May 2008 07:29 |
orarep
Messages: 44
Registered: September 2007 |
Member |
|
|
sir waht is REPORTS_PATH? some path isn't it and need to be set or what.
Other thisng i have spaces in my directory name so i will remove it then come to you sir but what is REPORTS_PATH?
regards
orarep
|
|
|
| Re: rep-0110:unable to open file [message #317450 is a reply to message #317449 ] |
Thu, 01 May 2008 07:35 |
Littlefoot
Messages: 5640
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
|
REPORTS_PATH shows the way to your reports; as you use Developer Suite 6i, I believe that its name is, actually, REPORTS60_PATH. Its value can be set as environment variable or as a string value in Windows registry.
|
|
|
| Re: rep-0110:unable to open file [message #318296 is a reply to message #317450 ] |
Tue, 06 May 2008 07:22 |
orarep
Messages: 44
Registered: September 2007 |
Member |
|
|
hi sir
well i also remove spaces from the directory name (as you told me above) but still not running, i am pasting the code
pl_id := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('tmpdata');
Add_Parameter(pl_id,'EXAMINER',TEXT_PARAMETER,:ST1.EXAMINER);
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Run_Product(REPORTS, 'd:\cdept\reports\award_list\AWARD_LIST', SYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id, NULL);
and the error is
Starting report AWARD_LIST [Thu May 01 05:59:11 2008] ...
REP-0110: Unable to open file 'd:\cdept\reports\award_list\AWARD_LIST'.
REP-1070: Error while opening or saving a document.
REP-0110: Unable to open file 'd:\cdept\reports\award_list\AWARD_LIST'.
End report AWARD_LIST [Thu May 01 05:59:11 2008].
Regards
orarep
|
|
|
]
Members
Search
Help
Register
Login
Home
