In preview for a Select in a SEC_SQLI Variable using bind parameter the first row of the result is taken as the column header

book

Article ID: 87887

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

When you click preview in the SEC_SQLI with the variableas bind parameter, the first row of the result is taken as the column header:

<Please see attached file for image>

0EMb0000000Hvrz.png

If you use a fixed value (literal) instead, it works as expected:

<Please see attached file for image>

0EMb0000000HvsE.png


 

Cause

Cause type:
Defect
Root Cause: N/A

Environment

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution

This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Version(s):
Automation.Engine 10.0.6 - already released
Automation.Engine 11.1.2 - already released
Automation.Engine 11.2.0 - already released

Additional Information

Workaround :
N/A

Attachments

1558692884139000087887_sktwi1f5rjvs16lvy.png get_app
1558692882443000087887_sktwi1f5rjvs16lvx.png get_app