123
返回列表 发新帖
楼主: Harry_shan

Oracle Discoverer Desktop选择Application User登录出错,如何解决?

[复制链接]
论坛徽章:
164
技术图书徽章
日期:2018-12-26 10:01:29指数菠菜纪念章
日期:2013-06-28 17:41:29蛋疼蛋
日期:2013-04-03 16:29:52指数菠菜纪念章
日期:2013-04-01 15:26:282013年新春福章
日期:2013-02-25 14:51:24指数菠菜纪念章
日期:2013-01-04 11:30:40指数菠菜纪念章
日期:2012-09-29 10:28:42版主6段
日期:2012-05-15 15:24:11指数菠菜纪念章
日期:2012-03-31 14:04:28茶鸡蛋
日期:2012-03-12 16:56:15
21#
 楼主| 发表于 2007-8-27 17:19 | 只看该作者
最初由 chirsdong 发布
[B]这个是要打个补丁的,至于JAVA认证方面到真没考虑过。。学习一下。 [/B]


打什么补丁?

使用道具 举报

回复
论坛徽章:
0
22#
发表于 2007-9-21 15:13 | 只看该作者
能否告知最后如何解决的?等待中。

使用道具 举报

回复
论坛徽章:
1
授权会员
日期:2007-07-02 14:00:51
23#
发表于 2007-9-27 19:10 | 只看该作者
最初由 Benin 发布
[B]1、        root/test
2、        su – appldemo
3、        cd /erpp/appldemo/demoappl/admin
4、        vi demo_erptest.xml
/SEC
找到SECURE修改为OFF,cd $COMMON_TOP/admin/scripts/

5、        cd $COMMON_TOP/admin/scripts/
6、        ./adautocfg.sh
7、        OK [/B]


这就是解决办法

使用道具 举报

回复
论坛徽章:
2
2009新春纪念徽章
日期:2009-01-04 14:52:28Jeep
日期:2013-12-27 22:48:52
24#
发表于 2007-10-20 15:44 | 只看该作者
有个补丁,可以去下metalink搜索一下.把补丁(如附件)放置到安装discoverer的目录下覆盖掉文件FNDPU115.DLL。不知道大家说的是这个补丁吗?

fndpu115.rar

145.55 KB, 下载次数: 77

使用道具 举报

回复
论坛徽章:
2
ITPUB新首页上线纪念徽章
日期:2007-10-20 08:38:44授权会员
日期:2007-11-01 10:46:50
25#
发表于 2007-10-22 14:04 | 只看该作者
补丁为 : PATCH 4148

使用道具 举报

回复
论坛徽章:
2
ITPUB新首页上线纪念徽章
日期:2007-10-20 08:38:44授权会员
日期:2007-11-01 10:46:50
26#
发表于 2007-10-22 14:07 | 只看该作者
README: (不能上传附件。呵呵)
Oracle Discoverer Administration Edition and
Oracle Discoverer Desktop Edition
Release 4.1.48.06 Production Patch  
for Microsoft Windows 95/98/2000/NT Release Notes

Oracle DiscovererTM
(c) Copyright Oracle Corporation, 2003
November 24, 2003
Release 4.1.48.06 Production Patch

This document provides various installation and late-breaking product information for Oracle Discoverer Administration Edition and Oracle Discoverer Desktop Edition for Windows 95/98/2000/NT. This patch can be applied to Discoverer Administration Edition or Desktop Edition 4.1.37, which is shipped with Oracle9i Developer Suite 1.0.2.4, or higher versions.

Important
If applied to a release prior to 4.1.46, note that this patch version of Discoverer Administration Edition will perform an End User Layer upgrade. As a result, the version of Discoverer Desktop Edition shipped with this patch will only be able to connect to End User Layers that have been either upgraded or created with Discoverer Administrator 4.1.46 or higher. The corresponding 4.1.46 or higher patch versions of Oracle9iAS Discoverer Plus and Oracle9iAS Discoverer Viewer will only be able to connect to an End User Layer that has been either upgraded or created with version 4.1.46 or higher of Discoverer Administration Edition.

Optional

Create a back-up copy of the [ORACLE HOME]directory and all subdirectories.  You may later revert to the pre-patch installation by restoring the back-up copy.  The entire [ORACLE HOME] directory should be backed-up/restored - this ensures that updates to shared libraries (such as RSF files) and Oracle Installer inventory files are also reverted to their previous state.

This document is divided into two sections:
- the first section contains updated release notes for the Discoverer Administration Edition
- the second section contains updated release notes for the Discoverer Desktop Edition





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

Contents - Discoverer Administration Edition

1   Required version of Oracle9i Application Server for compatibility
2   End User Layer upgrade
3.  Documentation updates
4.  Useful information
4.1   Upgrade, migration, and maintenance
4.2   Performance and scalability
4.3   Translation and multi-lingual support
4.4   Oracle Applications mode
4.5   Third party products and certifications
4.6   Miscellaneous
5   Known issues and workarounds
5.1   Upgrade, migration, and maintenance
5.2   Performance and scalability
5.3   Translation and multi-lingual support
5.4   Oracle Applications mode
5.5   Third party products and certifications
5.6   Miscellaneous
6   Issues fixed in this release (4.1.48)
7   Issues fixed in previous releases

1. Required version of Oracle9i Application Server for compatibility

The required version of Oracle9i Application Server for compatibility with this release is 1.0.2.2.

2. End User Layer upgrade

When applied to an EUL created with Discoverer Administration Edition versions 3.1, or any versions prior to 4.1.46, this version performs an upgrade to the End User Layer (EUL). When using Discoverer Administration Edition to connect to an existing EUL as the EUL owner, Discoverer will automatically detect whether an EUL upgrade is required. If an upgrade is required, you will be prompted to make a backup of the EUL tables. Upon confirmation that the backup has been made, the EUL upgrade is performed.

If applied to an End User Layer created with Discoverer Administration Edition versions prior to 4.1.44, after the End User Layer has been upgraded, it will not be possible to connect to the upgraded EUL using Discoverer Desktop Edition, Discoverer 4i Plus or Discoverer 4 i Viewer with a version prior to 4.1.44. Also, the versions of the end user products supplied with this patch cannot connect to EULs that have either not yet been upgraded or have been created with a version of Discoverer Administration Edition prior to 4.1.46.

If applied to an End User Layer created with Discoverer Administration Edition version 4.1.46, after the End User Layer has been upgraded, Discoverer Desktop Edition, Discoverer 4i Plus and Discoverer 4 i Viewer version 4.1.46 may still connect to the upgraded EUL.

NOTE:  Upgrade/import/export of an EUL created using a third-party product, such as Noetix Views, is not supported.  If problems are encountered with an EUL generated by a third-party product, contact the third-party vendor for support.

6. Issues fixed in this release (4.1.48.06 Production Patch)

3216523 ESM: CONDITION ON DATE DD-MON-RRRR HH24:MI:SS FAILS 'INVALID FORMULA OR FILTER'
3183271 PAGE ITEM VALUE 'ALL' FOR SCHEDULED CROSSTAB LAYOUT LEAVES MANY COLUMNS BLANKS
3180021 BACKPORT BUG 2651968 - INCORRECT RESULTS (DOUBLE) IN FAN TRAP CONDITION
3156237 OUTLINE WORKBOOK COMES BACK WITH STRANGE CALCULATION FOR DECODE FUNC.
3116082 OPENING SCHEDULED WB ERR: "..SCHEDULED WORKBOOK CAN NO LONGER BE USED.."
3066868 ORA-918 RUNNING A QUERY
3053599 COUNT TOTAL IN CROSSTAB GIVE INCORRECT RESULTS FOR GRAND TOTAL AT BOTTOM
3031287 TITLE VARIABLES(DATE, TIME, FILE, SHEET) ARE CASE SENSITIVE IN 4.1.XX
3019636 OPENING WORKBOOK IN VIEWER GIVES HTTP 500
2970786 TAKES ~ 5 MIN FOR SHARING DIALOG TO COME UP WHEN >180K ROWS IN EUL4_ACCESS_PRIVS
2956485 DESKTOP: INCORRECT JOIN NAME IN THE ERROR MSG EDITING A SHEET
2952263 BACKPORT: PLS BACKPORT BUG FIX 2900642 TO 4.1.46 RELEASE
2943025 CALCULATION AGGREGATED IN PLUS AND NOT AGGREGATED IN DESKTOP
2884118 PRINTING LARGE GRAPH CAUSES DISCOVERER DESKTOP TO HANG
2882075 MISSING TOTAL IN DESKTOP
2874025 ORA-936, INVALID SQL GENERATED WHEN 'HIDE DUPLICATE ROWS' CHECKED
2848587 PRINT AND PRINT PREVIEW PRINTS/DISPLAYS GREY PAGE AFTER CHANGE GRAPH YAXIS SCALE
2830291 UNABLE TO USE REPOSITORY FOR SCHEDULING WORKBOOKS IN DISCOVERER 4.1.44
2702218 WORKSHEET WITH ALTERNATE SORT DOES NOT GET REDIRECTED TO EXTERNAL SUMMARY TABLE
2702068 CANNOT OVERWRITE LOCAL WORKBOOK IN DISCOVERER DESKTOP EDITION.
2614088 ESM:WRONG DATA IS POPULATED IN "ITEM DEPENDANCY" ITEM "EUL DATA DEFINITION" WKBK
2371331 TO EXCEED 32K LIMIT OF SQL QUERY WHEN SCHEDULING APPS WB IN OTHER SCHEMA
2259368 NLS: DEFAULT GERMAN CURRENCY IS DM, SHOULD BE EURO

7. Issues fixed in previous releases

Issues fixed in 4.1.47

2884094 worksheet does not open in plus/viewer
2882075 missing total in desktop
2807128 dis4sch.exe generates errors when upgrading 3.1 scheduled workbooks
2697279 totals disappear after the workbook saved and opened back
2696912 import sql doesn't work in (apps mode eul) discoverer desktop edition.
2694031 query with calculation using analytic clause in condition returns ora-30563
2669038 worksheet with more than 256 column crashes excel97 on exporting to excel
2449043 one or more exceptions have overlapping ranges error does not occur in between
2314004 eul data definition workbook fails for eul4_get_analyzed function

Issues fixed in 4.1.46

955735  unable to create calculation with embedded nvl function in discoverer
1888341 behavior of query prediction has been changed from discoverer 3.1.x  to 4.1.x
2110550 apps: connect to apps 11i databases  may fail if server security level is secure
2329553 copy doesn't work at sql inspector immediately after starting
2373438 sec: db users can update the eul tables via sql plus
2579593 unable to connect with a role with an apostrophe. getting no access to eul
2602858 when export to excel, vertical axis label not change

Issues fixed in 4.1.45

2377947 performance: open workbook using user defined function can hit db too much
1055681 problem when drilling on quarters

Issues fixed in 4.1.44

2432133 share operation failed on sharing the workbook to responsibility

Issues fixed in 4.1.43

No new bug fixes.  (Internal development bugs which are not visible to the end-user were fixed in this release.)

Issues fixed in 4.1.42

820093  export to excel: export file is getting bigger each time you perform the export
1959994 pls backport bug 1500862 to discoverer 4.1
1985081 gpf dis4usr.exe using sort function
1994414 application error when drilling in crosstab report on dual processor win2000
2095543 nls: &parameter_name does not work if param_name contains greek characters
2111946 "retrieve all rows" returns blank page
2117402 outer join on master table not included in query
2154510 error " insufficient privilege for attempted operation - user edition "
2154828 blob with parameters doesn´t open directly
2174154 drill down/collapse cause wrong values in worksheet user defined item
2199179 apps responsibilities are always appearing in american locale

Issues fixed in 4.1.41

1973021 drill in crosstab with the option style outline gives wrong results
2000407 the display turn of conditions changes.
2004503 get crash when enter null as parameter value
2015782 changing the heading of data point
2054502 incorrect workbook shared when workbook has similar name with - instead of _

Issues fixed in 4.1.40.02c

1816837 apps: need to update apps 11i dll due to security patch bug #1779336

Issues fixed in 4.1.40.02

880428  cannot limit query rows returned in admin when using a role
1387378 receiving ora-936 when opening a scheduled workbook
1518227 csv export from discoverer (opening in excel) yields garbage characters
1756661 empty column with non-empty total in crosstab
1842963 fix  for bug 1586829 needs to be applied to windows version
1858761 a column has duplicated values when you retrive next group of data or refresh
1943528 dr watson error received when using a parameter which uses a decode in condition

Issues fixed in 4.1.38

1154898  Open scheduled wkbk with nested calc gives "query has changed" error
1550073  Failed to open scheduled workbook
1662557  Opening worksheet with subquery fails with ora-00933 (sql not properly ended)
1664958  Strange behavior with count and count distinct
1675115  User cannot run query on 8.1.7 database without select access on v$parameter
1727123  Fantrap query fails - not all the items transferred across to rewritten query

Issues fixed in 4.1.37

No new bug fixes.  (Internal development bugs which are not visible to the end-user were fixed in this release.)

Issues fixed in 4.1.36

664469   Totals:display totals for a subset of columns on one line in crosstabs
1395507  Target path in short-cut tab on user icon will not launched shared workbook in Apps mode
1488343  Unable to remove axis item from sheet
1559405  Nls bidi : condition with hebrew values is not saved with the workbook
1651449  Extracting workbook sql seems to work but isn't saved correctly
1664945  Share workbooks user list takes long time and cannot display more than 32k users
1700388  Percent of grand figure is wrong and changes after page item pivot

Issues fixed in 4.1.33f

856891   Error when running qstats31.dis after creating summary tables
1371136  NLS: Description format none and standard is not translated correctly in German
1395284  Numeric overflow error with qstats31.dis

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 未成年人举报专区 
京ICP备16024965号-8  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表