Jaise James
Reputable Poster
Guys,
I have issue. We have very large F0911 table and we wanted to add a new index to this table. The correct way would be to generate the index from OMW. But it will generate all the indexes ( after dropping them first). Since this is such a large table we want to avoid generating all of them. In addition, we have replication tuned on.
We created the index manaully directly on the database and deployed promoted the spec to prod, build and deployed the pacakge. But it still says unable to find the index.
Hence to resolve the issue in DEV I did following.
1. Renames F0911 table,
2. Created blank table F0911
3. FROM OMW i generated the index.
4. Deleted the New F0911 table
5. Rename the orignal table back to F0911.
Everything is working.
Question, Why do I have to generate the index from the OMW ( considering spec exist both in client and server and full pacakge was build and deployed). I looked thru the debug log and did not see any special table it updated for it to work.
Has any one seen this issue. Is there any thing I can do without actually doing a manual Index generation from OMW.
Appreciate any help
I have issue. We have very large F0911 table and we wanted to add a new index to this table. The correct way would be to generate the index from OMW. But it will generate all the indexes ( after dropping them first). Since this is such a large table we want to avoid generating all of them. In addition, we have replication tuned on.
We created the index manaully directly on the database and deployed promoted the spec to prod, build and deployed the pacakge. But it still says unable to find the index.
Hence to resolve the issue in DEV I did following.
1. Renames F0911 table,
2. Created blank table F0911
3. FROM OMW i generated the index.
4. Deleted the New F0911 table
5. Rename the orignal table back to F0911.
Everything is working.
Question, Why do I have to generate the index from the OMW ( considering spec exist both in client and server and full pacakge was build and deployed). I looked thru the debug log and did not see any special table it updated for it to work.
Has any one seen this issue. Is there any thing I can do without actually doing a manual Index generation from OMW.
Appreciate any help