Goal Performance Dashboard Throws Error
Date Published: Feb 17,2021 Category: Planned_First_Fix_Release:SaaS_v3900_8_0; Product:Reporting_Learn,Database_Learn; Version:SaaS Article No.: 000059829
Date Published: Feb 17,2021 Category: Planned_First_Fix_Release:SaaS_v3900_8_0; Product:Reporting_Learn,Database_Learn; Version:SaaS Article No.: 000059829
Product: Blackboard Learn
Release: SaaS
Service Pack(s): SaaS
Description: SaaS Environments return an error message when the Goal Performance report is run for a Student.
Steps to Replicate:
- Log into the Environment as a System Administrator
- Navigate to My Blackboard > Tools > Goal Performance
- View list of Students
- Click on any Student Username
The results of the report would be displayed
Observed Behavior:
SQL compilation error:
Unsupported subquery type cannot be evaluated
For reference, the Error ID is xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
<timestamp>
Unsupported subquery type cannot be evaluated
For reference, the Error ID is xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
<timestamp>
Symptoms:
Target Release: SaaS - Fixed (v3900.8.0)
Patch Available: No
Sample Stack Trace:
2019-04-29 21:24:12 +0000 - [WARNING] SQL compilation error:<br>Unsupported subquery type cannot be evaluated<P><span class="captionText">For reference, the Error ID is 4922c2a3-2d5f-4f91-8cce-a61701334cc6.</span> - net.snowflake.client.jdbc.SnowflakeSQLException: SQL compilation error:
Unsupported subquery type cannot be evaluated
at net.snowflake.client.jdbc.SnowflakeUtil.checkErrorAndThrowException(SnowflakeUtil.java:102)
at net.snowflake.client.core.StmtUtil.execute(StmtUtil.java:410)
at net.snowflake.client.core.SFStatement.executeHelper(SFStatement.java:371)
at net.snowflake.client.core.SFStatement.executeQueryInternal(SFStatement.java:195)
at net.snowflake.client.core.SFStatement.executeQuery(SFStatement.java:147)
at net.snowflake.client.core.SFStatement.describe(SFStatement.java:160)
at net.snowflake.client.jdbc.SnowflakePreparedStatementV1.<init>(SnowflakePreparedStatementV1.java:115)
at net.snowflake.client.jdbc.SnowflakeConnectionV1.prepareStatement(SnowflakeConnectionV1.java:1104)
at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75)
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
at com.sun.proxy.$Proxy27.prepareStatement(Unknown Source)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:288)
at blackboard.db.impl.MonitoringConnectionPool$MonitoringConnection.prepareStatement(MonitoringConnectionPool.java:112)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:288)
at blackboard.db.impl.SafetyNetConnection.prepareStatement(SafetyNetConnection.java:290)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:288)
at org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImpl.createPreparedStatement(PreparedStatementCreatorFactory.java:238)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:623)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680)
...
Target Release: SaaS - Fixed (v3900.8.0)
Patch Available: No