Skip to Content
0

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

Jul 26, 2017 at 05:21 AM

115

avatar image
Former Member

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Michael Healy
Jul 26, 2017 at 01:26 PM
0

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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?

0

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

0