Unable to edit any report in Report Builder, after upgrade to 4.1

[gmitrana]

I am unable to edit any report in Report Builder, after the upgrade to 4.1.

The error is "The object " does nor exist in databese 'lansweeperdb' "

[Hemoco]

Please contact us by e-mail to take a look at the problem

[Hemoco]

Please see this page: http://www.lansweeper.com/forum/yaf_postst4741_Fix-Report-builder-the-object--does-not-exist.aspx

[davidgeorge]

Lansweeper wrote:
Please see this page: http://www.lansweeper.com/forum/yaf_postst4741_Fix-Report-builder-the-object--does-not-exist.aspx

I get the following error message "Cannot define PRIMARY KEY constraint on nullable column in table 'tsysreports'" when I execute sql query.

Regards

[Hemoco]

@davidgeorge: which version of SQL, service pack are you using?

[davidgeorge]

Lansweeper wrote:
@davidgeorge: which version of SQL, service pack are you using?

SQL 2000 SP3.

[davidgeorge]

I'm also unable to customise or edit existing reports after upgrading from 4.0 to 4.1.

Error is "Line 1: incorrect syntax near 'from'"

If I try to edit a report is get "the object "does not exist in database 'lansweeperdb'.

[gmitrana]

Email sent.

For now, I saw only the Report Builder within the configuration tool, not working.

I will see in time if other items have issues

[Hemoco]

Is report builder the only thing not working?
Are you using the report builder in the configuration tool?
Can you upload (or mail to lansweeper@hemoco.com) a screenshot of the complete screen with the error please.