I am trying to configure data deploy 5.6 for teamsite 5.5 and oracle 8.1.7. I am able to successfully insert and update records, but deletes will not work. I have tried two things....
1) Setting delete-tracker="yes" and hoping it will delete. It did not. Instead it errored because it tried to update a non-nullable field to null.
2) Since I have a trigger on the wide-tuple table, setting alll fields to null could be just as good as a delete, so i tried setting all non-pk fields in the database to nullable, then deploying again. I get the following error:
Column: Title, field: TeamSite/Metadata/Title, Index: 29,null
Parameter Index: 30, Value: bogus.txt, Converting 'bogus.txt' to VARCHAR
Column: path, field: path, Index: 30,Converting 'bogus.txt' to VARCHAR
-- Failed
ERROR:WriteTuple failure to consumer[0]
ERROR:Unable to process TeamSite source bogus.txt, obtained from filelist=/export/home/sbouchar/filelist.txt
Filelist walk done
ERROR:deployment [prod_metadata_file_list] FAILED
Rollback database [165.224.230.104:1521
EVL]...
Deployment[prod_metadata_file_list] Table[DOCUMENTSTAGING]
-----------------------------------
Tuples inserted : 0
Tuples updated : 0
Tuples deleted : 0
Tuples failed : 0
Tuples rolled back : 0
Tuples skipped : 0
-----------------------------------
Started : Fri Jun 27 20:29:43 EDT 2003
Finished: Fri Jun 27 20:29:45 EDT 2003
--------------------
This looks like it is having a problem with the path though it has a value. I have attached my config file for data deploy.
Please help
Thanks,
Pete
