on 10-07-2008 7:26 PM
Hi experts,
We created a DB Connect source system in our BI Dev environment, and successfully extracted data there.
However, when we try the same connection in our QA environment, we get an error that the system cannot be connected to.
Our BI (7.0) is on Oracle 11, and our source is on an MS SQL server (2000).
Diagnosis
The database system XXXX is not accessible.
System Response
The system tried but failed to establish a database link. A short dump has been registered.
This connection was used successfully in the past (several months ago), but now the connection no longer works. We have checked the connection parameters, and there are no entries in the error log for the source system. We have successfully done some loads into BI Dev, so we know the systems can still communicate. We also just did a restart of our BI QA system.
Any hints, suggestions, or solutions would be most welcome!!
Thanks,
Darryl
Hi Darryl,
did you check the firewall and network connections ?
What infos are in the short dump ?
Kind regards,
Jürgen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jurgen,
Thanks for your reply. I'm pretty sure we checked those, but will ask our network guys again.
The message details (from SM21) are:
Unexpected return value 14 when calling up CON
When calling a function within the database interface, a return value which cannot be processed by the calling function was provided.
Technical details
File: 23
Offset: 142380
RecFm: h
System log type: Database Error (Non-SQL)
SysLogMsgGrp: BZ
SubName(N): Y
variable message data:
14 CON dbds 1057
it appears that nothing is in the ST22 dump log..
Thanks!
Darryl
Update: It appears that this is an intermittent connection issue. We are able to activate and check the connection successfully sometimes, and at other times this does not work. This is a random event, so is quite perplexing...
Edited by: Darryl Goveas on Oct 10, 2008 4:20 PM
our Dev BI box is co-located with the system we were connecting to. Our QA BI box is in another site. Network issues were causing the intermittent connection issues from our QA BI system to this source.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please perform this tasks;
Check value of DIR_LIBRARY environment variable on Your BI system:
u2022 DIR_LIBRARY
(DIR_LIBRARY = /usr/SAP/C 11/SYS/exe/run
dbms_type = ora)
Since the BI system is based on Oracle, you will need to install an additional database library, so that the BW system can access a Microsoft SQL Server database.
Download that library (Under the guidance of SAP Notes 323151 and 400818)
Target BI Platform: 64-bit Windows 2003 / Oracle
Source SQL Platform: 64-bit Windows 2003 / MS SQL
Downloaded the MS SQL database Library patch level 138: lib_dbsl_138-20001375.sar from the 64-bit Windows, SQL SAP kernel, Application Server ABAP section of SMP.
Set the System environment variable:
DIR_LIBRARY = F:\usr\sap\XYZ\SYS\exe\uc\NTAMD64 - (yours might be a bit different)
Unpacked the file lib_dbsl_138-20001375.sar in the E:\software\SQL DB Library\ directory.
Files:
dbmssslib.dll
dbmssslib.pdb
extracted and copied to kernel directory to ensure that they are in the PATH, as we as that they are in the DIR_LIBRARY env variable.
Setting up the Database Connection inside the BI system
Before this section can be complete, you have to have completed the section:
Installing the database shared library
Maintaining an entry in DBCON.
Go to transaction SM30 in your BI system:
Create a u201CNew Entryu201D
u2022 BW Administrator Workbench (RSA1) Goto Modeling
u2022 Source Systems (Root Nodes) Context Menu (right mouse click) Create
u2022 In the following dialog box, choose the source system type Dat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.