Job do not progress after certain percent...
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 75
- Joined: Thu Nov 27, 2008 10:12 am
Is this a new installation? Is this the only table you're having loading issues? Can you load the data into a another table with the same structure? There are too many variables.
It sounds like you have some sort of issue writing to this table. Start with a simple design that extracts your source data to a file. If this works then your problem is loading the table. This eliminates all of the false trails the other posters have laid for you to spend time on.
Now simply try to get the data to load the target table. Try to get just one row and make sure the data types are all correct. Make sure you are capturing rejects from the database. Since youre doing an OCI load and not and enterprise this should be fairly straightforward. If you get that working, then moe to the Enterprise stage and work out the kinks there.
It sounds like you have some sort of issue writing to this table. Start with a simple design that extracts your source data to a file. If this works then your problem is loading the table. This eliminates all of the false trails the other posters have laid for you to spend time on.
Now simply try to get the data to load the target table. Try to get just one row and make sure the data types are all correct. Make sure you are capturing rejects from the database. Since youre doing an OCI load and not and enterprise this should be fairly straightforward. If you get that working, then moe to the Enterprise stage and work out the kinks there.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 75
- Joined: Thu Nov 27, 2008 10:12 am
Thanks a lot for your valuable suggestion Ken. This is the issue for which I requested your permission and sent you a detailed mail after your go ahead. Hope you would have received the details. Thanks again for your valuable time and kind help.
Yes this is the only table having load issue. I have tried dropping and recreating the table, even then the same load issue persists. I'm able to load the data into sequential file/Data Set without issues. However, I'm unable to write the data from Sequential file to the table. Its strange. A straight simple load is not working. I tried to make all the target columns nullable for test reason and already I had tried the option of loading one row into target. The log shows
FactLoad,0: Progress: 90 percent.
FactLoad,0: Import complete; 731 records imported successfully, 0 rejected.
The only improvement that I see is the progress percent was increased from 40% to 90%
The job is in running stage and the records are not getting committed into the target.
Yes this is the only table having load issue. I have tried dropping and recreating the table, even then the same load issue persists. I'm able to load the data into sequential file/Data Set without issues. However, I'm unable to write the data from Sequential file to the table. Its strange. A straight simple load is not working. I tried to make all the target columns nullable for test reason and already I had tried the option of loading one row into target. The log shows
FactLoad,0: Progress: 90 percent.
FactLoad,0: Import complete; 731 records imported successfully, 0 rejected.
The only improvement that I see is the progress percent was increased from 40% to 90%
The job is in running stage and the records are not getting committed into the target.
-
- Participant
- Posts: 75
- Joined: Thu Nov 27, 2008 10:12 am
For those of us not yet migrated from 7.5 over to 8, could you please advise why this made a difference? What does DS_NO_PROCESS_METADATA affect and what did this change contribute to solving your issue of loading the data?
Thanks,
Mark
Thanks,
Mark
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>