Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
error converting data type nvarchar to bigint - validate/import error in DMM
Options
Go to last post Go to first unread
Previous Topic Next Topic
Richard Lamendin  
#1 Posted : Wednesday, January 11, 2023 7:49:57 AM(UTC)
Richard Lamendin
Rank: Member

Reputation:

Groups: Registered
Posts: 21

Thanks: 7 times

Encountering an error when trying to validate/import the Lab Sample Delivery Groups tab in ESdat online using the DMM. This is a soil vapour database we have exported from desktop and attempting to import to Online using an EDIF file. Can anyone please advise?

Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Nick Support  
#2 Posted : Wednesday, January 11, 2023 8:12:55 AM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 327
Canada

Was thanked: 29 time(s) in 29 post(s)

Hi Richard,

Are you able to provide more information on what the validation error is?

If you hover over the red exclamation point at the start of the row it will tell you what the problem is.

Thanks,

Nick
Back to top
WWW
Richard Lamendin  
#3 Posted : Wednesday, January 11, 2023 8:49:00 AM(UTC)
Richard Lamendin
Rank: Member

Reputation:

Groups: Registered
Posts: 21

Thanks: 7 times

Hi Nick, when I hover over the red exclamation point the validation error reads "Error converting data type nvarchar to bigint."

Regards,

 
Back to top
Nick Support  
#4 Posted : Thursday, January 12, 2023 4:14:23 AM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 327
Canada

Was thanked: 29 time(s) in 29 post(s)

Hi Richard,

We will look into that error.

If you want to import the related Sample and Chemistry data, you can do this by clearing the SDG value from the Sample Details tab (as it's not actually a required field) and then process the import.

Thanks,

Nick
Back to top
WWW
Richard Lamendin  
#5 Posted : Monday, January 16, 2023 9:15:39 AM(UTC)
Richard Lamendin
Rank: Member

Reputation:

Groups: Registered
Posts: 21

Thanks: 7 times

Thanks Nick, we'll give it a go.

Cheers
Back to top
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET