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.

We're having some sporadic performance issues in each application that accesses our database. I can't really tie it to load. We suspected a set of specific procedures, although we can run them via ISQL with no issues. I'm trying to do some Application Profiling and capturing in a tracing database. I've tried several options (on and off) but always get stopped at a certain point in creating the profiling database. Error: An error occurred while trying to create the tracing database. An error occurred while attempting to unload the database 'Billing2'. * SQL error: Syntax error near 'sajdbc'

Caused by: An error occurred while attempting to unload the database 'Billing2'.

Any suggestions? TIA.
Becky Snyder Bradley University

asked 20 Aug '19, 11:57

rsnyder's gravatar image

rsnyder
436121429
accept rate: 0%

2

Although it is specifically about v12, you may find this (un-official) step-by-step guide from Breck Carter helps: http://sqlanywhere.blogspot.com/2011/05/database-tracing-in-50-easy-steps.html

(20 Aug '19, 14:10) Justin Willey
Replies hidden
1

And do also consider the comments there, the same step seem to have failed for other folks...

(21 Aug '19, 03:36) Volker Barth
Be the first one to answer this question!
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:

×275
×32

question asked: 20 Aug '19, 11:57

question was seen: 821 times

last updated: 21 Aug '19, 03:36