The ETL interface Job got aborted today due to be below error message.Looks like this is error ralated to Database(PMMPROD).
Error msg:
Indexes on table 'MWW_19C_EXT' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.
Kindly suggest how to proceed further
direct parallel loading unless an index option is included.
Moderators: chulett, rschirm, roy
direct parallel loading unless an index option is included.
Thanks!!
Ajay Yogesh
!!Beat it & Get it!!
Ready to lose few battles to win the WAR
Ajay Yogesh
!!Beat it & Get it!!
Ready to lose few battles to win the WAR
As the error message suggests, you can either:
1) Select an index option in the database stage you are writing with. Typically you may elect to rebuild the index, but other options may be present
2) Disable or remove the index before loading the data. The stage may have the option to disable the index, or you can work with the DBAs to disable it.
Ask your DBA which option they recommend for their database. Also, you can read the database connectivity guide document for the type of database you are connecting to to gain a better understanding of the options available to you.
Regards,
1) Select an index option in the database stage you are writing with. Typically you may elect to rebuild the index, but other options may be present
2) Disable or remove the index before loading the data. The stage may have the option to disable the index, or you can work with the DBAs to disable it.
Ask your DBA which option they recommend for their database. Also, you can read the database connectivity guide document for the type of database you are connecting to to gain a better understanding of the options available to you.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
Be careful when you choose to disable the index before load and then enable it after load, particularly you have unique index on target table.
you should ensure that there is no violation of the unique constrain, or your table will be read only and the DBMS will not let you enable the unique index.
you should ensure that there is no violation of the unique constrain, or your table will be read only and the DBMS will not let you enable the unique index.
Jack Li
Re: direct parallel loading unless an index option is includ
Thankyou very much both of you!!!!
It solved the issues, actually there was no unique constrain so I tried with the first option, and it is good to go..
1) Select an index option in the database stage you are writing with. Typically you may elect to rebuild the index, but other options may be present
It solved the issues, actually there was no unique constrain so I tried with the first option, and it is good to go..
1) Select an index option in the database stage you are writing with. Typically you may elect to rebuild the index, but other options may be present
Thanks!!
Ajay Yogesh
!!Beat it & Get it!!
Ready to lose few battles to win the WAR
Ajay Yogesh
!!Beat it & Get it!!
Ready to lose few battles to win the WAR