Error, "The column name OutputColumn1 is not valid" when we use SQL Functions in JDBC Query?

book

Article ID: KB0092762

calendar_today

Updated On:

Products	Versions
TIBCO ActiveMatrix BusinessWorks	-
Not Applicable	-

Description

Description:
Use the JDBC query with SQL Functions, e.g., SELECT count(*) FROM [master].[dbo].[spt_values]] then we get the following error:
>>>>>>>>>>>
<CausedBy> com.tibco.bw.palette.jdbc.runtime.faults.JDBCSQLException: TIBCO-BW-PALETTE-JDBC-500009: SQL Exception occurred (SQL STATE = S1093) - detailMessage - The column name OutputColumn1 is not valid.-
>>>>>>>>>>>>

Symptoms:
Error similar to:
>>>>>>>>>>>
<CausedBy> TIBCO-BW-CORE-500051: Activity [JDBCQuery] fault.
<CausedBy> com.tibco.bw.palette.jdbc.runtime.faults.JDBCSQLException: TIBCO-BW-PALETTE-JDBC-500009: SQL Exception occurred (SQL STATE = S1093) - detailMessage - The column name OutputColumn1 is not valid.- {ActivityName=JDBCQuery, ProcessName=jdbc_sqlserver.module.Process, ModuleName=JDBC_SQLServer.module}
>>>>>>>>>>>>

Cause:
This issue is due to defect#AMBW-18192 in BW 6.2.0 HF3

Resolution

Use the SQL Functions, e.g., count, avg, etc., with AS to resolve the issue.

For example: Instead of running SELECT count (*) FROM <Table_Name> use SELECT count (*) as <Name> FROM <Table_Name>