An error message is returned when executing "getResource" operation with the parameters "TABLE" and "FULL" in TIBCO Data Virtualization.

An error message is returned when executing "getResource" operation with the parameters "TABLE" and "FULL" in TIBCO Data Virtualization.

book

Article ID: KB0074495

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Supported Versions

Description

Executing the below snippet for "getResource" webservice operation present at the path "/services/webservices/system/admin/resource/operations" on a table in TDV Studio may fail with an error message.
 

<resource:getResource xmlns:resource="http://www.compositesw.com/services/system/admin/resource" xmlns:common="http://www.compositesw.com/services/system/util/common">
  <resource:path>/shared/Test/Tablename</resource:path>
  <resource:type>TABLE</resource:type>
  <resource:detail>FULL</resource:detail>
</resource:getResource>

Below is the error message that may be returned:

Error: value may not be null.

Environment

All supported operating system.

Resolution

The error message is returned when the webservice operations "getResource" with "FULL" detail is executed on a table containing index columns without name.
When this webservice operation is executed on the same table using the "SIMPLE" detail value then the error message is not returned.

The below steps may help to resolve the error:

1. Remove the index columns without names from the table at the database end.
2. Re-introspect the data source to which the tables belongs.
3. Execute the web service operation to see if no error message is returned.

Issue/Introduction

An error message is returned when executing "getResource" operation with the parameters "TABLE" and "FULL" in TIBCO Data Virtualization.