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.
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
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
Thanks again, it was a Data mismatch issue.
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…
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.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
