Publish LiveSite Content workflow error

PayalGarg

Hi All,


I'm trying to publish default.site using "Publish LiveSite Content" workflow. It is throwing error java.sql.SQLException: ORA-01400: cannot insert NULL into ("LIVESITE_DEV"."IW_ASSET"."AST_BRANCH")

(Log file od-home\OpenDeployNG\log\LiveSite\src.SiteMetadataful5gkvzful5gkw0.SiteMetadata.HOSTNAME.to.database.log]
):

: TUPLE={TeamSite/Metadata/Business Unit=, Site/0/Directory/0=pages, Site/0/Resources/0/Resource/5/IsSiteResource=false, TeamSite/LiveSite/Type=site, Site/0/Resources/0/Resource/12/Path/0=iwov-resources/scripts/foundation/image-gallery.js, Site/0/Resources/0/Resource/8/Enabled=true, Site/0/Resources/0/Resource/14/Path/0=iwov-resources/scripts/foundation/rating-selector.js, Site/0/Resources/0/Resource/5/Type=0, Site/0/Resources/0/Resource/7/Path/0=iwov-resources/scripts/foundation/AjaxRequest.class.js, Site/0/Resources/0/Resource/9/Path/0=iwov-resources/scripts/foundation/effects.js, Site/0/Resources/0/Resource/15/Enabled=true, Site/0/Resources/0/Resource/9=

, Site/0/Resources/0/Resource/6/Enabled=true, Site/0=

, Site/0/Resources/0/Resource/8=

, Site/0/PageType/0/Layout/0=div-layout, Site/0/Resources/0/Resource/7=

, Site/0/Resources/0/Resource/6=

, Site/0/Controllers/0/Pre/0=, Site/0/Resources/0/Resource/5=

, Site/0/Resources/0/Resource/13/Enabled=true, Site/0/Resources/0/Resource/4=

, Site/0/Resources/0/Resource/15/Type=1, Site/0/Resources/0/Resource/3=

, Site/0/Resources/0/Resource/14/IsSiteResource=true, Site/0/Resources/0/Resource/2=

, Site/0/Resources/0/Resource/1=

, Site/0/Resources/0/Resource/0=

, Site/0/Resources/0/Resource/11/Enabled=true, Site/0/Private/0=false, TeamSite/Metadata/Locale=en_US, Site/0/Resources/0/Resource/10/Path/0=iwov-resources/scripts/foundation/content-slideshow.js, Site/0/Deployment/0=


, Site/0/Resources/0/Resource/3/Path/0=iwov-resources/css/teachyourself/teachyourself.css, Site/0/URL/0/Server/0=www, Site/0/Resources/0/Resource/5/Path/0=iwov-resources/css/teachyourself/product.css, Site/0/Branch/0=//hddlntd60184357/default/main/highered, Site/0/Login/0/Config/0=, Site/0/StartPage/0=start, Site/0/Resources/0=


, Site/0/Resources/0/Resource/6/Type=1, Site/0/Resources/0/Resource/4/Enabled=true, Site/0/Resources/0/Resource/4/IsSiteResource=true, Site/0/Resources/0/Resource/2/Enabled=true, TeamSite/LiveSite/Private=false, Site/0/Resources/0/Resource/16/Type=1, Site/0/Resources/0/Resource/0/Type=0, Site/0/Resources/0/Resource/0/Enabled=true, Site/0/Resources/0/Resource/1/Path/0=iwov-resources/css/foundation/dropdown.css, TeamSite/LiveSite/DependentURIs=iwov-resources/css/foundation/components.css;iwov-resources/css/foundation/dropdown.css;iwov-resources/css/foundation/foundation.css;iwov-resources/css/teachyourself/product.css;iwov-resources/css/teachyourself/style_wedding.css;iwov-resources/css/teachyourself/teachyourself.css;iwov-resources/scripts/advanced-backpacking/googlemaps.js;iwov-resources/scripts/foundation/AjaxRequest.class.js;iwov-resources/scripts/foundation/content-slideshow.js;iwov-resources/scripts/foundation/effects.js;iwov-resources/scripts/foundation/form-builder.js;iwov-resources/scripts/foundation/foundation.js;iwov-resources/scripts/foundation/image-gallery.js;iwov-resources/scripts/foundation/image-slideshow.js;iwov-resources/scripts/foundation/polling.js;iwov-resources/scripts/foundation/rating-selector.js;iwov-resources/scripts/teachyourself/wedding.js, TeamSite/LiveSite/DeploymentAudit=



SiteMetadata
development
Tue Apr 21 16:14:41 IST 2009

/default/main/advancedbackpacking/WORKAREA/shared/sites/advancedbackpacking/default.site
Tue Apr 21 16:14:41 IST 2009


, Site/0/Resources/0/Resource/13/IsSiteResource=true, TeamSite/Metadata/ContentType=, Site/0/Login/0/Attributes/0=, Site/0/Resources/0/Resource/10/Type=1, Site/0/Controllers/0/Post/0=, subjectMetadata0= <metadata>, Site/0/Resources/0/Resource/9/IsSiteResource=true, Site/0/Resources/0/Resource/7/Type=1, Site/0/PageType/0=


, Site/0/Login/0=


, Site/0/Resources/0/Resource/3/IsSiteResource=true, TeamSite/Metadata/Keywords=test, TeamSite/Metadata/Locale/en_US=y, Site/0/Resources/0/Resource/1/Type=0, path=sites\teachyourself\default.site, TeamSite/Metadata/ExpirationDate=, Site/0/Resources/0/Resource/11/Type=1, Site/0/Resources/0/Resource/13/Path/0=iwov-resources/scripts/foundation/polling.js, Site/0/Resources/0/Resource/12/IsSiteResource=true, Site/0/Resources/0/Resource/15/Path/0=iwov-resources/scripts/advanced-backpacking/googlemaps.js, Site/0/URL/0=


, Site/0/Resources/0/Resource/8/Path/0=iwov-resources/scripts/foundation/form-builder.js, Site/0/LoginPage/0=, Site/0/Resources/0/Resource/8/Type=1, Site/0/Resources/0/Resource/9/Enabled=true, Site/0/Resources/0/Resource/16=

, Site/0/Resources/0/Resource/8/IsSiteResource=true, Site/0/Resources/0/Resource/15=

, Site/0/Resources/0/Resource/7/Enabled=true, Site/0/ErrorPage/0=error, Site/0/Resources/0/Resource/16/Enabled=true, Site/0/Resources/0/Resource/14=

, Site/0/PageType/0/Id/0=html401-transitional, Site/0/Resources/0/Resource/13=

, Site/0/Resources/0/Resource/11/IsSiteResource=true, Site/0/Resources/0/Resource/12=

, TeamSite/Metadata/Expiration Date=, Site/0/Resources/0/Resource/11=

, Site/0/Resources/0/Resource/10=

, Site/0/Resources/0/Resource/2/Type=0, TeamSite/Metadata/CreationDate=2009-04-16 19:35:42, Site/0/Resources/0/Resource/5/Enabled=true, Site/0/Resources/0/Resource/14/Enabled=true, Site/0/Resources/0/Resource/11/Path/0=iwov-resources/scripts/foundation/image-slideshow.js, Site/0/Resources/0/Resource/2/IsSiteResource=true, Site/0/Resources/0/Resource/6/Path/0=iwov-resources/scripts/foundation/foundation.js, Site/0/Resources/0/Resource/12/Enabled=true, Site/0/Resources/0/Resource/12/Type=1, Site/0/Controllers/0=


, Site/0/ID=1241016343287, numberOfChunks=1, TeamSite/LiveSite/Id=1241016343287, Site/0/Resources/0/Resource/9/Type=1, Site/0/InternalProperties/0=, Site/0/Version=3.1.0.0, TeamSite/Metadata/Title=test, Site/0/Deployment/0/Name/0=LiveSite, Site/0/Resources/0/Resource/2/Path/0=iwov-resources/css/foundation/foundation.css, Site/0/Resources/0/Resource/4/Path/0=iwov-resources/css/teachyourself/style_wedding.css, Site/0/Resources/0/Resource/3/Enabled=true, Site/0/AdminServer/0=hddlntd60184357.HCLT.CORP.HCL.IN:80, Site/0/Resources/0/Resource/3/Type=0, Site/0/Resources/0/Resource/7/IsSiteResource=true, TeamSite/Metadata/Creation Date=, Site/0/Resources/0/Resource/1/Enabled=true, Site/0/Resources/0/Resource/10/Enabled=true, Site/0/Resources/0/Resource/10/IsSiteResource=true, Site/0/Description/0=This is a publishing domain website, Site/0/URL/0/Domain/0=teachyourself.com, Site/0/Resources/0/Resource/13/Type=1, Site/0/Resources/0/Resource/1/IsSiteResource=true, Site/0/Deployment/0/Definition/0=delta, Site/0/Resources/0/Resource/0/Path/0=iwov-resources/css/foundation/components.css, Site/0/Resources/0/Resource/16/IsSiteResource=true, TeamSite/Metadata/ContentCategories=, TeamSite/Metadata/Description=, Site/0/Resources/0/Resource/0/IsSiteResource=true, Site/0/Resources/0/Resource/4/Type=0, IWOV_PROC_FLAG=true, Site/0/Resources/0/Resource/15/IsSiteResource=true, Site/0/AnalyticsUrl/0=, state=Original, Site/0/Resources/0/Resource/16/Path/0=iwov-resources/scripts/teachyourself/wedding.js, Site/0/Resources/0/Resource/6/IsSiteResource=true, Site/0/Resources/0/Resource/14/Type=1}
DBD: TDbSchemaGroupCfg:RowsExistForTupleELECT COUNT(*) FROM iw_asset WHERE ast_id IN ( ? )
DBD: TTableSchemaHelper object for [iw_asset] found in cache.
DBD: TTableSchemaHelper object for [iw_asset] found in cache.
DBD: INSERT:INSERT INTO iw_asset(ast_id,ast_locale,ast_branch,ast_relative_path,ast_creation_date,ast_expiration_date,ast_last_modified_date,ast_last_modified_user) VALUES (?,?,?,?,?,?,?,?)
DBD: Column: ast_id, field: TeamSite/LiveSite/Id, Index: 1,Converting '1241016343287' to VARCHAR
DBD: Column: ast_locale, field: TeamSite/Metadata/Locale, Index: 2,Converting 'en_US' to VARCHAR
DBD: Column: ast_branch, field: TupleProcessor/BranchVpath, Index: 3,null
DBD: Column: ast_relative_path, field: TupleProcessor/AreaRelativePath, Index: 4,null
DBD: Column: ast_creation_date, field: TeamSite/Metadata/CreationDate, Index: 5,Converting '2009-04-16 19:35:42' to DATE
DBD: Column: ast_expiration_date, field: TeamSite/Metadata/ExpirationDate, Index: 6,Converting '' to DATE
DBD: Column: ast_last_modified_date, field: TupleProcessor/LastModifiedDate, Index: 7,null
DBD: Column: ast_last_modified_user, literal: HDDLNTD60184357\Administrator, Index: 8,Converting 'HDDLNTD60184357\Administrator' to VARCHAR
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: ORA-01400: cannot insert NULL into ("LIVESITE_DEV"."IW_ASSET"."AST_BRANCH")
DBD: Vendor Error Code: 1400
DBD: SQL state: 23000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: ORA-01400: cannot insert NULL into ("LIVESITE_DEV"."IW_ASSET"."AST_BRANCH")
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:954)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1167)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3367)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1301)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsert(TDbSchemaGroupCfg.java:1175)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1087)
at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:456)
at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:477)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TTuplePreProcessor.WriteTuple(TTuplePreProcessor.java:40)
at com.interwoven.dd100.dd.TPredicateEvaluator.WriteTuple(TPredicateEvaluator.java:116)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:1033)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:624)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:581)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:526)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:289)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:178)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

Please help me out...

Thanks

shanon

Hi,

Looks like the tupleprocessor isn't running; it populates all values that begin with "TupleProcessor/". Branch is one such value.

Look at the top of the SiteMetadata.xml in ODHOME/conf/LiveSite.

Do you see the tuple processor configured in the xml? Did you change this file at all from the OOTB version ?

Shanon