Advantage Database Server Service Update

  • This Service Update of the Advantage Database Server addresses the following issues:

  • Fixed a bug that caused crash dump being generated on the server when disconnecting a client. The problem surfaces after updating a table on a data dictionary link that has both trigger and RI.

  • Updated the permissions checking of SERVER:Admin and SERVER:Monitor permissions on system procedures used inside user-defined stored procedures. With this change, it is possible, for example, to call sp_mgGetInstallInfo inside a user-defined procedure without the calling user being a member of SERVER:Monitor.

  • Fix a bug that caused 9092 error being returned when executing a stored procedure with varying cursor output that resulted in a live cursor, and the DD is configured to check user permissions.

  • Fixed a bug where detail error message from failed trigger may be lost.

  • Fixed an issue where 2129 or 2239 may be retured when calling sp_EnableQueryLogging and passing a value to the OPTIONS input directly.

  • Fixed the ::conn.NetworkAddress system variable in SQL to return the web client IP address instead of the oData (apache) server's IP address for a web platform connection.

  • Fixed a bug in the REPLACE scalar when working with Unicode data.

  • Fixed an issue where spurious 2229 "ambiguous identifier" error is returned when executing a scripted stored procedure that inserts or updates to table that has column names begin with the _ (underscore) character.

  • Fixed a bug that could cause server to crash when evaluating large boolean or algebraic expression in SQL statement.

  • Fixed a bug where converting/casting binary data into SQL_WVARCHAR returned truncated result.

  • Fixed issue with ALTER TABLE or AdsRestructureTable where altering an ADT table can result in 7038 errors and a corrupt index.

asked 27 Sep '12, 14:20

MikeHagman's gravatar image

accept rate: 10%

edited 28 Sep '12, 08:30

Lance%20Schmidt's gravatar image

Lance Schmidt

Does this fix the problem reported regarding altering a table and then reindexing not working?

(28 Sep '12, 01:40) Mike

Yes this does fix that issue.

(28 Sep '12, 07:44) Lance Schmidt

Thank you.

(01 Oct '12, 01:33) Mike
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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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



Asked: 27 Sep '12, 14:20

Seen: 4,383 times

Last updated: 01 Oct '12, 01:33

Advantage Developer Zone Contact Us Privacy Policy Copyright Info

Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.