Problem Loading Data To the Target (ETL)

shahid_latif · ‎2014 Mar 17

Hi there,

I have this issue doing an simple ETL (with only one record) from Flat-File DataSource (Source) to the Info-Cube (Target).

I went all the way upto the second last stage (loading data to the PSA) where I got stuck. The data was loaded properly upto the PSA.

Could you please see the attached detailed document with screen shots, and advise if whether I should have done anything different, or if this is merely a Database issue, and I should address this matter with the people whom I am getting the SAP Access from.

I am using IDES BW 7.3, just to let you guys know.

Thanks. I really appreciate anybody's help, who contributes his / her efforts here. Please see the explanation of the scenario along with the screen shots.

Thanks.

Shahid.

Everything loaded into PSA properly. Please see below :

In the “Data Transfer Process” window, the only change I made is following :

Under Extraction Tab :

Extraction Mode --> Changed to Full

Then, saved, activated, and under the “Execute” tab, clicked “Execute”. I get the following ABAP Short Dump, almost right away.

As per the above “Dump”, it advised to check in SE14 for Consistency of the table. I have checked that, and the table is consistent. Please see below.

Also, I have checked the “Run-Time Object”, and that is consistent too.

Now, as per the dump, if the table is consistent, the error might be in “Database”.

I wasn’t able to access the database, since it gave me the “Authorization” error.

Also, there was “No Object Log” for this.

shahid_latif · ‎2014 Mar 30

Hi all,

Thanks again for all of you guys' help. Much appreciated.

Taking into consideration of all the help provided above, following is what I have done, which has given me to go ahead a bit, but I still was not able to get to the end of the transformation. Please see below :

I deleted that DataSource and started over. The transformation is done completely (like all the way to the target - InfoCube), but finally in the monitor, I get an error during the final step.
Also, this time, I have NOT selected the "Error Stack related to DTP."

Please see the note pad docs. for the errors / other work I have done so far.
I also have attached the short dump in txt file, ABAP Editor file.

Moreover, in the "ABAP Editor" file, the problem occurred, and exactly it was the line (last line below - ENDFORM) :

*&---------------------------------------------------------------------*

*& Form set_fae_threshold

*&---------------------------------------------------------------------*

FORM set_fae_threshold USING i_program TYPE sy-repid.

DATA: l_threshold TYPE i VALUE -1.

PERFORM get_fae_threshold CHANGING l_threshold.

PERFORM set_fae_threshold IN PROGRAM (i_program)

USING l_threshold.

ENDFORM. "set_fae_threshold

The Screenshots of the error are below.

Note : You can always make a right click on the image below, and choose to save it on your desktop. From there you can open up in .jpeg file, and resize the image (in case image is not clear on this forum screen).

Or, if you want me to send email to : Slatif123 (at) yahoo (dot) com, I will be more than happy to send you the screen shots, since this forum doesn't allow us to attach .doc files here.

Main Error On Monitor Screen after doing the DTP