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

An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…