Cannot Delete DTP Requests From the Characteristic InfoObject (Target)

5 pts.
Tags:
NetWeaver

Hi there,

I need some help please.  I have been struggling with this issue for some time now, and wondering if somebody would be kind enough to help me out.  I would really appreciate it very much.  Thanks.  I am new to SAP BW, so step by step instructions would be appreciated.

Here’s what I have done so far :

I have created an InfoSet query on table : BSEG.

Then created a Generic DataSource (ZBSEG_DataSource) , which is based on the above, and then have appended one transaction data field (ZZBKTXT) to it, coming out of table : BKPF.

Checked RSA3 before and after doing the CMOD enhancement, and everything was looking good (as far as the data retrieval goes).

Here is the coding I did in CMOD (for your reference only).

I had tweaked a bit (took out the line below from the coding), since the pdf file DataSource was based on 0FI_GL_4, and I simply couldn’t get a way to copy that DataSource (didn’t have authorization to change it); and I couldn’t find the field “fiscper” in BSEG, since it is a field coming out of structure, I believe.

AND gjahr = l_s_ZOXID30328-fiscper+0(4).

 

My Coding :

DATA: l_s_ZOXID30328 LIKE ZOXID30328,

CASE i_datasource.

WHEN ‘ZBSEG_DATASOURCE’.

            LOOP AT c_t_data INTO l_s_ZOXID30328.

                l_tabix = sy-tabix.

              SELECT SINGLE bktxt FROM bkpf INTO l_s_ZOXID30328-zzbktxt

               WHERE bukrs = l_s_ZOXID30328-bukrs

              AND belnr = l_s_ZOXID30328-belnr.

              MODIFY c_t_data FROM l_s_ZOXID30328 INDEX l_tabix.

           ENDLOOP.

           WHEN OTHERS.

               EXIT.

ENDCASE.

 

à Next, replicated DataSources in BW system.

à Activated “ZBSEG_DATASOURCE” in RSDS in the BW System.

à Checked the connection between R/3 & BW -à It was good; both system were talking to each other.

à Created the InfoObject (ZBKTXT1) in RSD1.

à Created “Transformation” under “Text” of the above InfoObject “ZBKTXT1”.

àMapped” the field “ZZBKTXT (Doc. Header Text)” from the DataSource (ZBSEG_DATASOURCE), to the field “ZBKTXT1” of the target InfoObject “ZBKTXT1”.

à Saved &  Activated.

 

à Created “DTP” under “Text” of the above InfoObject “ZBKTXT1”.

à Under “Extraction” tab, changed the “Extraction Mode” to “Full”.

à Under “Update” tab, changed to “Update Valid Records, Reporting Possible (Request Green).

 

à Saved &  Activated.

 

à Went under DTP’s DataSource “ZBSEG_DATASOURCE”, created “InfoPackage”, “Saved”, and “Started” extraction.

 

 

à Came out, waited a few minutes, and then selected “ZBSEG_DATASOURCE” under “DTP’s” DataSource, & called on to the "Call the Monitor For BW Object”, in the middle.

 

à Checked the data under “Status” & “Details” tab.

 

 

Now after doing all the above, I know I have done a couple of mistakes but at that point I wasn’t sure how to resolve them at that time:

# 1 : I should have fields in my Target InfoObject (ZBKTXT1), to map them with all the fields coming out of my Source DataSource (ZBSEG_DATASOURCE), but the pdf version didn’t give me details how to do it in T-code : RSD1, since the author was relying on the fact that he is using the BW 3.x, and during his “Transfer Rules” section, all those fields will automatically be there for his “Target” InfoObject (ZBKTXT1).  For me, it didn’t quiet work like that.

So, the question I have for you is this that, lets say if I were to follow the directions of the author / pdf, and used T-code RSD1 to create the Target InfoObject (ZBKTXT1), for next time, how would I incorporate all those fields in this Target InfoObject to match them with the Source DataSource (ZBSEG_DATASOURCE), at that point.

When I was creating the Target InfoObject, I got an option of “Reference Object” (like to copy the reference of an Object to create this new Target InfoObject), but in there, I was only getting an option to reference any of the “InfoObject” in the system, and NOT any DataSource.

 

And, if later on, I don’t want to goto the Target InfoObject, and put all the fields in there, one by one, to match my Source - DataSource (ZBSEG_DATASOURCE), is there another way of doing it ?

 

 

 

Errors :

A - For the fields below in DataSource (ZBSEG_DATASOURCE) in BW system, I have the missing description, to those fields (as part of my errors).

 

But, when I checked the same fields for descriptions in the Source System (R/3), they were fine, and didn't have any description missing in them. 


Fields w/ missing descriptions :

TXBHW - Original Tax Base Amount    ;  Data Type : Currency

(This above field is referencing to field : WAERS002 - Currency Key  ; Data Type : Currency)

which is also there in the DataSource, in the BW System.

 

 

SHZUZ - Debit / Credit Addition            ; Data Type : Character

STEKZ - Component Version Number  ; Data Type : Character String

TXGRP - Group Indicator For                 ; Data Type : Numeric - Character String with Only Digits

XHRES - Indicator Resident                   ; Data Type: Character String

XFAKT - Indicator Billing D                     ; Data Type: Character String

XUMAN - Indicator Transfer                    ; Data Type: Character String

XANET - Indicator Down Payment          ; Data Type: Character String

XNCOP - Indicator Items Can                  ; Data Type: Character String

 

 BOther error it gave me was for : "Duplicate records", in the Monitor. 

 

My Resolution :

à I have checked off the box “Handle Duplicate Records” in DTP.

à In “Transformation”, I had made the “Language Key” as Constant – “EN”, in my mapping.

 

à Executed the DTP again, but got the same errors.

 

Then, I tried to delete all the Requests inside my InfoObject (ZBKTXT1), under “Requests” tab, to start fresh :

 ABAP Short Dump (See the ABAP short dump pasted below).

 

I have also done the following :

"Red Symbol" shows for all the requests, in the monitor, for my InfoObject (ZBKTXT1). Below is what I have done so far :

 

1 - For all three requests, under "Requests" tab, for the push button, "Data Mart Status Of the Request", it says "Request Not Yet Updated With DataMart".  Even then, when I go in there, select the request & hit "Delete", it takes me to the ABAP Debugger, and not sure what do to up there.. Since, I am thinking as "Request Not Yet Updated With DataMart" status is showing, I don't even have to go in there.

 

2 - For each request, I went to the Monitor Screen :

a - Up there, if I hit "Delete" in there, it opens up again the ABAP Debugger, and then gives me the "Short Error Dump" when I try to go out of the application.

 

b - For all of the requests, I even cannot goto the Header tab, when I am inside the monitor - it gives me again the "Short Error Dump".

 

c - I have checked, and cleared the "Error Stacks" from within the Monitor, for all the requests, since when now I hit it, it gives me message

"Request # is not available".  I think at some point I might have deleted the "Error Stacks" for all the requests.


d - From the same screen (inside Monitor) for all the requests, when I hit the "Where-Used-List-For-Request" button, it comes up with another box, stating the "DTP Request: Where Used List".  And, it has that particular request number, and when I select that "Request Number" and hit "Delete", it again comes up with "ABAP Debugger". Again not sure what to do up there.

 

e - From the same screen (inside Monitor) for all the requests, when I hit the "Manage DataSource", I come up with the message "Data Transfer Process DTP_  _ _ _ _ " does not exit - which is true since I have deleted the "Transformations" (and everything below that) both under my 

DataSource (ZBSEG_DataSource)    &     InfoObject (ZBKTXT1). 

 

 

3- When I got to the "Contents" tab for this InfoObject (ZBKTXT1), I do see the following fields listed down there, but I don't get the option of "Edit" on this page.

InfoObject Name                                                                  InfoObject

DS ZBSEG_DATASOURCE Enhancement                    ZBKTXT1

Language key                                                                        0LANGU

Short description                                                                  0TXTSH

Medium description                                                              0TXTMD

 

4 - Being under the same tab (Contents), when I go and execute "Contents" push button, and run the report, I don't get any contents at all.

 

5 - Being under the same tab (Contents), when I goto the "Logs" push button, and on the next screen I choose "Delete Requests From InfoCube" and hit "Apply Changes", I come up with another box with those three requests saying under status :

Delete Request Finished successfully; No Errors found


6 - From the same screen, when I goto "Application Log" to "Analyse Application Log",

For Object : RSSM

Sub-Object : Mon - Monitor

 

External ID :  DTPR_4W68ELOCA99ZF5IR99XSSFJ0I-DELET-ZBKTXT1$T* and select the time restriction (3 days in which I did do the ETL) for this Analyse report, I come up with nothing.


 7 – Checked the Log File, in the Monitor, it said :

Too many error records - update terminated

Error in sub-step

Data package processing terminated

 

Then, in another request, monitor's log said the following :

 

                                 Message Text                                                ID                No.  

ZBKTXT1 : Data record 1 ( ' ' ) : Duplicate Data Record        RSDMD          191

 

 

For the details to the above message I had :

Long Description                                   T255

Error Location :  Object Type                   IOBJ

Error Location :  Object  Name              ZBKTXT1

Error Location :  Operation Type

Error Location :  Operation Name

Error Severity  :                                             100

Original Record Segment :                          0001

Original Record Number  :                              1

For another error it said :

                                 Message Text                                               ID                No.  

ZBKTXT1 : Data record 1 ( ' ' ) : Language key is initial        RSDMD          186

For the details to the above message I had :

 

Long Description                                   T255

Error Location :  Object Type                   IOBJ

Error Location :  Object  Name              ZBKTXT1

Error Location :  Operation Type

Error Location :  Operation Name

Error Severity  :                                          100

Original Record Segment :                        0001

Original Record Number  :                             1

 

 

The ABAP Error Dump I got is listed below.  Complete file is attached herewith. 

The exception, which is assigned to class 'CX_SY_REF_IS_INITIAL', was not                     |

|     caught in                                                                                    |

|    procedure "DELETE_ERRORSTACK" "(METHOD)", nor was it propagated by a RAISING                  |

|     clause.                                                                                      |

|    Since the caller of the procedure could not have anticipated that the                         |

|    exception would occur, the current program is terminated.                                     |

|    The reason for the exception is:                                                              |

|    You attempted to use a 'NULL' object reference (points to 'nothing')                          |

|    access a component (variable: "L_R_PSA").                                                     |

|    An object reference must point to an object (an instance of a class)                          |

|    before it can be used to access components.                                                   |

|    Either the reference was never set or it was set to 'NULL' using the                          |

|    CLEAR statement.                                                      

 

What I want to Do Now ?

à I need to delete "Those three requests" from my " InfoObject (ZBKTXT1) “, and start fresh - ETL.

 à Appreciate if you could please tell me that, if I need to delete my InfoObject (ZBKTXT1) and create a new InfoObject (by going into RSA1, and create InfoObject) with all the fields in that InfoObject, that will match the DataSource (ZBSEG_DataSource) fields, to do a one to one transfer.

à And, if I have to create a new Target InfoObject (up there), do I get an option of “Reference Object” (like to copy the reference of an Object to create this new Target InfoObject from a DataSource), in order to make my life a little easy; rather than putting all the fields of my DataSource one by one, into the new Target InfoObject.

Appreciate if you can give me step by step instructions, and I apologize if I have done more steps up there (functionality wise) than what I was supposed to be doing, and let me know (if possible) what to do next time, if I have a scenario like this again.  Hopefully, not.

Thanks.

Shahid. 

 

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following