Data not Loading in DataSource in BW from target Table in DS

[ashfaq_junaid]

Hi Folks,

Lately i tried to modify (by adding a column) in the Data Services and executed Batch Job. I am able to see the changes in target table with data in the Data Services Designer Target table.

But when i am trying to update or re create a new DataSource in BW it is unable to show the updated number of columns in the DataSource in BW.

Necessary steps taken :

1. I did delete the target table and again executed the batch job just in case. In the target table options delete data from table before loading is unchecked and drop and recreate table is checked.

2. In BW side the RFC is checked and it is working properly. Also checked via ping. Also newly created DataSource to check if it is working but it is ain't.

regards

A Junaid

[ashfaq_junaid]

Hi Guys,

I found out the way... I unmapped rules of the transformation to the respective DSO and then de activated the transformation saved it. Then I tried to run the Batch Job (successful). Then request for information I was able to see the added column into it. Thanks for all the efforts guys.

Regards

A Junaid

[Prabhith]

Hi ,

Great to hear that u found a solution.

But sorry, can you elaborate the sentence 'unmapped rules of the transformation to the respective DSO and then deactivated the transformation saved it.'

Are you taking about a query transformation in DS here..

BR

Prabhith

[ashfaq_junaid]

Dear Prabith,

Above I ahave marked in red what I actually meant.. that is deleting the mapping to the DSO. I tried your previous method but it wasn't successful.

Regards

Ashfaq

[former_member189153]

Hi junaid,

Please share your BW version and also specify where did you create your Datasource in BW.

Regards

M Ramesh

[ashfaq_junaid]

Hi Ramesh,

it is BW 7.3. I created the Datasource in the given Application Component for non-sap source area(BODS). Although all the connections are working prefectly I am unable to load the field from the SAP BODS.

[Prabhith]

Hi

Did you try the other approach which i mentioned in my previous mail.

BR

Prabhith

[former_member184511]

What does it show in ODQMON transaction?

[ashfaq_junaid]

Hi Vaseem,

I do not have authorization for ODQMON transaction.

[Prabhith]

Hi ,

Just help me to understand more on your issue:

1) You added a column in DS side and that is going to be your source.

2) You have added a corresponding column in the BW datasource., (which is your target)

3) You have reimported the BW DS again and freshly mapped the objects including the new column.

4) Now you are executing the DS batch job.

5) In the BW PSA for the data source(mentioned in step 2), you are not seeing a DI Generated infopackage request.

Is my understanding correct?

What error message you are getting when the batch job runs/fails?

BR

Prabhith

[ashfaq_junaid]

Hi Prabith Prabhakaran,

I thank you for efforts in finding a solution.

To be little precise..  I added a column in DS which is my Target table in DS side which is the Source for BW.

I have already created the DataSource and I am trying to edit the Data Source by clicking on request Structure Information in BW side.

By clicking the Request Structure Information all I could is the initially loaded no of columns.

Although my batch job is executing successfully.

Since the added column is not reflected in the Datasource I am unable to load in PSA and Info Package is not scheduled..

Regards

Junaid

[Prabhith]

Hi,

Why can't you try the following:

BW --> RSA1 --> source system/ BODS --> select your data

source -> Edit and add new fields --> Save and activate.

Once it is activated, go to BODS --> reimport the datasource by name --> map the new field and run the job again.

I will check and let you know about the tab: 'Request Structure Information'

BR

Prabhith