Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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
9.0k130169257
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:

×13
×11

question asked: 27 Jul '11, 12:09

question was seen: 2,159 times

last updated: 28 Jul '11, 22:14