Question Re: Unable to edit the data in PSA in Technology Q&A

Unable to edit the data in PSA

Former Member — Mon, 13 May 2013 09:35:52 GMT

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

Re: Unable to edit the data in PSA

anshu_lilhori — Mon, 13 May 2013 09:41:54 GMT

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,

Re: Unable to edit the data in PSA

Former Member — Mon, 13 May 2013 09:47:12 GMT

is this a 3.X or a 7 flow?

Re: Unable to edit the data in PSA

Former Member — Mon, 13 May 2013 09:54:02 GMT

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

Re: Unable to edit the data in PSA

Former Member — Mon, 13 May 2013 10:01:27 GMT

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

Re: Unable to edit the data in PSA

Former Member — Mon, 13 May 2013 10:27:07 GMT

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

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 06:02:08 GMT

it worked,

Thanks

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 06:07:37 GMT

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

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 06:10:10 GMT

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

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 06:11:19 GMT

Sorry one last query and then I will close

Regards,

Sayantan

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 06:23:27 GMT

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,

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 06:25:24 GMT

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.

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 06:31:59 GMT

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

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 06:33:32 GMT

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.

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 06:49:41 GMT

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.

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 07:09:59 GMT

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.

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 07:19:34 GMT

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

BR,

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 08:17:16 GMT

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

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 08:18:51 GMT

Thanks I will try with both ways one by one

Regards,

Sayantan

Re: Unable to edit the data in PSA

Former Member — Tue, 14 May 2013 08:22:59 GMT

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