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.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385