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

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

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>