cancel
Showing results for 
Search instead for 
Did you mean: 

Is possible to import the TR using TP.EXE with local system user

vivekananthan_sellavel
Active Participant
0 Kudos

Hi ,

Currently I am trying to import the TR using the TP.exe. Could please let me know is mandatory to use <SID>adm user. If yes could please let me know the procedures.

Because I try with local user but it was failed. Even though I set same environment variable (Both User and System).

Regards,

Vivek

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

SIDADM has the required environment to maintain and operate that SAP Instance. SIDADM will be part of DBA and SAPSYS groups which allows him execute TP and R3Trans which are required to import or export the TR's.

The local user you are trying to use, is he part of SAPSYS and DBA gruops?

Thanks

SM.

Former Member
0 Kudos

Hi Avishek...,

Really thanks for your advice.

It is having the admin rights but i am not sure whether it is in DBA group. If no then how can i add the user in both SAPSYS and DBA group.Is there any specific role i need to add to that user.FYI. I cross checked the both user SIDADM and local user but it is having the same user right .

P.S: I am using the MAXDB

Regards,

vivek

Former Member
0 Kudos

I'm not sure about MAXDB, but try to execute the

"tp connect <sapsid> and R3trans -d" using the local user and paste the error in reply.

Thanks

SM

Former Member
0 Kudos

Hi ,

Please find the log below

I am using the correct commend. if i try in SIDADM user it working fine.when i try with local user is not working.So i was confused.

This is tp version 372.04.40 (release 701, unicode enabled)

TRACE-INFO: 1: [dev trc ,00000] Thu May 12 00:09:50 2011 1042 0.001042

TRACE-INFO: 2: [dev trc ,00000] load shared library (dbsdbslib.dll), hdl 0, addr 0000000186C80000

TRACE-INFO: 3: 5 0.001047

TRACE-INFO: 4: [dev trc ,00000] using "E:\usr\sap\EC6\SYS\exe\uc\NTAMD64\dbsdbslib.dll"

TRACE-INFO: 5: 5 0.001052

TRACE-INFO: 6: [dev trc ,00000] } DbSlSdbControl(rc=0) 81 0.001133

TRACE-INFO: 7: [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=39,arg_p=0000000000000000)

TRACE-INFO: 8: 8 0.001141

TRACE-INFO: 9: [dev trc ,00000] } DbSlSdbControl(rc=0) 8 0.001149

TRACE-INFO: 10: [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=10,arg_p=000000000202EBE0)

TRACE-INFO: 11: 8 0.001157

TRACE-INFO: 12: [dev trc ,00000] } DbSlSdbControl(rc=0) 4 0.001161

TRACE-INFO: 13: [dev trc ,00000] { DbSlSdbControl(con_hdl=-1,command=10,arg_p=0000000140E5A1E8)

TRACE-INFO: 14: 15 0.001176

TRACE-INFO: 15: [dev trc ,00000] } DbSlSdbControl(rc=0) 5 0.001181

TRACE-INFO: 16: [dev trc ,00000] { DbSlSdbConnect(con_info_p=0000000000000000) 18 0.001199

TRACE-INFO: 17: [dev trc ,00000] DBSDBSLIB : version 700.08, patch 0.024 (Make PL 0.32) 18 0.001217

TRACE-INFO: 18: [dev trc ,00000] MAXDB shared library (dbsdbslib) patchlevels (last 10) 7 0.001224

TRACE-INFO: 19: [dev trc ,00000] (0.024) Default value for max. input variables is 2000 (note 655018)

TRACE-INFO: 20: 9 0.001233

TRACE-INFO: 21: [dev trc ,00000] (0.024) Profile parameter to define max. input variables (note 655018)

TRACE-INFO: 22: 9 0.001242

TRACE-INFO: 23: [dev trc ,00000] (0.024) Switch SQLMODE after CREATE INDEX SERIAL (note 1267841)

TRACE-INFO: 24: 8 0.001250

TRACE-INFO: 25: [dev trc ,00000] (0.024) Input parameters for SQL statements increased (note 655018)

TRACE-INFO: 26: 7 0.001257

TRACE-INFO: 27: [dev trc ,00000] (0.018) Create index serial for MaxDB 7.6 (note 1267841)

TRACE-INFO: 28: 8 0.001265

TRACE-INFO: 29: [dev trc ,00000] (0.018) More trace in case of packed to string conversion error (note 1262799)

TRACE-INFO: 30: 13 0.001278

TRACE-INFO: 31: [dev trc ,00000] (0.016) R3trans export aborts with signal 6 (note 1262245)

TRACE-INFO: 32: 7 0.001285

TRACE-INFO: 33: [dev trc ,00000] (0.009) IA64 alignment errors (note 1245982) 7 0.001292

TRACE-INFO: 34: [dev trc ,00000] (0.007) Support DB-Type 'SAP DB' by UPDSTAT (note 1225668)

TRACE-INFO: 35: 7 0.001299

TRACE-INFO: 36: [dev trc ,00000] 4 0.001303

TRACE-INFO: 37: [dev trc ,00000] -> init() 6 0.001309

TRACE-INFO: 38: [dev trc ,00000] -> sdb_malloc(size=18) : 0000000002810EB0 (34 bytes allocated)

TRACE-INFO: 39: 18 0.001327

TRACE-INFO: 40: [dev trc ,00000] STATEMENT_CACHE_SIZE = 1000 46 0.001373

TRACE-INFO: 41: [dev trc ,00000] -> sdb_malloc(size=152000) : 00000000028B9FA0 (152050 bytes allocated)

TRACE-INFO: 42: 16 0.001389

TRACE-INFO: 43: [dev trc ,00000] -> sdb_malloc(size=656000) : 0000000002C200B0 (808066 bytes allocated)

TRACE-INFO: 44: 13 0.001402

TRACE-INFO: 45: [dev trc ,00000] -> sdb_malloc(size=288000) : 0000000002CC10B0 (1096082 bytes allocated)

TRACE-INFO: 46: 11 0.001413

TRACE-INFO: 47: [dev trc ,00000] -> sdb_malloc(size=16144) : 0000000002D080B0 (1112242 bytes allocated)

TRACE-INFO: 48: 11 0.001424

TRACE-INFO: 49: [dev trc ,00000] -> sdb_malloc(size=32048) : 0000000002D0C020 (1144306 bytes allocated)

TRACE-INFO: 50: 11 0.001435

TRACE-INFO: 51: [dev trc ,00000] -> loadClientRuntime() 358 0.001793

TRACE-INFO: 52: [dev trc ,00000] Loading SQLDBC client runtime ... 7 0.001800

TRACE-INFO: 53: [dev trc ,00000] SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175

TRACE-INFO: 54: 339 0.002139

TRACE-INFO: 55: [dev trc ,00000] SQLDBC Library Version : libSQLDBC 7.6.5 BUILD 011-123-196-300

TRACE-INFO: 56: 8 0.002147

TRACE-INFO: 57: [dev trc ,00000] SQLDBC client runtime is MaxDB 7.6.5.011 CL 196300 21 0.002168

Regards,

vivek

Former Member
0 Kudos

Hi Vivek,

Please go through the below link:

http://help.sap.com/saphelp_sm32/helpdata/en/3d/ad5b744ebc11d182bf0000e829fbfe/content.htm

This will provide you all the information that you need while doing transport.

You have to login to the OS with <SID>adm user.

Anymore issues, let me know.

Avishek...