SQL Error: -575, SQLState: 51024

2010-12-07  来源:本站原创  分类:Database  人气:216 

1 cause of the error:

DB2 SQL Error: SQLCODE =- 575, SQLSTATE = 51024, SQLERRMC = DB2INST1.VWPERSONALVOUCHER, DRIVER = 3.50.152
Message: Can not use view or materialized query table "DB2INST1.VWPERSONALVOUCHER", because it has been marked as unavailable. . SQLCODE =- 575, SQLSTATE = 51024, DRIVER = 3.50.152

More exceptions ... DB2 SQL Error: SQLCODE =- 727, SQLSTATE = 56098, SQLERRMC = 2; -575; 51024; DB2INST1.VWPERSONALVOUCHER, DRIVER = 3.50.152

2 solutions:

Delete the view and rebuild.

相关文章
  • SQL Error: -575, SQLState: 51024 2010-12-07

    1 cause of the error: DB2 SQL Error: SQLCODE =- 575, SQLSTATE = 51024, SQLERRMC = DB2INST1.VWPERSONALVOUCHER, DRIVER = 3.50.152 Message: Can not use view or materialized query table "DB2INST1.VWPERSONALVOUCHER", because it has been marked as una

  • Hibernate encountered in the SQL Error: 156, SQLState: S1000 Error 2010-03-29

    Today, to face such an error util.JDBCExceptionReporter 77) SQL Error: 156, SQLState: S1000 (util.JDBCExceptionReporter 78) in the keyword 'user' near syntax errors. ....... Caused by: java.sql.SQLException: the keyword 'user' near syntax errors. ...

  • WARN JDBCException Reporter: 100 - SQL Error 0, sqlstate: 08003 2010-03-10

    Encountered WARN JDBCException Reporter: 100 - SQL Error 0, sqlstate: 08003 Database error problem. The reason is found through online inquiries: Tomcat server and MySQL server has lost connection. The value of the original MySQL wait timeout default

  • Background Report SQL Error: 1064, SQLState: 42000 error 2010-05-29

    Warning : SQL Error: 1064, SQLState: 42000 2010-5-29 22:04:38 org.hibernate.util.JDBCExceptionReporter logExceptions Serious : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax t

  • SQL Error: 1064, SQLState: 42000 error 2011-01-28

    Inadvertently used Year_Month do MySQL table field, of course, such a waste of a day ~ Work place can not be online until at home to be found ... In MySQL, the word in the following table are explicitly reserved. Most of the word binary is used as a

  • MySQL5.xa class of SQL Error: 1267 solution to the problem 2010-08-15

    Recently when using MySQL5.x, used a combination of the two tables query, similar to the following simple statement: select pa.userId as userId,pa.userName as userName,pb.orgId as orgId,pb.orgName as orgName from tbl_user pa,tbl_org pb where pa.userI

  • (SQL error) DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null 2011-03-08

    (SQL error) DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null db no problem in the implementation, java call execution time error. Baidu was the answer: Result set, you can not pass parameters Parameter markers can never be used: * In a s

  • com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002 2011-10-08

    Db2 support in the project encountered an error: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLH203 0X5359534C564C3031 Checked under the Internet, probably the following reasons: 1 program, there

  • SQL Warning: 17110, SQLState: null 2010-12-30

    Recent project experience to write such a warning. I use the database is oracle9i WARN [http-8088-2] JDBCExceptionReporter.logWarnings (54) | SQL Warning: 17110, SQLState: null WARN [http-8088-2] JDBCExceptionReporter.logWarnings (55) | Warning: exec

  • Usage ddsdsds sql error 2010-09-28

    Usage ddsdsds sql error

  • SQL error: ORA-00054: resource busy and acquire with NOWAIT specified 2011-07-20

    Delete database records broke exception: SQL error: ORA-00054: resource busy and acquire with NOWAIT specified Use Oracle SqlDeve ... software continue to remove the statement, the software is not a response - not! Can not do anything, do not shut do

  • PowerDesigner Database connection error: Non SQL Error: Could not load class 2011-03-30

    PowerDesigner Database connection error: Non SQL Error: Could not load class PowerDesigner is a bug. The solution: drive files, such as: ojdbc14.jar copied to the PowerDesigner installation directory, then edit the connection configuration, select th

  • oracle pl / sql error solution can not listening 2010-05-02

    Error name: ORA-12514: TNS: listener does not recognize the current request to connect the service descriptor ORA-12514: TNS: listener does not currently know of service requested in connect descriptor Result can not enter pl / sql Solution: install

  • 编程趣事:SQL Error 191 2015-03-06

    软件开发里有很多有趣的事情,你通常只接触某种特定类型的应用,见识太少.比如,这HTTP 414 错误:请求的URI太长.对于这个长度没有一个标准的上限,很多web服务器都没有说明多长的GET请求会太长. 当我在维护这家公司的服务处的应用时,Ben在SQL Server里发现了一个相似类型的错误. Incorrect syntax near '('. //你的一部分SQL语句嵌套的太深. Some part of your SQL statement is nested too deeply. /

  • sql error in the replace function 2010-04-02

    As the image server to change the text field to be replaced in the server address Type of text field Test procedure: update image_server set image_text = replace (image_text, url1, url2) Error message: Replace the parameters of a function data type t

  • PL / SQL error message to print 2010-10-12

    dbms_output.put_line (SQLERRM);

  • sql error continues ~ ~ ~ 2010-12-14

    1, java.lang.ClassNotFoundException: com.mysql.jdbc.Driver Please see if the import-related jar ~ ~ ~ I always make such a mistake ~ Oh

  • PL / SQL error message is printed 2010-10-12

    dbms_output.put_line (SQLERRM);

  • MySQL创建一个简单的存储过程,报错:SQL Error (1064) 2013-12-07

    源代码: CREATE PROCEDURE AvgFruitPrice4() BEGIN SELECT AVG(f_price) AS avgprice FROM fruits; END; 解决方法1: delimiter $$ CREATE PROCEDURE AvgFruitPrice4() BEGIN SELECT AVG(f_price) AS avgprice FROM fruits; END $$ 解决方法2: CREATE PROCEDURE AvgFruitPrice4() SE

  • MySQL创建函数,报错:SQL Error (1418) 2013-12-07

    MySQL函数不能创建,是未开启创建功能: mysql> show variables like '%func%'; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | log_bin_trust_function_creators | OFF | +---------------------------------+