I resolved the issue with the above error. All we need to do is just use same alias name in all union/union all in select statement ( when your sql have multiple union/unions). I think when Infoview is reading version 9 database, it required to code the sql in above manner.