Mar 19, 2010 8:06 PM
"missing fragment" errors
-
Like (0)
Hi-
Is anyone familiar with errors like
ERROR: Missing fragments in '_t_actionfrag' for 26975312
The error cannot be consistently reproduced, but it occurs during the creation of a view in a script.
I've searched and asked around and not surprisingly haven't found anything useful.
Anyone know what may trigger this error?
Thanks!
-Scott
Are your dropping or replacing multiple views at the same time in different sessions? Possibly modifying views which reference each other? If you execute 'create or replace view' in two sessions in parallel, and one view references the other view, I believe you can get this error if your timing is just right (or just wrong, as the case may be).
Thanks Shawn....that sounds exactly like what is going on. I had a script running in the background, and it must have collided with another one that I ran directly. That also explains the difficulty in reproducing the error. Thanks again!

