Hi,
I am using datadeploy5.6 and TS5.52 on unix environment.I am getting the ORA-02292 error.
If some can tell me how datadeploy getting the below SQL.
It is trying to delete content id 2601 . But in my DCR i don't have any info regarding this id.
While it is trying delete 2601 it is giving error bcz it has child tables. Actual scnearia it should delete this record.
I am wondering how it is finding this record to delete
SELECT
ELECT CONTENT_ID, BUSINNESS_UNIT,CONTENT_CATEGORY_ID,TITLE,DESCRIPTION,DCR_PATH,DCR_NAME,TO_CHAR(PUBLISH_DATE,'MM/DD/YY') AS PUBLISH_DATE,TO_CHAR(EXPIRE_DATE,'MM/DD/YY') AS EXPIRE_DATE,DEALER_AUTH_TYPE,AUTHOR,TO_CHAR(EVENT_START_DATE,'MM/DD/YY') AS EVENT_START_DATE,TO_CHAR(EVENT_END_DATE,'MM/DD/YY') AS EVENT_END_DATE,SITE_ID,OWNER_SITE_ID,IS_ALL_SITES,IS_ALL_MODELS,IS_ALL_CHANNELS,ACTIVE,APPROVE_STATUS,TO_CHAR(CREATED_DATE,'MM/DD/YY') AS CREATED_DATE,CREATED_USER_ID,TO_CHAR(LAST_MODIFIED_DATE,'MM/DD/YY') AS LAST_MODIFIED_DATE,LAST_MODIFIED_USER_ID FROM CONTENTS WHERE CONTENT_ID = ?
Recurse select: pIndex = 0, value = 2631
BuildTuples:executeQuery returned valid result set
TTableSchemaHelper object for [CONTENTS] found in cache.
BuildTuples:BuildRows returned: true
DeleteForUpdate: skipping root group
TTableSchemaHelper object for [CONTENTS] found in cache.
SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'CONTENT_ID')
1 PK values retrieved from iwdeltracker for repository/DocumentType/ISGHouse/data/copier_QATEST_HC10, /default/main/IsgMarketingQA/WORKAREA/Copier/repository/DocumentType/ISGHouse/data/
TTableSchemaHelper object for [CONTENTS] found in cache.
db-datetime-format is not specified for [PUBLISH_DATE]. Using default converter.
Converted JDK DateFormat [MM/dd/yy] to Oracle DateFormat [MM/DD/YY].
db-datetime-format is not specified for [EXPIRE_DATE]. Using default converter.
Converted JDK DateFormat [MM/dd/yy] to Oracle DateFormat [MM/DD/YY].
db-datetime-format is not specified for [EVENT_START_DATE]. Using default converter.
Converted JDK DateFormat [MM/dd/yy] to Oracle DateFormat [MM/DD/YY].
db-datetime-format is not specified for [EVENT_END_DATE]. Using default converter.
Converted JDK DateFormat [MM/dd/yy] to Oracle DateFormat [MM/DD/YY].
db-datetime-format is not specified for [CREATED_DATE]. Using default converter.
Converted JDK DateFormat [MM/dd/yy] to Oracle DateFormat [MM/DD/YY].
db-datetime-format is not specified for [LAST_MODIFIED_DATE]. Using default converter.
Converted JDK DateFormat [MM/dd/yy] to Oracle DateFormat [MM/DD/YY].
SelectCurrentRows
ELECT BUSINNESS_UNIT,CONTENT_CATEGORY_ID,TITLE,DESCRIPTION,DCR_PATH,DCR_NAME,TO_CHAR(PUBLISH_DATE,'MM/DD/YY') AS PUBLISH_DATE,TO_CHAR(EXPIRE_DATE,'MM/DD/YY') AS EXPIRE_DATE,DEALER_AUTH_TYPE,AUTHOR,TO_CHAR(EVENT_START_DATE,'MM/DD/YY') AS EVENT_START_DATE,TO_CHAR(EVENT_END_DATE,'MM/DD/YY') AS EVENT_END_DATE,SITE_ID,OWNER_SITE_ID,IS_ALL_SITES,IS_ALL_MODELS,IS_ALL_CHANNELS,ACTIVE,APPROVE_STATUS,TO_CHAR(CREATED_DATE,'MM/DD/YY') AS CREATED_DATE,CREATED_USER_ID,TO_CHAR(LAST_MODIFIED_DATE,'MM/DD/YY') AS LAST_MODIFIED_DATE,LAST_MODIFIED_USER_ID,CONTENT_ID FROM CONTENTS WHERE CONTENT_ID IN (? ) ORDER BY CONTENT_ID
Index: 1, value: 2601
SelectCurrentRows: 1 rows selected.
Thanx in advance
