PCo ignores Tag Value with Comma

[former_member229176]

Hello Friends,

Current Infrastructure:

MII 14.0

PCo 15.0

We are trying to write to PHD database via PCo DA conenctor using TagStore Query.

When we write values to Material tag, it gets written to PHD correctly. But while writing COMMENT tag if it contains Comma, PCo query is ignoring the

text after comma.

If I run this query, it just updates "I am" and ignores ", Testing"

Has anyone faced this problem? What can be the corrective action?

Soham

[former_member196557 · Accepted solution]

Hi Soham,

Please review this SAP Note 2035545

Basically, in PCoQuery expression editor, you have to base64encode the SelectedTagsValue property for all the values being passed, similar to this:

base64encode("value1","value,contains, a comma")

and then set TagValueEncoded property to string value "true"

This will pass the tag values with embedded commas to PCo correctly so that they can be written to the target.

Regards, Steve

[former_member229176 · Accepted solution]

Hi Steve,

Thanks for the information.

Unfortunately, I could not find TagValueEncoded property which i can set to "true".

Am I doing something wrong?

Soham

[former_member196557 · Accepted solution]

Hi Soham,

Please review the SAP Note again. I believe you need MII14.0 SP4 or later to get this functionality.

Regards, Steve

[former_member229176 · Accepted solution]

Hi Steve,

Yeah, it seems so. I will further research and update this forum.

Thanks a ton for your help. At least it showed me a correct path to research on.

Soham