on 05-11-2011 11:50 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.