Search in user list - converting error in vatnumber

Henrik Madsen

Posted on 23/09/2017 15:19:54

We recently upgrade an old DW8 to DW9 currently on DW 9.3.

The thing is, when we do a search backend in the user list and search for at text string the result is displayed just fine.

But when we do a search on a number we end up whit this: "Conversion failed when converting the nvarchar value 'DK36937599' to data type int".I know what it is. It is the column "AccessUserVatRegNumber" in the tabel AccessUser witch is defind af nvarchar(20). Our customer have all CVR numbers in the above format.
What to do?

Error stack trace:

[SqlException (0x80131904): Conversion failed when converting the nvarchar value 'DK36937599' to data type int.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3189216
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +753
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +5042
   System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +278
   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +295
   System.Data.SqlClient.SqlDataReader.Read() +42
   Dynamicweb.Security.UserManagement.User.GetUsersBySql(String sqlCommandText) +125
   Dynamicweb.Admin.UserManagement.ListUsers.GetUsersFromGroups() +3155
   Dynamicweb.Admin.UserManagement.ListUsers.GetUsers() +103
   Dynamicweb.Admin.UserManagement.ListUsers.get_Users() +28
   Dynamicweb.Admin.UserManagement.ListUsers.MakeList() +780
   Dynamicweb.Admin.UserManagement.ListUsers.Page_PreRender(Object sender, EventArgs e) +43
   System.Web.UI.Control.OnPreRender(EventArgs e) +11911581
   System.Web.UI.Control.PreRenderRecursiveInternal() +162
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +6925

Replies

Nicolai Pedersen

Posted on 23/09/2017 16:18:16

Hi Henrk

I can see that. Made a bugfix on TFS#39728 that will be out with the next DW9.3 hotfix next week.

Sorry about the inconvenience.

BR Nicolai

Henrik Madsen

Posted on 25/09/2017 17:44:22

Hi Nicolai

Okay, thank you. I will not be able to update this solution next weekend, but I will report back soon as possible.

Kristian Kirkholt

Posted on 26/09/2017 14:04:50

This post has been marked as an answer

Hi Henrik

The problem TFS#39728 "VAT regnumber is registered as integer when searching" has now been fixed in version 9.3.3

You are able to find this build in the download section:

http://doc.dynamicweb.com/releases-and-downloads/releases

Please contact Dynamicweb Support if you need any additional help regarding this.

Kind Regards
Dynamicweb Support
Kristian Kirkholt

Votes for this answer: 1

Henrik Madsen

Posted on 09/10/2017 15:13:57

We just did the 9.3.3 upgrade last night on Azure. It has solved the problem. :-)

Buy the way... Is the only way to upgrade, overwriting the all the files in Admin and bin folder? It is a ton of files to overwrite eats time.

Best Regards
Henrik Madsen

Nicolai Pedersen

Posted on 09/10/2017 15:45:23

It depends. If you setup your solution for packages, you can just update the package(s) that causes the problem. See http://doc.dynamicweb.com/documentation-9/platform/system-architecture/package-management

You must be logged in to post in the forum

Developer forum

Search in user list - converting error in vatnumber

Replies