You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Enterprise Data Integration » General questions
- » Failure in tOracleSP does not produce record in Talend Logs table
#1 2011-11-21 16:14:45
- leonardocloureiro
- New member
- Registered: 2011-11-21
- Posts: 2
Failure in tOracleSP does not produce record in Talend Logs table
I have an issue with Stats & Log feature using the component tOracleSP.
The job fails executing the tOracleSP .Therefore a single Record is only produced in table “monitor_velvelox_stats”.
But it is not being produced in log table “monitor_velvelox_log”.
Should not the Record have been produced in both tables? This is what have happened for other sort of failures.
Below the error throwed in tOracleSP component.
Any help is appeciated .
Starting job LoadInvDsl at 11:38 21/11/2011.
[statistics] connecting to socket on port 3806
[statistics] connected
Exception in component tOracleSP_1
java.sql.SQLException: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file Rel_portadsl.AC.OBJECTEL.txt in OBJECTEL_INPUT not found
ORA-06512: at "SYS.ORACLE_LOADER", line 19
ORA-06512: at "INVDSL.CARGA_INV_VELVELOX_3", line 95
ORA-06512: at line 1
Offline
#3 2011-11-22 13:03:55
- leonardocloureiro
- New member
- Registered: 2011-11-21
- Posts: 2
Re: Failure in tOracleSP does not produce record in Talend Logs table
The issue was related to the size of field Message in Log table. It is very small to store the whole exception message. Solved!
Thanks!
Offline
Pages: 1
- Index
- » Talend Enterprise Data Integration » General questions
- » Failure in tOracleSP does not produce record in Talend Logs table