Get "Error (S0002, D0)...[SQL Server][Invalid object name...]" quering temp table (4244723)

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Get "Error (S0002, D0)...[SQL Server][Invalid object name...]" quering temp table
Descripción

The following error is returned, when executing SQL that queries a temp table. The SQL runs fine outside of BMF.

Error (S0002, D0) – [Microsoft][SQL Server Native Client 11.0 ][SQL Server][Invalid object name ‘TABLE_NAME’.
Causa

The issue is due to the scope of the temporary table that is created and how BMF does the transactions. Temporary tables are only visible to the user session or stored procedure/function that creates them. BMF prepares and then executes the SQL and if the prepared statement is not called again, the statement is dropped. This causes the temporary table to go out of scope and become not visible to the next transaction.
Resolución

WORKAROUND:
None

STATUS:
This issue is fixed in Benchmark Factory 8.2. This version can be downloaded from the downloads section of our website, which you can access by clicking here.
ID de defecto

BMF-5148

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Historial del artículo:: Creado el: 12/11/2018
Última actualización: 5/7/2023

Título