We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE: [sap-basis] Runtime error DBIF_REPO_SQL_ERROR cause?

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by Waelz, Dean
on Mar 8 at 4:44 PM
Good Day Carla

Can you see the event occur in dev_rd (gateway log)?

Can you pinpoint the first time when it started to occur? What else happened at that same time?

Regards,

---------------Original Message---------------
From: cranece
Sent: Tuesday, March 08, 2011 3:05 PM
Subject: Runtime error DBIF_REPO_SQL_ERROR cause?

Our landscape is comprised of:
Windows 2008, sp 2
SQL Sever 2005, sp 3
We have 7 application servers
ECC 6.0

The issue is that we co have communication issues with our application nodes that then cause performance problems for our end users.

• The issue manifests itself via dumps in ST22 (DBIF_REPO_SQL_ERROR & DBIF_REPO_INTERNAL_ERROR are the two most frequent)

• There are days when it does not happen, there are days when it happens multiple times.
o Typically it happens early in the morning (0000-0100) and is isolated to a single app node - however
? Yesterday it started on AppServer1 (0000-0022), moved to AppServer6 (0100-0117) and then on to AppServer2 (1058 – 1108)
? This morning it was AppServer4 and it happened between 0100 & 0200

• The SAP application, the Client and the User change

• On the database server there are no indications of issues in the system or SQL Server error logs

• On the SAP application server(s) there are SAP log entries (dev_w0) corresponding to the dumps (example sent yesterday) but nothing in the system error logs. The dev_w0 shows OpenOledbConnection errors: Login timeout expired, An error has occurred while establishing a connection, TCP Provider: No connection could be made because... (can't see the remaining text)


Thank you for any ideas and suggestions,
Carla

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Waelz, Dean
SAP Basis Helper

Posted helpful replies on 5 threads in a group to earn a Bronze Achievement
Most Popular White Papers

In the Spotlight
Get Fast, Reliable Enterprise-Class Storage. Learn About IBM Storwize® v7000
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language