nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Anaplan Connect JDBC Error # 28

Kudiarasu

Hello

I am trying to export data from Anaplan to Vertica and i get the Error # 28 / Error # 27 for some files.

Not sure of the error type. Other files in similar formats are exported fine.

Accepted answers

ABerenguela

Hi,

for the error 27 check the type of data of the columns, maybe you are sending a text to a number field.

The error 28 for vertica is authentication issue, check the credentials. For other jdbc connections it is a disk space error

Regards

All comments

ABerenguela

Hi,

for the error 27 check the type of data of the columns, maybe you are sending a text to a number field.

The error 28 for vertica is authentication issue, check the credentials. For other jdbc connections it is a disk space error

Regards

Kudiarasu

Thanks @ABerenguela, do you know where i can find the list of errors?

ABerenguela

this link for vertica:

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ErrorCodes/SQLStates.htm?tocpath=Vertica%20Error%20Messages%7CSQL%C2%A0State%20List%7C_____0

this one for jdbc

https://docs.oracle.com/cd/B10501_01/java.920/a96654/ermesap.htm

Regards

Kudiarasu

Thanks again, it was a Data mismatch issue.

Quick Links

Can you help?

Unanswered questions

Near-Real-Time Anaplan → Claude MCP: Any Faster Than Bulk Export + MySQL?
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
Anaplan AI Actions
The July and August releases added several useful capabilities to Anaplan AI, including the ability to create and retrieve saved views and create list import actions. It would be valuable to extend these capabilities to support the full end-to-end user story: creating a saved view and using it as the source for an import…
Anaplan Analyst performance on large, sparse models
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.