SAP DBTech JDBC: [259]: invalid table name.

[Former Member]

How to resolve this error. I also visited many blogs but could not find any satisfactory answer to resolve this error. The error is showing as:-

Could not execute 'insert into DB_WEEK_SERIES(REPORT_DATE,REPORT_WEEK,WEEK_END) select ...' SAP DBTech JDBC: [259]: invalid table name: Could not find table/view DB_WEEK_SERIES in schema AFS_BASE: line 1 col 13 (at pos 12). I want the precise steps to resolve this error. Any help is appreciated. Thank you.

capture2.png

[former_member212589]

Hi Bhavya,

Could you please try the same query by adding the schema name to the table name.

I have tried the same in HANA Studio and its working fine for me.

It should be like this.

"SCHEMA NAME"."PACKAGE_NAME::DB_WEEK_SERIES"

Please validate and let us know whether it is working or not.

Thank You,

RP

[former_member183326]

What version of studio are you using? Update it and try again

[Former Member]

I am using it on eclipse.

[former_member183326]

Ok, try it in HANA Studio then.