NetSuite Error: Disk Cache Error. Field Length:4000000 Exceeds Maximum Limit of 65535link

Updated 12 days ago

Issuelink

The connector fails with the following error:

Error updating table: <TABLE NAME> java.sql.SQLException:   
\[NetSuite\]\[SuiteAnalytics Connect JDBC Driver\]\[OpenAccess SDK SQL Engine\]  
Disk cache error. Field length:4000000 exceeds maximum limit of 65535.\[10232\]
content_copy

Environmentlink

Connector: NetSuite SuiteAnalytics

Answerlink

Solution 1: Disable the table

1. Access the connector dashboard.
2. Click on the Schema tab.
3. Filter for the table containing the problematic column.
4. Click the checkbox next to the table to disable it.
5. Save the schema changes.

Solution 2: Truncate the problematic column

1. Log in to the NetSuite source.

2. Run the following query to isolate the problematic column. Replace anything in <> with the correct value.

   SELECT COUNT(*) from ""<SCHEMA>"".<TABLE> WHERE LENGTH(<COLUMN_NAME>) > 65535;

3. Truncate the column so it no longer exceeds the limit.

Causelink

One of the columns in the table referenced in the error has data greater than the limit supported by the JDBC driver.