Can't Publish .site files using PLC workflow.

I am trying to publish sites to production but am not able to publish the .sites pages using the PLC workflow. I get the following errors.

Content Center Log:
WARN com.interwoven.ui.datacapture.core.dcxp.DTDNodeOrderingStrategy ( )
Error reading DTD http://localhost/iw-cc/datacapture6.0.dtd.

Message: http://localhost/iw-cc/datacapture6.0.dtd

ERROR com.interwoven.livesite.deployment.impl.DeploymentRunner () - deployFiles: received failure result for deployment: SiteMetadata

ERROR com.interwoven.livesite.deployment.impl.DeploymentRunner () - deployFiles: serviceResponseMessage: Completed with errors

ERROR com.interwoven.livesite.deployment.impl.DeploymentRunner () - deployFiles: failOnError is true; no other deployments will be executed.

ERROR com.interwoven.livesite.workflow.task.DeploymentTaskUtils () - deployFiles: found one or more errors while processing target node(s): [development]

SiteMetaData Deploy using DD failure Logs

**********************************************************

DBD: ERROR: DoRealUpdate( ) failed for group [teamsite_asset].
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source sites/XXXcom/default.site, obtained from filelist=E:\Interwoven\TeamSite\tmp\LiveSite\workflow\gz0a3cu0\SiteMetadata.gz0a3cu0gz0a3cu1.filelist

DBD: Filelist walk done
DBD: ERROR:deployment [SiteMetadata] FAILED
DBD: Rollback database [XXXXXX:XXXX;databaseName=SitePublisher]...
DBD: Deployment[SiteMetadata]
DBD: -----------------------------------
DBD: DCRs inserted : 0
DBD: DCRs updated : 0
DBD: DCRs deleted : 0
DBD: DCRs failed : 1
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: -----------------------------------
DBD: Started : Sat Mar 03 13:40:24 PST 2012
DBD: Shutting down DDD PublisherThread
DBD: Finished: Sat Mar 03 13:40:25 PST 2012

### IWDataDeploy FAILED ###

DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: The DELETE statement conflicted with the REFERENCE constraint "fk_site_id". The conflict occurred in database "SitePublisher", table "dbo.iwcont_site", column 'site_id'.
DBD: Vendor Error Code: 547
DBD: SQL state: 23000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************

DBD: ERROR:
com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "fk_site_id". The conflict occurred in database "SitePublisher", table "dbo.iwcont_site", column 'site_id'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)

Find more posts tagged with

Comments

nipper

You will need to look at the DB, there is a foreign key constraint which is preventing the submit from happening.

Use this as a guide:

DBD: Exception Message: The DELETE statement conflicted with the REFERENCE constraint "fk_site_id". The conflict occurred in database "SitePublisher", table "dbo.iwcont_site", column 'site_id'.

Is this an older copy of SP/LS ? I saw errors like this in 6.7.2 but not in 7.2.1, but I did have to clean up the older DB.

AakarshC

@nipper nope its 7.2.1. So a complete clean-up is a good practice ? Currently we not using targetening/content services. Assuming the "runtimes" are not communicating with the databases at all. Runtimes are not pulling stuff out of databases right.

Naira.zip

nipper

That is surprising that it happened in 7.2.1

Have you copied that site from another site ?

How many are on the server ? Any with the same name ?

AakarshC

No I have not manually copied to files from one webserver to another. There is just one site. What I did is just made changes in the odnodes.xml to deploy to the new runtime/webserver. In a development environment when I delete the constraint in the table in the SitePublisher Database which the error mentions, I can deploy the site. Seems like a bug or is the constraint there for a reason ?

The constraint is the foreign key constraint on the tables in which the site id resides. I went out and deleted it in the development environment and I can deploy the stuff.