Problem Loading Data To the Target (ETL)

[shahid_latif]

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]

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

Error Message Details of the Actual Error Line :

DTP Not Available – See Below :

Job Overview Details :

Job Log Details :

ABAP Run Time Error :

Line “332” Where The Problem Resides :

ABAP Editor Problem Line (332) Where The Problem Occurred :

System Log Analysis (SM21)

Run Time Analysis Report (ST22)

Checked Lock Entries (SM12), for the table defined under “What Happened?”, in the Short Dump – Just in case :

Thanks again for your help.

Shahid.

ABAP Editor Reading.txt.zip

ST22 Error Analysis.txt.zip

[mohd_abdullah]

The log clearly states

"Field "/BI0/XDBDUNS_NUM" is unknown. It is neither in one of the specfied tables nor defined by a "DATA" statement "

Check whether the InfoObject 0DBDUNS_NUM is active !!

[shahid_latif]

Hi guys,

I hope the image is big enough now.

If you want to click on the image, then, right click and choose "Save Image As", you can save the image on your desktop as a ".jpeg" file.  Once you open up the file, you have the option to maximize it more.

[former_member183290]

Also just one suggestion- if you are facing any error, you can provide that error screenshot alone and other things that you have done as corrective can be mentioned in oneliner. That way, you can be clear.

[shahid_latif]

Hi there,

Sorry, guys, I thought the screen shots were big enough, but apparently not.  I, however, wasn't able to put all these in a file and attach it to the conversation since there is a limit of 1 MB, and also files of certain type, which I didn't know how to put everything (like pictures and stuff) in one file, and that is of the type of file, they require.

But, I have attached it now after reducing the size of the file.  Please see attached.

Also, I have deleted the DataSource now, and will start over.  Could anybody give me please step by step instructions as what steps specifically take, and what to avoid, or what options to select in the course.  I would really appreciate it.  I am very new to BW, so I would appreciate all the help here.

Also, another confusion I had from the above is this that.  When I am doing my transformation again, should I be using the option of creating "Error Stack", and if so, how would you do that in the process.

Thanks again.  Appreciate all the effort and understanding.

Take care.

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.

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.

[KodandaPani_KV]

Hi Shaid,

i will explain step by step.

you are loading the data form flat file to SAP BW system is it ok?

1. first create the data source and enter the info objects at fields tabs.

data source contain 5 table while laoding the flat file

1.general 2. extraction 3. fields 4. proposal 5. preview tabs.

chose the file path the file must be close while seeing the in preview tab.

2. run the info package check the data in PSA level cross check the excel data.

3. create the DSO and CUBE.

4. map the form data source to dso to cube using transformation

5. map the fields at transformation level.

6. run the DTP and check the data in target level.

how to create the process chain

find the below document.

Thanks,

Phani.

[former_member183290]

Hi Shahid,

Adding to Phani, another thing is - It's not advisable to go for error stack by creating error DTP, because you need to monitor the error stack seperately.Though you again have options within- not to make the request reportable until you correct the error stack.

so please create normal DTP alone.

Thanks.

[KodandaPani_KV]

Hi,

don't send these many screens shots.

where ever your getting the issue send that error screen shots.

delete the transformations and dtp activate the cube and dso then run the info package and DTP.

it will work hopefully.

Thanks,

Phani.

[Former Member]

Hi,

Just delete the DTP and create a new DTP....and try loading.....

It should work......

Regards,

Mayank

[mohd_abdullah]

The screenshot is very small...cant read anything ....please post the dump again ..

mean while try deleting the DTP and create a new one with full load option and try ....

[RamanKorrapati]

Hi,

Please share error message or screen shot which can be visible for us.

Can you check your transformation between your data source to info cube.

Can you share your record details which you loaded to PSA.

Can you activate your info cube and transformations, later try to run your dtp again.

Thanks

[former_member183290]

Hi Shahid,

I am not able to view the screenshots properly. Its very small & blurred. Coming to your point, can you please run the DTP through process chain and see the Display messages tab of what exact issue / runtime error it is throwing.

Also, if possible - post the short dump in notepad.

Thanks,

Vikranth