Databases
StackOverflow2013
Postsdbo
POContent deployer error when publishing to Oracle broker db
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POContent deployer error when publishing to Oracle broker db
    primarykey
    data
    text
    <p>I'm getting an error when trying to deploy content to an oracle broker database (I'm running Tridion 2011 sp1). I've had a search on the SDL Tridion forum and cannot find anyone that's had the same issue.</p> <p>The error message in the cme is:</p> <pre><code>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, org.hibernate.exception.SQLGrammarException: could not execute query, Unable to prepare transaction: tcm:0-55-66560, org.hibernate.exception.SQLGrammarException: could not execute query, org.hibernate.exception.SQLGrammarException: could not execute query </code></pre> <p>And in the deployer logs i get the following:</p> <pre><code>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, org.hibernate.exception.SQLGrammarException: could not execute query for transaction: tcm:0-55-66560 2012-02-24 15:07:27,866 DEBUG DeployPipelineExecutor - Failure in Phase: Deployment Prepare Commit Phase attempt: 11 for transaction: tcm:0-55-66560 2012-02-24 15:07:27,866 ERROR DeployPipelineExecutor - Final attempt in Phase: Deployment Prepare Commit Phase failed for transaction: tcm:0-55-66560 2012-02-24 15:07:27,875 ERROR DeployPipelineExecutor - Original stacktrace for transaction: tcm:0-55-66560 com.tridion.deployer.ProcessingException: Unable to prepare transaction: tcm:0-55-66560, org.hibernate.exception.SQLGrammarException: could not execute query, 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$1.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-66560 2012-02-24 15:07:27,876 ERROR DeployPipelineExecutor - Unable to start processing deployment package with transactionId: tcm:0-55-66560 2012-02-24 15:07:27,880 DEBUG DeployPipelineExecutor - Checking if transaction is completed: tcm:0-55-66560 is true 2012-02-24 15:07:27,880 INFO DeployPipelineExecutor - Transaction is completed: tcm:0-55-66560 2012-02-24 15:07:27,882 INFO DeployPipelineExecutor - Finished executing deployment pipeline for: tcm:0-55-66560 in 2274 ms. </code></pre> <p>EDIT: </p> <p>Here is the node from the cd_storage_conf.xml file:</p> <pre><code>&lt;Storages&gt; &lt;Storage Type="persistence" Id="ddeploy" dialect="ORACLESQL" Class="com.tridion.storage.persistence.JPADAOFactory"&gt; &lt;Pool Type="jdbc" Size="5" MonitorInterval="60" IdleTimeout="120" CheckoutTimeout="120" /&gt; &lt;DataSource Class="oracle.jdbc.pool.OracleDataSource"&gt; &lt;Property Name="driverType" Value="thin"/&gt; &lt;Property Name="networkProtocol" Value="tcp"/&gt; &lt;Property Name="serverName" Value="secret"/&gt; &lt;Property Name="portNumber" Value="1526"/&gt; &lt;Property Name="databaseName" Value="secret"/&gt; &lt;Property Name="user" Value="secret"/&gt; &lt;Property Name="password" Value="secret"/&gt; &lt;/DataSource&gt; &lt;/Storage&gt; &lt;Storage Type="filesystem" Class="com.tridion.storage.filesystem.FSDAOFactory" Id="defaultFile" defaultFilesystem="false"&gt; &lt;Root Path="/htdocs/en_US/" /&gt; &lt;/Storage&gt; &lt;Storage Type="filesystem" Class="com.tridion.storage.filesystem.FSDAOFactory" Id="defaultDataFile" defaultFilesystem="true" defaultStorage="true"&gt; &lt;Root Path="/htdocs/en_US/data" /&gt; &lt;/Storage&gt; &lt;/Storages&gt; </code></pre> <p>And the item types</p> <pre><code>&lt;ItemTypes defaultStorageId="ddeploy" cached="false"&gt; &lt;Item typeMapping="Page" cached="false" storageId="defaultFile"/&gt; &lt;Item typeMapping="Binary" cached="false" storageId="defaultFile"/&gt; &lt;/ItemTypes&gt; </code></pre> <p>Any help would be greatly appreciated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USFrank van Puffelen
    1. USjohnwinter
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POContent deployer error when publishing to Oracle broker db
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POContent deployer error when publishing to Oracle broker db
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POContent deployer error when publishing to Oracle broker db
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COHi John. Which Oracle version (and patch) are you using? Is it all content that is failing to deploy (I suspect that this is the case) or just a certain type?
      singulars
      1. POContent deployer error when publishing to Oracle broker db
      1. USJonathan Williams
    2. COHave you checked that your lib folder contains the correct JAR file for your version of Java? (ojdbc5.jar for Java 5 and ojdbc6.jar for Java 6)
      singulars
      1. POContent deployer error when publishing to Oracle broker db
      1. USJonathan Williams
    3. COhey Jonathan - its everything to db. Jar's are all fine. thanks :)
      singulars
      1. POContent deployer error when publishing to Oracle broker db
      1. USjohnwinter
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload