Well I'm here to wrap this up. In doing my diagnostic checking fuses, looking for any rodent damage to wiring harness etc. I happen to glance at the fuel pump relay for the third time. In looking at so many bloody electrical connections and relays I noticed it didn't look like a BMW relay. I pulled the thing and sure enough it was a generic relay. I went over to my box of BMW relays and installed the proper green relay and BINGO!!!! all was good and ran great especially for sitting for so long. Interesting how this relay could cause so many unrelated and serious codes appear.
End of the day I have become very proficient in checking fuse boxes and electrical connections. Now onto the air suspension compressor. Thanks for all the support!