Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Schema could not be resolved for public synonym

I was executing the following document Using Predictive Analysis Library (PAL) in SAP HANA Cloud Platform I'm currently stuck in step 4 .I get the following when i try to activate PAL_DEMO_TABLES.hdbti. All the previous steps where successfully executed.

Error:

     p1940812895trial.dev.myhanaXS.data.loads:PAL_DEMO_TABLES.hdbti

           Schema could not be resolved for public synonym. Check that the target table exists.

PAL_DEMO_TABLES.hdbdd


namespace p1940812895trial.dev.myhanaXS.paldemo.data;

@Schema: '_SYS_BIC'

context PAL_DEMO_TABLES {

@Catalog.tableType : #COLUMN

Entity PAL_ABC_RESULT_TBL {

  key ABC: String(10);

    key COMPANY_NAME: String(100);

};

@Catalog.tableType : #COLUMN

Entity PAL_CONTROL_TBL {

  key Name: String(100);

    intArgs: Integer null;

    doubleArgs: Decimal(15,2) null;

    strArgs: String(100) null;

};};

PAL_DEMO_TABLES.hdbti:


import = [{

  schema = "_SYS_BIC";

  cdstable = "p1940812895trial.dev.myhanaXS.paldemo.data::PAL_DEMO_TABLES.PAL_CONTROL_TBL";

  file = "p1940812895trial.dev.myhanaXS.paldemo.data.loads:pal_control.csv";

  header = false;

}];

system_view.jpg (85429 B)
Tags:
Former Member
Former Member replied

Yes i was able to resolve it . I Had to reload the entire project and start from scratch  thats the only way i could. Still did not find the cause of the error

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question