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.

 

 

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.