Error when uploading data using generic

[Former Member]

Hi,

I have created a gereic datasrc using view & i took the following fields

MATNR Material

WERKS Plant

PBDNR Req.plan number

BDZEI Reqmts pointer

LAEDA Last change

MEINS Base Unit

FIXMG Planned qty

In the transfer rules of BW the system gave mapping only for LAEDA Last changewith the infoobj 0CH_ON,so I took 0mat infoobj formapping with Matnr

0plant for werks & created ZpBDNR,ZBDZEI for PBDNR BDZEI & for FIXMG i mapped with the infoobj 0PRDPLN_QTY

In the monitor screen it is showing me 0 records with status yellow then I went to the job overview it is giving me the following msg in job overview

Date Time Message

24.12.2006 12:18:13 Job started

24.12.2006 12:18:13 Step 001 started (program SBIE0001, variant &0000000006181, user ID ALE_MASTER)

24.12.2006 12:18:13

24.12.2006 12:18:13 DATASOURCE = PLANEW

24.12.2006 12:18:13 *************************************************************************

24.12.2006 12:18:13 * Current Values for Selected Profile Parameters *

24.12.2006 12:18:13 *************************************************************************

24.12.2006 12:18:13 * abap/heap_area_nondia......... 2000000000 *

24.12.2006 12:18:13 * abap/heap_area_total.......... 2000000000 *

24.12.2006 12:18:13 * abap/heaplimit................ 40000000 *

24.12.2006 12:18:13 * zcsa/installed_languages...... DE *

24.12.2006 12:18:13 * zcsa/system_language.......... E *

24.12.2006 12:18:13 * ztta/max_memreq_MB............ 250 *

24.12.2006 12:18:13 * ztta/roll_area................ 2000000 *

24.12.2006 12:18:13 * ztta/roll_extension........... 2000000000 *

24.12.2006 12:18:13 *************************************************************************

24.12.2006 12:18:14 Could not determine BW release of logical system 'QEMCLNT003'

24.12.2006 12:18:14 Job cancelled after system exception ERROR_MESSAGE

Thanks,

Maya

[Former Member]

Hi maya,

There is a connection problem to your connection from R3 to BW.Kindly check it .

KK.

[Former Member]

Dear Maya,

Check in RSA3 whether your view is pulling data .if yes, Check your RFC from R/3 to BW . Check the Logical names of the clients ..

Thanks

Krish

[Former Member]

Hi Krish,

I have checked the RFC connection b/w BW & R/3 in SM59 everything is OK

what might be the problem

Thnaks

Krish

[Private_Member_9643]

Did you created Logical system also? If not you have to create logical system and assign it to ur source system.

If u on BW3.5 system:

Tcode SPRO->ref Img->SAP NetWeaver->SAP BI->Links to other systems->define logical system. (not sure abt path...but it must be somehow similar to this only)

Check this link it may help you:

http://www.erpgenie.com/sapgenie/docs/MySAP%20BW%20Cookbook%20Vol%202.pdf

Message was edited by:

KJ (Kamaljeet)