cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Profile imports failing after system copy.

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Samba,

We checked TPFET table and indedd found the data of Source system profile.

we went to t code se14, to delete the data but were skeptical of how to go about it.

we are attaching a snap shot.

kindly help.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Samba,

Tried with the above optioned specified in SE14 but still not able to import profiles,

previously we were able to find DEFAULT profile in RZ10, now that profile is also missing and its empty.

our database is MSSQL.

Please help.

Thanks

sagar.

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

former_member185239
Active Contributor
0 Kudos

Hi Sagar,

Whats your kernel version? is kernel version is same as source system?

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks samba,

my issue is resolved by creating profile name with import button in RZ10 and then importing the profile with the file present in the profile directory.

Answers (4)

Answers (4)

JPReyes
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Vaibhav,

We tried all the steps recommended by you but of no avail.

This is what we are getting time and again.
Kindly suggest.

former_member185239
Active Contributor
0 Kudos

Hi Mamta,

Can you create a copy of the above file and then rename the original profile.

After this , rename the copied profile to original and then try to import it.

With Regards

Ashutosh Chaturvedi

former_member188883
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hello Deepak,

Both the entries in secstore are marked with green traffic light.

Do you still want us to delete them?

former_member185239
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi ashutosh,

Invalid and duplicate entries have been deleted from the import profile.

Could you throw some light on your second point?

2. apply the secure storage key to the system..

former_member185239
Active Contributor
0 Kudos

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