Instance failed to start after kernel replacment

[former_member142535]

Hi Expert,

My SAP instance cannot start up after replace the kernel to 742 lvl 200.

The SAP Note 2168574 should be the solutions.

However, new error occur as below after I have done the solution 1 from this note.

Solution 1

Update the SSFS connection data so that it points to your HANA database. Execute the following command as <sid>adm user: rsecssfx put DB_CONNECT/<hostname>:3<Instance #>15 -plain

Error

C  Loading SQLDBC client runtime ...

C  SQLDBC Module  : D:\usr\sap\D03\hdbclient\libSQLDBCHDB.dll

C  SQLDBC Runtime : libSQLDBCHDB 1.00.82.00 Build 0394270-1510

C  SQLDBC client runtime is 1.00.82.00.0394270

C  Try to connect as SAPSR3/<pwd>@acmhdbd03:31015 on connection 0 ...

C  *** ERROR => Connect to database failed, rc=1, rcSQL=10

[dbhdbsql.cpp 512]

C  SQLCODE    : 10

C  SQLERRTEXT : invalid username or password:

B  ***LOG BY2=> sql error 10     performing CON [dbsh         1252]

B  ***LOG BY0=> invalid username or password:  [dbsh         1252]

B  ***LOG BY2=> sql error 10     performing CON [dblink       573]

B  ***LOG BY0=> invalid username or password:  [dblink       573]

M  ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 79]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c   2407]

M 

R3trans -d also reply the same error from trans.log.

I have replace r3load ,tp and so on with the latest level. But, still the same.

Fyi, HANA db version is Rivision 82 and the system is working find with kernel 742 lvl 28.

Kindly advise if you have any idea.

Thank you.

BRs,

Por.

[AtulKumarJain · Accepted solution]

Hi Joo,

What is your relase of your SAP instance.

Please check below recommendation

NetWeaver 7.4 Support Package	requires SAP HANA minimal Revision	recommended SAP HANA Revision **
SP02 (released on 10.05.2013)	HDB SPS04 revision 45 or higher
SP03 (released on 15.07.2013)	HDB SPS04 revision 53 or higher
SP04 (released on 30.09.2013)	HDB SPS04 revision 56 or higher
SP05 (released on 20.12.2013)	HDB SPS06 revision 63 or higher *	HDB SPS06 maintenance revision 69 or higher *
SP06 (released on 28.03.2014)	HDB SPS06 revision 63 or higher *	HDB SPS06 maintenance revision 69 or higher *
SP07 (released on 10.06.2014)	HDB SPS07 revision 73 or higher *	HDB SPS07 maintenance revision 74 or higher *
SP08 (released on 15.09.2014)	HDB SPS08 revision 81 or higher *	HDB SPS08 maintenance revision 85 or higher *
SP09 (released on 24.11.2014)	HDB SPS08 revision 82 or higher *	HDB SPS08 maintenance revision 85 or higher *
SP10 (released on 09.03.2015)	HDB SPS08 maintenance revision 85 or higher *	HDB SPS08 maintenance revision 85 or higher *
SP11 (released on 01.06.2015)	HDB SPS08 maintenance revision 85 or higher *	HDB SPS08 maintenance revision 85 or higher *
SP12 (planned for August 2015)	HDB SPS08 maintenance revision 85 or higher *	HDB SPS08 maintenance revision 85 or higher

more information please check sap note 1914052

BR

AKJ

[former_member142535 · Accepted solution]

Hi AKJ, My SAP system is ERP6.0 EHP7 and SAP NW is SAPKB74008 - SPS 8. HANA DB version is 82. No error if use back the old kernel which is 742 lvl 28. But, I need to upgrade the kernel to the latest(prerequisite) for add on installation. Please advise if you have any idea. Thank you. Regards, Por.

[AtulKumarJain · Accepted solution]

Hi Joo,

You need to upgrade your HDB to SAP recommended level,you can do this in sandox environment before moving to other environment.

Please also check this

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/802456c5-dba5-3110-7284-b67945cdc...

2178917 - SAP Support Package Stack Kernel 7.42 Patch Level 200

I hope SAP also suggest the same solution.

BR

AKJ

[former_member142535]

Hi all, Thanks you guys for your advise. The problem is solved after execute below command. rsecssfx put DB_CONNECT/DEFAULT_DB_USER -plain rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD Thank you. BRs, Por.

[lucas_oliveira]

Hi Soon Joo Por,

This sounds like a switch from hdbuserstore to SSFS due to the upgrade (no clue why this would be forced...).

It should be clear on your trans.log file (result of R3trans -d) if you're using hdbuserstore or SSFS. If you're using the later and previously used hdbuserstore you can, for the moment, deactivate it's usage with step 2 of  2168574.

I understand SSFS is now a best practice so it might be important to configure it properly.

BRs,

Lucas de Oliveira

[Former Member]

Hello Soon,

before touching on SSFS, Please try updating DBSL patch also.

then try.

Regards

Anand

[former_member142535]

Hi Anand, Yes. I have update the DBSL as well. But, still no luck. Thank you. Regards, Por.