Gpload error: [could not execute SQL in sql:after "Vacuum analyze
来源：互联网 发布：unity3d在线教程 编辑：程序博客网 时间：2024/05/21 03:56
今天把greenplum版本4.2.3.0升级到4.3.7.0后，Powercenter服务器的gpload版本也升级到4.3.7.0。在Powercenter执行完任务进行greenplum表分析的时候报错
[ERROR] Gpload error: [could not execute SQL in sql:after "Vacuum analyze PS_ACTION_TBL;": ERROR: VACUUM cannot run inside a transaction block]
Powercenter设置如下
经过测试发现，只要存在两个并行的Vacuum analyze就会报错，无奈把gpload版本降为4.2.3.0后解决。
转载请注明出处http://blog.csdn.net/wolaiye320/article/details/51015224
0 0
- Gpload error: [could not execute SQL in sql:after "Vacuum analyze
- After restoring database in SQL Server, if you can't use diagram, execute these sentences
- PL/SQL Developer 中的问题：Initialization error Could not load
- PL/SQL Developer 中的问题：Initialization error Could not load
- org.hibernate.exception.SQLGrammarException: could not inYou have an error in your SQL syntax;完美解决错误
- org.hibernate.exception.SQLGrammarException: could not inYou have an error in your SQL syntax;完美解决错误
- 小谈Hibernate下SQL Grammer Exception,Could not execute JDBC batch update异常的解决
- Hibernate报错:SQLGrammerException:Could not execute native bulk manipluation query(执行完sql报错)
- Could not execute JDBC batch update; bad SQL grammar [insert into
- struts “could not execute statement; SQL [n/a]; constraint [null];” 错误
- Could not execute JDBC batch update : java.sql.BatchUpdateException: ORA-00926: 缺失 VALUES 关键字
- could not execute query; SQL [select count(*) as col_0_0_ from order order0_]; nested exception is o
- Could not execute JDBC batch update; SQL [delete from role where roleId=?]; constraint [null]; neste
- :[org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a];
- could not execute statement; SQL [n/a]; constraint [null]级联删除异常
- TFS Project error in SQL Server 2005 after installing SQL Server 2008
- Could not execute: invalid directory (Win32 error 267)
- Could not execute: invalid directory (Win32 error 267)
- Hibernate多对多简单配置
- Windows与UNIX/Linux之比较
- UNIX、Linux、Solaris、Windows到底谁更好？
- 经验风险最小化与结构风险最小化笔记
- Red Hat Enterprise Linux 7.0 Beta —— document
- Gpload error: [could not execute SQL in sql:after "Vacuum analyze
- linux mutt详解
- style.width和offsetwidth区别
- Windows8下硬盘安装Fedora17——可能会遇到的问题
- 电影里的黑客为何都不用鼠标
- hdu 2066 一个人的旅行 最短路spfa
- 92. Reverse Linked List II
- 硬盘安装Fedora20出错
- 了解蓝牙
