cancel
Showing results for 
Search instead for 
Did you mean: 

SQLDBC version not upgraded after MaxDB upgrade 7.6.03 to 7.7.07.26

Former Member
0 Kudos

MaxDB used for ERP 6.0 system, database and Central (only) Instance on same host, has been upgraded from 7.6.03 build 009 to 7.7.06 Build 10 and then patched to build 7.7.07.26. Both were successful according to logs. However, DB59 Connection Test still shows SQLDBC (Database Client) to be on version 7.6.06.16 although DBMRFC and DBMCLI are on 7.7.07.26. Also from ST04/DB50 when Tools > Database Studio is launched it starts Database Studio 7.6 and does not connect. Other patch levels:

DBMRFC Release 7.7.07.26

DBMCLI Release 7.7.07.26

Kernel Release 700_REL

Kernel Patch 236

DBSL Release 700.08

DBSL Patch 236

SQLDBC Runtime 7.6.06.16

O/S: SUSE Linux x64

Process followed to achieve above was from /instguides u2018GUIDE_MAX_UPG-UX-77-102.pdfu2019 and referenced notes. To try and resolve issue ran DBUPDATE.SH u2013client as per section 4.3 of the guide (although this should not have been necessary as DB and SAP instance are on same host. This gave message u2018cannot downgrade packageu2019. As per note 822239 I ran command 'sdbregview -l | grep -i SQLDBC' which came back with:

SQLDBC 77 /sapdb/programs 7.7.07.26 64 bit valid

SQLDBC /sapdb/programs 7.7.07.26 64 bit valid

SQLDBC 76 /sapdb/programs 7.6.06.16 64 bit valid

Which shows that there is an installed version of SQLDBC for 7.7.07.26 but it is not being called by SAP. I looked at note 649814 to try to understand if I have further steps to action to complete the upgrade but it is not clear to me what I have to do. Note 822239 also said to check SQLDBC being used by SAP in SM50 Process > Trace > Display File, and there it also confirms 7.6 is being used:

Loading SQLDBC client runtime ...

SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 002-121-083-965

SQLDBC Library Version : libSQLDBC 7.6.6 BUILD 016-123-239-726

SQLDBC client runtime is MaxDB 7.6.6.016 CL 239726

SQLDBC supports new DECIMAL interface : 0

SQLDBC supports VARIABLE INPUT data : 1

SQLDBC supports keepAlive indicator : 0

INFO : SQLOPT= -I 0 -t 0 -S SAPR3

Try to connect (DEFAULT) on connection 0 ...

Attach to SAP DB : Kernel 7.7.07 Build 026-123-240-463

Database release is SAP DB 7.7.07.026

u2026.

Now I'm connected to SAP DB

Can someone tell me what I have to do to complete the upgrade and bring SQLDBC up to version 7.7.07.26 (or at least get SAP to use 7.7.07.26 version which is already there) ?

Many Thanks,

James.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Jared,

That's really useful information, thank you. I also raised a message to SAP, about 12 hours after posting in SDN, same question. I thought I understood as you're saying, that the SQLDBC version relates to the kernel, although I wasn't sure if it was the SAP kernel or MaxDB kernel. So it's the SAP kernel ? It seems very strange as SAP recommend using Database Studio 7.7 for MaxDB 7.7 (and even for MaxDB 7.6 !) but then drive the Tools in DB50/ST04 based on SAP Kernel, not MaxDB kernel (so you end up with SQL Studio 7.6 and Database Manager 7.6 offered as the tools). Even more strange as you see SQLDBC 7.7 version is installed from output of sdbregview -l | grep -i SQLDBC. I guess I'll get the same response as you from SAP, but will let you know.

Thanks again,

James.

Former Member
0 Kudos

Yes it is the SAP Kernel.

Jared

former_member229109
Active Contributor
0 Kudos

Hello James,

as you are SAP customer, it's good idear to create the SAP message and get SAP support.

I hope that you already got the answers on the posted questions and the thread could be closed.

As you know, the SAP Note No. 822239 <4. and 14. > has answer on your question.

The assignment of the SAP kernel to the relevant SQLDBC versions can be found under point 14 in this note.

The SAP kernel is used with database dependent MAXDB DBSL that requires the compatible SQLDBC version,

see the answer on 14. in the SAP Note No. 822239.

What is the SAP kernel version of your system and OS of the application server?

Please also read the answers on the questions - 2., 5. and 9. -

in the SAP note:

822271 FAQ: SAP MaxDB client software

for more information on the SAP MaxDB client software.

As you saw, to operate the data assistant or liveCache assistant (transactions DB50/LC10) and the DBA planning calendar (transaction DB13), you require a minimum version of the client (DBMCLI) that corresponds to the relevant MaxDB database kernel. After you change the database version from 7.6 to 7.7, we recommend the MAXDB client upgrade on the application servers.

If you still have open questions on what version on the SAP MaxDB client software you need on the application servers and when the SAP MaxDB client software need to be updated/installed.

When you start the DBMGUI, SQLStudio or DB studio through DB50/LC10, the DBMGUI SQLStudio or DB studio is started on the same host where the SAPGUI runs. That would be your local desktop PC, where you run SAPGUI to connect to system.

What versions of DBMGUI, SQLStudio, DB studio installed on that PC ?

Regards, Natalia Khlopina

Former Member
0 Kudos

We had this exact problem when we went to MaxDB 7.8 from 7.6. I ended up opening up a message with SAP and the response that I was given is that the SQLDBC is tied to the SAP Kernel; and since I was running Kernel 700 then SQLDBC 7.6 is correct.

SAP response:

The sqldbc version is relevant for the SAP Kernel. As you system

is at kernel 700, the proper sqldba is indeed the 7.6, so as you

have already installed this version, the system should be working

as design. For more details about this, you may check the note:

822271 FAQ: SAP MaxDB client software

Regards,

Jared