R3Trans - Connection failed (RTE:could not create comm. shared memory [5])

[Former Member]

Hi all,

I am having trouble using the R3Trans utility in the command line... The SAP instance runs perfectly, so this is not about installation problems or problems getting SAP to run. I am trying to use the R3Trans tool in the command prompt to do an advanced transport export.

We are running a central instance with all on same server:

- Windows Server 2008 R2

- MaxDB 7.6

- ECC6 (SAP_BASIS 700 patch 0014)

- System ID is K5D

- SAP Kernel version = 700

- R3trans version = 6.14

When I run "R3Trans -x" logged in as k5dadm, I get the following in the trans.log file: (extract)

4 ETW000 r3trans version 6.14 (release 700 - 23.07.10 - 09:23:00).
4 ETW000 unicode enabled version
4 ETW000 control file: <no ctrlfile>
...
4 ETW000  [dev trc     ,00000]  New connection 0 created                                                  12  0.036684
4 ETW000  [dev trc     ,00000]  000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO 
...
4 ETW000  [dev trc     ,00000]  db_con_connect (con_name=R/3)                                             12  0.036792
4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:                13  0.036805
4 ETW000  [dev trc     ,00000]  000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,
4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO 
...
4 ETW000  [dev trc     ,00000]  DBSDBSLIB : version 700.08, patch 0.272 (Make PL 0.278)                   50  0.036922
4 ETW000  [dev trc     ,00000]  MAXDB shared library (dbsdbslib) patchlevels (last 10)                    43  0.036965
...
4 ETW000  [dev trc     ,00000]   -> getNewConnection()                                                    13  0.040627
4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=1936) : 0000000009DE0460 (1146260 bytes allocated)
4 ETW000                                                                                53  0.040680
4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=608) : 0000000009DE0C10 (1146884 bytes allocated)
4 ETW000                                                                                89  0.040769
4 ETW000  [dev trc     ,00000]   <- getNewConnection(con_hdl=0)                                          111  0.040880
4 ETW000  [dev trc     ,00000]   -> checkEnvironment(con_hdl=0)                                           26  0.040906
4 ETW000  [dev trc     ,00000]   -> connect()                                                             26  0.040932
4 ETW000  [dev trc     ,00000]  INFO : SQLOPT= -I 0 -t 0 -S SAPR3                                         46  0.040978
4 ETW000  [dev trc     ,00000]  Try to connect (DEFAULT) on connection 0 ...                              59  0.041037
4 ETW000  [dbsdbsql    ,00000]  *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:could not create comm. shared memory [5]))
...

I have already read and implemented note 688028 for SAPServiceK5D and K5Dadm, but this did not work. I have also added both those users to the "Administrators" group, but still no luck.

Here is the output of "sdbregview -l":

DB Analyzer         c:/sapdb/programs    7.6.03.09     64 bit    valid
Server Utilities    c:/sapdb/programs    7.6.03.09     64 bit    valid
PCR 7300            c:/sapdb/programs    7.3.00.59               valid
PCR 7301            c:/sapdb/programs    7.3.01.22               valid
PCR 7500            c:/sapdb/programs    7.5.00.46     64 bit    valid
SAP Utilities       c:/sapdb/programs    7.6.03.09     64 bit    valid
Redist Python       c:/sapdb/programs    7.6.03.09     64 bit    valid
Base                c:/sapdb/programs    7.6.03.09     64 bit    valid
JDBC                c:/sapdb/programs    7.6.03.03               valid
Messages            c:/sapdb/programs    MSG 0.5603              valid
ODBC                c:/sapdb/programs    7.6.03.09     64 bit    valid
Database Kernel     c:/sapdb/k5d/db      7.6.03.09     64 bit    valid
Loader              c:/sapdb/programs    7.6.03.09     64 bit    valid
SQLDBC              c:/sapdb/programs    7.6.03.09     64 bit    valid
SQLDBC 76           c:/sapdb/programs    7.6.03.09     64 bit    valid
Fastload API        c:/sapdb/programs    7.6.03.09     64 bit    valid

Does anyone know how I can sort this out?

[markus_doehr2 · Accepted solution]

You may have run into the configured MaxTask/MAXUSER limit (no more users able to connect).

How big is this parameter configured?

Markus

[Former Member · Accepted solution]

Hi Markus,

Are you talking about the MaxDB parameter called MAXUSERTASKS? If so the value is set to 50. If that's not the parameter you are talking about, how do I find it?

[former_member188883]

Hi David,

In the log posted by you:
u201CLOG BY0=>Connection failed (RTE:[1] could not create comm. shared memory [5]) dblink#3 @ 431u201D

-> Please check the solution of SAP Note No. 688028.

Hope this answers your query.

Regards,

Deepak Kori

[Former Member]

Hi Deepak - I mentioned in my first post that I had already implemented not 688028 which didn't help...

I am running on a VM (Hyper-V) - not really sure if that would make any difference.