Please help Reports Team: Oracle 9i Reports - Reports

Reports Team:
I tried to use Excel as a datasoruce to run a report, but I got an error "ERR 62007: SQL-error: S1C00 [Microsoft] [ODBC Excel Driver] Optional feature not implemented.
According to Tech Support, I need to apply Reprots 9i Patch 1 to fix this problem.
However, I couldn't find the patch under the Metalink Patches. Could the Reports Team point me to the right direction? I am using Oracle9iDS R2. Thanks.

Hello,
Please download Patch Request 2030678 from ARU site.
With Regards
Reports Team

Related

Oracle Designer - How can I generate a report ?

Hi !
I'm new user of Oracle Designer and did reverse engineering of an existing database.
Is this application support report generation ?
I would like to generate a data dictionary with all the Oracle object with their description and special annotations.
Is there a simple way to do it ?
Thanks for any tips. 
Hi,
Designer has inbuilt reporting capability. The 'Repository reports' tool has a lot of reports that display data about the entities, tables, pl/sql objects etc contained in the repository.
Regards
Praveen 
Thanks..I found the repository reports, but now I tried generate one of them and I got this error:
CDI-21300: Executable file not found.
I got this error for all the reports.
Did you encountered this kind of problem ? Do I need to install additional tools ?
Thanks. 
Hi,
I haven't encountered the error. The most probable cause could be that Oracle reports is not installed. The repository reports are basically 'Oracle Reports' objects. Inorder to be able to run the report you need Oracle reports to be installed. It is part of Oracle iDS.
Regards
Praveen 
Hi,
My problem is the same, but I am experienced user in designer.
I use the Designer 9i.
The Repository Reports doesn't run.
Still I can open the main screen, every report that I try to execute I get the error "CDI-21300 - Executable File Not Found".
I try to deinstall the Designer and re-install it from my CDs (version 9.0.2.0.1) and aply the patch downloaded from Oracle site (version 9.0.2.10)...
...but the problem persists
Anybody, any idea ?
Thanks in advance.
Carlos 
Hi again !
I realize that I can trace internal commands in "options", "diagnostics".
After invoke the report again, the content of the log was:
================================================
ckrpt61 File 'ckrptutl.cpp' at line:895 -TRACE-c:\orades9i\BIN\RWRUN.EXE errfile='\designer.log.err' BLANKPAGES=NO USERID=admdados#case.world CMDFILE="C:\WINDOWS\TEMP\ckr4F.tmp"
ckrpt61 File 'ckglobal.cpp' at line:248 -TRACE-CDI-21300: Executable File Not Found
================================================
So, the problem is that the Repository Reports didn't find the RWRUN.EXE.
BUT... I have instaled the repository from the original CDs and aplied the patch downloaded from Oracle.
Where can I find this executable (RWRUN.EXE) ???
Thanks...
Carlos 
Hi
As has been said you probably need Oracle Reports installed and this is part of iDS. In any case rwrun.exe is the "ReportWriter" runtime execute - so it sounds like you need to do this.
Steve 
OK.
I run the installer again and select a FULL install (to avoid other missings).
The file RWRUN.EXE is now present and running.
I am getting another error, but this is another topic of this forum.
I think this is a installer bug. Once the Repository Reports is avaiable in Designer menu it should must work.
Well... Thank you !!!! 
How did you select full install, I can't see that option. 
I have installed Oracle Developer suite and facing the same error while clicking on run report.
The error message that pops up is : CDI-21300: Executable file not found.
Can anyone reply to this issue asap, as already i have read thread above and trued reinstalling it with the each of the two options provuided.
There is no FULL installtion option as stated in the thread.
Would apprecaite for an early reply.
Gaurav Tewari 
Hi,
I was going to post something separate, but instead have appended to this post:
Is the Oracle iDS the same thing as the Developer Suite? I am testing migrating our Designer 6.0 content to 10g. Somebody else here (who has now left!) installed Designer 10g but opted not to install the full Developer Suite.
I too am getting the CDI-21300 error and am unsure whether I should be reinstalling Designer and doing a full Developer Suite install or just installing Oracle Reports separately?
Thanks,
Antony 
For reinstalling designer you have to first install iDS (Developer Suite) then install Designer over the same oracle home.
you could use
Oracle 10gR2
==========
iDS 10.1.2.0.2 + iDS patch 10.1.2.2 + Designer 10.1.2.3
Oracle 10g
========
iDS 9.0.4.3 + Designer 9.0.4.7 
Thanks. Are you saying that we don't have Oracle Reports installed because we didn't install the Developer Suite? Or that it's possible to install Designer and Oracle Reports without installing the full Developer Suite? 
You cannot install Oracle Reports and Designer without installing Developer suite. 
It looks like the person who installed Designer here was able to do so without installing the Developer Suite - the only thing not working in Designer 10g is the reports.
What does iDS patch 10.1.2.2 do? I can't find it on the Oracle website (I can find the iDS and Designer releases ok).
Thanks, Antony

Forms & Reports 6i Patch 11 for Windows

Hi,
my forms developer does not open the layout editor when I define a bean section. I have read that the patch fixes the problem, but I cannot find a download for this patch anywhere in the net. If anybody has this patch file or can tell me a link I would be very happy.
Thanks! 
Patches are available, with a valid support contract, only from http://metalink.oracle.com 
ok. Thanks for letting me know.

reports can not open sometimes.

we can not open our report file sometimes especially contains OLE object.
In Open report dialog we click the file name but nothing happen .
I thing file format is corrupt.
How can we solve this problem.
Thanks...
Hi,
I believe you are taking about Reports 6i version here since OLE support is deprecated in 9i Reports. Please note that this feature is only for Windows platform. One or two issues were resolved in latest version of 6i Reports patch. Please try with ont of the latest pathces.
Thanks,
Rohit

Patch for Oracle Reports

I have a problem with developer/2000 6.0
When i preview a character report and then try to print the report server crashes and all the application hangs. I downloaded a patch to solve that problem but now the file is damaged. I search all over ORACLES' website but didn't find it. PLEASE, can anyone tell me where to download it again? 
Adibis,
You can try to contact Oracle Support Services through MetaLink (logging a TAR), but typically we only have the latest patches available on MetaLink. Your only other chance is that one of our readers may have it for you to copy.
The Oracle Reports Team.

How do I find a Patch?????

I submitted a TAR about upgrading Forms 6i. I was told you want Patch 13 and it's on OTN. I searched OTN using the parameters "Oracle 8i Forms 6i Patch 13". I received a ton of hits but none of them told me where the patch is located. Or maybe I just skimmed them too fast. Any help would be most appreciated.

Categories

Resources