Skip to Content
avatar image
Former Member

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

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 26, 2017 at 01:26 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded