Unable to edit the data in PSA

[Former Member]

Hello Friends,

For last few days I am getting an process chain error due to invalid data in PSA. The error seems to be because of a trailing SPACE " " but I am not able to edit the data as no edit option is appearing. I have deleted the failed requests but still its not coming. I think there may some other related targets also. Is there any way to find the all the related target.

I have attached some screens as I am not sure of the cause, any help is appreciated.

Although this load failing but chain after it is running as normal and the corresponding reports are getting updated, I don't understand how it is possible and if really there is any impact ?

Thanks in advance..

Regards,

Sayantan

[Former Member · Accepted solution]

Hello All,

I was able to delete all the requests and now I am able to edit the data in PSA. However now I am skeptical about the cause of the issue ( error in PSA ).

I thought the error is due to a extra space after the field version (ex 'Support ', 'Dobbins ' etc ) but there is no field/attribute with name 'Version'.  Though there is a field with name "BP: Person's First N" containing values 'Support ', 'Dobbins ' etc but it seems fine.

I have attached some more screens, can any one suggest what is the issue. If possible please let me know how to handle PSA error in general.

Regards,

Sayantan

[former_member186445 · Accepted solution]

I see a lot of lowercase in different fields. Check that the infoobject supports lowercase. Else you need to add a routine to translate to uppercase.

BR,

M.

[Former Member · Accepted solution]

0OI_SORT2

0OI_SORT1

are the 2 info objects which are causing the issue... and your screen shot shows the same... you proceed to edit the records in the PSA and retrigger the load...

i.e If your in BI 7 or an higher version u can edit the PSA record even without deleting the request. Please do delete the request unnecessarily without knowing the exact cause of the issue... Hope u understand...

To edit the PSA follow the approach suggested by AL, thats the best approach anyone could suggest.

Right click on that particular datasource---Manage---Select the request---Select the PSA icon---Select the records

Revert back for any clarifications.

Thanks,

Nithesh.

[former_member209895 · Accepted solution]

Hi Sayantan,

     It seems to be the lower case letters causing the problem. If in Infoobject General tab the "Lower Case" letters are not checked then you will not be allowed to store lower case letters in those info objects. In your case it seems to be infoobjects 0OI_SORT1 and 0OI_SORT2.

If you are loading data from a flat file then kindly edit the flat file to have only upper case and run the load, if not then you can either check the "LOWERCASE" checkbox in the infoobject or you can use a routine in the transformation to convert the lower case to upper case letters.

Regards,

  Manohar. D

[former_member209895 · Accepted solution]

Please refer the below thread for approaches on writing the routine:

http://scn.sap.com/thread/1815704

The only hurdle in checking the lower case checkbox would be to delete the data in the infoobjects before doing so.

[Former Member · Accepted solution]

Both your info objects doesn't support lowercase.

Enabling the lowercase should fix your issue, if you are ok with allowing lowercase values. Else you need to edit the records manually or enable a formula in transformation to convert to uppercase.

Hope this helps...

Thanks,

Nithesh.

[former_member186445 · Accepted solution]

allowing lowercase in objects will slow down the slice and dice in queries on these objects.

BR,

M.

[Former Member · Accepted solution]

Thanks,

I want follow this workaround, in case there is any performance issue I will try to add the transformation program. Could you tell me how to get into above screen .

Regards,

Sayantan

[Former Member · Accepted solution]

Thanks I will try with both ways one by one

Regards,

Sayantan

[former_member209895 · Accepted solution]

Transaction RSD1 and enter the name of the infoobject and click on display or maintain.

But as said before you might get activation problems if the data is already loaded to these info objects and you might be requried to delete the data from the infoobjects before you can successfully activate.

Hope this helps, please search for infoobject creation to know more.

Regards,

  Manohar. D

[Former Member · Accepted solution]

Hi,

On just another note, is this data coming from R/3 system.

Can you find out the table from which the error records are coming and check with your master data team to find out users responsible for maintaining this data.

You can suggest them to maintain this in ALL CAPS alphabets.

Br,

Arpit

[Former Member · Accepted solution]

I see all possible solutions provided here.. but you can also try the following:

in the transformation you can select the target mapping field and apply formula for direct assignment rule type.

TOUPPER(IO NAME) is the formula for converting to lower case.

checking the box in the characteristic for lower case is easy but if that object has many reports built on it--you might not know the impact on other reports.

let me know if this helps.

thanks!

[Former Member · Accepted solution]

Thanks everyone,

Issue is resolved , just one query. how you guys identified that the issue is with use of lower case letters .

Regards,

Sayantan

[former_member209895 · Accepted solution]

Hi Sayantan,

      Good to know the issue is fixed. SAP BW / BI is a very smart tool/software. If you take time to read through the error message properly, then generally you will know what to do.

In this case if you look at the monitor window of the infopackage, especially the details tab, you could figure out that the error occurred in processing, Under processing you could see the RED traffic light only under UPDATE to infocube, so it means that the error did not occur while updating PSA, through transfer structure or through update rules, but just before update to Infocube, so under update you could clearly see that BW had already done the work for you by specifying which values for which infoobjects are wrong. The next part of checking the lower case letters occured to me due to having solved many such errors. So over a period of exposure to such issues you're eyes will spot the error with no time and you'll know where to check first if you want to fix the errors.

Please read the error message carefully and more than half of your error resolution will be done.

Regards and good luck,

Manohar. D

[Former Member]

If we want to edit the request in PSA ......first we need to delete that particular request in the data target level, then only we ll get that edit option.

[Former Member]

Hi,

As Manohar previously said, mark answers as Correct and close discussions if answered. This is not just for assigning points, but for helping and guiding other  SCN users who might face the same issue. In this way, if you have a 2nd concern, please, put it in a different post thinking in other users.

Thanks.

[Former Member]

Hi,

Please delete the requests from both the targets.

Example:

Let us say you have already deleted the failed request from the1st target, but still you will not get the edit option. Now you need to deleted the request from 2nd target make request as red in target, then you will get the edit option in PSA level. So that you can remove the Space from PSA then Execute the Info Package manually.

Regards,

Somesh

[former_member209895]

Hi Sayantan,

       Please search all the data targets into which this particular request is loaded, only once you delete the bad request from all, will you be able to edit the PSA data. To find all the targets to which the data is loaded please click on the monitor window of your infopackage. From the screenshots it is evident that you have infopackage in use, if that is the case then one infopackage can load to multiple targets which can all be found in the DATA TARGETS tab of the infopackage.

Else from the monitor window of infopackage click on the data targets ICON on the top or go to the HEADER tab and click on data targets, you'll find the list of all data targets, make sure you delete the requests in all these before trying to edit the data.

Regards,

  Manohar. D

[former_member209895]

Just to add... SHIFT + F1 from the monitor infopackage window (or process monitor from process chain of the infopackage) will take you to MANAGE DATA TARGETS window, from where you'll have to delete the request from every visible target.

Regards,

  Manohar. D

[Former Member]

it worked,

Thanks

[former_member209895]

Hi Sayantan,

   Good to know.. Please take some time to mark an answer as CORRECT ANSWER, thereby closing the thread and awarding points to the right answer.

Appreciate your time spent,

Regards,

  Manohar. D

[Former Member]

Sorry one last query and then I will close

Regards,

Sayantan

[former_member186445]

is this a 3.X or a 7 flow?

[anshu_lilhori]

Hi,

Follow this approach to edit the data in PSA.

Right click on that particular datasource---Manage---Select the request---Select the PSA icon---Select the records.

Now you will get the Edit option.

Hope this helps.

Regards,

AL