issue during the initial download of DNL_CUST_PROD1

[Former Member]

Hi ,

i am new to crm.

currently i am downloading customizing adopter objects from R/3 to CRM.

Already i downloaded the objects like below order

DNL_CUST_ACGRPB,DNL_CUST_ACGRPP,DNL_CUST_ADDR,DNL_CUST_BASIS,DNL_CUST_BASIS2,DNL_CUST_BASIS3,DNL_CUST_BASIS5,DNL_CUST_BASIS6,DNL_CUST_BNKA,DNL_CUST_KTOKD,DNL_CUST_PAYPL,DNL_CUST_PRICE,DNL_CUST_PROD0.

all objects are succesfully downloaded.

Then i started DNL_CUST_PROD1.In R3AM1 it says still it is running.

But i checked with SMQ2 it says SYSFAIL and it genrated short dump.

In short dump says

Short text of error message:

'COM_PRCAT_READ_DB': Database access not allowed during saving

Long text of error message:

Technical information about the message:

Message class....... "COM_HIERARCHY"

Number.............. 039

any one plz help me.

regards

raja durai

[Former Member]

Check for the Filter settings and in Smw01 and bdoc message flow and in site whether data is down loading succesfully or not

Cheeers

Venkat

[Former Member]

hi

everything ok i have not use any filter for customization objects..

in R3AC3 transcation

initial flow context tab which flow context i am going to use

<b>Mbdoc validate or MBDoc intial load</b>.

but in my system the flow context is in disable mode.i cannot make MBDoc intial load.It always in Mbdoc validate.

plz guide me.i am totally new to CRM.

regards

raja durai

[Former Member]

Hi Raja,

Before downloading the object DNL_CUST_PROD1 you need to verify and map the product hierarchy structure levels between ERP and CRM.

ECC : go the view 'PRODHS' using SE11. The number of components corresponds to the number of levels in the CRM system. The field Length defines the number of digits for each level.

CRM : SPRO > Cross Application Components > SAP Product > Product Category > Define Category Numbering Schemes. Here make sure you have an entry 'R3PRODHIER'. If not create a new entry with description 'Numbering Scheme R/3'

Select the number scheme R3PRODHIER and double-click on folder Define Numbering Scheme Levels.

Choose New entries and enter the matching levels and number of digits for each level. They need to be exactly the same as in the ECC system.

Now cancel the object DNL_CUST_PROD1 using R3AM1 and run the object using R3AS. This should definetly solve your problem.

<b>Do not forget to reward if it helps,</b>

Regards,

Paul Kondaveeti

[Former Member]

HI Paul,

Already i did this.

I got a short dump.it is says 'The ABAP/4 Open SQL array insert results in duplicate database records.'.

Can u give idea regarding this issue to fix.

Thanks and regards.

raja durai