Both valid. Minor difference in viewpoint. Difference in aspect, actually, i.e., a difference in the conceptualization of time regarding the expectation about the location of the map.
... thought it should be ... The map wasn't at the expected place at the time of the discovery that it was missing. ... thought it should have been ... The map hadn't been at the expect