SAP MDG Consolidation Business Partner on s/4 HANA throwing SQL 257 Error in trace

[jaya27]

Hi ,

We are configuring BP Consolidation on S/4 HANA system and to load data, we are using import data for consolidation. Import works fine, We make use of BRF+ rules for standardization. But the matching phase keeps on executing without any error or exception. While checking the trace file, i could see error as below[in Italics]:

C {root-id=90B8FF4902D7446C99E7875735D63F55}_{conn-id=F74ADF5A6045D636E10000000A4E691C}_1

C *** ERROR => PREPARE C_0791 on connection 0, rc=257

[dbslsdb.cpp 9603]

C SQLCODE : 257

C SQLERRTEXT : sql syntax error: incorrect syntax near ")": line 1 col 320 (at pos 320)

C sc_p=b022728,no=791,idc_p=(nil),con=0,act=0,slen=355,smax=768,#vars=0,stmt=7fad9eb0a480,table=

C select COUNT(*) from "MDC_MATCH_GROUP" mtc where "CLIENT" = '100' and "PROCESS_ID" = '000000000061' \

C and "BEST_RECORD" = 'X' and "MATCH_GROUP_ID" in ( select distinct "MATCH_GROUP_ID" from "MDC_MATCH_G\

C ROUP" mtc where "CLIENT" = '100' and "PROCESS_ID" = '000000000061' and "APPROVAL_STATUS" <> 'D' and \

C "SOURCE_SYSTEM" = ) WITH RANGE_RESTRICTION('CURRENT');

B ***LOG BY2=> sql error 257 performing OPC [dbds 447]

B ***LOG BY0=> sql syntax error: incorrect syntax near ")": line 1 col 320 (at pos 320) [dbds 447]

I believe the error is near the source system, and i have checked the loaded tables and found source system is updated with value provided while creating the consolidation process.

Kindly help.

[Ranjan]

This error occurs when the system can't identify its own system while calling class-method: CL_MDG_CA_GET_OWN_BUS_SYS=>GET_LOCAL_BUSINESS_SYSTEM. Defining the local system can be achieved by implementing BADI: MDG_IDM_GET_LCL_SYSTEM or by maintaining the system in SLD.