The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

When upgrading a v10.0.1 database to v16 (GA release - there aren't any ebfs yet are there?) we run into this problem. The unload goes smoothly, but on the rebuild, once the data is loaded this error message comes up repeatedly. If you edit the statements out of the file - then everything goes OK.

An important point was that the reload was stopped and restarted part way through (an issue with space running low) - this turns out to be crucial - see solution. During the course of writing up this question I found the answer!

error message

asked 16 May '13, 09:10

Justin%20Willey's gravatar image

Justin Willey
6.4k101132197
accept rate: 20%

edited 16 May '13, 09:31

Mark%20Culp's gravatar image

Mark Culp
22.3k9129262

Thank you for having "displayed your unload-problem-solving-self-learning-status":)

(16 May '13, 10:35) Volker Barth

The solution was in a post on the old newsgroups of Karim Khamis's from April 2010.

sa_unload_display_table_status() is a temporary function created by the reload script after the tables have been created but before the data is loaded. Because the script was re-started the function no longer existed. As its purpose is simply to update the display, editing it out was fine as a workaround, but we'll know better another time!

permanent link

answered 16 May '13, 09:19

Justin%20Willey's gravatar image

Justin Willey
6.4k101132197
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×186
×97
×51
×14

question asked: 16 May '13, 09:10

question was seen: 693 times

last updated: 16 May '13, 10:36