OraFAQ Forum: Reports & Discoverer » Upgrading Oracle8i to Oracle Database 10g Enterprise Edition

Home » Developer & Programmer » Reports & Discoverer » Upgrading Oracle8i to Oracle Database 10g Enterprise Edition (Oracle Database 10g Enterprise Edition, Oracle8i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656397]

Wed, 05 October 2016 04:55

Salehin
Messages: 63
Registered: March 2013
Location: Chittagong, Bangladesh

Member

Hello everybody, Smile

I am trying to upgrade my database version from Oracle8i to Oracle Database 10g Enterprise Edition. All of my other reports are running except Monthly_Attendance_with_OT2 report. Can anybody find out why my this report is not running? I upload my rdf file.

here is my previous and current version of oracle

Previous version

Code: [Select all] [Show/ hide]

SQL*Plus: Release 8.0.6.0.0 - Production on Wed Oct 5 15:39:26 2016

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to:
Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option

Current version

Code: [Select all] [Show/ hide]

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Oct 5 15:40:55 2016

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

Thnak's in advance. Cool

Attachment: Monthly_Attendance_with_OT2.Buy_Work.RDF
(Size: 184.00KB, Downloaded 2183 times)

Report message to a moderator

Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656417 is a reply to message #656397]

Wed, 05 October 2016 10:24

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

Are you getting an error message?

And why are you upgrading from an incredibly out of date version to a seriously out of date version?

I wouldn't bother upgrading to anything less than 11.2 at this point.

Report message to a moderator

Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656419 is a reply to message #656397]

Wed, 05 October 2016 10:35

John Watson
Messages: 8977
Registered: January 2010
Location: Global Village

Senior Member

Your licensing situation also looks odd: 8i personal edition to 10g enterprise edition?

Report message to a moderator

Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656436 is a reply to message #656419]

Wed, 05 October 2016 21:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

John Watson wrote on Wed, 05 October 2016 08:35

Your licensing situation also looks odd: 8i personal edition to 10g enterprise edition?

You assume facts that are not supported by any evidence; that OP is has any Oracle license.

It is a head scratcher why anyone would upgrade from one obsolete & unsupported Oracle version to another obsolete & unsupported version.

Report message to a moderator

Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656443 is a reply to message #656397]

Thu, 06 October 2016 01:19

Salehin
Messages: 63
Registered: March 2013
Location: Chittagong, Bangladesh

Member

I found this error.

Attachment: orafaq.JPG
(Size: 97.30KB, Downloaded 2930 times)

Report message to a moderator

Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656446 is a reply to message #656443]

Thu, 06 October 2016 03:19

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

What happens if you do compile all in the report?

Report message to a moderator

Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656447 is a reply to message #656446]

Thu, 06 October 2016 03:28

Salehin
Messages: 63
Registered: March 2013
Location: Chittagong, Bangladesh

Member

When I compile it, again says to compile.

Report message to a moderator

Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656455 is a reply to message #656447]

Thu, 06 October 2016 05:00

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm not sure you understood what CM said; I believe he meant to say that you should compile all, i.e. <CTRL + SHIFT + K>. So, did you do that?

Report message to a moderator

Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656501 is a reply to message #656455]

Fri, 07 October 2016 23:57

Salehin
Messages: 63
Registered: March 2013
Location: Chittagong, Bangladesh

Member

Yeh I tried compile all i.e. <CTRL + SHIFT + K> same result.

Report message to a moderator

Re: Upgrading Oracle8i to Oracle Database 10g Enterprise Edition [message #656526 is a reply to message #656501]

Mon, 10 October 2016 03:49

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

Sounds like a bug, you may be best off just recreating the report from scratch with 10g report builder.

Report message to a moderator

Previous Topic:	Separate queries in one report with page filter
Next Topic:	Excel file generation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 21 07:40:31 CDT 2025