xml records drop while loading into oracle target table
Moderators: chulett, rschirm, roy
xml records drop while loading into oracle target table
Dear Experts,
rejected Records are dropping while loading into reject table. but same datastage job is able to load in dev /test environment with same structure of Rejecetd table.
Please help me in resolving this.
rejected Records are dropping while loading into reject table. but same datastage job is able to load in dev /test environment with same structure of Rejecetd table.
Please help me in resolving this.
RD
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Never mind the fact that there is an extreme lack of detail here so not sure how anyone could help straight away. Are you getting errors / warnings in your log that you can post? Can you describe your job design? Any other information you can provide that may help people help you would be appreciated.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
More information, please. For example, what exactly is your "user defined update" sql? From what I recall, there should also be a final entry logged for the target stage in question here with details on records written, etc - can you post that as well?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Update SQL Query:
INSERT INTO TB_REJECT (FILE_NAME, TABLE_NAME, SOURCE, ROW_NUM, RECORD, ERROR_DESC, DATA_DATETIME, CREATED_DATETIME, MODIFIED_DATETIME, CREATED_BY, MODIFIED_BY) VALUES (ORCHESTRATE.FILE_NAME, ORCHESTRATE.TABLE_NAME, ORCHESTRATE.SOURCE, ORCHESTRATE.ROW_NUM, ORCHESTRATE.RECORD, ORCHESTRATE.ERROR_DESC, ORCHESTRATE.DATA_DATETIME, ORCHESTRATE.CREATED_DATETIME, ORCHESTRATE.MODIFIED_DATETIME, ORCHESTRATE.CREATED_BY, ORCHESTRATE.MODIFIED_BY)
INSERT INTO TB_REJECT (FILE_NAME, TABLE_NAME, SOURCE, ROW_NUM, RECORD, ERROR_DESC, DATA_DATETIME, CREATED_DATETIME, MODIFIED_DATETIME, CREATED_BY, MODIFIED_BY) VALUES (ORCHESTRATE.FILE_NAME, ORCHESTRATE.TABLE_NAME, ORCHESTRATE.SOURCE, ORCHESTRATE.ROW_NUM, ORCHESTRATE.RECORD, ORCHESTRATE.ERROR_DESC, ORCHESTRATE.DATA_DATETIME, ORCHESTRATE.CREATED_DATETIME, ORCHESTRATE.MODIFIED_DATETIME, ORCHESTRATE.CREATED_BY, ORCHESTRATE.MODIFIED_BY)
RD
below are the log information for rejected records:
orc_TB_REJECT_ins,1: Records inserted: 0
Records used for update: 0
Records rejected: 1
Total records: 1.
orc_TB_REJECT_ins,2: Records inserted: 0
Records used for update: 0
Records rejected: 0
Total records: 0.
orc_TB_REJECT_ins,3: Records inserted: 0
Records used for update: 0
Records rejected: 0
Total records: 0.
orc_TB_REJECT_ins,0: Records inserted: 0
Records used for update: 0
Records rejected: 0
Total records: 0.
it is showing 1 record is rejectedin the log,but in the reject table ,that record is not rejected/inserted in the recject table.
please help me here to trouble shoot this
orc_TB_REJECT_ins,1: Records inserted: 0
Records used for update: 0
Records rejected: 1
Total records: 1.
orc_TB_REJECT_ins,2: Records inserted: 0
Records used for update: 0
Records rejected: 0
Total records: 0.
orc_TB_REJECT_ins,3: Records inserted: 0
Records used for update: 0
Records rejected: 0
Total records: 0.
orc_TB_REJECT_ins,0: Records inserted: 0
Records used for update: 0
Records rejected: 0
Total records: 0.
it is showing 1 record is rejectedin the log,but in the reject table ,that record is not rejected/inserted in the recject table.
please help me here to trouble shoot this
RD
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: