cancel
Showing results for 
Search instead for 
Did you mean: 

Error while extracting data from ODS using Infospokes - URGENT

Former Member
0 Kudos

Hi all,

I am extracting data from an ODS using infospokes and nothing fancy, no selection criteria but I am getting an error message saying

Syntax error in row3(-> long text) Msg id = "RG" and msgno is 102

Any ideas on how I can see what is the exact error and how to debug this?

thanks

Sabrina.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sabrina,

Are you extracting data to a table using Infospoke. Have you selected the check box for deleting the contents of the table before loading. The chances are you might be getting this error due to duplicate records.

Bye

Dinesh

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Sabrina,

I am facing the same error RG: msg # : 102.

Syntax error in RSCDELTA

But I am neither using ODS nor Infospokes to extract data I am using a third party tool instead of BW.

I ran the setup , and the first delta went fine. I am getting this error from second delta onwards.

Can you please explain how did you resolve this error so that it is helpful in our situation too.

Thanks

Regards,

Priya

Former Member
0 Kudos

Hi Priya,

I don't know if my solution can help you but, I found an OSS note which solved my problem. I don't remember the OSS note on top of my head but let me know if you need it. All I did was to make some change(may be description) and activate the ods again. It seems while an upgrade the def of the ODS was not created properly, this is what the note said. I made some change, activated the ods and was able to use the infospoke successfully.

thanks

Sabrina.

Former Member
0 Kudos

Hi Sabrina,

Change the extraction mode to 'FULL' and then Excecute the infospoke..

If useful,Don't forget to assign points...

Former Member
0 Kudos

Hi Sabrina,

For message long text go to SE91 -> Message Class(eg. RG) and message number. Select the message # and click on long text button.

Bye

Dinesh

Former Member
0 Kudos

Can anyone tell me where I can look for long description for msg id "RG" and msgno 102

thanks

Sabrina.

Former Member
0 Kudos

Hi Sabrina

service.sap.com can help you getting the details of your mesg.

I found one OSS note suitable to your mesg. So just check out OSS note # 671097. I hope this note will be some help to you. If not go and chk in the OSS you can find some more.

Here is the note details also

<i>Symptom

Error message RG102: 'Syntax error in &1, row &2 (-> long text)' appears in the request log of an InfoSpoke.

Reason and Prerequisites

The data source is an ODS object and the extraction mode is 'delta'. The cause of the error message is that the ODS extractor is unable to select the request ID (InfoObject 0REQUID) from the change log of the ODS object. However, the request ID is mistakenly provided in the field list of the ODS object on the InfoSpoke maintenance screen. --

Solution

Delete the 0REQUID InfoObject from the field list of the InfoSpoke and activate the InfoSpoke. As of the patch mentioned below, the request ID in the template tab is no longer provided.

BW 3.0B

Import Support Package 16 for 3.0B (BW3.0B Patch 17 or SAPKW30B16) into your BW system. The Support Package will be available once note 571699 with the short text "SAPBWNews BW 3.0B Support Package 16", which describes this Support Package in more detail, has been released for customers.

BW 3.1 Content

Import Support Package 10 for 3.1 Content (BW3.10 Patch 11 or SAPKW31010) into your BW system. The Support Package will be available once note 571747 with the short text "SAPBWNews BW 3.1 Content Support Package 10" has been released for customers.

To provide information in advance, the notes mentioned above may already be available before the Support Package is released. In this case, however, the short text still contains the words "preliminary version".

Refer to note 110934, which contains information about BW Support Packages.</i>

Regards,

Rohini