Hi,
I need help in serting the records into taget Oracle table.
oracle_stage-transf-lkp-lkp-oracle target
' '
ref table
'
ref table
Warning1:APT_CombinedOperatorController(1),3: Conversion error calling conversion routine timestamp_from_string data may have been lost.
Warning2:Lookup: Input dataset 1 has a partitioning method other than entire specified; disabling memory sharing.
Lookup,2: Ignoring duplicate entry at table record 4; no further warnings will be issued for this table
Info:Tgt_EXPERIENCE_PERIOD,0: Records inserted: 0
Records used for update: 0
Records rejected: 0
Total records: 0.
Fatal:node_node1_2: Player 4 terminated unexpectedly.
not inerting reords into target
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
Re: not inerting reords into target
Hi Sunitha,sunitha_cts wrote: Warning1:APT_CombinedOperatorController(1),3: Conversion error calling conversion routine timestamp_from_string data may have been lost.
Warning2:Lookup: Input dataset 1 has a partitioning method other than entire specified; disabling memory sharing.
Lookup,2: Ignoring duplicate entry at table record 4; no further warnings will be issued for this table
Info:Tgt_EXPERIENCE_PERIOD,0: Records inserted: 0
Records used for update: 0
Records rejected: 0
Total records: 0.
.
I think the problem could be that no records are reaching the target Oracle stage itself. As i dont see any rejected record count.
can you confirm the same?
w.r.t warning,
stringToDate conversion - there are lot of posts in this forum and you can search for the solution easily. Issue could be with Null handling.
and there are multiple records matching for the giving set of lookup keys.
so, if it is valid scenario, then you need to enable the option in lookup so that multiple lookup records can be retrieved.
Hope it helps.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
ray.wurlod wrote:We don't even bother trying to diagnose errors from APTCombinedOperatorController. ...
If you have a Timestamp feild, which you might be reading as a String.
And you are not using StringToTimestamp conversion function.
Please check your data and use the Conversion function.
Thanks,
Pavan
Pavan