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; } } }

DD Can't Update existing data

cc96ai

I try to update the existing record,
Open & Edit DCR, and send through the workflow,
However, the data didnt update in database

In my log file src.dd_client.submitlist.tela.to.database.log.dd
I found this in the bottom

1 rows inserted into iwdeltracker for templatedata\JobPostings\content\data\2005-164, /default/main/Internet/STAGING
-- Updated
Filelist walk done
Stat for group [content]:
-----------------------------------
Rows inserted : 0
Rows updated : 0
Rows deleted : 0
Rows failed : 0
Rows rolled back : 0
Rows skipped : 0
-----------------------------------
Committing database [falcon:3306/MainData]...
Deployment[submitlist]
-----------------------------------
DCRs inserted : 0
DCRs updated : 1
DCRs deleted : 0
DCRs failed : 0
DCRs rolled back : 0
DCRs skipped : 0
-----------------------------------
Started : Fri Oct 28 12:32:56 EDT 2005
Finished: Fri Oct 28 12:32:56 EDT 2005

### IWDataDeploy DONE ###
### Sending result ###

Any suggestion?
Thanks

--------------------------------------------
TS 6.1 W2K3
TS 6.5 SP2, W2K3 SP1
OpenDeploy 6.0

Find more posts tagged with

Comments

Migrateduser

It could be the way you have your mapping setup, and DD didn't find a mapping of your DCR to a table in your schema... hard to tell just from that log msg.

Mariam

cc96ai

But DD still able to insert a new record to database

--------------------------------------------
TS 6.1 W2K3
TS 6.5 SP2, W2K3 SP1
OpenDeploy 6.0

Migrateduser

Well the 'DCR updated' message doesn't mean it updated your table. It may have updated an interwoven tracker table.

Mariam

Migrateduser

have you tried setting real-update="no" in database.xml? real-update never worked well for us, especially w/ replicant heavy DCRs

WoW Profile
TS 6.5 SP1
OD 6.0.2

cc96ai

src.humber_dd_test.submitlist.tela.to.database.log
i saw the following error in the log file.

[Wed Nov 02 10:03:13 EST 2005] Begin executing submitlist
Area VPath:/default/main/Internet/STAGING
Setting up TDbSchemaAgent.
Validating cached connection...
SQLExceptionCommunication link failure: java.io.EOFException, underlying cause: null

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1388)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1532)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1923)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1218)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2233)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2181)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1158)
at com.mysql.jdbc.DatabaseMetaData.getCatalogs(DatabaseMetaData.java:408)
.TDbAgent.ValidateConnection(TDbAgent.java:586)
.TDbConnectionManager.GetConnection(TDbConnectionManager.java:64)
.TDbAgent.EstablishConnection(TDbAgent.java:548)
.TDbAgent.<init>(TDbAgent.java:271)
.TDbSchemaAgent.<init>(TDbSchemaAgent.java:63)
.TConsumerManager.CheckDbSchemaPresent(TConsumerManager.java:513)
.TConsumerManager.SetupConsumer(TConsumerManager.java:586)
.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:191)
.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
.TAgentClient.Go(TAgentClient.java:97)
.IWDataDeploy.Go(IWDataDeploy.java:520)
.TWorkItem.DoIt(TWorkItem.java:165)
.TLonelyWorker.run(TLonelyWorker.java:49)
at java.lang.Thread.run(Thread.java:479)

** END NESTED EXCEPTION **

--------------------------------------------
TS 6.1 W2K3
TS 6.5 SP2, W2K3 SP1
OpenDeploy 6.0