3942879 Newbie

"Mixed role" occurs when a query is done across 2 tables that exists on 2 different company/role. For example, if the odbc login has 2 roles, odbc will generally select the default login role. If a default does not exist, it chooses the first role. When table resolution occurs, ODBC will attempt the first role before…

Connect by is not supported.

"Unexpected error, please contact support for assistance." This error is only shown during the login stage and incorrect login credentials where used. Try logging in with an email/password that has ODBC access. The fact that you received this message implies that your application and driver are correctly talking to each…

try rownum()

Sounds like the db connection is internally disconnecting from NetSuite, leaving the connection worthless and unusable. If configurable, try increasing the timeout to > 20 minutes. Select top 1 * from transaction, while returns 1 row, still queries all the rows of the rows and does not gain any advantage over "select *…

Permission restriction is dependent on the type of data being requested. What tables are you accessing?

Can you access the Items table via Excel?

also try rownum() < 10

Please file a case and specify the tool you are using. Thanks -Ivan

My last post did not include enough detail. There was no downtime for the regular application, but we ran into an issue that required us to temporarily shutdown the ODBC and partner servers. The problem was resolved and we apologize for the inconvenience.

The majority of the time is taken up in the custom fields. I'm currently working on a way to make this faster. As soon as I'm done, you should notice a performance boost both custom field and non-custom field queries. Thanks.

We had a scheduled release of code at 6:00. Sorry for the inconvenience.

Have you tried installing on a seperate machine with any success?

try datediff('day',getdate(),create_date) In a few days, getdate() can be replaced with sysdate() or current_date.

What query are you running?

How man rows are you recieving and at what time did you last run the query?

You should be good now. Let me know if it happens again.

getdate() should return the current date. Issues have been filed to support other names for the date type, for example sysdate(), current_date, etc.

Can you please file a case and attach the SQL you are running? Thank you. NetSuite has an internal page size limit of 10,000 rows, but we send multiple pages. We have successfully returned millions of rows in Excel, Aquodata Studio, Crystal and a few command line tools. I'd like to recreate this issue so that I can…

This was an issue that should be fixed. -Ivan

I see your query and we are working on a solution.

Are the extra fields custom fields?

Access is required for TCP 1706 out of the firewall and the established return data back in. Please confirm that your network configuration allows for return connections on port 1706.

What errors are you recieving from the JDBC ODBC Bridge? We are aware that the strings exposed via the JDBC/ODBC Bridge is not correctly exposed if you use the "getObject" method because the bridge incorrectly handles the unicode data type. However, using "getString" works fine. Other than that, I have not seen any other…

Window System Error 998 is an Invalid access to memory location. Was something installed after the ODBCDriver was installed? Does reinstalling the driver make a difference? If the driver works on some machines, but not others, what are the differences between the machines? We will need as much information about your…

Can you file a case so that I can appropriately track and fix this issue. Thanks. -Ivan

We had an unexpected downtime, we are currently looking into it.

Niels is correct. There are multiple components at work here, all of which can be the source of the problem and can be tested individually. Only by testing each source seperately(NS, NS+Sun JDBC/Bridge, NS+Sun JDBC/Bridge+ADS) will the source of this issue be obviated. Each addition can either expose a bug in the previous…

Aqua Data Studio is apparently not showing unicode characters. The data can been seen within Excel and Crystal, which implies the issue is within the tool in use and not the driver.

Shanon is right. The only possibly overlap between the old driver and new driver may be the SSL package. Some machines already have the necessary SSL package and will not require the openSSL installation. What you can do is first install the ODBC driver and see if you can connect. If it it fails to access NetSuite, then…