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 EngineeringBug Number
212605
Additional Information
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