Why does the execution of the pubtest.bat file fail with an error?

Why does the execution of the pubtest.bat file fail with an error?

book

Article ID: KB0070690

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Supported Versions

Description

 PubTest is used to ensure that resources published by a Composite server are functioning properly. Every time a new resource is published, a test should be added to PubTest’s input file to test that new resource. 

To execute pubtest.bat, open the command prompt and navigate to the location:
'..\<TDV_Server_Dir>\apps\jdbc'


A sample command to run the executable file:
 pubtest.bat -host localhost -dbPort 9811 -wsPort 9810 -user admin -password password -domain composite -input pubtest_sample.dat -printOutput true -encrypt false

On execution, the following error was encountered as displayed in the image:

User-added image

Issue/Introduction

This article will share the steps required to avoid errors while executing the file pubtest.bat.

Environment

Windows

Resolution

The user encounters this error as there is no published datasource with the name 'examples' in the TDV instance against which this test is created using the procedure 'LookupProduct'.

To resolve this issue, the user will have to publish 'LookupProduct' in TDV Studio under 'Composite Data Services > Databases'. They will also have to ensure that the published datasource's name is entered as 'examples'.

After completing this operation, execute the command again using pubtest.bat and the issue will be resolved.