Hi,
I have created an agent, which contains a report to schedule it.I am not sending to any one, i just had schedule on it, When i ran, i got the below errors.
Eventually succeeded, but encountered and resolved errors...
Number of skipped deliveries: 0 of 0
AgentID: /shared/Test/Clearcache
Invalid subscribers skipped: weblogic
I have taken Log file from view logs.
PM GMT-07:00
SELECT Logon, Email, "Email Type", "Email Priority", "Cell Phone", "Cell Phone Priority", Pager, "Pager Priority", Handheld, "Handheld Priority", Locale, Language, "Time Zone" FROM "SA System" WHERE Logon IN ('weblogic') /* type='delivers' */select distinct T178842.LOGIN as c1,
T180885.EMAIL_ADDR as c2,
'html' as c3,
'HNL' as c4,
'' as c5,
'en' as c6,
T180881.NAME as c7
from
S_USER T178842,
S_TIMEZONE T180881,
S_CONTACT T180885 /* S_CONTACT_User */ ,
S_EMP_PER T181073
where ( T178842.PAR_ROW_ID = T180885.ROW_ID and T178842.PAR_ROW_ID = T181073.PAR_ROW_ID and T178842.LOGIN = 'weblogic' and T180881.ROW_ID = T180885.TIMEZONE_ID and (TO_DATE('2013-10-16' , 'YYYY-MM-DD') < T181073.TERMINATION_DT or T181073.TERMINATION_DT is null) )
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
Regards,
Sree