cancel
Showing results for 
Search instead for 
Did you mean: 

Error occurred in the data selection

Former Member
0 Kudos

while loading delta for GL Line Itean (0FI_GL_4) this error is coming , any idea why?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Assuming you have done all the simple things - like check the alpha conversions for the selection parameters (if you have any) and the delta queue is not screwed up then

What does the job log for the R3 job say?

Former Member
0 Kudos

i am not getting u..how to check R/3 job log? i ave init syuccesfully and loaded almost 1 million record previously. any suggestions?

former_member188975
Active Contributor
0 Kudos

Did you put any selections in your InfoPackage? May be the values you entered are not correct or in correct format for that char...

Former Member
0 Kudos

How to check the R3 job log???

Infopackage monitor - environment - job overview - in the source system

log on

execute ont he sm37 with the BIREQU_* job

then display job log

Former Member
0 Kudos

infopackage selection creiteria is on the basis of init which i did. so data selections are on the basis of that only. and data format is correct.

any more suugestions?

Former Member
0 Kudos

Check the R3 job log - you may have to check sm37 between the two times that you did it if the BW session does not find the job

Former Member
0 Kudos

here is job log in source system

Date Time Message

09/20/2006 09:15:40 Job started

09/20/2006 09:15:40 Step 001 started (program SBIE0001, variant &0000000000314, user

09/20/2006 09:15:40 Asynchronous transmission of info IDoc 2 in task 0001 (0 parallel

09/20/2006 09:15:40 DATASOURCE = 0FI_GL_4

09/20/2006 09:15:40 *****************************************************************

09/20/2006 09:15:40 * Current Values for Selected Profile Parameters

09/20/2006 09:15:40 *****************************************************************

09/20/2006 09:15:40 * abap/heap_area_nondia......... 2000000000

09/20/2006 09:15:40 * abap/heap_area_total.......... 4000000000

09/20/2006 09:15:40 * abap/heaplimit................ 20971520

09/20/2006 09:15:40 * zcsa/installed_languages...... ED

09/20/2006 09:15:40 * zcsa/system_language.......... E

09/20/2006 09:15:40 * ztta/max_memreq_MB............ 2047

09/20/2006 09:15:40 * ztta/roll_area................ 3000320

09/20/2006 09:15:40 * ztta/roll_extension........... 2000683008

09/20/2006 09:15:40 *****************************************************************

09/20/2006 09:15:41 Synchronized transmission of info IDoc 3 (1 parallel tasks)

09/20/2006 09:15:41 IDOC: Info IDoc 3, IDoc No. 2777712, Duration 00:00:00

09/20/2006 09:15:41 IDoc: Start = 20.09.2006 09:15:41, End = 20.09.2006 09:15:41

09/20/2006 09:15:41 Job finished

Former Member
0 Kudos

You seem to be missing an important part of the job - the actual job selection eg..

7 LUWs confirmed and 7 LUWs to be deleted with function module RSC2_QOUT_CONFIRM_DATA

Call customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 3.171 records

Check your RFC queue on the R3 side - are you missing a fiscal period calendar, currencies etc???

Former Member
0 Kudos

but for init of delta job selection went fine...and delta for 0FI_AP_4 is also working fine.....

could you elobrate more on the steps i have to perform before running repeat delta?

Former Member
0 Kudos

Hello Bhanu,

The same problem has came for me also..

But i have given the 0plant (1500-1501) in the selections..Eeven though it showing "an error occurred in data selection" .

There is no IDoc Issue at all.

Can you please let me know ,what can i do here?

BR

Bhupal