Any–Any Transformation Cannot use ‘{}’ for XML names

Any–Any Transformation Cannot use ‘{}’ for XML names

book

Article ID: KB0079935

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization TDV 7.0.5, 7.0.6, 7.0.7

Description

While creating any-any transformation on XML datasource and if XML sources are named with ‘{}’ example (dataset {20} - Brackets) than below error will be displayed.

ERROR [jetty thread pool-869] 2018-06-15 12:16:09.681 +0530 Util -

java.lang.Exception: Error executing /shared/trasnf/Facility: Exception thrown by URIResolver  [transform-1900015]

Cause: Exception thrown by URIResolver

Caused by: java.net.URISyntaxException: Illegal character in path at index 26: /shared/trasnf/XMLSources/"dataset%20{20}%20-%20Brackets.xml"

  at java.net.URI$Parser.fail(Unknown Source)

  at java.net.URI$Parser.checkChars(Unknown Source)

  at java.net.URI$Parser.parseHierarchical(Unknown Source)

  at java.net.URI$Parser.parse(Unknown Source)

  at java.net.URI.<init>(Unknown Source)

  at net.sf.saxon.lib.StandardURIResolver.resolve(StandardURIResolver.java:145)

  ... 55 more

Issue/Introduction

While creating any-any transformation on XML datasource and if XML sources are named with ‘{}’ example (dataset {20} - Brackets) than below error will be displayed.

Resolution

Workaround for this issue.

1. Rename XML sources with ‘()’ simple brackets which are using ‘{}’ brackets.

2. Re introspect the data source.

3. Now we can execute the transformation and get the results.

The fix for this issue has been integrated in TDV 7.0.8 release and available for download.

https://edelivery.tibco.com/storefront/view-download.ep?sku=11801-1&version=7.0.8