Skip to Content
0
Former Member
Jun 06, 2011 at 09:04 AM

Dump while data loading

36 Views

Hello Everybody,

I am getting dump while data loading from DSO to Cube.My data flow is from PSA(0fi_gl_10) to DSO(0figl_o10) to Cube(0figl_c10).

Dump is DBIF_RSQL_SQL_ERROR. I guess this error is because of huge amount of data that is coming while full load.It's almost

65L records which are coming and which is creating problem.So the strategy that I am following is doing int without data transfer first without any selection criteria and then doing full load on yearly basis. i.e. from 2004 to 2005 then 2005 to 2006 and so on so data will come in chunks and I can go ahead then.My area of concern is when I'll run delta will it lead to any data duplicacy, also in my case I have DSO in between(which can handle data duplicacy problem) but if only cube is there then how can we achieve the same.

Any help will be appreicated.

Thanks,

Mayank