DB Analyzer error in DB50 when reading logs

[Former Member]

Hi All:

I have the 7.6.03.09 DB. I have enabled DB Analyzer and it is running with no issues. It collects logs (apparently).

When I go to DB50 and go to the "bottleneck" analysis and open any log folder it says "Error opening log file" (message SADA001)

Also (maybe totally unrelated) ...if I go to DB59 and check the db instance, it shows all versions to be as is above except SQLDBC version is 7.6.00.2.

Please assist.

Thanks

TOny

[former_member229109 · Accepted solution]

Hello Tony,

-> What is the SP of the SAP basis on your system?

How many application servers do you have?

Do you have the database running on the application server?

Please update with output 'sdbgegview -l' on the database & application servers.

Please create the SAP ticket to 'BC-DB-SDB' component, therefore we will be able to logon to your system and check the status of the problems.

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Natalie:

Here is the sdbregview:

DB Analyzer d:/sapdb/programs 7.6.03.09 32 bit valid

Server Utilities d:/sapdb/programs 7.7.03.18 32 bit valid

PCR 7300 d:/sapdb/programs 7.3.00.59 valid

PCR 7301 d:/sapdb/programs 7.3.01.22 valid

PCR 7500 d:/sapdb/programs 7.5.00.46 32 bit valid

PCR 7104 d:/sapdb/programs 7.1.04.45 valid

WebSQL d:/sapdb/programs 7.6.03.09 valid

SAP Utilities d:/sapdb/programs 7.6.03.09 32 bit valid

WebDAV Servlet d:/sapdb/programs 7.6.03.09 valid

Base d:/sapdb/programs 7.6.03.09 32 bit valid

Redist Python d:/sapdb/programs 7.6.03.09 32 bit valid

JDBC d:/sapdb/programs 7.6.03.03 valid

Messages d:/sapdb/programs MSG 0.5603 valid

ODBC d:/sapdb/programs 7.6.03.09 32 bit valid

Database Kernel d:/sapdb/bid/db 7.6.03.09 32 bit valid

Database Kernel c:/program files/sdb/maxdb1 7.6.03.09 32 bit valid

Loader d:/sapdb/programs 7.6.03.09 32 bit valid

SQLDBC d:/sapdb/programs 7.6.03.09 32 bit valid

SQLDBC 76 d:/sapdb/programs 7.6.03.09 32 bit valid

Fastload API d:/sapdb/programs 7.6.03.09 32 bit valid

PCR 7403 d:/sapdb/programs 7.4.03.49 32 bit valid

All is on 1 server. Only 1 app server.

Tony.

[lbreddemann · Accepted solution]

Hi Tony,

please check if installing patch 7.6.03 Build 11 fixes that issue.

I came across the same issue and Build 11 seem to have fixed it (PTS 1151727).

Best regards,

Lars

[Former Member · Accepted solution]

Excellent .. this worked.