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

  • Document ID:3680450
  • Creation Date:14-Nov-2006
  • Modified Date:08-Feb-2013
    • Micro Focus Products:
      ZENworks Asset Management

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