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.

How to get more information (details) when an error occurs during creation of a tracing database?

An error occurred while attempting to unload the database 'xxx'.
***** SQL error: Syntax error near '' on line 2

How to determine what was really going wrong in the above procedure?

asked 27 Jul '11, 12:09

Martin's gravatar image

Martin
8.6k114149237
accept rate: 14%


You can manually create a tracing database with dbunload -n -k.

-n ensures that no data is loaded into the tracing database (not that it would do any harm, it just consumes needless space) -k populates a table that maps schema objects from between the production and tracing databases

If you run this dbunload, you can dbinit a database and run the reload script yourself to see where the syntax error is being generated.

permanent link

answered 28 Jul '11, 22:14

Dan%20Farrar's gravatar image

Dan Farrar
43143
accept rate: 80%

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:

×12
×11

question asked: 27 Jul '11, 12:09

question was seen: 779 times

last updated: 28 Jul '11, 22:14