We have a layer in 9.3 with joined tables that started throwing a drawing error pop-up in ArcMap 9.3 stating "One or more layers failed to draw. The field is not nullable." This happens when someone zooms in close enough for labels to turn on. There are no null values in any of the non-nullable fields in either the feature class or the joined tables, and all of the features do appear to draw.
I opened the same layer in ArcMap 10.1 and got the drawing error "The function ID is out of range" once I hit the scale where the labels turn on. I went back to the original feature class and set the label specifications to the same parameters and I am not getting an error, so in our case, it does seem to have something to do with the layer that has joined tables rather then hitting the SDE 9.3 database from ArcMap 10.1.
