We’re currently experiencing a high volume of support requests, which may result in longer response times — Thank you for your patience and understanding.
Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Dennis_Tap
Engaged Sweeper
The object 'web30repnameofthereport' does not exist in database 'Lansweeper32' or is invalid for this operation.

Me and my fellow systemsmanager made a few report scripts of our own, but some of them went wrong.
Now I checked the SQL DB and the above message is correct, the object no longer exists in the DB.
Apparently when it goes wrong it erases the entire script and fails to open the report or remove the report from the builder.
But how do you remove it from the report builder when it is no longer in the DB?
Selecting and pressing delete does nothing, right clicking gives no remove option.
I already tried to find it in the DB but isn't there an easy way to remove reports that went bad?

Please help me, I made a working report but because of the bad original still in there I cant add it to the UI.
Because everything after that report goes invisible.

SELECT 
dbo.tblComputers.Computername,
dbo.tblSerialnumber.ProductKey
FROM
dbo.tblComputers
INNER JOIN dbo.tblSerialnumber ON (dbo.tblComputers.Computername = dbo.tblSerialnumber.Computername)
WHERE
dbo.tblSerialnumber.Product NOT LIKE 'Internet Explorer' AND
dbo.tblSerialnumber.Product = 'Microsoft Windows XP'


As you can see, this only gives all XP serials. And its scripted correct, so I realy believe the origin comes from the original that cant be removed.
2 REPLIES 2
Dennis_Tap
Engaged Sweeper
Thanks, that helps!
Hemoco
Lansweeper Alumni
We have an updated version of the report builder which will be released next week together with 3.5.1. (which makes it easy to delete bad reports)
Meanwhile you can manually delete the report from table tsysreports

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now