nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Database Auto-Synchronization not working

mpeters

Hello:

Attached is my DataDeploy configuration file. When I run...


/usr/od-home/OpenDeployNG/bin/iwodcmd start workflow_logger_dd -k iwdd=workflow_logging -k xmlarea=/tmp -k filename=/tmp/workflow_log.xml -k dbname=poll -inst _workflow_log_myDeployment

...no error is raised...


 Locating OpenDeploy service.
 Got OpenDeploy service
 >>>>>-- Start deployment bluesource_workflowlogger_dd_workflow_log_myDeployment.
          iwodstart running in default synchronous mode.
          Need to wait for deployment to complete.
 >>>>>-- Deployment bluesource_workflowlogger_dd_workflow_log_myDeployment finished:
          ID: m100     Start time: Thu Sep 20 16:42:50 CDT 2007
          Status: Completed
          Status details:
All targets got completed status

...however the database tables aren't populated with data from my XML source file. What could be the cause of this issue?

Find more posts tagged with

Comments

moonkhanna

paste the contents of your micro deploy log..

mpeters

paste the contents of your micro deploy log..


ENG: 2007-09-20 16:45:42 CDT GMT-05:00  Begin logfile [/usr/od-home/OpenDeployNG/log/src.workflow_logger_dd_workflow_log_myDeployment.workflow_logging.iwovxdapp1.to.database.log] ---------
ENG: 2007-09-20 16:45:42 CDT GMT-05:00  Job ID=m101   Deployment=workflow_logger_dd_workflow_log_myDeployment
ENG: 2007-09-20 16:45:42 CDT GMT-05:00  DataDeploy Version is 6.1.1.0.0
ENG: 2007-09-20 16:45:42 CDT GMT-05:00  Owner started the deployment is root
ENG: 2007-09-20 16:45:42 CDT GMT-05:00 DD args  iwdd="workflow_logging"  filename="/tmp/workflow_log.xml"  xmlarea="/tmp"  dbname="poll"  cfg=/usr/od-home/OpenDeployNG/conf/workflow_logger_dd.xml need-result=yes depuuid=d6286480-67c2-11dc-8151-d696ea0d910b leglabel=database

...

ENG: 2007-09-20 16:45:42 CDT GMT-05:00 Proceed to execute the database deployment

...

ENG: 2007-09-20 16:45:42 CDT GMT-05:00 Exec'ing [/usr/od-home/OpenDeployNG/lib/iwddexec  iwdd="workflow_logging"  filename="/tmp/workflow_log.xml"  xmlarea="/tmp"  dbname="poll"  cfg=/usr/od-home/OpenDeployNG/conf/workflow_logger_dd.xml need-result=yes depuuid=d6286480-67c2-11dc-8151-d696ea0d910b leglabel=database  svrlogfile=/usr/od-home/OpenDeployNG/log/src.workflow_logger_dd_workflow_log_myDeployment.workflow_logging.iwovxdapp1.to.database.log execProcess=yes loadhopi="yes"]
DBD: Server log file /usr/od-home/OpenDeployNG/log/src.workflow_logger_dd_workflow_log_myDeployment.workflow_logging.iwovxdapp1.to.database.log
DBD: DD module version: 6.1.1.0.0 Build 63840 Interwoven 20070214
DBD: In Thread: Thread[OpenDeploy Main,5,main]
DBD: Run in Thread: Thread[DDThread,5,main]
DBD: Database Vendor set to microsoft-inetuna
DBD: Max Identifier length set to 128 characters.
DBD: SQL datatype for column JOB_ID is INT
DBD: SQL datatype for column JOB_CREATOR is VARCHAR(10)
DBD: SQL datatype for column JOB_BRANCH is VARCHAR(100)
DBD: SQL datatype for column JOB_TEMPLATE is VARCHAR(100)
DBD: # of columns: 4
DBD: # of primary key columns specified: 1
DBD: SQL datatype for column FILE_ID is INT
DBD: SQL datatype for column JOB_ID is INT
DBD: SQL datatype for column FILE_NAME is VARCHAR(1000)
DBD: SQL datatype for column FILE_VERSION is VARCHAR(5)
DBD: SQL datatype for column FILE_DEPLOYMENT_DATE is DATETIME
DBD: # of columns: 5
DBD: # of primary key columns specified: 1
DBD: SQL datatype for column TASK_ID is INT
DBD: SQL datatype for column JOB_ID is INT
DBD: SQL datatype for column TASK_NAME is VARCHAR(500)
DBD: SQL datatype for column TASK_DESCRIPTION is VARCHAR(100)
DBD: SQL datatype for column TASK_ACTIVATION_TIME is DATETIME
DBD: SQL datatype for column TASK_UNACTIVATION_TIME is DATETIME
DBD: SQL datatype for column TASK_DURATION_IN_SECONDS is INT
DBD: SQL datatype for column TASK_NEEDS_ATTENTION is CHAR
DBD: SQL datatype for column TASK_OWNER is VARCHAR(10)
DBD: # of columns: 9
DBD: # of primary key columns specified: 1
DBD: # of groups defined in  element: 3
DBD: [Thu Sep 20 16:45:44 CDT 2007] Begin executing workflow_logging
DBD: Area VPath:/tmp
DBD: Setting up TDbSchemaAgent.
DBD: >>> Loading drivers <<<

...

DBD: login timeout=3
DBD: Connecting to the database...

...

DBD:   Driver         i-net UNA 2000
DBD:   Version        4.18

...

DBD: Building mappings cache...
DBD: Built mapping cache(s) successfully.
DBD: # column mappings: 0
DBD: # table mappings: 0
DBD: # view mappings: 0
DBD: # constraint mappings: 0
DBD: Table [TSITE_TBL_DETAIL_JOB] exists.
DBD: Table [TSITE_TBL_DETAIL_FILE] exists.
DBD: Table [TSITE_TBL_DETAIL_TASK] exists.
DBD: Running deployment [workflow_logging]
DBD: extraction type=default
DBD: tuple mode=wide
DBD: area=/tmp
DBD: No data capture contents for /tmp/workflow_log.xml
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={state=NotPresent, path=/tmp/workflow_log.xml}
DBD: TTableSchemaHelper not found in cache for [TSITE_TBL_DETAIL_JOB]. Creating new.
DBD: SELECT  KEYCOLNAME , KEYCOLVALUE   FROM IWDELTRACKER WHERE  PATH  = ? AND  AREA   = ? AND  KEYCOLNAME  IN ( 'JOB_ID')
DBD: TTableSchemaHelper not found in cache for [TSITE_TBL_DETAIL_FILE]. Creating new.
DBD: SELECT  KEYCOLNAME , KEYCOLVALUE   FROM IWDELTRACKER WHERE  PATH  = ? AND  AREA   = ? AND  KEYCOLNAME  IN ( 'FILE_ID')
DBD: TTableSchemaHelper not found in cache for [TSITE_TBL_DETAIL_TASK]. Creating new.
DBD: SELECT  KEYCOLNAME , KEYCOLVALUE   FROM IWDELTRACKER WHERE  PATH  = ? AND  AREA   = ? AND  KEYCOLNAME  IN ( 'TASK_ID')
DBD: 0 PK values retrieved from iwdeltracker for /tmp/workflow_log.xml, /tmp
DBD:  DELETE FROM IWDELTRACKER WHERE  PATH  = ? AND  AREA  = ?
DBD:  -- Deleted
DBD: Stat for group [TSITE_TBL_DETAIL_JOB]:
DBD: -----------------------------------
DBD:   Rows inserted      : 0
DBD:   Rows updated       : 0
DBD:   Rows deleted       : 0
DBD:   Rows failed        : 0
DBD:   Rows rolled back   : 0
DBD:   Rows skipped       : 0
DBD: -----------------------------------
DBD: Stat for group [TSITE_TBL_DETAIL_FILE]:
DBD: -----------------------------------
DBD:   Rows inserted      : 0
DBD:   Rows updated       : 0
DBD:   Rows deleted       : 0
DBD:   Rows failed        : 0
DBD:   Rows rolled back   : 0
DBD:   Rows skipped       : 0
DBD: -----------------------------------
DBD: Stat for group [TSITE_TBL_DETAIL_TASK]:
DBD: -----------------------------------
DBD:   Rows inserted      : 0
DBD:   Rows updated       : 0
DBD:   Rows deleted       : 0
DBD:   Rows failed        : 0
DBD:   Rows rolled back   : 0
DBD:   Rows skipped       : 0
DBD: -----------------------------------

...

DBD: Deployment[workflow_logging]
DBD: -----------------------------------
DBD:   DCRs inserted      : 0
DBD:   DCRs updated       : 0
DBD:   DCRs deleted       : 1
DBD:   DCRs failed        : 0
DBD:   DCRs rolled back   : 0
DBD:   DCRs skipped       : 0
DBD: -----------------------------------
DBD: Started : Thu Sep 20 16:45:44 CDT 2007
DBD: Finished: Thu Sep 20 16:45:45 CDT 2007
ENG: 2007-09-20 16:45:45 CDT GMT-05:00 nullDBD: 2007-09-20 16:45:43 CDT GMT+01:00 OpenDeploy install location /usr/od-home/OpenDeployNG
DBD: 2007-09-20 16:45:43 CDT GMT+01:00 OpenDeploy install location /usr/od-home/OpenDeployNG
DD Home : /usr/od-home/OpenDeployNG
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[0]:iwdd=workflow_logging
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[1]:filename=/tmp/workflow_log.xml
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[2]:xmlarea=/tmp
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[3]:dbname=poll
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[4]:cfg=/usr/od-home/OpenDeployNG/conf/workflow_logger_dd.xml
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[5]:need-result=yes
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[6]:depuuid=d6286480-67c2-11dc-8151-d696ea0d910b
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[7]:leglabel=database
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[8]:svrlogfile=/usr/od-home/OpenDeployNG/log/src.workflow_logger_dd_workflow_log_myDeployment.workflow_logging.iwovxdapp1.to.database.log
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[9]:execProcess=yes
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[10]:loadhopi=yes
DBD: 2007-09-20 16:45:44 CDT GMT+01:00 numArgs=11

ENG: 2007-09-20 16:45:45 CDT GMT-05:00 Database deployment execution returned 0

ENG: 2007-09-20 16:45:45 CDT GMT-05:00 <<< Completed database deployment Invocation>>>

ENG: 2007-09-20 16:45:45 CDT GMT-05:00 doTask returned 0

ENG: 2007-09-20 16:45:45 CDT GMT-05:00 Setting final state to TASKDONE

ENG: 2007-09-20 16:45:45 CDT GMT-05:00  Job ID=m101   Deployment leg=database   Elapsed Time=2424 ms <<<
ENG: 2007-09-20 16:45:45 CDT GMT-05:00  End logfile [/usr/od-home/OpenDeployNG/log/src.workflow_logger_dd_workflow_log_myDeployment.workflow_logging.iwovxdapp1.to.database.log]

moonkhanna

ENG: 2007-09-20 16:45:42 CDT GMT-05:00 Begin logfile [/usr/od-home/OpenDeployNG/log/src.workflow_logger_dd_workflow_log_myDeployment.workflow_logging.iwovxdapp1.to.database.log] --------- ENG: 2007-09-20 16:45:42 CDT GMT-05:00 Job ID=m101 Deployment=workflow_logger_dd_workflow_log_myDeployment ENG: 2007-09-20 16:45:42 CDT GMT-05:00 DataDeploy Version is 6.1.1.0.0 ENG: 2007-09-20 16:45:42 CDT GMT-05:00 Owner started the deployment is root ENG: 2007-09-20 16:45:42 CDT GMT-05:00 DD args iwdd="workflow_logging" filename="/tmp/workflow_log.xml" xmlarea="/tmp" dbname="poll" cfg=/usr/od-home/OpenDeployNG/conf/workflow_logger_dd.xml need-result=yes depuuid=d6286480-67c2-11dc-8151-d696ea0d910b leglabel=database ... ENG: 2007-09-20 16:45:42 CDT GMT-05:00 Proceed to execute the database deployment ... ENG: 2007-09-20 16:45:42 CDT GMT-05:00 Exec'ing [/usr/od-home/OpenDeployNG/lib/iwddexec iwdd="workflow_logging" filename="/tmp/workflow_log.xml" xmlarea="/tmp" dbname="poll" cfg=/usr/od-home/OpenDeployNG/conf/workflow_logger_dd.xml need-result=yes depuuid=d6286480-67c2-11dc-8151-d696ea0d910b leglabel=database svrlogfile=/usr/od-home/OpenDeployNG/log/src.workflow_logger_dd_workflow_log_myDeployment.workflow_logging.iwovxdapp1.to.database.log execProcess=yes loadhopi="yes"] DBD: Server log file /usr/od-home/OpenDeployNG/log/src.workflow_logger_dd_workflow_log_myDeployment.workflow_logging.iwovxdapp1.to.database.log DBD: DD module version: 6.1.1.0.0 Build 63840 Interwoven 20070214 DBD: In Thread: Thread[OpenDeploy Main,5,main] DBD: Run in Thread: Thread[DDThread,5,main] DBD: Database Vendor set to microsoft-inetuna DBD: Max Identifier length set to 128 characters. DBD: SQL datatype for column JOB_ID is INT DBD: SQL datatype for column JOB_CREATOR is VARCHAR(10) DBD: SQL datatype for column JOB_BRANCH is VARCHAR(100) DBD: SQL datatype for column JOB_TEMPLATE is VARCHAR(100) DBD: # of columns: 4 DBD: # of primary key columns specified: 1 DBD: SQL datatype for column FILE_ID is INT DBD: SQL datatype for column JOB_ID is INT DBD: SQL datatype for column FILE_NAME is VARCHAR(1000) DBD: SQL datatype for column FILE_VERSION is VARCHAR(5) DBD: SQL datatype for column FILE_DEPLOYMENT_DATE is DATETIME DBD: # of columns: 5 DBD: # of primary key columns specified: 1 DBD: SQL datatype for column TASK_ID is INT DBD: SQL datatype for column JOB_ID is INT DBD: SQL datatype for column TASK_NAME is VARCHAR(500) DBD: SQL datatype for column TASK_DESCRIPTION is VARCHAR(100) DBD: SQL datatype for column TASK_ACTIVATION_TIME is DATETIME DBD: SQL datatype for column TASK_UNACTIVATION_TIME is DATETIME DBD: SQL datatype for column TASK_DURATION_IN_SECONDS is INT DBD: SQL datatype for column TASK_NEEDS_ATTENTION is CHAR DBD: SQL datatype for column TASK_OWNER is VARCHAR(10) DBD: # of columns: 9 DBD: # of primary key columns specified: 1 DBD: # of groups defined in element: 3 DBD: [Thu Sep 20 16:45:44 CDT 2007] Begin executing workflow_logging DBD: Area VPath:/tmp DBD: Setting up TDbSchemaAgent. DBD: >>> Loading drivers <<< ... DBD: login timeout=3 DBD: Connecting to the database... ... DBD: Driver i-net UNA 2000 DBD: Version 4.18 ... DBD: Building mappings cache... DBD: Built mapping cache(s) successfully. DBD: # column mappings: 0 DBD: # table mappings: 0 DBD: # view mappings: 0 DBD: # constraint mappings: 0 DBD: Table [TSITE_TBL_DETAIL_JOB] exists. DBD: Table [TSITE_TBL_DETAIL_FILE] exists. DBD: Table [TSITE_TBL_DETAIL_TASK] exists. DBD: Running deployment [workflow_logging] DBD: extraction type=default DBD: tuple mode=wide DBD: area=/tmp DBD: No data capture contents for /tmp/workflow_log.xml DBD: Building replicant order column information. DBD: Building replicant order column information... Done. DBD: TUPLE={state=NotPresent, path=/tmp/workflow_log.xml} DBD: TTableSchemaHelper not found in cache for [TSITE_TBL_DETAIL_JOB]. Creating new. DBD: SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'JOB_ID') DBD: TTableSchemaHelper not found in cache for [TSITE_TBL_DETAIL_FILE]. Creating new. DBD: SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'FILE_ID') DBD: TTableSchemaHelper not found in cache for [TSITE_TBL_DETAIL_TASK]. Creating new. DBD: SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'TASK_ID') DBD: 0 PK values retrieved from iwdeltracker for /tmp/workflow_log.xml, /tmp DBD: DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? DBD: -- Deleted DBD: Stat for group [TSITE_TBL_DETAIL_JOB]: DBD: ----------------------------------- DBD: Rows inserted : 0 DBD: Rows updated : 0 DBD: Rows deleted : 0 DBD: Rows failed : 0 DBD: Rows rolled back : 0 DBD: Rows skipped : 0 DBD: ----------------------------------- DBD: Stat for group [TSITE_TBL_DETAIL_FILE]: DBD: ----------------------------------- DBD: Rows inserted : 0 DBD: Rows updated : 0 DBD: Rows deleted : 0 DBD: Rows failed : 0 DBD: Rows rolled back : 0 DBD: Rows skipped : 0 DBD: ----------------------------------- DBD: Stat for group [TSITE_TBL_DETAIL_TASK]: DBD: ----------------------------------- DBD: Rows inserted : 0 DBD: Rows updated : 0 DBD: Rows deleted : 0 DBD: Rows failed : 0 DBD: Rows rolled back : 0 DBD: Rows skipped : 0 DBD: ----------------------------------- ... DBD: Deployment[workflow_logging] DBD: ----------------------------------- DBD: DCRs inserted : 0 DBD: DCRs updated : 0 DBD: DCRs deleted : 1 DBD: DCRs failed : 0 DBD: DCRs rolled back : 0 DBD: DCRs skipped : 0 DBD: ----------------------------------- DBD: Started : Thu Sep 20 16:45:44 CDT 2007 DBD: Finished: Thu Sep 20 16:45:45 CDT 2007 ENG: 2007-09-20 16:45:45 CDT GMT-05:00 nullDBD: 2007-09-20 16:45:43 CDT GMT+01:00 OpenDeploy install location /usr/od-home/OpenDeployNG DBD: 2007-09-20 16:45:43 CDT GMT+01:00 OpenDeploy install location /usr/od-home/OpenDeployNG DD Home : /usr/od-home/OpenDeployNG DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[0]:iwdd=workflow_logging DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[1]:filename=/tmp/workflow_log.xml DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[2]:xmlarea=/tmp DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[3]:dbname=poll DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[4]:cfg=/usr/od-home/OpenDeployNG/conf/workflow_logger_dd.xml DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[5]:need-result=yes DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[6]:depuuid=d6286480-67c2-11dc-8151-d696ea0d910b DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[7]:leglabel=database DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[8]:svrlogfile=/usr/od-home/OpenDeployNG/log/src.workflow_logger_dd_workflow_log_myDeployment.workflow_logging.iwovxdapp1.to.database.log DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[9]:execProcess=yes DBD: 2007-09-20 16:45:44 CDT GMT+01:00 args[10]:loadhopi=yes DBD: 2007-09-20 16:45:44 CDT GMT+01:00 numArgs=11 ENG: 2007-09-20 16:45:45 CDT GMT-05:00 Database deployment execution returned 0 ENG: 2007-09-20 16:45:45 CDT GMT-05:00 <<< Completed database deployment Invocation>>> ENG: 2007-09-20 16:45:45 CDT GMT-05:00 doTask returned 0 ENG: 2007-09-20 16:45:45 CDT GMT-05:00 Setting final state to TASKDONE ENG: 2007-09-20 16:45:45 CDT GMT-05:00 Job ID=m101 Deployment leg=database Elapsed Time=2424 ms <<< ENG: 2007-09-20 16:45:45 CDT GMT-05:00 End logfile [/usr/od-home/OpenDeployNG/log/src.workflow_logger_dd_workflow_log_myDeployment.workflow_logging.iwovxdapp1.to.database.log]

Looks like DD is not able to find any Primary Keys. can you recheck your PK configuration for all the three groups

Bhargav Coca

These 2 parameters has to be set on your replicants in your dbschema. Please correct it and try again?

is-replicant="yes" allows-null="yes" is-url="no"

Drop the tables which the system has created and then start DAS.
Let me know how did it go?

Thanks

mpeters

These 2 parameters has to be set on your replicants in your dbschema. Please correct it and try again?

is-replicant="yes" allows-null="yes" is-url="no"

Drop the tables which the system has created and then start DAS.
Let me know how did it go?

Thanks

It creates the tables indicated by the schema, as before: it does not find the xml-source and populate the created tables with data, as before.


...
DBD: Running deployment [workflow_logging]
DBD: extraction type=default
DBD: tuple mode=wide
DBD: area=/tmp
DBD: No data capture contents for /tmp/workflow_log.xml
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={state=NotPresent, path=/tmp/workflow_log.xml}
...

Bhargav Coca

Please post your DCT, as moonkhanna said there is something wrong with your primary key, when you have a replicant, at somepoint there will a common Primary key for all the three tables. Look at a common example which does DAS for a DCT with Replicants.

Thanks

mpeters

Please post your DCT, as moonkhanna said there is something wrong with your primary key, when you have a replicant, at somepoint there will a common Primary key for all the three tables. Look at a common example which does DAS for a DCT with Replicants.

Thanks

It's attached: it's a custom xml-source that's being generated by an IPL when users submit content.