Has anyone seen this error trying to connect to Su...
# suitescriptc
Craig
07/19/2024, 12:28 PMHas anyone seen this error trying to connect to SuiteAnalytics Connect (I'm using datagrip but that shouldn't matter)?
DBMS: OpenAccess (ver. 08.10)
Case sensitivity: plain=mixed, delimited=mixed
Driver: OpenAccess (ver. 8.1.00.0147, JDBC4.0)
Ping: 500 ms
[NetSuite][SuiteAnalytics Connect JDBC Driver]A client info name specified is not recognized by the driver : ApplicationName.
Craig
07/19/2024, 12:30 PMMy connection string and I have the latest driver from NS.
jdbc:ns://NS_ACCOUT_ID.connect.api.netsuite.com:1708;ServerDataSource=NetSuite2.com;Encrypted=1;NegotiateSSLClose=false;CustomProperties=(AccountID=NS_ACCOUT_ID;RoleID=1248)
I made a custom role with the follow permissions:
m
michoel
07/20/2024, 9:30 PMI had this too in data grip. It's only an error when you test the connection but the actual connection works fine. But to prevent the error, edit the driver options and untick "Send Application Info"
c
Craig
07/22/2024, 5:40 AMThanks @michoel
Craig
07/22/2024, 5:43 AMStill getting this error when running a query though
m
michoel
07/22/2024, 5:44 AMBut the query is still running?
michoel
07/22/2024, 5:45 AMDid you uncheck this?
c
Craig
07/22/2024, 5:48 AMI have now! thanks again 😄
Craig
08/02/2024, 1:58 PM@michoel Did you manage to get intellisense to work?
m
michoel
08/05/2024, 3:23 AMYup works well enough for me. Did you select the schema?
c
Craig
08/05/2024, 4:52 PMMaybe it's already working - I was looking for it to work with the Item table but I've just realised that I can't see Item (although I can still query it?). Could be a permissions issue maybe.
Craig
08/05/2024, 4:53 PMI also notice aggregateItemLocation is not visible (but I can query that too).
Craig
08/06/2024, 1:55 AMCraig
08/06/2024, 1:56 AMCraig
08/06/2024, 1:56 AMMight just try rebuilding the schema and creating everything from scratch.
212 Views