Hi,
I am trying to select all custom tables and fields for data replication from NetSuite to Amazon RedShift and I see an error and cannot see any of the columns.
Thanks,
Sravanth
Unable to pull NetSuite Custom Tables and Columns
- 575Views
- Last Post 19 March 2018
0
votes
Nick Babcock
posted this
12 March 2018
0
votes
Simon Bubnov
posted this
14 March 2018
posted
14 March 2018
There can be 2 reason of the issue:
1. Skyvia NetSuite connection has two parameters: "Use Custom Tables" and "Use Custom Fields". Perhaps you have selected these connection parameters first. Then you have created the replication package with custom objects. After this you have cleared the check boxes for these parameters. Package metadata contain information about custom objects/fields, but the NetSuite connection doesn't see them any more.
2. You have created NetSuite connection with "Use Custom Tables" and "Use Custom Fields" parameters set to true. But after this some custom objects were deleted from NetSuite. NetSuite metadata are cached in the connection, and thus, the connection thinks that these objects are present. Open your NetSuite connection and click 'clear' for the Metadata Cache parameter. For more information, please refer to https://skyvia.com/resources/docs/index.html?netsuite_connections.htm
As well, as in the first case, the information about these objects is still present in the package metadata.
0
votes
Nick Babcock
posted this
14 March 2018
posted
14 March 2018
I have deleted all the connections and packages and re-created a new source and target connections and this time I cannot see any of the columns. Please find the attached screenshot of the error.
0
votes
Nick Babcock
posted this
14 March 2018
posted
14 March 2018
0
votes
Nick Babcock
posted this
15 March 2018
posted
15 March 2018
Hello,
I see the problem when I check the custom tables and fields. Can anyone setup a meeting to look at the issue? What is your turn around time for a ticket?
Thanks,
Sravanth
0
votes
Mariia Zaharova
posted this
19 March 2018
Sorry for the delay. Please specify the following details:
- with which exactly connection this error occurs - NetSuite Production or NetSuite Sandbox?
- whether "Use Custom Tables" and "Use Custom Fields" check boxes are selected for this connection?
- in what exactly scenario this error occurs (e.g. when you are selecting some custom table in the replication package, etc.)?
- with what exactly custom table this error occurs (specify its name).
Thank you and looking forward to your reply.
JIC: Skyvia support is provided within a timeframe of our response policy - 2 working days. However, we do our best to process requests as soon as possible.
