Has anyone been able to access FR table from suite...
# suiteanalytics
l
Has anyone been able to access FR table from suite analytics data source ? I was able to retrieve the data via SuiteTalk REST API with the exact same query, but couldn't get it work with JDBC connection. fulfillmentrequest dataset is accessible from Analytics menu as well.
Copy code
Executing query: SELECT status, externalid, tranid, transactionnumber FROM fulfillmentrequest
Exception in thread "main" java.sql.SQLException: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Cannot retrieve metadata. Error ticket# koiqvygw1ha33gk4t8m18[104]
	at com.netsuite.jdbc.oabase.oaa_.a(Unknown Source)
	at com.netsuite.jdbc.oabase.oaa_.b(Unknown Source)
	at com.netsuite.jdbc.oabase.oaa_.a(Unknown Source)
	at com.netsuite.openaccess.ssp.oaar.a(Unknown Source)
	at com.netsuite.openaccess.ssp.oaf.a(Unknown Source)
	at com.netsuite.openaccess.ssp.oaf.a(Unknown Source)
	at com.netsuite.openaccess.ssp.oaf.f(Unknown Source)
	at com.netsuite.openaccess.ssp.oaf.e(Unknown Source)
	at com.netsuite.openaccess.ssp.oaf.b(Unknown Source)
	at com.netsuite.openaccess.ctxt.stmt.oac.a(Unknown Source)
	at com.netsuite.jdbc.openaccess.oad.j(Unknown Source)
	at com.netsuite.jdbc.oabase.oac5.p(Unknown Source)
	at com.netsuite.jdbc.oabase.oac5.o(Unknown Source)
	at com.netsuite.jdbc.oabase.oac5.executeQuery(Unknown Source)
	at jdbcdriver.example1.JdbcExample.main(JdbcExample.java:101)