SID issue when Bex Query is executed

[Former Member]

Hi,

I am getting the following error when running a BEX query in analyzer.:

SID 34 for characteristic Zxxxxxx could not be converted CL_RSDM_READ_MASTER_DATA->_SIDVAL_DIRECT_READ2

Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION

this query is based out of 0InfoObject MD and Zxxxxxxx is one of the attributes of 0InfoObject.

I have tried RSRV--> ran combined test for MD, all tests are green, but error is still there., adjusted the data base tables in se14 too...

Please help me out. The query is in QA and we are planning to move to prod after this--but cant because of this issue.

thanks in advance!

[Former Member · Accepted solution]

Hi All,

I know this has been a while and I couldnot reply back. the issue is still there.

I requested to apply OSS 1639786, but this BW system is in SP 2 and this OSS note requires SP8. Upgrdae is not possible.

This ZXXXXX is attribute of 0XXXXXX and when I checked RSRV there are SID errors for this 0MD. I tried to correct the error its giving me short dump. SE14 adjusting also didnot work.

Any idea what should I do now?

please reply.

thanks!

[Former Member · Accepted solution]

Hi Poulami,

the process I am mentioning is just a trial.

1.) Remove the attribute from the ZXXXX info object. Activate the info object.

2.) Adjust the master data table in SE14. Try RSRV on the master data info object.

3.) Generate the query in RSRT. Check if you are getting the same error. If not then add the attribute which you have removed. Activate, adjust in SE14 & generate in RSRT.

Try that and let me know.

Cheers,

Krishna Vadlapatla

[Former Member · Accepted solution]

Hi Krishna,

thanks for the reply. I do not have authorization for editing query in QA. In dev this is working good. Problem is in QA. if I have to do this that means I have to edit it in D and then move to Q which again no permission.

in RSRV and SE14 checks has been applied in QA--status is green but issue remains.

is there any other possible solution--because the debugger screen is coming up and my guess is I have to have an ABAP er look into the code... please advice

thanks!

[Former Member · Accepted solution]

Does your 0infoobject belong to currencies or unit's of measurement or fiscal year variants?

Cheers,

Krishna Vadlapatla

[Former Member · Accepted solution]

Debugger screen is coming up in RSRV or RSRT...

If so its on rsrt... Please share properties screen shot of the query from rsrt window..

if its on rsrv please check you have authorization to correct the errors through rsrv... ( after you try to run correct error and if you get a dump run tcode su53 to find the authorization object which you are missing..) else run rsrv check and fix the error with help of basis...

Thanks,

Nithesh.

[former_member209895 · Accepted solution]

Hi Poulami,

   Once the debugger screen comes up in RSRT, please hit F8, it will open up the output with a list of error messages. Check the long texts of these messages and you might get a clue on how to proceed. Some messages get suppressed in queries that are run through web or Bex, due to message display properties in RSRT, but these messages should be visible in RSRT run.

Please share the messages as well..

Regards,

  Manohar. D

[Former Member · Accepted solution]

Hi Manohar,

I did press F8 and below is the error:

I think its ABAP program error

[Former Member · Accepted solution]

What check you performed in RSRV?

[Former Member · Accepted solution]

Hi Manohar,

Any suggestion?

thanks!

[Former Member · Accepted solution]

Hi Krishna,

no its an employee IO

thanks!

[former_member209895 · Accepted solution]

Hi Poulami,

      Unfortunately your options are limited. As you are not able to upgrade to SP8, or edit the query in QA it really becomes tough to analyze further.

If my understanding is right then the same query is working fine in DEV, even though this error has nothing to do with the design issue and its purely something to do with the master data, please try capturing the query again in DEV and transport across to QA. With all the restrictions related to upgrade and change this option seems the only way out here.

Have you tried reloading the master data for the infoobject specified in the error message and activating it ? I'm sure you have, but just in case.

Sorry that I'm not sure if it'll help, as every other option seems to be exhausted now.

Regards,

  Manohar. D

[Former Member]

any other suggestion?

[Former Member]

Dear Poulami,

I think its a master data issue where SID was not generated properly. If possible please do the below.

Delete the master data from the Infoobject and for this you have to delete data from the cube also and reload.

I am not sure how big is your Data targets. I have faced this issue earlier and i have done the same thing and please make sure its QA and you can  reload the data back for your testing.

Thanks

Sree

[koleti_madhusudan]

Hi,

please check at Data source level, you need to change internal to external and need to put conversion exit at Data source level.

Thanks

Madhu

[Former Member]

This message was moderated.

[snitwipro]

Hello,

  Apparently the query is aiming to show some characters values which are not permitted. Please identify the SID and the corresponding values, update the value directly to the SID table. Regenerate the query from RSRT. And try again.

Regards

Sourav

[Former Member]

Hi Sourav,

SID has been identified and fixed in RSRV as well data base table adjusted in SE14... but still error is there...

I am trying to check the OSS notes and see if that helps..

thanks!

[umashankar_poojar]

This message was moderated.

[Former Member]

this didnot work... any other suggestion.. whenever I am using RSRT--and executing the query--the ABAP debugger program is coming up--my guess is the associated program error--any suggestion?

[former_member209895]

Hi Poulami Nandi,

      Please confirm if the infoobject that is displayed in the error message has restrictions in the filter section (Characteristic Restrictions) of the report.? If so then all you have to do is to remove the restriction, save the query and again set the restriction back to the same value and the report should not throw the error again. I had faced a similar issue with an error message related to "SID does not exist for a characteristic or is not selected", and the only thing that helped was editing the query. Hope you have sufficient authorization to do so.

Hope this helps,

Regards,

  Manohar. D

[Former Member]

Hi,

I donot have any characteristic restriction in query.

thanks!

[Former Member]

there is no filter restriction. what type of editing should i do? the uery is performing right in dev.. in qa its throwing error

[former_member209895]

Hi Poulami,

       When I had faced a similar error all I had to do was refresh the restriction, so please check if there are any restricted key figures in use, based on the characteristic ZXXXXXX, which appears in the error message. If yes then check if the characteristic is being restricted by a VALUE in that particular key figure, this value would be related to the SID 34 which is being displayed in the error message, so remove this value and save the query, again restrict with the same value, save the query and try executing.

But in my scenario whenever I ran the query in RSRT, it would clearly display an error message and not the debugger screen. Please check in query designer - messages section, if the query is consistent or if there are errors in the query design.

Also please share any short dumps that you are facing for better understanding.

Regards,

  Manohar. D

[Former Member]

there is no restriction in KF.. there are some characteristic restriction.. I checked them-- no issues. This query is working fine in dev but throwing error in QA....

when you say this is related to SID  34 for the query--in the SID table I dont see any 34 but there is 100,034 number in the SID table for this ZXXXXX object...and the corresponding data matches with the rest of the data.. is this what you are asking me to do?

please advice.

thanks!

[anindya_bose]

Hello Poulami

Can you please check  OSS note 1452121.

Cheers

Anindya

[Former Member]

Hi,

Can you please give the details of this note? somehow I am not finding the note

thanks

[ravi_chandra3]

Hi Poulami,

Please refer the below link,

https://websmp130.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1452121

Regards,
RaviChandra.

[Former Member]

its still not working for me

[RamanKorrapati]

Hi Poulami,

Below notes applicable when we get class(CL_RSDM_READ_MASTER_DATA) issue in bex.

Please check this OSS Note -   1660089, 1670128, 1686281 and 1732291.

Thanks

[Former Member]

I will check

[Former Member]

these didnot not work.. any other suggestion?