Question Re: Error While importing table to SAP Data services Designer from PostgreSQL DB in Technology Q&A

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

former_member542326 — Fri, 18 May 2018 08:26:49 GMT

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.

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

former_member192448 — Fri, 18 May 2018 14:59:14 GMT

Hi Kaushik

Can you provide the DDL of the table?

Regards

Charles

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

nagarajuvsap — Sun, 20 May 2018 02:28:48 GMT

Hi Kaushik ,

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

BR,

Nagaraju

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

former_member542326 — Mon, 21 May 2018 11:01:53 GMT

Hi Charles,

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

table-structure.jpg

Regards

Kaushik

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

Former Member — Tue, 22 May 2018 04:13:14 GMT

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

Regards

Arun Sasi

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

akhileshkiran — Wed, 23 May 2018 13:07:28 GMT

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.