cme中的错误消息是:
Committing Deployment Failed Phase: Deployment Prepare Commit Phase Failed,Unable to prepare transaction: tcm:0-55-66560,org.hibernate.exception.sqlGrammarException: Could not execute query,Unable to prepare transaction: tcm:0-55-66560,org.hibernate.exception.sqlGrammarException: Could not execute query
在部署日志中,我得到以下内容:
2012-02-24 15:07:27,866 WARN DeployPipelineExecutor - Phase: Deployment Prepare Commit Phase failure message: Unable to prepare transaction: tcm:0-55-66560,org.hibernate.exception.sqlGrammarException: Could not execute query for transaction: tcm:0-55-665602012-02-24 15:07:27,866 DEBUG DeployPipelineExecutor - Failure in Phase: Deployment Prepare Commit Phase attempt: 11 for transaction: tcm:0-55-665602012-02-24 15:07:27,866 ERROR DeployPipelineExecutor - Final attempt in Phase: Deployment Prepare Commit Phase Failed for transaction: tcm:0-55-665602012-02-24 15:07:27,875 ERROR DeployPipelineExecutor - Original stacktrace for transaction: tcm:0-55-66560com.tridion.deployer.ProcessingException: Unable to prepare transaction: tcm:0-55-66560,org.hibernate.exception.sqlGrammarException: Could not execute query at com.tridion.deployer.phases.PreCommitPhase.handleFailure(PreCommitPhase.java:120) ~[cd_deployer.jar:na] at com.tridion.deployer.phases.PreCommitPhase.execute(PreCommitPhase.java:101) ~[cd_deployer.jar:na] at com.tridion.deployer.phases.DeployPipelineExecutor.runMainExecutePhase(DeployPipelineExecutor.java:186) [cd_deployer.jar:na] at com.tridion.deployer.phases.DeployPipelineExecutor.doExecute(DeployPipelineExecutor.java:97) [cd_deployer.jar:na] at com.tridion.deployer.phases.DeployPipelineExecutor.execute(DeployPipelineExecutor.java:61) [cd_deployer.jar:na] at com.tridion.deployer.TransactionManager.handleDeployPackage(TransactionManager.java:80) [cd_deployer.jar:na] at com.tridion.deployer.queue.QueueLocationHandler.run(QueueLocationHandler.java:176) [cd_deployer.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417) [na:1.5.0_11] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269) [na:1.5.0_11] at java.util.concurrent.FutureTask.run(FutureTask.java:123) [na:1.5.0_11] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) [na:1.5.0_11] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) [na:1.5.0_11] at java.lang.Thread.run(Thread.java:595) [na:1.5.0_11]2012-02-24 15:07:27,875 INFO TransactionPersistence - Removing deployment transaction information: tcm:0-55-665602012-02-24 15:07:27,876 ERROR DeployPipelineExecutor - Unable to start processing deployment package with transactionID: tcm:0-55-665602012-02-24 15:07:27,880 DEBUG DeployPipelineExecutor - Checking if transaction is completed: tcm:0-55-66560 is true2012-02-24 15:07:27,880 INFO DeployPipelineExecutor - Transaction is completed: tcm:0-55-665602012-02-24 15:07:27,882 INFO DeployPipelineExecutor - Finished executing deployment pipeline for: tcm:0-55-66560 in 2274 ms.
编辑:
以下是cd_storage_conf.xml文件中的节点:
<Storages> <Storage Type="persistence" ID="ddeploy" dialect="ORACLEsql" Class="com.tridion.storage.persistence.JPADAOFactory"> <Pool Type="jdbc" Size="5" MonitorInterval="60" IDleTimeout="120" CheckoutTimeout="120" /> <DataSource Class="oracle.jdbc.pool.OracleDataSource"> <Property name="driverType" Value="thin"/> <Property name="networkProtocol" Value="tcp"/> <Property name="servername" Value="secret"/> <Property name="portNumber" Value="1526"/> <Property name="databasename" Value="secret"/> <Property name="user" Value="secret"/> <Property name="password" Value="secret"/> </DataSource> </Storage> <Storage Type="filesystem" Class="com.tridion.storage.filesystem.FSDAOFactory" ID="defaultfile" defaultfilesystem="false"> <Root Path="/htdocs/en_US/" /> </Storage> <Storage Type="filesystem" Class="com.tridion.storage.filesystem.FSDAOFactory" ID="defaultDatafile" defaultfilesystem="true" defaultStorage="true"> <Root Path="/htdocs/en_US/data" /> </Storage></Storages>
和项目类型
<ItemTypes defaultStorageID="ddeploy" cached="false"> <Item typeMapPing="Page" cached="false" storageID="defaultfile"/> <Item typeMapPing="Binary" cached="false" storageID="defaultfile"/></ItemTypes>
任何帮助将不胜感激.
解决方法 卫生署! – 我可以确认这里的问题是oracle数据库用户无法访问正确的模式.如果有人在这里搜索相同的问题,他们会知道正确的地方:)
@H_404_0@ 总结以上是内存溢出为你收集整理的发布到Oracle代理数据库时出现内容部署程序错误全部内容,希望文章能够帮你解决发布到Oracle代理数据库时出现内容部署程序错误所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)