cancel
Showing results for 
Search instead for 
Did you mean: 

Error during Content conversion

Former Member
0 Kudos

Hi,

The scenario is file to file. Inbound and async. The encrypted data is coming from third party. we are decrypting it and doing the content conversion. Earlier there was only 1 node. now the requirement is that they will be sending the header also. now there are 2 nodes with children. earlier there was only 1 node with children and the data was processing successfully. now when I have added header the fields of the header are not getting the value. Like header has the fields like Number_of_records, sbm_system_date etc.. but the fields of the header are getting replaced by the fields of the other node. I have attached the screenshots for the same. let me know if you need any more information. The payload is like below

<?xml version="1.0" encoding="utf-8" ?>

- <ns:MT_BillingData_SBM xmlns:ns="http://pspcl.com/xi/SBM/IF0043_BillingData_100">

- <BillingData_SBM>

<SUB_DIVISION_CODE>11</SUB_DIVISION_CODE>

<MRU>16/08/2014</MRU>

<Connected_Pole_INI_Number>11:26:09</Connected_Pole_INI_Number>

<NEIGHBOR_METER_NO>I0027G14_14082014112726.enc</NEIGHBOR_METER_NO>

<STREET_NAME>1</STREET_NAME>

<INSTALLATION>I0027G14</INSTALLATION>

</BillingData_SBM>

- <BillingData_SBM>

<SUB_DIVISION_CODE>4272</SUB_DIVISION_CODE>

<MRU>MR60BM</MRU>

<Connected_Pole_INI_Number>J-DP06-FL12-031-004_G-1-P07</Connected_Pole_INI_Number>

<NEIGHBOR_METER_NO />

<STREET_NAME />

<INSTALLATION>5000057583</INSTALLATION>

<MR_DOC_NO>200000001829984</MR_DOC_NO>

<SCHEDULED_MRDATE>25-04-2014</SCHEDULED_MRDATE>

<METER_NUMBER>10089749</METER_NUMBER>

<MANUFACTURER_SR_NO>3376181</MANUFACTURER_SR_NO>

<MANUFACTURER_NAME>Capital Meters</MANUFACTURER_NAME>

<CONTRACT_ACCOUNT_NUMBER>100106763</CONTRACT_ACCOUNT_NUMBER>

<CONSUMPTION_KWH>16430.000</CONSUMPTION_KWH>

<CONSUMPTION_KWAH>18256.000</CONSUMPTION_KWAH>

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Sherwin,

In your FCC you have added only <BillingData_SBM> node RecordSetStructe in channel, so the header data not coming in your payload. add <BillingData_Header> also like below.

RecordSet Structure: BillingData_Header, 1 ,BillingData_SBM, *

Regards,

Praveen

Former Member
0 Kudos

HI Praveen,

I am not able to understand your 2nd reply. Can you please tell me again.

Thanks,

Sherwin

Former Member
0 Kudos

Hi Sherwin,

The "BillingData_Header" node not created in your XML payload because you have not added the node "BillingData_Header" in your FCC.

Add that node in recordset structure like below.

This will convert your FCC into XML with nodes <BillingData_Header> and <BillingData_SBM>.

<?xml version="1.0" encoding="utf-8" ?>

<ns:MT_BillingData_SBM xmlns:ns="http://pspcl.com/xi/SBM/IF0043_BillingData_100">

  <BillingData_Header>

  ....

  </BillingData_Header>

  <BillingData_SBM>

  ....

  </BillingData_SBM>

</MT_BillingData_SBM>

Please check this link SAPTechnical.COM - File Content Conversion

Regards,

Praveen

Former Member
0 Kudos

Sorry for the late reply. I will Check and will inform you the status. Thank you very much for the help.

Former Member
0 Kudos

Hi,

I have done the following changes but still the result is same.

former_member191435
Contributor
0 Kudos

whenever you are doing such scenarios I mean header,1 , detail, *

we need Keyfield in both header as well as Detail otherwise FCC wont perform correctly...

Meanwhile if you have keyfields in both structure use the same content conversion and add one more parameter

ignoreRecordsetName = true

let us know if you stillface an issue.

Thanks,

Sreenivas

Former Member
0 Kudos

Hi All,

The problem is still the same. Please check the screenshot which I have put. I must be using 1 wrong parameter or Must be missing a required parameter. Please help.

Thanks,

former_member191435
Contributor
0 Kudos

Hi,

what is your keyfield value for detail segmant i.e. occurence ..unblunded one..

Former Member
0 Kudos

Hi ,

Its (0,1)

Thanks

former_member191435
Contributor
0 Kudos

Hi can u please paste ur structure here once again

I will tell u the fcc for that..

and tel me what is the error ur getting now...

Former Member
0 Kudos

The last field of the node BillingData_SBM is also KeyField.

former_member191435
Contributor
0 Kudos

please show m eur content conversion and wat is the error ur getting right now....

Former Member
0 Kudos

I am using the below entries for content conversion.

BillingData_Header.fieldSeparator,
BillingData_Header.endSeparator'nl'
BillingData_Header.fieldNamesOf_Records,BillingData_Header,BillingData_SBM,KeyField
BillingData_Header.keyFieldInStructureignore
BillingData_Header.keyFieldValueH
BillingData_SBM.fieldSeparator,
BillingData_SBM.endSeparator'nl'
BillingData_SBM.fieldNamesSUB_DIVISION_CODE,MRU,Connected_Pole_INI_Number,NEIGHBOR_METER_NO,STREET_NAME,INSTALLATION,MR_DOC_NO,SCHEDULED_MRDATE,METER_NUMBER,MANUFACTURER_SR_NO,MANUFACTURER_NAME,CONTRACT_ACCOUNT_NUMBER,CONSUMPTION_KWH,CONSUMPTION_KWAH,CONSUMPTION_KVA,CUR_METER_READING_KWH,CUR_METER_READING_KVA,CUR_METER_READING_KVAH,CUR_METER_READING_DATE,CUR_METER_READING_TIME,CUR_METER_READER_NOTE,PRV_METER_READING_KWH,PRV_METER_READING_KVA,PRV_METER_READING_KWAH,PRV_METER_READING_DATE,PRV_METER_READING_TIME,PRV_METER_READER_NOTE,OCTROI_FLAG,SOP,ED,OCTROI,DSSF,SURCHARGE_LEIVED,SERVICE_RENT,METER_RENT,SERVICE_CHARGE,MONTHLY_MIN_CHARGES,PF_SURCHARGE,PF_INCENTIVE,DEMAND_CHARGES,FIXEDCHARGES,VOLTAGE_SURCHARGE,PEAKLOAD_EXEMPTION_CHARGES,SUNDRY_CHARGES,MISCELLANEOUS_CHARGES,FUEL_ADJUSTMENT,BILL_NUMBER,NO_OF_DAYS_BILLED,BILL_CYCLE,BILL_DATE,DUE_DATE,BILL_TYPE,PAYMENT_AMOUNT,PAYMENT_MODE,CHECK_NO,BANK_NAME,PAYMENT_ID,IFSC_CODE,MICRCODE,PAYMENT_DATE,PAYMENT_REMARK,TOT_BILLAMOUNT,SBM_NUMBER,METER_READER_NAME,INHOUSE_OUTSOURCED_SBM,TransfromerCode,MCB_RENT,LPSC,TOT_AMT_DUE_DATE,TOT_SOP_ED_OCT,KeyField
BillingData_SBM.keyFieldInStructureignore
BillingData_SBM.keyFieldValueP
ignoreRecordsetNametrue

The error is like I am not able to get the value/fields of the header. only the fields of BillingData_SBM is getting displayed.

former_member191435
Contributor
0 Kudos

please follow below procedure...

Still if u r facing any issues please let me know... and show me ur input data....

Thanks,

Sreenivas

Former Member
0 Kudos

Hi,

I am still facing the issue. below is the input data.

11,16/08/2014,11:26:09,I0027G14_14082014112726.enc,1,I0027G14,H

4272,MR60BM,J-DP06-FL12-031-004_G-1-P07,,,5000057583,200000001829984,25-04-2014,10089749,3376181,Capital Meters,100106763,16430.000,18256.000,0.000,0.000,0.000,0.000,13-08-2014,182427,D,19170.000,0.000,0.000,30-06-2011,,,Y,95465.00,7636.92,1643.00,4773.08,0.00,0.00,292.00,0.00,11638.20,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,I002714H131824001,1141,2,28-08-2014,26-08-2014,2,0.00,,,,,,,,,109970.00,I0027G14,USER1,PSPCL,,156.00,9591.00,119561.00,109518.00,P

4272,MR60BM,J-DP06-FL12-031-004_G-1-P06,,,5000057703,200000001830038,25-04-2014,10089869,8,Saraf Industries,100106883,5429.000,6032.000,0.000,0.000,0.000,0.000,13-08-2014,182458,N,10990.000,0.000,0.000,31-08-2011,,,Y,27437.00,2195.08,543.00,1371.92,0.00,0.00,294.00,0.00,6963.88,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,I002714H131824002,1078,2,28-08-2014,26-08-2014,2,0.00,,,,,,,,,71110.00,I0027G14,USER1,PSPCL,,146.00,2788.00,73898.00,70671.00,P

4272,MR60BM,J-DP06-FL12-031-004_G-1-P06,,,5000057589,200000001829990,25-04-2014,10089755,426884,BHEL,100106769,4811.000,5346.000,0.000,0.000,0.000,0.000,14-08-2014,093421,N,2550.000,0.000,0.000,30-06-2011,,,Y,23404.00,1872.62,481.00,1170.38,0.00,0.00,317.00,0.00,11143.64,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,I002714H140934003,1142,2,02-09-2014,27-08-2014,2,0.00,,,,,,,,,27400.00,I0027G14,USER1,PSPCL,,156.00,2388.00,29788.00,26928.00,P

4272,MR60BM,J-DP06-FL12-031-004_G-1-P04,,,5000057735,200000001830044,25-04-2014,10089901,371552,Havell,100106915,12627.000,14030.000,0.000,16000.000,0.000,0.000,14-08-2014,093448,I,17580.000,0.000,0.000,31-08-2011,,,Y,71534.00,5722.46,1263.00,3576.54,0.00,0.00,294.00,0.00,3338.43,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,I002714H140934004,1079,2,02-09-2014,27-08-2014,2,0.00,,,,,,,,,125150.00,I0027G14,USER1,PSPCL,,146.00,7197.00,132347.00,124708.00,P

4272,MR60BM,J-DP06-FL12-031-004_G-1-P04,,,5000057727,200000001830039,25-04-2014,10089893,826804,ECE,100106907,20717.000,23019.000,0.000,0.000,0.000,0.000,14-08-2014,093606,D,29810.000,0.000,0.000,31-08-2011,,,Y,123634.00,9890.46,2072.00,6181.54,0.00,0.00,294.00,0.00,13463.76,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,I002714H140936005,1079,2,02-09-2014,27-08-2014,2,0.00,,,,,,,,,181900.00,I0027G14,USER1,PSPCL,,146.00,12407.00,194307.00,181456.00,P

former_member191435
Contributor
0 Kudos

its working fine for me...

Can you please recheck and do whatever I did in FCC...

Dont use DocumentOffset parameter here ...

Former Member
0 Kudos

Hi,

Thanks for the reply. I have used the parameters in FCC which I have posted above. are they correct?

I am not getting the desired result. There may be issue with the input file/Parameters.

I am getting the below result in which the header values are not coming.

<?xml version="1.0" encoding="utf-8" ?>

- <ns:MT_BillingData_SBM xmlns:ns="http://pspcl.com/xi/SBM/IF0043_BillingData_100">

- <BillingData_SBM>

<SUB_DIVISION_CODE>4272</SUB_DIVISION_CODE>

<MRU>MR60BM</MRU>

<Connected_Pole_INI_Number>J-DP06-FL12-031-004_G-1-P07</Connected_Pole_INI_Number>

<NEIGHBOR_METER_NO />

<STREET_NAME />

<INSTALLATION>5000057583</INSTALLATION>

<MR_DOC_NO>200000001829984</MR_DOC_NO>

<SCHEDULED_MRDATE>25-04-2014</SCHEDULED_MRDATE>

<METER_NUMBER>10089749</METER_NUMBER>

<MANUFACTURER_SR_NO>3376181</MANUFACTURER_SR_NO>

<MANUFACTURER_NAME>Capital Meters</MANUFACTURER_NAME>

<CONTRACT_ACCOUNT_NUMBER>100106763</CONTRACT_ACCOUNT_NUMBER>

<CONSUMPTION_KWH>16430.000</CONSUMPTION_KWH>

<CONSUMPTION_KWAH>18256.000</CONSUMPTION_KWAH>

<CONSUMPTION_KVA>0.000</CONSUMPTION_KVA>

<CUR_METER_READING_KWH>0.000</CUR_METER_READING_KWH>

<CUR_METER_READING_KVA>0.000</CUR_METER_READING_KVA>

<CUR_METER_READING_KVAH>0.000</CUR_METER_READING_KVAH>

<CUR_METER_READING_DATE>13-08-2014</CUR_METER_READING_DATE>

<CUR_METER_READING_TIME>182427</CUR_METER_READING_TIME>

<CUR_METER_READER_NOTE>D</CUR_METER_READER_NOTE>

<PRV_METER_READING_KWH>19170.000</PRV_METER_READING_KWH>

<PRV_METER_READING_KVA>0.000</PRV_METER_READING_KVA>

<PRV_METER_READING_KWAH>0.000</PRV_METER_READING_KWAH>

<PRV_METER_READING_DATE>30-06-2011</PRV_METER_READING_DATE>

<PRV_METER_READING_TIME />

<PRV_METER_READER_NOTE />

<OCTROI_FLAG>Y</OCTROI_FLAG>

<SOP>95465.00</SOP>

<ED>7636.92</ED>

<OCTROI>1643.00</OCTROI>

<DSSF>4773.08</DSSF>

<SURCHARGE_LEIVED>0.00</SURCHARGE_LEIVED>

<SERVICE_RENT>0.00</SERVICE_RENT>

<METER_RENT>292.00</METER_RENT>

<SERVICE_CHARGE>0.00</SERVICE_CHARGE>

<MONTHLY_MIN_CHARGES>11638.20</MONTHLY_MIN_CHARGES>

<PF_SURCHARGE>0.00</PF_SURCHARGE>

<PF_INCENTIVE>0.00</PF_INCENTIVE>

<DEMAND_CHARGES>0.00</DEMAND_CHARGES>

<FIXEDCHARGES>0.00</FIXEDCHARGES>

<VOLTAGE_SURCHARGE>0.00</VOLTAGE_SURCHARGE>

<PEAKLOAD_EXEMPTION_CHARGES>0.00</PEAKLOAD_EXEMPTION_CHARGES>

<SUNDRY_CHARGES>0.00</SUNDRY_CHARGES>

<MISCELLANEOUS_CHARGES>0.00</MISCELLANEOUS_CHARGES>

<FUEL_ADJUSTMENT>0.00</FUEL_ADJUSTMENT>

<BILL_NUMBER>I002714H131824001</BILL_NUMBER>

<NO_OF_DAYS_BILLED>1141</NO_OF_DAYS_BILLED>

<BILL_CYCLE>2</BILL_CYCLE>

<BILL_DATE>28-08-2014</BILL_DATE>

<DUE_DATE>26-08-2014</DUE_DATE>

<BILL_TYPE>2</BILL_TYPE>

<PAYMENT_AMOUNT>0.00</PAYMENT_AMOUNT>

<PAYMENT_MODE />

<CHECK_NO />

<BANK_NAME />

<PAYMENT_ID />

<IFSC_CODE />

<MICRCODE />

<PAYMENT_DATE />

<PAYMENT_REMARK />

<TOT_BILLAMOUNT>109970.00</TOT_BILLAMOUNT>

<SBM_NUMBER>I0027G14</SBM_NUMBER>

<METER_READER_NAME>USER1</METER_READER_NAME>

<INHOUSE_OUTSOURCED_SBM>PSPCL</INHOUSE_OUTSOURCED_SBM>

<TransfromerCode />

<MCB_RENT>156.00</MCB_RENT>

<LPSC>9591.00</LPSC>

<TOT_AMT_DUE_DATE>119561.00</TOT_AMT_DUE_DATE>

<TOT_SOP_ED_OCT>109518.00</TOT_SOP_ED_OCT>

<KeyField>P</KeyField>

</BillingData_SBM>

- <BillingData_SBM>

<SUB_DIVISION_CODE>4272</SUB_DIVISION_CODE>

<MRU>MR60BM</MRU>

<Connected_Pole_INI_Number>J-DP06-FL12-031-004_G-1-P06</Connected_Pole_INI_Number>

<NEIGHBOR_METER_NO />

<STREET_NAME />

<INSTALLATION>5000057703</INSTALLATION>

<MR_DOC_NO>200000001830038</MR_DOC_NO>

<SCHEDULED_MRDATE>25-04-2014</SCHEDULED_MRDATE>

<METER_NUMBER>10089869</METER_NUMBER>

<MANUFACTURER_SR_NO>8</MANUFACTURER_SR_NO>

<MANUFACTURER_NAME>Saraf Industries</MANUFACTURER_NAME>

<CONTRACT_ACCOUNT_NUMBER>100106883</CONTRACT_ACCOUNT_NUMBER>

<CONSUMPTION_KWH>5429.000</CONSUMPTION_KWH>

<CONSUMPTION_KWAH>6032.000</CONSUMPTION_KWAH>

<CONSUMPTION_KVA>0.000</CONSUMPTION_KVA>

former_member191435
Contributor
0 Kudos

can u please do the FCC whatever I posted with screenshot and let me know....

Former Member
0 Kudos

Hi,

Here are the parameters which I have used.

BillingData_Header.fieldSeparator,
BillingData_Header.endSeparatornl
BillingData_Header.fieldNamesNumber_Of_Records,BillingData_Header,BillingData_SBM,KeyField
BillingData_Header.KeyFieldNameKeyField
BillingData_Header.keyFieldValueH
BillingData_SBM.fieldSeparator,
BillingData_SBM.endSeparatornl
BillingData_SBM.fieldNamesSUB_DIVISION_CODE,MRU,Connected_Pole_INI_Number,NEIGHBOR_METER_NO,STREET_NAME,INSTALLATION,MR_DOC_NO,SCHEDULED_MRDATE,METER_NUMBER,MANUFACTURER_SR_NO,MANUFACTURER_NAME,CONTRACT_ACCOUNT_NUMBER,CONSUMPTION_KWH,CONSUMPTION_KWAH,CONSUMPTION_KVA,CUR_METER_READING_KWH,CUR_METER_READING_KVA,CUR_METER_READING_KVAH,CUR_METER_READING_DATE,CUR_METER_READING_TIME,CUR_METER_READER_NOTE,PRV_METER_READING_KWH,PRV_METER_READING_KVA,PRV_METER_READING_KWAH,PRV_METER_READING_DATE,PRV_METER_READING_TIME,PRV_METER_READER_NOTE,OCTROI_FLAG,SOP,ED,OCTROI,DSSF,SURCHARGE_LEIVED,SERVICE_RENT,METER_RENT,SERVICE_CHARGE,MONTHLY_MIN_CHARGES,PF_SURCHARGE,PF_INCENTIVE,DEMAND_CHARGES,FIXEDCHARGES,VOLTAGE_SURCHARGE,PEAKLOAD_EXEMPTION_CHARGES,SUNDRY_CHARGES,MISCELLANEOUS_CHARGES,FUEL_ADJUSTMENT,BILL_NUMBER,NO_OF_DAYS_BILLED,BILL_CYCLE,BILL_DATE,DUE_DATE,BILL_TYPE,PAYMENT_AMOUNT,PAYMENT_MODE,CHECK_NO,BANK_NAME,PAYMENT_ID,IFSC_CODE,MICRCODE,PAYMENT_DATE,PAYMENT_REMARK,TOT_BILLAMOUNT,SBM_NUMBER,METER_READER_NAME,INHOUSE_OUTSOURCED_SBM,TransfromerCode,MCB_RENT,LPSC,TOT_AMT_DUE_DATE,TOT_SOP_ED_OCT,KeyField
BillingData_SBM.keyFieldNameKeyField
BillingData_SBM.keyFieldValueP
ignoreRecordsetNametrue
former_member191435
Contributor
0 Kudos

use ignorerecordset name as first one and better use endseparator at last.....

and let me know...

please paste audit log of ur comunication channel...

Thanks,

Sreenivas

Former Member
0 Kudos

Hi Shrewin,

The below entry in your FCC is wrong i think.

BillingData_Header.fieldNamesNumber_Of_Records,BillingData_Header,BillingData_SBM,KeyField

Correct entry:

BillingData_Header.fieldNames Number_Of_Records,SBM_System_Date,SBM_System_Time,SBM_System_File_Name,Billing_Cycle,SBM_Number,KeyField

Based on your configuration keyfield is 4th element but in your file its coming as the 7th element.

Try the configuration suggested by sreenivas, it works for me also.

Regards,

Praveen

Former Member
0 Kudos

Yes right. I have corrected it and it is working fine now. Thank you so much Sreenivas Veldanda and praveen kumar. You guys are great

Former Member
0 Kudos

Hi Sherwin,

Please find the below link might be help you.

Regards,

Rajendar K