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:

Windows

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.

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