SLT Replication not replication tables after SPS09 Upgrade on HANA

[Former Member]

Hello All,

Recently I have upgraded HANA system from Rev 83 to SPS 09. After upgrade slt replication stopped working.

Tried creating a new configuration in SLT, below is the error while creating a new configuration.

Need your inputs on this

Please help

Regards,

Raj

[Former Member · Accepted solution]

Issue resolved.

1. Check DBCON, if the connection details are maintained if not maintain.

2. Run ADBC_TEST_CONNECTION in se38 and see if connection is successfull if not see dev_w* files at OS level for errors.

Below is the error after SPS09 Upgrade.

With SAP HANA SP9, the revision indicator in the version number has changed to 3

places (1.xx.xxx).

"Database release is HDB 1.00.090.00.1413897729        54  0.055046

  ***

ERROR => Using non supported HANA version: 1.00.090.00.1413897729

  ***

ERROR => Min. version for this release must be 1.00.62"

1952701 - DBSL supports new SAP HANA SP9 version number

Regards,

Raj

[former_member231215 · Accepted solution]

We need to update Kernel in SLT system or ECC source system? I think it should be updated in ECC source system, please correct me if I am wrong

[Former Member]

Hi Dheeraj

I was facing one issue similar issue

and i want to know if you can help me with this

I have this error in one log

___________________________________________________________________________________________________

C  Database release is NewDB 1.00.102.04.1453734118

C  *** ERROR => Using non supported NewDB version: 1.00.102.04.1453734118

[dbhdbsql.cpp 119]

C  {root-id=00163E0940231EE682FD040F89832D94}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => Min. version for this release must be 1.00.17

[dbhdbsql.cpp 120]

C  {root-id=00163E0940231EE682FD040F89832D94}_{conn-id=00000000000000000000000000000000}_0

_________________________________________________________________________________________________________

The from here

its important to know that I have 2 SIDs

one CD1  HANA in version NewDB 1.00.102.04 and SD1 MAXDB on version 7.9.07 (This is the SLT and its MaxDB)

Both sids have the same hdbclient

In this version

HDBSQL version 1.00.102.04 Build 1453734118-1530,

and when I run the Transaction se38 and run the report  ADBC_TEST_CONNECTION  with the customer connection

return this

Testing a Database Connection Defined in DBCON

Could not open connection TMPXXXXXXXX20160415134217

DBI error    16  occured.

See trace file for further info:    dev_w**

and when i check in the logs apear the error that i put first

C  *** ERROR => Using non supported NewDB version: 1.00.102.04.1453734118

C  *** ERROR => Min. version for this release must be 1.00.17

I already patched the DBSL on the version

lib_dbsl_620-10007262.sar

But it didn't work for me the system

Reboot normaly

without problems but when I run the se38 for the connection test

It appears in the same way the same issue of

C  *** ERROR => Using non supported NewDB version: 1.00.102.04.1453734118

C  *** ERROR => Min. version for this release must be 1.00.17

I hope that you can give me a hand on this.

Regards

Oziel Garza from Mexico

[Former Member]

Hello Oziel,

could you please let me know the output for the below commands... from you application servers.

-->which hdbsql

--> <output of above command> -v

have upgraded hana client on all the application servers ? can help me with the sm21 scrteen shot after report test connection

Please check the DBCO entry if the db string ius maintian properly as <hostname>:<3<instance no>15 and its accessible.

Please let me know.

Regards

Amar Ghuge

[Former Member]

Hi Amar Ghuge,

This is the info that you ask

hec03v00XXXX:sd1adm 59> ./hdbsql -v

HDBSQL version 1.00.102.04 Build 1453734118-1530, the SAP HANA Database interactive terminal.

Copyright 2000-2016 by SAP SE.version 1.00.102.04

*Yes the in the manifiest on folder hdbclient this have the version 1.00.102.04 on both servers

Do you have further info,
somebody said  that may be I need to update the kernel
cause my kernel is on 720_REL

and it could help?

Do you think that way

I hope that you can help me with this.

Regards

Oziel Garza

[Former Member]

Hello Oziel,

As per the screen shot you have the authorization error, please check the DBCO connection strings for user names and check the status of the user in HANA DB whether it is locked or something.

please let me know update on this, this should help you.

also it is recommended to you the same client as of HANA revision , not mandatory but recommended

Amar Ghuge

[Former Member]

Hi Amar Ghuge

I fixed this issue updating the kernel release

also I update the DBSL libraries to the HANA version in both systems,
but it works after the kernel release update

Thanks for your help and support

Regards
Oziel Garza

[Former Member]

Hello,

Please mark your ans as completed and close the thread it will help others.

amar

[tobias_koebler]

Have you checked SM21 for DB errors? We are not aware of any issues that occures after this upgrade.

Best, Tobias

[Former Member]

Yes Tobias, I have checked and below are screenshots.

Also,

hdbclient on SLT is 1.81and on HANA its 1.90 will there be any issues establishing connection to HANA ?

Regards,

Raj

[Saritha_K]

Hi Raj,

Please refer to below thread once.

http://scn.sap.com/thread/3161308

.

Regards,

Saritha K

[tobias_koebler]

You do try to connect to a MultiDB Hana?

[Former Member]

Thanks Saritha,

We have a config working on SLT, but another config is not working.

Regards,

Raj

[Former Member]

We have multiple HANA systems(X & Y) on one server. X is upgraded to HANA SPS 09 and Y is on SPS 08.

Also, we have a SLT where we configure multiple connections to X & Y systems. On this SLT system hdbclient in 1.81.XX, where as on X its 1.90 and on Y its 1.83.

Config related to X has stopped replicating data and Config Y is working fine.

And are you reffereing to multitenant DB feature of HANA? if so, No

Please suggest

Regards,

Raj

[Former Member]

Hi Raj,

Also before creation of new SLT configuration for X , ensure that SYSTEM user is activated & not locked. Also truncate the table RS_REPLICATION Component from HANA side before doing the configuration.

Just a query-For X, have you tried with IP instead of hostname? Just check that.

Regards,

Joydeep