The following error message:
"Schema needs to be updated. Contact your system administrator. Sql text: Invalid column name 'dbo'."
is now produced after upgrading to 8.2.3 (from 8.2.2 where application works fine).
This appears to be similar to the reported Bug B97076.
DBUpdater produces a stack trace when attempted.
Upon further investigation, it works with SQL Server Express 2005 but fails with SQL Server 2000. Unfortunately our client
is tied to SQL Server 2000 for the forseeable future.
This really is a showstopper unless we downgrade back to 8.2.2.
Bug Report
B97182
Visible to All Users
Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.
Have just tried to run MainDemo application against a SQL Server 2000 database and got the same error.
The offending generated SQL statement is clearly wrong.
'select fk.name, c.name, rc.name, dbo, rtbl.name
from sysforeignkeys fkdata
join sysobjects fk on fkdata.constid=fk.id
join sysobjects rtbl on rtbl.id=fkdata.rkeyid
join sysobjects tbl on tbl.id=fkdata.fkeyid
join syscolumns c on c.id=fkdata.fkeyid and c.colid=fkdata.fkey
join syscolumns rc on rc.id=fkdata.rkeyid and rc.colid=fkdata.rkey
where tbl.name = @p1 order by fk.name, fkdata.keyno' with parameters {Task},{dbo}
Hi Michael,
Thank you for the report.
This bug has been fixed. The fix contains the DevExpress.Xpo.v8.2 assembly. I suggest you copy this file to the …\Developer Express .NET v8.2\Sources\DevExpress.DLL\ folder with replacing and then uninstall the old version from GAC and install this new one there instead.
Please let us know in case of any difficulty.
Thank you for your patience,
Dennis
Thanks, Dennis
Everything seems to work as before.
Regards,
Mike