ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CASE SENSITIVE column error in Javelin Bulk Copy

book

Article ID: 186392

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Facing issue with CASE SENSITIVE column error in Javelin Bulk Copy

Error in Javelin:

Running flow...

2020-02-14 11:39:31 - Run flow: C:\Users\TestUsr\Documents\GTSubset\vf_TT)_Test_BTT.vwf

2020-02-14 11:39:32 - Running Test Case: Flowchart

2020-02-14 11:39:32 - Running Test Case: Bulk Copy

2020-02-14 11:39:32 - Executing Step: Read data from SSO.C_PLLL

2020-02-14 11:39:32 - With Params:

2020-02-14 11:39:32 - Variable Name = AdditionalConnectionParameters                             Value = <NULL>

2020-02-14 11:39:32 - Variable Name = OdbcConnectionString                   Value = <NULL>

2020-02-14 11:39:32 - Variable Name = OleDbConnectionString                 Value = <NULL>

2020-02-14 11:39:32 - Variable Name = Timeout                                Value = 0

2020-02-14 11:39:32 - Variable Name = CommandTimeout                           Value = 600

2020-02-14 11:39:32 - Variable Name = Database                              Value = xxxx

2020-02-14 11:39:32 - Variable Name = Port                        Value = 61932

2020-02-14 11:39:32 - Variable Name = Provider                               Value = DB2

2020-02-14 11:39:32 - Variable Name = Query                    Value = select ....

2020-02-14 11:39:32 - Variable Name = Schema                 Value = SSO

2020-02-14 11:39:32 - Variable Name = Server                   Value = xxx

2020-02-14 11:39:32 - Variable Name = ServiceName                      Value =

2020-02-14 11:39:32 - Variable Name = Username                           Value = xxxxx

2020-02-14 11:39:32 - Connecting to database...

2020-02-14 11:39:33 - Executing  query

2020-02-14 11:39:33 - Error executing Read data from SSO.C_PLLL: ERROR [42703] [IBM][DB2/LINUXX7777] SQL0206N  "TESTQREPVERTIME" is not valid in the context where it is used.

2020-02-14 11:39:33 - Running Test Case: Bulk Copy

2020-02-14 11:39:33 - Test Case: Bulk Copy Execution Complete

2020-02-14 11:39:33 - Running Test Case: Flowchart

2020-02-14 11:39:33 - Test Case: Flowchart Execution Complete

Cause

Defect

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

The issue is resolved in the Subset version SubSet-4.9.5.0.zip.