Global Address Cleanse error for Chinese characters in BODS 4.2

[former_member335073]

Hi,

I am trying to process almost 27 millions of Chinese records in BODS 4.2. Till now 19 millions have been processed but stuck for further processing.

In previous executions, I have encountered with the error "Word in the component is already used by another component in the method Sublist". Analysing further I found that the error is due to "——" present in "北京市朝阳区——路安苑北里小区5楼2003室" type of Address. So I simply removed these type of Addresses from my input set of records and executed the job again. After that, the job was running fine till 19 millions but now it is stuck with below error.

This is a simple dataflow which is using Global Address Ceanse to process the Chinese records.

(14.2) 01-21-19 12:59:02 (E) (7143546:3342) DQX-058306: |Data flow DF_Mtch_Key_Test|Transform Europe_AddressCleanse Transform <Europe_AddressCleanse>: <GAC0000>: [Word in the component is already used by another component in the method InsertComponent.].

(14.2) 01-21-19 12:59:02 (E) (7143546:3342) DQX-058306: |Data flow DF_Mtch_Key_Test|Transform Europe_AddressCleanse Transform <Europe_AddressCleanse>: <GAC0000>: [[Word in the component is already used by another component in the method InsertComponent.]].

(14.2) 01-21-19 12:59:02 (E) (7143546:3342) DQX-058302: |Data flow DF_Mtch_Key_Test|Transform Europe_AddressCleanse Transform <Europe_AddressCleanse>: DLL <libgactransformu.so> runtime function <ProcessRecord> failed with error <4>. More detailed information may be obtained from previous errors.

I have also analysed some of the data but everything seems fine.

If anyone else has encountered with this type of error please provide the solution.

Thanks in advance.

[former_member214856 · Accepted solution]

Looks like this question was also asked via a Support Incident. The answer was created into KBA 2750519

Cause

The GAC transform is not able to process the double quotation marks in address data

Resolution

Remove the double quotation marks in address data as workaround or upgrade DS version to SAP Data Services 4.2 SP11.