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

Notification

Icon
Error

Options
Go to last post Go to first unread
Stephen Mulligan  
#1 Posted : Thursday, May 23, 2019 9:58:38 AM(UTC)
Stephen Mulligan
Rank: Newbie

Reputation:

Groups: Registered
Posts: 1

Hi there,

When working within one of our SQL databases, I am getting the error '11850 Type Mismatch' when attempting to export chemistry tables. ESdat will then export an ill-formatted table.

I've isolated the problem to be something to do with asbestos in soil results. If I filter these out it appears to be working fine. I have only started to receive this error after fixing conversion errors for asbestos data yesterday.

Any assistance on troubleshooting this issue would be appreciated.

Stephen

NickT  
#2 Posted : Friday, May 24, 2019 9:08:30 AM(UTC)
Nick Support
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 327
Canada

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

Hi Stephen,

You've identified that the issue started when you updated some unit conversions for asbestos.

Can you provide some details on the conversions you set up?

Typically asbestos results in ESdat are either 1 or 0, respectively indicating presence or not, so I am curious if your data matches this, and if not, how it might be impacting the export.

Thanks,

Nick

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.