Problem Loading Data To the Target (ETL)

[#1]

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 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.