Error during execution of SQL command: GRANT SELECT ON SAP.SVERS TO DBA_COCKPIT

[former_member430198]

Hello experts

I am performing an SCM installation over and already installed HANA Database with SWPM, but I get the following error message when the installation process is executing:

Error during execution of HdbCmdClazz 'ABAP_POST_LOAD_EXECUTION' : class com.sap.hdb.sl.lib.utils.cmd.clazz.CmdClazzParameterFactory, parameters received. Start execution. Check HdbCmdOut.log and HdbStdout.txt for further information. Tue Jul 25 22:20:45 CDT 2017 | com.sap.hdb.core.main.cmd.HdbCmdMain | Error during execution of SQL command: GRANT SELECT ON SAPEP1.SVERS TO DBA_COCKPIT SAP DBTech JDBC: [397] (at 23): invalid object name: SVERS: line 1 col 24 (at pos 23))

I have checked with HANA Studio and the user SAP<SID> is already created but the schema is empty and no SAP<SID>.SVERS object exists. Am i missing any step on the installation?

Please your help,

[former_member183326 · Accepted solution]

I think the problem here is with the ID in which you have placed in the hdbuserstore.

So in your question:

I have checked with HANA Studio and the user SAP<SID> is already created but the schema is empty and no SAP<SID>.SVERS object exists. Am i missing any step on the installation?

Where did you import the tables too? Its looking for the tables in the DBA_Cockpit SCHEMA when in fact I think you may have imported the tables elsewhere, so I think you may need to start the whole installation again and follow the steps carefully and import the tables into the correct schema and also set the correct schema when you establish the hdbuserstore key.

[former_member430198 · Accepted solution]

Thank you for your answer Michael,

Yes indeed, all tables were created on SYSTEM Schema. I will add hbuserstore key with SAP<SID> and restart installation so that the tables are created in proper schema. Now my question is, I can't leave SYSTEM schema this way, is there any way I could revert the schema to its original state?

[former_member183326 · Accepted solution]

you could restore your system back to a time before you did it? PIT recovery...do you have a backup from this time?