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

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

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

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’.
Ursache

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.
Lösung

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.
Fehler-ID

BMF-5148

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Artikelhistorie:: Erstellt am: 12/11/2018
Letzte Aktualisierung am: 5/7/2023

Titel