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.5k104135200
accept rate: 21%

edited 16 May '13, 09:31

Mark%20Culp's gravatar image

Mark Culp
22.5k9129264

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.5k104135200
accept rate: 21%

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:

×190
×98
×51
×14

question asked: 16 May '13, 09:10

question was seen: 713 times

last updated: 16 May '13, 10:36