datadeploy says EAs are deleted but i still see them in the DB

brvhrt

i am not sure if this is a duplicate post. i tried searching but i didnt get an helpful results

so here is the issue: we have a full deploy script which deploys all the files in staging to the webserver and the metadata ( EAs ) to the DB.

i deleted a file from the workarea then submitted it to staging. now it doesnt exist in STAGING. I then kicked off the full deploy workflow which run successfully. the file that i deleted was deleted from the web server but the EAs for that file didnt get deleted from the DB. The log file indicates that it did.

This workflow - OD-DD process was working before.

what puzzles me is that why the DD log is indicating a success delete but the EAs still exist.

Where else should i look. could it be a permissions issue in which DD may not have enough access to commit the delete in the DB.

thanks in advance

area=/data/iwmnt/wpp/main/Health/Main/STAGING
DBD: filelist=[/logs/interwoven/wpp20/deployment/dd_full_filelist_26437.txt]
DBD: /data/iwmnt/wpp/main/Health/Main/STAGING//health/content/en-us/kparticles/pregnancy/test_moh_emb.html
DBD: Generate DirectoryContents start:Tue Dec 22 10:12:38 PST 2009
DBD: Generate DirectoryContents end  :Tue Dec 22 10:12:38 PST 2009
DBD: Generate TFullEAExtractor start:Tue Dec 22 10:12:38 PST 2009
DBD: Generate TFullEAExtractor end  :Tue Dec 22 10:12:38 PST 2009
DBD: Path not found -- interpret as 'NotPresent'
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={state=NotPresent, path=/health/content/en-us/kparticles/pregnancy/test_moh_emb.html}
DBD: TTableSchemaHelper not found in cache for [wpp_asset]. Creating new.
DBD: SELECT  KEYCOLNAME , KEYCOLVALUE   FROM IWDELTRACKER WHERE  PATH  = ? AND  AREA   = ? AND  KEYCOLNAME  IN ( 'asset_id')
DBD: 0 PK values retrieved from iwdeltracker for /health/content/en-us/kparticles/pregnancy/test_moh_emb.html, /data/iwmnt/wpp/main/Health/Main/STAGING
DBD:  DELETE FROM IWDELTRACKER WHERE  PATH  = ? AND  AREA  = ?
DBD:  -- Deleted 
DBD: Filelist walk done
DBD: Deployment all_content ok
DBD: Committing database [(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ****.****.xx.xx)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = xxxxxx)))]...
DBD: Deployment[all_content] 
DBD: -----------------------------------
DBD:   Files with EAs inserted      : 0
DBD:   Files with EAs updated       : 0
DBD:   Files with EAs deleted       : 1
DBD:   Files with EAs failed        : 0
DBD:   Files with EAs rolled back   : 0
DBD:   Files with EAs skipped       : 0

jagadesh

i am not sure if this is a duplicate post. i tried searching but i didnt get an helpful results so here is the issue: we have a full deploy script which deploys all the files in staging to the webserver and the metadata ( EAs ) to the DB. i deleted a file from the workarea then submitted it to staging. now it doesnt exist in STAGING. I then kicked off the full deploy workflow which run successfully. the file that i deleted was deleted from the web server but the EAs for that file didnt get deleted from the DB. The log file indicates that it did. This workflow - OD-DD process was working before. what puzzles me is that why the DD log is indicating a success delete but the EAs still exist. Where else should i look. could it be a permissions issue in which DD may not have enough access to commit the delete in the DB. thanks in advance area=/data/iwmnt/wpp/main/Health/Main/STAGING DBD: filelist=[/logs/interwoven/wpp20/deployment/dd_full_filelist_26437.txt] DBD: /data/iwmnt/wpp/main/Health/Main/STAGING//health/content/en-us/kparticles/pregnancy/test_moh_emb.html DBD: Generate DirectoryContents start:Tue Dec 22 10:12:38 PST 2009 DBD: Generate DirectoryContents end :Tue Dec 22 10:12:38 PST 2009 DBD: Generate TFullEAExtractor start:Tue Dec 22 10:12:38 PST 2009 DBD: Generate TFullEAExtractor end :Tue Dec 22 10:12:38 PST 2009 DBD: Path not found -- interpret as 'NotPresent' DBD: Building replicant order column information. DBD: Building replicant order column information... Done. DBD: TUPLE={state=NotPresent, path=/health/content/en-us/kparticles/pregnancy/test_moh_emb.html} DBD: TTableSchemaHelper not found in cache for [wpp_asset]. Creating new. DBD: SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'asset_id') DBD: 0 PK values retrieved from iwdeltracker for /health/content/en-us/kparticles/pregnancy/test_moh_emb.html, /data/iwmnt/wpp/main/Health/Main/STAGING DBD: DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? DBD: -- Deleted DBD: Filelist walk done DBD: Deployment all_content ok DBD: Committing database [(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ****.****.xx.xx)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = xxxxxx)))]... DBD: Deployment[all_content] DBD: ----------------------------------- DBD: Files with EAs inserted : 0 DBD: Files with EAs updated : 0 DBD: Files with EAs deleted : 1 DBD: Files with EAs failed : 0 DBD: Files with EAs rolled back : 0 DBD: Files with EAs skipped : 0

Yes, Check in DB whether Particular Table has Delete access for the user(DD configured User). Check the entry still present in iwdeltracker table