Oracle Connector is not pulling the records !!
Posted: Tue Nov 15, 2011 9:34 am
Hi ,
I'm using Oracle connector stage for the first time.
Have totally 19 columns in the Table definiton
Out those 1 column length is 16383 of Data type LongNVarChar
I'm running the jobs in Dev and IT..its running fine. giving the count.
It seems Dev and IT data is not the correct data.
If i run the same job from ST . Its finished without any warnings but Oracle Connector is not pulling any records from the ST database.
query is given below :
SELECT
OE.NAME AS Account_NAME ,
AA.FILE_NAME AS Attachment,
EA.CREATED AS Message_Sent,
EA.NAME AS Subject,
EM.EMAIL_BODY AS Message,
EM.EMAIL_SNDR_ADDR AS EMAIL_SNDR,
EM.EMAIL_TO_LINE AS EMAIL_TO ,
EAX.ATTRIB_45 AS Inbox,
EA.OWNER_LOGIN AS Owned_By,
EA.PREV_ACT_ID AS Previous_Activity_ID,
EAX.X_PRODUCT_LINE AS X_PRODUCT_LINE,
SR.SR_NUM AS SR_NUM,
EAX.X_SERVICE_TYPE AS Service_Type,
EA.EVT_STAT_CD AS Status,
EA.TODO_CD AS EMAIL_Type,
EA.PAR_EVT_ID AS Parent_Communication_Id,
SC.LAST_NAME AS Last_Name,
SC.FST_NAME AS First_Name,
SC.X_PIN AS PIN
FROM
SIEBEL.S_EVT_ACT EA,
SIEBEL.S_ORG_EXT OE,
SIEBEL.S_ACTIVITY_ATT AA,
SIEBEL.S_EVT_MAIL EM,
SIEBEL.S_EVT_ACT_X EAX,
SIEBEL.S_SRV_REQ SR,
SIEBEL.S_CONTACT SC,
EIMUSER.T_SEC17A_DAT TSEC
WHERE
EA.TARGET_OU_ID = OE.ROW_ID(+)
AND EA.ROW_ID = AA.PAR_ROW_ID(+)
AND EA.ROW_ID = EM.PAR_ROW_ID(+)
AND EA.ROW_ID = EAX.PAR_ROW_ID(+)
AND EA.SRA_SR_ID = SR.ROW_ID(+)
AND EA.TARGET_PER_ID=SC.ROW_ID(+)
AND EA.TODO_CD in ('Email - Inbound', 'Email - Outbound')
AND EA.EVT_STAT_CD='Done'
AND SC.CON_CD ='Participant'
AND EA.X_RECORD_TYPE = 'Email'
AND NVL(EA.PAR_EVT_ID, 'Y') <> 'Y'
AND EA.PAR_EVT_ID <> 'No Match Row Id'
AND EA.PAR_EVT_ID = TSEC.PRIMARY_ID AND EA.ROW_ID = TSEC.MID_ID
AND TSEC.TYPE_CD = 'SECDSBL36'
AND ROWNUM <=10
I'm using Oracle connector stage for the first time.
Have totally 19 columns in the Table definiton
Out those 1 column length is 16383 of Data type LongNVarChar
I'm running the jobs in Dev and IT..its running fine. giving the count.
It seems Dev and IT data is not the correct data.
If i run the same job from ST . Its finished without any warnings but Oracle Connector is not pulling any records from the ST database.
query is given below :
SELECT
OE.NAME AS Account_NAME ,
AA.FILE_NAME AS Attachment,
EA.CREATED AS Message_Sent,
EA.NAME AS Subject,
EM.EMAIL_BODY AS Message,
EM.EMAIL_SNDR_ADDR AS EMAIL_SNDR,
EM.EMAIL_TO_LINE AS EMAIL_TO ,
EAX.ATTRIB_45 AS Inbox,
EA.OWNER_LOGIN AS Owned_By,
EA.PREV_ACT_ID AS Previous_Activity_ID,
EAX.X_PRODUCT_LINE AS X_PRODUCT_LINE,
SR.SR_NUM AS SR_NUM,
EAX.X_SERVICE_TYPE AS Service_Type,
EA.EVT_STAT_CD AS Status,
EA.TODO_CD AS EMAIL_Type,
EA.PAR_EVT_ID AS Parent_Communication_Id,
SC.LAST_NAME AS Last_Name,
SC.FST_NAME AS First_Name,
SC.X_PIN AS PIN
FROM
SIEBEL.S_EVT_ACT EA,
SIEBEL.S_ORG_EXT OE,
SIEBEL.S_ACTIVITY_ATT AA,
SIEBEL.S_EVT_MAIL EM,
SIEBEL.S_EVT_ACT_X EAX,
SIEBEL.S_SRV_REQ SR,
SIEBEL.S_CONTACT SC,
EIMUSER.T_SEC17A_DAT TSEC
WHERE
EA.TARGET_OU_ID = OE.ROW_ID(+)
AND EA.ROW_ID = AA.PAR_ROW_ID(+)
AND EA.ROW_ID = EM.PAR_ROW_ID(+)
AND EA.ROW_ID = EAX.PAR_ROW_ID(+)
AND EA.SRA_SR_ID = SR.ROW_ID(+)
AND EA.TARGET_PER_ID=SC.ROW_ID(+)
AND EA.TODO_CD in ('Email - Inbound', 'Email - Outbound')
AND EA.EVT_STAT_CD='Done'
AND SC.CON_CD ='Participant'
AND EA.X_RECORD_TYPE = 'Email'
AND NVL(EA.PAR_EVT_ID, 'Y') <> 'Y'
AND EA.PAR_EVT_ID <> 'No Match Row Id'
AND EA.PAR_EVT_ID = TSEC.PRIMARY_ID AND EA.ROW_ID = TSEC.MID_ID
AND TSEC.TYPE_CD = 'SECDSBL36'
AND ROWNUM <=10