MarkView All Components - URL in MarkView emails contains extra characters.

Applies To

• ERP System: All
• MarkView Version: All

Behavior

• URL in MarkView emails contains extra characters.

Known Causes

• Data migration processes populating MarkView data incorrectly; the SQL*Flow Mail Gateway creates the email from this database record.

Resolution

Run a query similar to:

set lines 150

select property_value from sf_workitem_property_value
where workitem_class_property_id = 37
and property_value like '%http%';

Change '%http%' to something appropriate in the email message (such as '%mvsd?d=123%').

If the url in the property value field looks accurate, without extra carriage returns, spaces or other characters, then the problem is occurring after the email has left MarkView .

The property_value field will contain the entire email message body, not just the url.

Please check the checkbox while importing the transport.

Keywords: url,urls,URL,URLS,email,email message,characters,invalid url,EMAIL,message