PSA Table Provisioning Issue & Resolution

Business Scenario

During the Master Data loads for the 0Employee object, the process chain ends with error. The issue comes up with the error saying “Inactive Transfer Structure for Data Source”.  Given the dependencies of the Master Data loads for the downward flow and the business on this data, the process becomes vital. Also for certain other restrictions, we cannot migrate/transport the object again.

With all these points, I show the available options & the steps which help to resolve this issue in the document below.

Available Options

Whilst trying to activate the datasource table with the program RS_TRANSTRU_ACTIVATE_ALL, the SAP Standard program also fails with the message “Transfer Structure not activated successfully, Activate Manually.”  There is no issues with the source system connectivity or any other authorization issues with the user.

/wp-content/uploads/2014/01/1_356243.png

At the same time, if the PSA table in context is checked, we find that the table is already active.

2.JPG

Checking with the RSRV tests on the object shows all success & no errors to actually go ahead & repair.

Final Steps for Resolution

So in order to go ahead with the process, execute the transaction SE14 & provide the database table name.

3.JPG

Once done the system will identify if you have the table entry valid. If valid you would come to the next screen with the following options as shown below :

4.JPG

The “Save Data” & “Delete Data” are the options that the system performs during the database operation. Both the options as suggested by their name itself perform the Save or Deletion of the data during the activation.

Now in order to proceed with the issue resolution, we have to select the “Activate & Adjust Database” option. At this juncture it is important to note that is the data in the PSA table required. In our scenario we could have the data deleted from the PSA & we proceeded with the same

5.JPG

Once this operation completes, re run the Standard Program RS_TRANSTRU_ACTIVATE_ALL.

These steps would negate the PSA table Provisioning error & you can proceed with the remaining steps to the successful completion of the flow.

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Anshu Lilhori

    In most cases authorization of SE14 Tcode would not be there in production system.

    Also for certain other restrictions, we cannot migrate/transport the object again.

    I do not understand why this option cannot be used.With this statement you are saying that in future if any requirement comes to enhance the master datasource you will not take it up or rather end up doing directly in production to avoid transportation.

    (0) 
    1. Sriram Veerubhotla Post author

      Hi Anshu,

      Thanks for your comments. For your points, please see my comments below:

      That is correct, you can suggest your Admin/Basis team to actually proceed in this manner, provided you do not have authorizations. I proceeded with this in the Quality actually.

      With the statement above, I meant ” we could not transport the objects when we faced this issue due to other restrictions” ie we had our transport lines closed due to environment management processes for our project landscape.

      Please let me know if you have any other points.

      (0) 
      1. Anshu Lilhori

        I would appreciate if you can add these points in your post itself related to restriction.

        It always makes sense to give complete details with proper information when you share such real time scenario.

        (0) 
        1. Sriram Veerubhotla Post author

          I dont think these points make valid sense in this case. The idea is to work with this approach as there would not be any need to make any transports as explained.

          Although I would try to enforce these points going forward

          (0) 

Leave a Reply