You are not logged in.
Announcement
Unanswered posts
|
- Index
- » General questions
- » Failure in tOracleSP does not produce record in Talend Logs table
Post a reply
Topic review (newest first)
- leonardocloureiro
- 2011-11-22 13:03:55
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!
- pedro
- 2011-11-22 08:00:18
Hi
Could you upload picture of you job?
We need more details.
In theory, the records should be produced in both tables.
Best regards!
Pedro
- leonardocloureiro
- 2011-11-21 16:14:45
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