Mysql Error While Fetching Schema Table Status
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: MySQL Administrator :: Error: Could Not Fetch Schema Table Status New Topic Advanced Search Error: Could Not Fetch Schema Table Status Posted by: Joan Nunez () Date: August 28, 2007 10:44AM Hi, i'm getting this error every time i try to see any schema with MySQL ADMINISTRATOR.. a similar error occurs with MySQL BROWSER Error MySQL ADMINISTRATOR: Could Not Fetch Schema Table Status Error MySQL BROWSER: Could Not Fetch Columns Can someone Help me with this... Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted Error: Could Not Fetch Schema Table Status Joan Nunez 08/28/2007 10:44AM Re: Error: Could Not Fetch Schema Table Status Joan Nunez 08/28/2007 12:44PM Re: Error: Could Not Fetch Schema Table Status Frank Albrecht 09/11/2007 05:15AM Re: Error: Could Not Fetch Schema Table Status Steve Betts 03/11/2008 09:43PM Re: Error: Could Not Fetch Schema Table Status Steve Betts 03/11/2008 09:50PM Re: Error: Could Not Fetch Schema Table Status Julio Ferrari 04/16/2008 12:42PM Re: Error: Could Not Fetch Schema Table Status Steve Parker 08/01/2008 12:13PM Re: Error: Could Not Fetch Schema Table Status Vesa Nieminen 08/13/2008 11:14PM Re: Error: Could Not Fetch Schema Table Status Linus Gustafsson 10/16/2008 02:27AM Re: Error: Could Not Fetch Schema Table Status Michelle Inzunza 04/01/2009 10:01AM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community Server MySQL Cluster MySQL Fabric MySQL Utilities MySQL Workbench About MySQL Contact Us How to Buy Partners Job Opportunities Site Map Documentation MySQL Reference Manuals MySQL Workbench Expert Guides Topic Guides MySQL Cluster Legal Legal Policies Your Privacy Rights Terms of Use Trademark Policy Contributor Agreement © 2015, Oracle Corporation and/or its affiliates
Updates: Status: Not a Bug Impact on me: None Category:MySQL Administrator Severity:S2 (Serious) Version:1.2.11 OS:Microsoft Windows (XP SP2) Assigned to: Tags: fetch, schema, STATUS, table View Add Comment Files Developer Edit Submission View Progress Log Contributions [20 Apr 2007 22:58] Brad Kaenel Description: After importing a database from MS SQL Server, the Administrator tool "Catalog" pan no longer functions. The databases are listed, but clicking on any entry generates an error message dialog box stating: "Could not fetch schema table status." No useful admin functions can be performed, since the http://forums.mysql.com/read.php?34,169966,169966 database schema cannot be retrieved (thus, no tables/columns are available, either). However, the database *does* exist and seems to operate correctly. Query Browser can execute queries; client .Net programs can access the data, etc. How to repeat: Not certain. May have to reinstall MySql Server and/or Administrator. [23 Apr 2007 10:13] Sveta Smirnova Thank you for the report. Please provide output of statement http://bugs.mysql.com/27992 SHOW GRANTS FOR user_you_connect_to_MA_via. [23 Apr 2007 15:15] Brad Kaenel Results of SHOW GRANTS FOR devteam; 'GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON *.* TO 'devteam'@'%' IDENTIFIED BY PASSWORD '*35D788DF08469BE202FE5B611FF17D318FC6C287' WITH GRANT OPTION' 'GRANT ALL PRIVILEGES ON `devteam`.* TO 'devteam'@'%' WITH GRANT OPTION' [8 May 2007 10:35] Sveta Smirnova Thank you for the feedback. Seems this bug corelated with Bug #27996. Could you please change tmpdir value in the my.cnf configuration file to some existing path located not in the Windows system directory and check if it solves this issue? [9 May 2007 21:53] Brad Kaenel Yes, I'm sure bug 27996 is the same problem; solving one will likely solve the other. Since I don't have access to the server box, it will take a day or so before my sysop can make the change and notify me. I'll let you know the results... [10 May 2007 7:36] Victor Castell Hello, I had the same problem and I can c
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more http://stackoverflow.com/questions/17038716/not-retrieving-schema-list-from-source-when-migrating-from-mssql-to-mysql-using about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping http://community.jaspersoft.com/documentation/jasperreports-server-install-guide/v561/database-related-problems each other. Join them; it only takes a minute: Sign up Not retrieving schema list from source when migrating from MSSQL to MySQL using Workbench up vote 9 down vote favorite I'm trying to migrate my database which mysql error is in MS SQL Server to MySQL, I'm using Workbench to do so. I get connection to both databases but get the following warning: Retrieve schema list from source. And this is the message log: Starting... Connect to source DBMS... - Connecting to source... Connect to source DBMS done Check target DBMS connection... - Connecting to target... Connecting to Mysql@74.5.3.2:3306... Connecting to Mysql@74.5.3.2:3306... Connected Check target DBMS connection done Retrieve schema list from source.... - Checking connection... mysql error while - Fetching catalog names... WARNING: The following catalogs where not found: Autotask - Fetching schema names... - Finished Retrieve schema list from source finished Tasks finished with warnings and/or errors, view the logs for details Finished performing tasks. Autotask is the name of the db. Please what am I doing wrong? Note: even with the warning the wizard let me click next, but the next screen is supposed to list schematas, but as it is empty I can't continue. Thanks in advance. Pablo mysql sql-server mysql-workbench migrate share|improve this question edited Jul 10 '13 at 11:01 a_horse_with_no_name 186k24234312 asked Jun 11 '13 at 7:30 Pablo Santamaria 6615 I am also having this issue, using SQL Server Native Client 10.0 to connect to a sql server 2008. The connection succeeds but the Schemata Selection is an empty list –Chausser Jul 19 '13 at 21:14 add a comment| 3 Answers 3 active oldest votes up vote 16 down vote In case someone else comes across this same issue, and you don't have access to the "sa" user, I thought I'd post how to resolve the issue. The underlying problem is user permissions. Although you can login to the database fine there is a specific permission that needs to be set in order for it to work with MySQL Workbench. The permission you need is "View Any Definition" whic
Community Contact Login/Register Download Now ProductsAnswersExchangeDocsWikiPlanetTracker ContentsIndexIntroductionConventions Java Version Supported JasperReports Server Distributions Release Notes System Requirements Support for Internationalization Installing JasperReports ServerPre-Installation Steps Starting the Installer Accepting the License Agreement Choosing Installation Type Choosing an Installation Directory Selecting a Tomcat Configuration Selecting a PostgreSQL Configuration Installing Sample Data Completing the Installation Post-Installation Steps Starting and Stopping JasperReports ServerStart/Stop Menu — Windows Start/Stop Scripts — Linux Start/Stop Apps — Mac OSX Logging into JasperReports Server JasperReports Server Log Files Uninstalling JasperReports ServerWindows Linux Mac OSX Uninstall Survey Installing the WAR File DistributionApplications Supported by the WAR File Distribution Installing the WAR File Using js-install Scripts Additional Steps for Using DB2 and js-install Scripts Additional Steps for Using JBoss AS 7 Starting JasperReports Server Logging into JasperReports Server Troubleshooting Your JasperReports Server Configuration Installing the WAR File Manually JVM Options, License Setup, Manual Database CreationSetting JVM Options for Application Servers Setting Up the JasperReports Server License Manually Creating the JasperReports Server Database Working With JDBC Drivers Locating and Changing Buildomatic Configuration Files Configuring Report Scheduling Updating XML/A Connection Definitions Installing the WAR File for WebSphereProcedure for Installing and Deploying the WAR File in WebSphere Logging into JasperReports Server Configuring Report Scheduling Updating XML/A Connection Definitions (Optional) Troubleshooting your JasperReports Server Configuration Installing the WAR File for WebLogicProcedure for Installing the WAR File for WebLogic Setting Java Properties Configuring Other Database Connections Starting JasperReports Server Logging into JasperReports Server Configuring Report Scheduling Restarting JasperReports Server Updating XML/A Connection Definitions (Optional) Troubleshooting Your