Novell ZENworks 7 Asset Management - ZAM7
Error on screen: The data you requested is not available. Details: [Microsoft][ODBC Driver Manager] Invalid cursor state
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;
StatusReported to Engineering
Steps to duplicate:
- Create a custom report as user A
- Log in as user B, and delete user A
- Try to open custom report definitions created by A