Error While importing table to SAP Data services Designer from PostgreSQL DB

[former_member542326]

Hi All,

I am getting a syntax error while trying to import a table from postgreSQL DB using SAP BODS. Please find the below screenshot and help me out solving this issue.

Thank you.

[akhileshkiran]

Hi kaushik goli,

For the column status the ddl statement is populating as the status varchar(-1) null,

As the varchar(-1) can be rewritten as nvarchar(max) / varchar(max). I suggest you to please check the checkbox in the datastore as highlighted below.

Regards,

Akhilesh Kiran N.

[Former Member]

Check the DDL of the table. There is some issue with the datatype definition of column

Regards

Arun Sasi

[former_member542326]

Hi Charles,

I am trying to import a PostgreSQL View and please find the image for view structure

table-structure.jpg

Regards

Kaushik

[nagarajuvsap]

Hi Kaushik ,

Can you try to do drop the table and re-create it again and re-import it in Data services.

BR,

Nagaraju

[former_member192448]

Hi Kaushik

Can you provide the DDL of the table?

Regards

Charles