BigCommerce Insert Issue

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
StonewareSoftware
Posts: 2
Joined: Sat 18 Aug 2018 14:30

BigCommerce Insert Issue

Post by StonewareSoftware » Sat 18 Aug 2018 14:46

We receive an error when trying to execute the following SQL in OAUTH. It works fine in Basic Authentication.

insert into optionsetsoptions (optionid, optionsetid, displayname, sortorder, isrequired) values(2116,1395,'COLOR',0,true)

It does trigger an exception, however the exception message is blank.

exception {""} Devart.Data.Bigcommerce.BigcommerceException
Source "Devart.Data.SqlShim"
Stack Trace Devart.Data.SqlShimCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)" & vbCrLf & " at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)" & vbCrLf & " at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)" & vbCrLf & " at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)" & vbCrLf & " at Devart.Common.DbCommandBase.ExecuteScalar()" & vbCrLf & " at BigCommerceLibrary.BCConnect.InsertedData(String Query) in BigCommerceLibrary\BigCommerceLibrary\BCConnect.vb:line 398"

We have also tried this with SkyVia and the OAUTH doesn't work however the basic authentication does there as well.
We can insert into other tables as expected with both OAUTH and Basic with our code and on Skyvia.

Can you give me some advice on how to correct this error?, This keeps us from being able to add new product that have SKU's since we cant add the options values.

StonewareSoftware
Posts: 2
Joined: Sat 18 Aug 2018 14:30

Re: BigCommerce Insert Issue

Post by StonewareSoftware » Mon 20 Aug 2018 21:10

This appears to be an issue with the http error code returned. Error 422 is returned. The driver (Devart.BigCommerce) is not trapping this error or it's subsequent message.

Using a normal HTTP Post, we can see the error 422 and reading the stream, we can see the details as to why.

May I suggest an update to the BigCommerce Connector to trap error 422 and subsequently the response stream in order to show the returned message from BigCommerce.

Thanks

Pinturiccio
Devart Team
Posts: 2279
Joined: Wed 02 Nov 2011 09:44

Re: BigCommerce Insert Issue

Post by Pinturiccio » Thu 23 Aug 2018 12:52

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Pinturiccio
Devart Team
Posts: 2279
Joined: Wed 02 Nov 2011 09:44

Re: BigCommerce Insert Issue

Post by Pinturiccio » Wed 19 Sep 2018 14:07

We have fixed the bug with not inserting data to the BigCommerce OptionSetsOptions object via an OAuth connection. We will post here when the corresponding build of dotConnect for BigCommerce is available for download.

Pinturiccio
Devart Team
Posts: 2279
Joined: Wed 02 Nov 2011 09:44

Re: BigCommerce Insert Issue

Post by Pinturiccio » Thu 20 Sep 2018 12:36

New build of dotConnect for BigCommerce 1.7.744 is available for download now!
It can be downloaded from https://www.devart.com/dotconnect/bigco ... nload.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=37709

Post Reply