Problem with tp import in command line

Former Member · ‎02-07-2008

Hi,

We have a little problem with the tp.exe utility for the import, as the addtobuffer order is working well it's impossible to make an import, tp command couldn't authenticate on SQL Server

I tried to do it with a Windows domain account (as SQL Server services are running with domain account) and local account.

I guess there may be a problem with an environment variable but couldn't find information to solve it on SAP Notes.

Here is the following result of the tp execution.

Thanks a lot for your help.

C:\>E:/usr/sap/V05/DVEBMGS00/exe/tp.exe IMPORT DEVK903214 V05 client=400 U01 pf=
E:/usr/sap/trans/bin/TP_DOMAIN_V05.PFL
This is E:/usr/sap/V05/DVEBMGS00/exe/tp.exe version 371.02.23 (release 700, unic
ode enabled)
Warning: Parameter DBHOST is no longer used.
Warning: Parameter DBNAME is no longer used.
ERROR: Connect to V05 failed (20080207123211, probably wrong environment).
TRACE-INFO: 1:  [dev trc     ,00000]  Thu Feb 07 12:30:39 2008
                   7997  0.007997
TRACE-INFO: 2:  [dev trc     ,00000]  load shared library (dbmssslib.dll), hdl 0
                      9  0.008006
TRACE-INFO: 3:  [dev trc     ,00000]      using "E:\usr\sap\V05\DVEBMGS00\exe\db
mssslib.dll"          8  0.008014
TRACE-INFO: 4:  [dev trc     ,00000]  Thread ID:548
                   7324  0.015338
TRACE-INFO: 5:  [dev trc     ,00000]  Thank You for using the SLOLEDB-interface
                     37  0.015375
TRACE-INFO: 6:  [dev trc     ,00000]  Using dynamic link library 'E:\usr\sap\V05
\DVEBMGS00\exe\dbmssslib.dll'
TRACE-INFO: 7:
                     64  0.015439
TRACE-INFO: 8:  [dev trc     ,00000]  dbmssslib.dll patch info
                    122  0.015561
TRACE-INFO: 9:  [dev trc     ,00000]    patchlevel   0
                     12  0.015573
TRACE-INFO: 10:  [dev trc     ,00000]    patchno      87
                      20  0.015593
TRACE-INFO: 11:  [dev trc     ,00000]    patchcomment MSSQL: UTAB/ATAB/Dynp-acce
ss via clientside cursor (1002914)
TRACE-INFO: 12:
                      37  0.015630
TRACE-INFO: 13:  [dev trc     ,00000]  np:(local) connection used on TAEL
                     138  0.015768
TRACE-INFO: 14:  [dev trc     ,00000]  CopyLocalParameters: dbuser is 'dbo'
                      49  0.015817
TRACE-INFO: 15:  [dev trc     ,00000]  Using Provider SQLNCLI
                   25215  0.041032
TRACE-INFO: 16:  [dev trc     ,00000]  OpenOledbConnection: MARS property was se
t successfully.      428  0.041460
TRACE-INFO: 17:  [dev trc     ,00000]  Thu Feb 07 12:30:54 2008
                 14267045  14.308505
TRACE-INFO: 18:  [dev trc     ,00000]  OpenOledbConnection: line 23531. hr: 0x80
00ffff Login timeout expired
TRACE-INFO: 19:
                      64  14.308569
TRACE-INFO: 20:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 0, sev 0), Login timeout expired
TRACE-INFO: 21:
                     201  14.308770
TRACE-INFO: 22:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  14.308781
TRACE-INFO: 23:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 2, sev 0), An error has occurred while establishing a c
onnection to the server. When connecting to SQL Server 2005, this failure may be
 caused by the fact that under the default settings SQL Server does not allow re
mote connections.
TRACE-INFO: 24:
                     208  14.308989
TRACE-INFO: 25:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  14.309000
TRACE-INFO: 26:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a conne
ction to SQL Server [2].
TRACE-INFO: 27:
                      92  14.309092
TRACE-INFO: 28:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      10  14.309102
TRACE-INFO: 29:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 0, sev 0), Invalid connection string attribute
TRACE-INFO: 30:
                      97  14.309199
TRACE-INFO: 31:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  14.309210
TRACE-INFO: 32:  [dev trc     ,00000]  Using Provider SQLNCLI
                   12626  14.321836
TRACE-INFO: 33:  [dev trc     ,00000]  OpenOledbConnection: MARS property was se
t successfully.      126  14.321962
TRACE-INFO: 34:  [dev trc     ,00000]  Thu Feb 07 12:31:09 2008
                 14282545  28.604507
TRACE-INFO: 35:  [dev trc     ,00000]  OpenOledbConnection: line 23531. hr: 0x80
00ffff Login timeout expired
TRACE-INFO: 36:
                      18  28.604525
TRACE-INFO: 37:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 0, sev 0), Login timeout expired
TRACE-INFO: 38:
                      33  28.604558
TRACE-INFO: 39:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  28.604569
TRACE-INFO: 40:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 2, sev 0), An error has occurred while establishing a c
onnection to the server. When connecting to SQL Server 2005, this failure may be
 caused by the fact that under the default settings SQL Server does not allow re
mote connections.
TRACE-INFO: 41:
                     105  28.604674
TRACE-INFO: 42:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  28.604685
TRACE-INFO: 43:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a conne
ction to SQL Server [2].
TRACE-INFO: 44:
                      93  28.604778
TRACE-INFO: 45:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  28.604789
TRACE-INFO: 46:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 0, sev 0), Invalid connection string attribute
TRACE-INFO: 47:
                      90  28.604879
TRACE-INFO: 48:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      28  28.604907
TRACE-INFO: 49:  [dev trc     ,00000]  Using Provider SQLNCLI
                   13862  28.618769
TRACE-INFO: 50:  [dev trc     ,00000]  OpenOledbConnection: MARS property was se
t successfully.       93  28.618862
TRACE-INFO: 51:  [dev trc     ,00000]  Thu Feb 07 12:31:24 2008
                 14282453  42.901315
TRACE-INFO: 52:  [dev trc     ,00000]  OpenOledbConnection: line 23531. hr: 0x80
00ffff Login timeout expired
TRACE-INFO: 53:
                      18  42.901333
TRACE-INFO: 54:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 0, sev 0), Login timeout expired
TRACE-INFO: 55:
                      33  42.901366
TRACE-INFO: 56:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      10  42.901376
TRACE-INFO: 57:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 2, sev 0), An error has occurred while establishing a c
onnection to the server. When connecting to SQL Server 2005, this failure may be
 caused by the fact that under the default settings SQL Server does not allow re
mote connections.
TRACE-INFO: 58:
                     207  42.901583
TRACE-INFO: 59:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  42.901594
TRACE-INFO: 60:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a conne
ction to SQL Server [2].
TRACE-INFO: 61:
                      96  42.901690
TRACE-INFO: 62:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  42.901701
TRACE-INFO: 63:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 0, sev 0), Invalid connection string attribute
TRACE-INFO: 64:
                     139  42.901840
TRACE-INFO: 65:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      14  42.901854
TRACE-INFO: 66:  [dev trc     ,00000]  failed to establish conn to np:(local).
                   14100  42.915954
TRACE-INFO: 67:  [dev trc     ,00000]  Retrying without protocol specifier: (loc
al)                   12  42.915966
TRACE-INFO: 68:  [dev trc     ,00000]  Using Provider SQLNCLI
                      60  42.916026
TRACE-INFO: 69:  [dev trc     ,00000]  OpenOledbConnection: MARS property was se
t successfully.       92  42.916118
TRACE-INFO: 70:  [dev trc     ,00000]  Thu Feb 07 12:31:40 2008
                 15010592  57.926710
TRACE-INFO: 71:  [dev trc     ,00000]  OpenOledbConnection: line 23531. hr: 0x80
00ffff Login timeout expired
TRACE-INFO: 72:
                      17  57.926727
TRACE-INFO: 73:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 0, sev 0), Login timeout expired
TRACE-INFO: 74:
                      35  57.926762
TRACE-INFO: 75:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  57.926773
TRACE-INFO: 76:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 2, sev 0), An error has occurred while establishing a c
onnection to the server. When connecting to SQL Server 2005, this failure may be
 caused by the fact that under the default settings SQL Server does not allow re
mote connections.
TRACE-INFO: 77:
                     124  57.926897
TRACE-INFO: 78:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  57.926908
TRACE-INFO: 79:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a conne
ction to SQL Server [2].
TRACE-INFO: 80:
                      91  57.926999
TRACE-INFO: 81:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      10  57.927009
TRACE-INFO: 82:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 0, sev 0), Invalid connection string attribute
TRACE-INFO: 83:
                      98  57.927107
TRACE-INFO: 84:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  57.927118
TRACE-INFO: 85:  [dev trc     ,00000]  Using Provider SQLNCLI
                   14582  57.941700
TRACE-INFO: 86:  [dev trc     ,00000]  OpenOledbConnection: MARS property was se
t successfully.      219  57.941919
TRACE-INFO: 87:  [dev trc     ,00000]  Thu Feb 07 12:31:55 2008
                 14861734  72.803653
TRACE-INFO: 88:  [dev trc     ,00000]  OpenOledbConnection: line 23531. hr: 0x80
00ffff Login timeout expired
TRACE-INFO: 89:
                      16  72.803669
TRACE-INFO: 90:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 0, sev 0), Login timeout expired
TRACE-INFO: 91:
                      78  72.803747
TRACE-INFO: 92:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  72.803758
TRACE-INFO: 93:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 2, sev 0), An error has occurred while establishing a c
onnection to the server. When connecting to SQL Server 2005, this failure may be
 caused by the fact that under the default settings SQL Server does not allow re
mote connections.
TRACE-INFO: 94:
                     253  72.804011
TRACE-INFO: 95:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  72.804022
TRACE-INFO: 96:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a conne
ction to SQL Server [2].
TRACE-INFO: 97:
                      86  72.804108
TRACE-INFO: 98:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc]
                      11  72.804119
TRACE-INFO: 99:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 235
31]: Error/Message: (err 0, sev 0), Invalid connection string attribute
TRACE-INFO: 100:
                      109  72.804228
TRACE-INFO: 101:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc
]                      10  72.804238
TRACE-INFO: 102:  [dev trc     ,00000]  Using Provider SQLNCLI
                    14286  72.818524
TRACE-INFO: 103:  [dev trc     ,00000]  OpenOledbConnection: MARS property was s
et successfully.      163  72.818687
TRACE-INFO: 104:  [dev trc     ,00000]  Thu Feb 07 12:32:11 2008
                  14653157  87.471844
TRACE-INFO: 105:  [dev trc     ,00000]  OpenOledbConnection: line 23531. hr: 0x8
000ffff Login timeout expired
TRACE-INFO: 106:
                       16  87.471860
TRACE-INFO: 107:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 23
531]: Error/Message: (err 0, sev 0), Login timeout expired
TRACE-INFO: 108:
                       31  87.471891
TRACE-INFO: 109:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc
]                      11  87.471902
TRACE-INFO: 110:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 23
531]: Error/Message: (err 2, sev 0), An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this failure may b
e caused by the fact that under the default settings SQL Server does not allow r
emote connections.
TRACE-INFO: 111:
                      104  87.472006
TRACE-INFO: 112:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc
]                      11  87.472017
TRACE-INFO: 113:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 23
531]: Error/Message: (err 2, sev 0), Named Pipes Provider: Could not open a conn
ection to SQL Server [2].
TRACE-INFO: 114:
                       90  87.472107
TRACE-INFO: 115:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc
]                      11  87.472118
TRACE-INFO: 116:  [dev trc     ,00000]  sloledb.cpp [OpenOledbConnection,line 23
531]: Error/Message: (err 0, sev 0), Invalid connection string attribute
TRACE-INFO: 117:
                       88  87.472206
TRACE-INFO: 118:  [dev trc     ,00000]  Procname: [OpenOledbConnection - no proc
]                       8  87.472214
TRACE-INFO: 119:  [dev trc     ,00000]  failed to establish conn. 0
                    14442  87.486656
TRACE-INFO: 120:  [dblink      ,00431]  ***LOG BY2=>sql error 0      performing
CON [dblink#3 @ 431]
TRACE-INFO: 121:
                      942  87.487598
TRACE-INFO: 122:  [dblink      ,00431]  ***LOG BY0=><message text not available>
 [dblink#3 @ 431]
TRACE-INFO: 123:
                       18  87.487616

tp returncode summary:

TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0232
tp finished with return code: 232
meaning:
  connect failed

Former Member · ‎02-07-2008

Cnam,

First verify / check to see that you could connect to the database at the command level:

R3trans -d

R3trans -x

Also check the values of DBHOST and DBNAME in the profile.

Thanks

BMG

Problem with tp import in command line

Accepted Solutions (0)

Answers (1)

Answers (1)

SAP S/4HANA Structure for Developer

Re: Questions on SDK APIs for Business Partners

Unable to connect to Datasphere using the CLI

Shared variable doesn't work when exported to exce...

Re: Datasphere Working Capital Dashboard for SAP S...