Question
Optimization wizard issues
There is a class : MyClass-Layer-Layer-Current
There is a property Property1 in MyClass-Layer.
When I tried to optimize Property1 using the optimization wizard, the wizard shown the list of class contexts I want to optimize. I chose my class MyClass-Layer-Layer-Current. And the wizard keeps saying that the property is already optimized. But the column does not exist in the table corresponding to MyClass-Layer-Layer-Current class.
Note:
1. Property1 is optimized in MyClass-Layer
2. MyClass-Layer-Layer-Current & MyClass-Layer - they are not mapped to same data base table.
***Updated by moderator: Lochan to add Categories***
Looks like some one already run the optimization wizard unsuccessfully for the above property -- NO.
I checked the way you suggested too, no such instance are there.
Could you please provide the screenshot of general tab of class configuration for both the classes MyClass-Layer and MyClass-Layer-Layer-Current .
I will give a try at my end will let you know my comments .
Hi,
Can you find the instructions in the attached doc and try re-optimizing the property again ? I think this should help .
The drop column query - I dont have the column at all in the table. Any other options?
Probably, if you dont have any any column as such, can you skip that step, and check if any entries are present in pr_changelog table and delete them ?
Thanks for your reply, this resolved my problem.
Looks like some one already run the optimization wizard unsuccesfully for the above property(I guess this could be one of the reason as I faced similar issue)
If optimization wizard already run then an instance will be created for (System-Job-PropertyOptimization) class.
So I am not sure whether this is a recommended approach but you can try the following approach.
1.enter this class System-Job-PropertyOptimization in App explorer.
2.open its instances .You will see all the job ids.
3.Click on each job then you will see an xml opened of the job details.
4.check for the "pyProperties" value which should corresponding to your property which you wanted to optimize.
5.If you click delete.this job will be deleted and when you re run the optimization wizard You will not see that property already optimized.