SAP CPQ Initial Load Configuration

[Former Member]

Could someone please tell the location of dataloaderAdmin.bat file?

[Former Member]

Hi Manish, We are using direct communication between Hybris & ECC.

[Former Member]

Could you check that RFC maintained in SM59 has single record or multiple record for multi language?

Check tables RFCATTRIB, RFCDOC and RFCDES for this.

[Former Member]

We are installing the productconfigaddon on b2c storefront. This error could be due to that?

[Former Member]

Productconfig support b2b. May I ask for which organisation are you doing this work?

[Former Member]

One more question if you want to answer: For which organisation are u facing this issue? And are you using router gateway or direct communication between hybris and ECC?

[Former Member]

Direct communication.

[Former Member]

Then check entries for that RFC destinaion.

[Former Member]

Hi Manish, In function module 'CRM_SEND_DATA' the system is trying to call BAPI in Hybris system, which should not be the case.

CALL FUNCTION i_crmrfcpar-bapiname DESTINATION i_crmrfcpar-rfcdest EXPORTING download_header = i_bapicrmdh2 object_class = i_obj_class object_name = i_obj_name TABLES bapistructures = t_bapistructures messages = t_messages key_info = t_key_info other_info = t_other_info id_list = ti_idlist EXCEPTIONS error_message = 1 communication_failure = 2 system_failure = 3.

ENDIF.

The call to load the product configuration data is initiated from Hybris but SAP ECC is trying to send the data using BAPI. Since BAPIs will not be available in Hybris system, the exception is being thrown. Any idea why this is happening?

Regards, Raj

[Former Member]

Did you follow all the steps mentioned in dataloader install guide for implementing all the note in ABAP and Hybris side?

[Former Member]

Yes. I did. Implemented ABAP Note too.

[Former Member]

Could you check that RFC maintained in SM59 has single record or multiple record for multi language?

[Former Member]

Its a single record

[Former Member]

Check tables RFCATTRIB and RFCDES for this.

[Former Member]

Did you set the CPQ db parameter in local.proeties file.

[Former Member]

Yes. I had done db settings of type mysql.

[Former Member]

Could you please share the details of that setting.

[Former Member]

Please see below image attached.

[Former Member]

Thank you Manish. The consumer is "null" issue got solved. But the initial load is still giving short dump exception. The SAP dump is same as image attached yesterday.

My db configurations as follows:

crm.system_type=MySQL crm.database_hostname=hostname crm.database=test crm.database_port=3306 crm.database_user=root crm.database_password=myPassword crm.ssc_jndi_usage=false crm.ssc_jndi_datasource=

[Former Member]

Short dump error - com.sap.mw.jco.JCO$Exception: (104) RFC_ERROR_SYSTEM_FAILURE:

The current application triggered a termination with a short dump.

This problem occurs if there is an ABAP error while calling a function module from dataloader.Use transaction ST22 in the backend system(ECC system) to examine the dump.

[Former Member]

How to check ABAP dump: 1. Connect to customer ABAP system and enter st22 2. Search for the date on which the dump has occurred as per dataloader logs. 3. Open the log and check 'source code extract'. 4.The error analysis section gives a short text of the error message. Also you can scroll down to check the line of code where the error was thrown and analyze further.For more details on ABAP dump analysis refer Note#1896868.

[Former Member]

Following is one example of this error messages:

   Authorization issue - No authorization to select data . This issue occurs because the user which is being used to run dataloader does not have required authorizations. Contact your  for the required authorizations.

[Former Member]

Please check the SAP dump screenshot attached

[Former Member]

In your organisation are u using any SAP router gateway?

[Former Member]

Attaching dump from ECC. Please suggest how to solve the same.

Hybris Log: NFO [data loader requester] [SpcRequester] The Consumer is null, the R/3 filtering won't run ! Please define a Consumer. INFO [00000ENV::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (00000ENV) [DataloaderInfoParameters] save status Initial download running INFO [00000ENV::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (00000ENV) [Receiver] Receiver started in initial mode.

ERROR [data loader requester] [ExceptionLog] Exception : The current application has triggered a termination with a short dump. com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: The current application has triggered a termination with a short dump. (Remote shortdump: MESSAGE_TYPE_X in system ECM|01HW800724VM1) at com.sap.conn.jco.rt.MiddlewareJavaRfc.generateJCoException(MiddlewareJavaRfc.java:678) at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcClient.execute(MiddlewareJavaRfc.java:2092) at com.sap.conn.jco.rt.ClientConnection.execute(ClientConnection.java:1179) at com.sap.conn.jco.rt.ClientConnection.execute(ClientConnection.java:1008) at com.sap.conn.jco.rt.RfcDestination.execute(RfcDestination.java:1458) at com.sap.conn.jco.rt.RfcDestination.execute(RfcDestination.java:1428) at com.sap.conn.jco.rt.AbapFunction.execute(AbapFunction.java:300) at com.sap.sxe.loader.controller.Client.setCRSFIRSTDOWNLOADTRIGGER(Client.java:481) at com.sap.sxe.loader.controller.Client.executeSpleRequest(Client.java:366) at com.sap.sxe.loader.controller.Client.run(Client.java:187) at java.lang.Thread.run(Thread.java:745) Caused by: RfcException raised by system [ECM|01HW800724VM1]: message: The current application has triggered a termination with a short dump. return code: RFC_SYS_EXCEPTION (3) error group: 104 key: RFC_ERROR_SYSTEM_FAILURE message class: 00 message type: X message number: 341 message parameter 0: MESSAGE_TYPE_X at com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcReceive(RfcIoOpenCntl.java:2041) at com.sap.conn.jco.rt.MiddlewareJavaRfc$JavaRfcClient.execute(MiddlewareJavaRfc.java:2032) ... 9 more Caused by: com.sap.conn.rfc.exceptions.RfcGetException: The current application has triggered a termination with a short dump. at com.sap.conn.rfc.engine.RfcImp.ab_rfcerror(RfcImp.java:1176) at com.sap.conn.rfc.engine.RfcGet.ab_rfcget(RfcGet.java:120) at com.sap.conn.rfc.engine.RfcRcv.ab_rfcreceive(RfcRcv.java:36) at com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcReceive(RfcIoOpenCntl.java:1983) ... 10 more Thank you, Selvi

[former_member623616]

Hi Selvi,

Were you able to resolve this issue ? If yes, could you please share the solution approach.

Thanks, Yaten

[Former Member]

Hi Yetendra,

Yes , I could resolve the issue.

We were registering the server program in SAP ERP using "rfcexec". That was the mistake. The proghould be registered by hybris sytem. No manual registration is required.

Hope it helps.

[former_member623616]

Thanks Selvi. Yes we also registered this program using "rfcexec".

Could you please let me know the steps to register this program by hybris system ? Also do we need to first unregistered the program we registered earlier(using "rfcexec") ?

Thanks, Yaten

[Former Member]

Hi Yaten,

No need to register the program manually. Unregister the program in sap system. Start your initial download.

[Former Member]

Thank you Manish and Yatendra. Uploaded those three files. But while initial load I get following exception.

ERROR [data loader requester] [ExceptionLog] Exception : The current application has triggered a termination with a short dump. com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: The current application has triggered a termination with a short dump. (Remote shortdump: MESSAGE_TYPE_X in system ECM|01HW800724VM1) Caused by: RfcException raised by system [ECM|01HW800724VM1]: message: The current application has triggered a termination with a short dump. return code: RFC_SYS_EXCEPTION (3) error group: 104 key: RFC_ERROR_SYSTEM_FAILURE message class: 00 message type: X message number: 341 message parameter 0: MESSAGE_TYPE_X

Caused by: com.sap.conn.rfc.exceptions.RfcGetException: The current application has triggered a termination with a short dump. at com.sap.conn.rfc.engine.RfcImp.ab_rfcerror(RfcImp.java:1176) at com.sap.conn.rfc.engine.RfcGet.ab_rfcget(RfcGet.java:120) at com.sap.conn.rfc.engine.RfcRcv.ab_rfcreceive(RfcRcv.java:36) at com.sap.conn.rfc.engine.RfcIoOpenCntl.Rve(RfcIoOpenCntl.java:1983) ... 10 more

Please suggest.

[former_member623616]

could you please test your TCP/IP connection created for CPQ, if it's successful.

Thanks, Yaten

[Former Member]

Which version of dataloader jar are you using and is RFC destination is pinging? And aslo check Program ID in SM59 in ECC. Is that same are you using.

[Former Member]

Yatendra,

I did TCP/IP connection test from ERP, Its successful.

Manish,

Ping RFC destination is successful. Program id is same, and it is registered too. I am using dataloaderof version 2.4.0

[former_member623616]

could you please share log file or more lines from error log..

Thanks, Yaten

[Former Member]

Could you please eloborate your question. And which hybris version you want this? You want to download something from ECC to hybris using dataloader?

[Former Member]

Thank you manish for quick response.

Yes. I want to download Configurable products from ECC.

I am using hybris 6.0. I need to fill the filters in Data load tab.

Knowledge Base Filter, Conditions Filter, Material Filter

SAP Note 557928, mention what need to be given those filters. Do we need to upload those files as text file in these filter? please suggest.

[former_member623616]

Yes, those filter files would be uploaded as .txt files under Product Configuration tab in Backoffice/hMC.

Thanks, Yaten

[Former Member]

Yatendra is right you need to upload filter in the form of txt file and filter are like below:-

Knowledge base are like KB name1,KBversion1 KB name2,KBversion1

Condition filter are like: table=A304 table=A305

Material filter are like:- table=MARA, table=MAKT