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

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