Error after deleting the SLT schema

[former_member199283]

Hi,

I have stopped all the loads and then deleted the user created as of SLT schema (with cascade option). The schema got deleted in HANA studio and then I have deleted the corresponding configuration from SLT system (through LTR transaction) as well.

Schema name was SLTTEST 

Now, in HANA studio, when I click on the "Data provisioning", it is throwing warning as

"SAP DBTech JDBC [259]: invalid table name. Could not find the table/view RS_STATUS in schema SLTTEST" .

Can anybody help how do i resolve it?

[former_member256353 · Accepted solution]

Hi,

Well I got that one too.

So I went playing....

Go into your scheman, open "SYS_REPL" and look at the tables there. Do a data preview.

You'll see a target schema there that is not anymore vaild - and to delte it, use an SQL....for example like this:

delete FROM "SYS_REPL"."RS_REPLICATION_COMPONENTS" where "TARGET_SCHEMA" = 'SLTTEST'

or however your target schema is called.

Hope you will get rid of those entries.

Regards

Greg