# NumberFormatException running dropAllDatabaseObject ant task on SQLServer

**URL:** <https://forum.liquibase.org/t/numberformatexception-running-dropalldatabaseobject-ant-task-on-sqlserver/846>\
**Category:** General Discussion\
**Created:** [October 6, 2010, 4:08pm UTC](https://forum.liquibase.org/t/numberformatexception-running-dropalldatabaseobject-ant-task-on-sqlserver/846 "2010-10-06T16:08:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dean.m.jones](https://avatars.discourse-cdn.com/v4/letter/d/ba8739/32.png) [@dean.m.jones](https://forum.liquibase.org/u/dean.m.jones)\
**Post date:** [October 6, 2010, 4:08pm UTC](https://forum.liquibase.org/t/numberformatexception-running-dropalldatabaseobject-ant-task-on-sqlserver/846/1 "2010-10-06T16:08:00Z")

</div>

Hi folks,

Once I’d reverse-merged revision 1733 out (following the previous problem: [http://liquibase.org/forum/index.php?topic=730.0](http://liquibase.org/forum/index.php?topic=730.0)) I now get the following error when running the dropAllDatabaseObject task (again, full stacktrace attached):

liquibase.exception.DatabaseException: java.lang.NumberFormatException: null  
&nbsp; &nbsp; &nbsp; &nbsp; at liquibase.Liquibase.dropAll(Liquibase.java:491)

This seems to be a problem introduced by revision 1747 ([http://liquibase.jira.com/source/changelog/CORE/?cs=1747](http://liquibase.jira.com/source/changelog/CORE/?cs=1747)): in MSSQLTypeConverter, the error is caused by the following condition (starting on line 59) as “precision” can be null:

if (columnTypeString.equalsIgnoreCase(“varbinary”) && Long.valueOf(precision) \> 8000) {  
&nbsp; &nbsp; precision = “max”;  
}

I’ve attached a patch which just does a null check in the condition. Don’t know if this is correct though.

Best wishes,

Dean.

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [October 6, 2010, 4:08pm UTC](https://forum.liquibase.org/t/numberformatexception-running-dropalldatabaseobject-ant-task-on-sqlserver/846/2 "2010-10-06T16:08:00Z")

</div>

It looks right.&nbsp; I applied the patch, thanks

Nathan