Can't access NetSuite table

  • 312Views
  • Last Post 29 November 2019
0
votes
Andrew McDonald posted this 29 October 2019

Hi 

I've configured a Netsuite connection and can access the majority of netsuite tables except for a couple.  A really critical table is SalesOrder however I get a generic error when trying to access it stating "Error accessing web service".

I'm an admin of the NetSuite instance and appear to have configured all the required role permissions, however I'm stuck, could you please advise.

 

 

Andrew

netsuite backup query
Order By: Standard | Newest | Votes
0
votes
Dmitriy Muzurov posted this 29 October 2019

Hi Andrew,

Thank you for submitting a ticket with us.

NetSuite does not allow using Administrator/Full access role for API starting 2019.1 but still allows the use of a custom role with Full permissions on some objects (Contacts, Customers, etc.).

The best practice for Skyvia integration setup for NetSuite roles/permissions is to create a NetSuite custom role, assign required permissions to it, assign the role to NetSuite user used in your Skyvia integration.

Make sure SalesOrder has Full level of permissions for your custom role in Setup -> Manage Roles -> Permissions (Transactions)

Should you have any questions, do not hesitate to contact us back.

0
votes
Andrew McDonald posted this 29 October 2019

The role has a huge amount of access and has managed to backup/access all other tables except the SalesOrder table. The role specifically has SalesOrder with full permission.   When I try to query the table it just sits there for a very long time and either returns a generic web service error or it never returns at all.   e.g. query:    select * from salesorder limit 5;

0
votes
Dmitriy Muzurov posted this 29 October 2019

Dear Andrew,

Thank you for getting back to us.

Please create an export package with SalesOrder object and authorize us a test run. We will not access any sensitive data, the package will be run with extended logging.

An export package can be created by following this guide.

We are looking forward to hearing from you.

0
votes
Andrew McDonald posted this 29 October 2019

I've setup the export package and clicked run:

https://app.skyvia.com/#/packages/82542

 

0
votes
Andrew McDonald posted this 30 October 2019

Export package crashed after 6 hours with no records processed.

 

0
votes
Dmitriy Muzurov posted this 30 October 2019

Dear Andrew,

Thank you for reply.

We have created a request for our development team.

Once we have any details, we will update the post.

0
votes
Dmitriy Muzurov posted this 31 October 2019

Dear Andrew,

Our developers looked into your use case and catched timeout exception.

They increased the time for awaiting replies from NetSuite and re-configured the failovers.

This fix will be released with new Skyvia version. Once it is released, we will update the post.

0
votes
Andrew McDonald posted this 06 November 2019

Did you have an ETA as to when you think the update might go live?

0
votes
Dmitriy Muzurov posted this 06 November 2019

Hi Andrew,

Thank you for your reply.

We expect a new version to be released within the next couple of weeks.

0
votes
Dmitriy Muzurov posted this 29 November 2019

Dear Andrew,

A new Skyvia version has been released these days and your issue should be fixed.

Should you have any questions, do not hesitate to contact us back.

New Ticket
Categories
Popular Tags
Close