Details: [Microsoft][ODBC Driver Manager] Invalid cursor state

  • 3680450
  • 14-Nov-2006
  • 08-Feb-2013

Environment

Novell ZENworks 7 Asset Management - ZAM7

Situation

Error on screen: The data you requested is not available. Details: [Microsoft][ODBC Driver Manager] Invalid cursor state

Resolution

At sites where this has already occurred you can run the below script from within the SQL Query Analyzer against the ZAM database to correct:
 
-- This will associate custom reports whose owner has been deleted with a non-login user.
-- This will enable an enterprise administrator to open the reports.
 
Begin declare @defuser uniqueidentifier; set @defuser = (select top 1 ncuseroid from NC_NCUSER where Role=6); update wc_creport set accountid = @defuser where not accountid in (select ncuseroid from nc_ncuser) end;

Status

Reported to Engineering

Bug Number

212605

Additional Information

Steps to duplicate:
  1. Create a custom report as user A
  2. Log in as user B, and delete user A
  3. Try to open custom report definitions created by A