Re: OT: IDS 10 QPlan sanity failure problems
Davorin Kremenjas still hit QPlan sanity failures on IDS 10 after running update statistics for procedure. scottishpoet said query plans changed after 9.40.UC4, so procedure plans need updating, and asked about ER (none used). He said the requirement should be in the IDS 10 migration guide, otherwise it is a docs bug. Unresolved; Davorin contacted support.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Well, the truth is I didn't specify "for procedure" the first time but I did it this time and still the same problem appears. I'll drop and recreated all problematic procedures and hope it works. I also contacted my local support, maybe they'll know the solution. "scottishpoet" <dryburghj@yahoo.com> wrote in message news:1127217937.510858.314160@z14g2000cwz.googlegroups.com... > what update statistics did you run > > If you didn't specify "for procedure" it would not have updated the > query plans for the procedure > > Personally, I'd drop and recreate the procedure.
surprised that didn't work! there was a change to the query plans after 9.40.UC4 which means the plans all need updated and the update statistics for procedure requirement should be documented. Are you using ER?
No, no ER, HDR or anything like that... I'll search through release notes, defect notes etc. for v10, maybe it really is documented. "scottishpoet" <dryburghj@yahoo.com> wrote in message news:1127231331.200732.213480@g43g2000cwa.googlegroups.com... > surprised that didn't work! there was a change to the query plans after > 9.40.UC4 which means the plans all need updated and the update > statistics for procedure requirement should be documented. > > Are you using ER? >
the requirement to run aupdate statistics for procedure is supposed to be documented in the IDS 10 migration guide if its not then its a docs bug