Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 28, 2017 at 07:17 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Ok, try it in HANA Studio then.

  • Jul 17, 2017 at 12:10 PM

    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

    Add comment
    10|10000 characters needed characters exceeded