Error during data upload through procss chain

[Former Member]

Dear Experts,

During the load of the data through process chain I got the error in details tab:

Error when assigning SID: Action VAL_SID_CONVERT table 0DOC_HD_TXT

Value "Stale GCBY11055 (PIONEER" (HEX 5300740061006C00650020001B004700430042005900310031) of characteristic

0DOC_HD_TXT contains an error at position 7

Process 000039 returned with errors.

My question is what was the reason and how could this problem could be solved.

Thanks

[former_member182516]

Hi JKTECH,

First delete the request from DSO.

Goto DS-manage to get the PSA data.

Select the column 0DOC_HD_TXT and filter the values"Stale #GCBY11055 (PIONEER" and try to edit the value and save the record and reload the data to DSO(trigger the DTP) and activate the data.

Remove the # value from the Record and save it, it will work.

Regards

KP

[Former Member]

Dear All,

Thanks for all your help.

[Former Member]

Hi,

I think the IO 0DOC_HD_TXT is holding some Description. Make sure that "Lowercase Letters" check box is checked for that IO. Also if you are getting any special characters in that description, either correct them at PSA level or include that special charcter in RSKC trans. Delete the Red request from DSO & run the DTP again.

At PSA there wont be any validation check w.r.t data. So Whatever the data you get from source, it will be loaded into PSA & request will be Green. Even when you load to DSO it will be loaded fine without any errors. But when you activate the Data in DSO, it will check for the correctness of the data. So if there are any disperencies, it will give the error.

Hope it helps!

Regards,

Pavan

[Former Member]

Hi,

But how can I find which is the erroneous record in the psa.As the request is showing green in the psa level.

Thanks

[Former Member]

Also below is the error shown in the detail tab:

Characters that have a hexadecimal display between HEX00 and HEX1F are not permitted in characteristic values. The character at position 7 is one of these characters. The value is therefore not permitted.

Note that these characters cannot be displayed and are therefore displayed as '#'. The actual character '#' has the hexadecimal display HEX23.

Thanks

[Former Member]

Hi

If you are getting the error in the DSO activation step

step 1: delete the red requestfrom DSO?

step 2: Goto the PSA of the datasource----

---

>filter the field 0DOC_HD_TXT with description "Stale" and check for the description "Stale GCBY11055 (PIONEER" and click on change you will see the # in the value remove the # and save the record in PSA

step 3: Goback to the psa moniotr and load the request to the target using scheduler

step 4: repeat from the failed step in the process chain

Thanks

[Former Member]

The issue is coming due to special character in the text most likely the back space arrow... if you can remove it, the activation should be correct

[Former Member]

Should I correct the error in the PSA level ?

Thanks

[Former Member]

yes, can do at PSA level

[Former Member]

But the error is not at psa level since the request status that is displayed is green.

Then where should I correct the error?.

Thanks

[Former Member]

Since there is no issue with dataloading, PSA is accepting the value <- without an error, so the request is green,

when you are trying to load the data from PSA to target, the SID is being generated... thats when the error is occuring... so if you find that record in PSA and correct it... the SID generation will be successful.