if someone can take a couple of minutes to chek it...
# general
a
if someone can take a couple of minutes to chek it out and help me I would really appreciate it!!
b
without seeing the queries
the guess is that your permissions are not setup correctly
a
the queries are:
Copy code
SELECT COUNT(*) FROM DeletedRecord;
SELECT COUNT(*) FROM SystemNote:
first query throws following error:
Copy code
SQL Error [10129] [42S02]: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Base table:DeletedRecord not found.[10129]
the second query returns zero as result (0)...
b
and which permissions does the role have?
a
it has de DWI role... according to documentation, it should have access to all Netsuite data...
b
double check that the role has access to deleted records and i guess suiteanalytics workbook
otherwise make sure that you are actually using netsuite2
a
yes, JDBC URL has NetSuite2.com as the service data source.... and let me double check the role permissions with our admins... thanks
b
a
my bad... that was a typo... let my edit it
b
more general things are making sure that the token you are using is actually the role you think it is
if you dont know, you want to get a new access token
a
well, we do have TBA... but I did the queries mentioned before using DBeaver... the connection URL has NetSuite2.com as I said before, but I'm using user and password only...
do you perhaps have any inputs or ideas on this? @battk
b
your information sounds inconsistent
you should be forced to use tba using the data warehouse integrator role
a
yes, that is correct... that's why we have a second role with read only access (sorry I didn't mentioned before), that way we can connect to NetSuite2.com data source using DBeaver... because we haven't been able to connect to NetSuite2.com using DBeaver with the DWI role only...
b
for dwi, you need to be using tba, which usually means you cant use standard tools
you need to make extra sure that whatever second role you are using has the correct permissions