cancel
Showing results for 
Search instead for 
Did you mean: 

(DB) ERROR: db_connect rc = 256 in Import ABAP

Former Member
0 Kudos

I am installing ECC 6.0 SR1 EHP4 Ready in AIX 6.1 db2 9.1.7.

Got following error in step 27 (IMPORT ABAP)

ARNING 2011-03-03 16:42:02.173

CJSlibModule::writeWarning_impl()

Execution of the command "/usr/sap/WD1/SYS/exe/run/R3load -testconnect" finished with return code 2. Output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

/usr/sap/WD1/SYS/exe/run/R3load: START OF LOG: 20110303164202

/usr/sap/WD1/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP

/usr/sap/WD1/SYS/exe/run/R3load: version R7.01/V1.4 [UNICODE]

Compiled Feb 24 2009 21:54:08

/usr/sap/WD1/SYS/exe/run/R3load -testconnect

DbSl Trace: DbSlConnect to 'WD1' as 'sapwd1' failed

(DB) ERROR: db_connect rc = 256

DbSl Trace: DbSlConnect to 'WD1' as 'sapwd1' failed

(DB) ERROR: DbSlErrorMsg rc = 29

/usr/sap/WD1/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/WD1/SYS/exe/run/R3load: END OF LOG: 20110303164202

WARNING[E] 2011-03-03 16:42:02.176

CJSlibModule::writeError_impl()

Thanks

Amit Barnawal

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

The R3load looks well out of date, download the latest kernel bundle.

Can you do an R3trans -x and post the trans.log

Mark

Former Member
0 Kudos

This is ./R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

unicode enabled version

2EETW169 no connect possible: "environment variable dbms_type is not set."

./R3trans finished (0012).

Thanks

Amit

Answers (3)

Answers (3)

Former Member
0 Kudos

This is how i resolved issue without formating the system

This is an old post, i was having this problem, then i searched for solution on this page, but the solution to format the system is not a proper one and would not apply to a serious project. In my case as well, setting the environment and restarting system and sapinst with Run New option did not change anything. There are number of collected variables by sapinnst from the system and these are stored in usr/sap/<sid> directory and each time installation starts, sapinst uses this variables, if sapinst could not find this file, it will read the current system profile again for installation. Best practse is to delete the usr/sap directory and restart installation

Former Member
0 Kudos

All the R3load and R3trans is of current version only, so I formatted the system and tried once again, It worked.

former_member189546
Active Contributor
0 Kudos

Hello,

dbms_type

Must be always set to "mss" for SQL Server.

MSSQL_SERVER

Name of the SQL Server instance. E.g. "SQLSERVER" (default

instance on server "SQLSERVER") or "SAPSQL\PRD" (named instance

"PRD" on server "SAPSQL")

MSSQL_DBNAME

Name of the database, usually <SID> in uppercase letters.

MSSQL_SCHEMA

Name of the database schema, usually "dbo" in lowercase letters.

With an MCOD system, the database schema is <sid> in lowercase

letters.

regards,

John Feely

Former Member
0 Kudos

My problem get solved by reformatting the system.....

Thank you

Amit Barnawal