RE: [development-axapta] SQL sync error
Thanks Dilip, What you say is mostly correct see what I found out (important point is who the owner of the view is): It seems this error is because the view called 'VIEWS' in the master DB of my SQL has the owner as 'dbo' and not 'Information_SCHEMA'. I think maybe at some point I accidental ran the change owner script on the master db rather than the Ax DB Now I just need to find a way to set back the right views etc to the right user...or otherwise reinstall SQL (since I don't have a backup of master before the change owner happened) Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dilip N Sent: 19 July 2005 20:54 To: development-axapta@yahoogroups.com Subject: Re: [development-axapta] SQL sync error Information_schema.views is a system view which resides in master database. First step, you just check whether this view is present in the location by expanding master database-VIews, Nextly, you check if proper permissions like dbo is the owner of the view..I believe it might be corrupted. or if you have another sql server hosted, just try using that copy of master database..maybe backup this master db and restore the other master db.. Good luck :-) James Flavell [EMAIL PROTECTED] wrote: Can anyone tell me anything about INFORMATION_SCHEMA.VIEWS in SQL ...I get teh following error messages when I try to sync Axapta. I guess I am missing this view or table and so the system gets stuck but where shoul dthis view be? In the Ax DB or the master DB or where? I hope someone can help as I am not able to do any sync to my databases because of this... Thanks James Error given during sync: Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCES') DROP VIEW LEDGERBALANCES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCESDIM') DROP VIEW LEDGERBALANCESDIM Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNUSERSPERLINES') DROP VIEW BMRUNUSERSPERLINES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMUSERSCRIPTTIMINGAGG') DROP VIEW BMUSERSCRIPTTIMINGAGG Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNSTEPSPREADING') DROP VIEW BMRUNSTEPSPREADING Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMSCRIPTSTEP') DROP VIEW BMSCRIPTSTEP Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERVENDPAYMPROPOSAL') DROP VIEW LEDGERVENDPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERCUSTPAYMPROPOSAL') DROP VIEW LEDGERCUSTPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'CUSTVIEW') DROP VIEW CUSTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
Re: [development-axapta] SQL sync error
Information_schema.views is a system view which resides in master database. First step, you just check whether this view is present in the location by expanding master database-VIews, Nextly, you check if proper permissions like dbo is the owner of the view..I believe it might be corrupted. or if you have another sql server hosted, just try using that copy of master database..maybe backup this master db and restore the other master db.. Good luck :-) James Flavell [EMAIL PROTECTED] wrote: Can anyone tell me anything about INFORMATION_SCHEMA.VIEWS in SQL ...I get teh following error messages when I try to sync Axapta. I guess I am missing this view or table and so the system gets stuck but where shoul dthis view be? In the Ax DB or the master DB or where? I hope someone can help as I am not able to do any sync to my databases because of this... Thanks James Error given during sync: Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCES') DROP VIEW LEDGERBALANCES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERBALANCESDIM') DROP VIEW LEDGERBALANCESDIM Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNUSERSPERLINES') DROP VIEW BMRUNUSERSPERLINES Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMUSERSCRIPTTIMINGAGG') DROP VIEW BMUSERSCRIPTTIMINGAGG Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMRUNSTEPSPREADING') DROP VIEW BMRUNSTEPSPREADING Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'BMSCRIPTSTEP') DROP VIEW BMSCRIPTSTEP Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERVENDPAYMPROPOSAL') DROP VIEW LEDGERVENDPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERCUSTPAYMPROPOSAL') DROP VIEW LEDGERCUSTPAYMPROPOSAL Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'CUSTVIEW') DROP VIEW CUSTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERACCOUNTVIEW') DROP VIEW LEDGERACCOUNTVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'LEDGERTRANSVIEW') DROP VIEW LEDGERTRANSVIEW Cannot execute the required database operation.,The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'INFORMATION_SCHEMA.VIEWS'. SQL statement: IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE
