[Liquibase-user] New Topic: Exception running dropAllDatabaseObject task on SQLServer

[Liquibase Community Forum]

A new topic, 'Exception running dropAllDatabaseObject task on SQLServer', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=730.new#new

The text of the topic is shown below:

Hello folks,

I'm having a problem with the head of trunk when calling the dropAllDatabaseObject ant task on a SQLServer db (this worked previously, the only change was to update liquibase from revision 1719 to 1776). I now get the following error when running dropAllDatabaseObject (full stacktrace attached):

BUILD FAILED
liquibase.exception.DatabaseException: Error getting jdbc:jtds:sqlserver://myserver/mydatabase view with ***@13f210f
at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readView(JdbcDatabaseSnapshotGenerator.java:147)

Looking back through the recent commits on liquibase, commit 1764 (http://liquibase.jira.com/source/changelog/CORE/?cs=1764) seemed to be the most relevant so I backed-off to revision 1763 and the exception no longer occurs. The error is caused by liquibase trying to run the following sql:

select object_definition(object_id) from sys.objects where type='v' and upper(name)='CASEENTITIES' and schema_id='dbo'

Clearly, "dbo" is not a valid value for the schema_id.

Best wishes,

Dean.

Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The Liquibase Community Forum Team.