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 cranece (DBA / Basis )
on Mar 10 at 12:12 PM
Dean,
No, I do not see the event in dev_rd.

And as to when. This has been happening 'forever'. But we (I) was hoping that the ECC upgrade and associated new OS/DB servers would automagically fix this issue.

Yesterday though we impacted our warehouse and thus our customers so I thought this forum might have some additional ideas for me. The network folks have looked and each time see nothing.

We have moved SAP background jobs and tape backup jobs of the OS. The only job that I know is running during the 0000-0100 timeframe is the database backup which starts at 2300 and typically ends by 0800 - the database is over 600 GB.

FYi - it did not happen this morning.

Thank you for your time,
Carla

---------------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
  
Most Popular White Papers

In the Spotlight
Overcome the Top Inhibitors to Cloud Computing. View the IBM Cloud Briefing, Available on Demand.
_.____.__

0 comments:

Post a Comment

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