on 10-07-2014 5:21 PM
Hi Experts,
we have built a new training system with QAS data via system copy.
now while importing Active system profiles in RZ10, we are facing error where the profiles are not able to upload in to application from OS.
we have checked SECSTORE Tcode also there
/HMAC_INDEP/RFC_EXTERNAL_TICKET_4_TRUSTED_SYSTEM
/HMAC_INDEP/RFC_INTERNAL_TICKET_4_TRUSTED_SYSTEM
both are green.
also we have implemented snote: 1532825, but still not able to import profiles.
Please suggest.
Thanks in advance.
sagar.
Hi Sagar,
As part of Post activity have u deleted the Source system profiles entries in tables TPFET, TPFHT and TLOCK. if not done try this then try to import Profiles in RZ10.
Regards,
Samba
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Mamta,
Select the Background Option and select the check box deletedata and then click on Activate and adjust database option. try to delete data from the three tables which i mentioned in above reply . and then check in RZ10 it wont show source system profiles it will show only target system profiles.
And in the Above screenshot u have attached it is showing that profile could not be read in that case check the profile directory access and mount point access for sidadm user with prooper gorup and permissions.
which database u are using now if u are using the oracle do the below
sqlplus "/ as sysdba"
connect SAPSR3/<PASSWORD>;
sql>
truncate table TPFET;
truncate table TPFHT;
truncate table TLOCK;
sql>commit;
If u are using MaxDB do the below:
connect to the maxdb dbmcli and enter the below commands
sql_execute truncate table <<SCHEMA>>.TPFET
sql_execute truncate table <<SCHEMA>>.TPFHT
sql_execute truncate table <<SCHEMA>>.TLOCK
Regards,
Samba.
Hi Sagar,
what is the issue it is showing while importing profiles. provide the error screen shot . And in System copy method which method u have done export/import or Backup/Restore.And also check the Profile directory mount point contains sidadm rights with full permissions.
if possible check at database level in sqlserver is there any data available in TPFET,TPFHT,TLOCK tables.
or else Try the IMPORT button in RZ10 by giving profile name and then provide the file system path of Profile directory then try to copy. it seems not able to read the profiles.
Regards,
Samba.
hi Samba,
while importing profile its throwing below error:
we have performed standard R3load method with system exports generated from source SAP ERP6 EHP4 system with MSSQL 2005 database.
we have check with the mount point also we are able to access the saploc and sapmnt folders from local workstations and also provided full permissions to <SIDADM> user for <SID> folder.
we have cleared the tables as per standard system copy post installation steps via SE14 tcode in target system. but still not able to upload profiles.
but when we check in se11 for the same tables we are able to vie some filed's, in the database levele also same fileds are available.
please suggest.
Hi sagar,
check in se11 the three profile tables should contains target system profile entries only. it should not contain the Source system entries. cross check this once again in se11 then if available try to truncate the three tables at database level and then try to import again.
and also try the manual import of profiles option in RZ10 as below
Try the IMPORT(F8) button in RZ10 by giving profile name and then provide the file system path of Profile directory then try to copy.
Regards,
Samba
Hi Sagar,
You need to create report RS_TT_CLEANUP_SECSTORE from code available in SAP Note 1532825 - Deleting SECSTORE entries during system export/system copy and execute it.
After that it should work fine
Regards, Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sagar,
There are few checkpoints which you can try for your problem:
1. Solution by manually deleting two SECSTORE entries:
Call transaction SECSTORE.
Choose "Execute" (F8).
In the entries that are displayed, delete the entry /HMAC_INDEP/RFC_INTERNAL_TICKET_4_TRUSTED_SYSTEM entry /HMAC_INDEP/RFC_EXTERNAL_TICKET_4_TRUSTED_SYSTEM
In transaction SE37, execute the function module RFC_PING with the destination NONE. If the system displays an error message, execute the function module RFC_PING again; the error message cannot appear a second time in this case.
2. You might have lost a mount point... check if /sapmnt/<sid>/profile is available , and permissions should be owned by SIDADM with read/write access.
3.You would need to delete all the existing profiles and bring the active profiles from
RZ10 > utilities > import profiles > Of active servers.
Hope it helps
Br Vaibhav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi SAgar,
Please delete these entries from secstore
/HMAC_INDEP/RFC_EXTERNAL_TICKET_4_TRUSTED_SYSTEM
/HMAC_INDEP/RFC_INTERNAL_TICKET_4_TRUSTED_SYSTEM
Check the results.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sagar,
What error are you getting while importing the profile?
1. If you have duplicate entry in your profiles then it will not get import to SAP system via rz10.
You need to remove the duplicate entry or redundant entry from import profile.
2. Apply the secure storage key to the system.
3. Delete the invalid enteries.
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mamta,
I think from november 2013 the service is no more available for Migration key for Secure Storage.
You can check the same in SMP->keys&Request -->Migration Key and option Migration Key for Secure Storage
Follow the sapnotes and if you are facing the same error upgrade the kernel as per sapnote 1894435.
816861 - Migration of entries in secure storage
1894435 - Kernel for the Secure Storage Key Management
1922423 - SecStoreDB: Drop of System Dependency (Key Generator inside)
So you have done the first part by removing the duplicate entries from the all the profiles of SAP?
After removing the duplicate entries from profiles just try to import the profile fromRZ10
With Regards
Ashutosh Chaturvedi
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.