HANA Migration - CREATE_SQL_ROLE_USER_SEQUENCE Error

[Former Member]

Hello colleagues,

I am getting the below error during the DB import in the HANA Database

************

ue Feb 19 13:40:47 EST 2013 | com.sap.hdb.sl.lib.connection.sql.JdbcConnection | Start new connection with connect URL: jdbc:sap://aus-qa-hana-f94-blade-1-1:30015 connect user: System

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.sl.lib.connection.sql.JdbcConnection | Run SQL command: SELECT ACTIVE_STATUS FROM SYS.M_SERVICES WHERE SERVICE_NAME = 'statisticsserver'

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.sl.lib.connection.sql.JdbcConnection | Closing connection.

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.core.main.cmd.HdbCmdMain | Error during execution of HdbCmdClazz section!

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.core.main.cmd.HdbCmdMain | Empty result for sql query: SELECT ACTIVE_STATUS FROM SYS.M_SERVICES WHERE SERVICE_NAME = 'statisticsserver'

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.core.main.cmd.HdbCmdMain | com.sap.hdb.sl.lib.instance.Database.getStatus(Database.java:12)

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.core.main.cmd.HdbCmdMain | com.sap.hdb.sl.lib.instance.Database.isStatisticsServerOnline(Database.java:93)

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.core.main.cmd.HdbCmdMain | com.sap.hdb.sl.lib.user.role.DbaCockPitRole.grantSysStat(DbaCockPitRole.java:82)

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.core.main.cmd.HdbCmdMain | com.sap.hdb.sl.lib.user.role.DbaCockPitRole.createNewRole(DbaCockPitRole.java:68)

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.core.main.cmd.HdbCmdMain | com.sap.hdb.sl.lib.utils.cmd.clazz.CreateRole.execute(CreateRole.java:52)

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.core.main.cmd.HdbCmdMain | com.sap.hdb.sl.lib.utils.cmd.clazz.BatchExecutionBase.executeCmdClazz(BatchExecutionBase.java:52)

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.core.main.cmd.HdbCmdMain | com.sap.hdb.sl.lib.utils.cmd.clazz.CreateSqlRoleUserSequence.execute(CreateSqlRoleUserSequence.java:18)

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.core.main.cmd.HdbCmdMain | com.sap.hdb.core.main.cmd.HdbCmdMain.execute(HdbCmdMain.java:113)

Tue Feb 19 13:40:47 EST 2013 | com.sap.hdb.core.main.cmd.HdbCmdMain | com.sap.hdb.core.main.cmd.HdbCmdMain.main(HdbCmdMain.java:74)

********************************************

I am getting empty result for the SQL query during the sapinst DB import.

But when i execute the same SQL in HANA studio i am getting the correct output which is 3.

Due to this i am not able to proceed further.

I checked note 1793145 but it didnt fix my issue.

Please let me know if anybody faces similar issue

[former_member247883]

Dear:

You can solve that error with the SAP note Note 1824729 - Error in com.sap.hdb.sl.lib.jar / HdbSlLib

Download the attach, extract with SAPCAR and paste and replace  on the sapinst directory, and retry the sapinst.

Best Regards

[Former Member]

Hi Carlos - Thanks. But SAP created this very note for this issue based on my OSS message.

[lbreddemann]

Hi there,

Did you check, whether the statisticsserver process is up and running?

Looks like for some reason the statsserver doesn't appear in the system landscape services view (M_SERVICES).

- Lars

[Former Member]

Hi Lars,

its up and running fine...HANA studio gives me correct output(below)... I tried restarting the complete HANA servers as well....Didn't help the issue.

**********

Statement 'SELECT ACTIVE_STATUS FROM SYS.M_SERVICES WHERE SERVICE_NAME = 'statisticsserver'' successfully executed in 29 ms 918 µs  (server processing time: 0 ms 617 µs)

Fetched 3 row(s) in 0 ms 20 µs (server processing time: 0 ms 0 µs)

**********

Regards,

Durairaj

[lbreddemann]

Hmm... in that case I propose to open a support message for this.

- Lars