Learn Discoverer Blog: Unable to save a workbook to the database

Friday, June 02, 2006

Unable to save a workbook to the database

One of my clients recently had an issue with Discoverer 10.1.2 in that every time a user tried to save a workbook to the database they got the following error:

ORA-1483 INVALID LENGTH FOR DATE OR NUMBER

Upon further investigation it was noted that they were using 10.1.0.4 version of the database and that the database was installed onto a HP-UX(PA-RSIC) 64 bit server.

According to Oracle, there is a known bug, number 3668164, within the 10.1.0.4 database that will prevent Discoverer from being able to save to the database. SAVING A WORKBOOK USING DISCOVERER 10G GIVES - ORA-1483. I have to admit that I had not heard of this bug and so my interest was aroused. Upon further investigation it turns out that the operating system is a red herring and that this issue can arise on any operating system.

The solution is to patch the database to 10.1.0.5 or higher. Apparently there is a one-off patch for 3668164 but not if your database is running on a Windows server. In this case you will have to apply the full 10.1.0.5 database upgrade. My recommendation though is to upgrade to 10.1.0.5 anyway as many other bugs were fixed in this release.

Postscript: my client informed me that after they upgraded their database that the issue went away.

Note: bug 3668164 is not available for public viewing. This is most frustrating because Oracle have lots of cross references to it on MetaLink.

1 comment:

Srinadh Reddy Maram said...: Hello Guys,

Its nice to see your blog and the solutions u r providing to the viewers are awesome.

Here i've a small issue with Discoverer report. I can able to create parameters in Discoverer Plus but the parameters are disappearing once after done in it even though I've saved them.

Please responnd for my query which is helpful to me to complete the issue quickly.

Please write a mail to srinadh.maram@gmail.com if you have any solution with you.

Thank you.; 4:05 AM

Post a Comment

Michael Armstrong-Smith

Michael is co-owner, CIO and principal consultant of Armstrong-Smith Consulting. He is the author of the Oracle Discoverer 10g Handbook. Armstrong-Smith specialize in everything Business Intelligence, including data warehouse and curriculum design. Michael is also the founder and owner of this blog and has over 25 years experience in applications development. He has presented at many conferences and is one of the founder members of Oracle's advisory board for business intelliegence. Appointed to be an Oracle ACE in 2006, Michael has been working in the Business Intelligence arena for over 12 years. Please contact me if you would like help with your BI installtion or are planning or implementing any BI initiative.