Skip to Content
0

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

Jun 28, 2017 at 06:44 PM

248

avatar image
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

capture.png (210.8 kB)
capture2.png (200.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Michael Healy
Jun 28, 2017 at 07:17 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

I am using it on eclipse.

0

Ok, try it in HANA Studio then.

0
avatar image
Former Member Jul 17, 2017 at 12:10 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded