We were using 2 storeviews and now have deleted the extra one we added for testing. Now we have 1 store view and adding new products results in 404 page for the new product added. We have the below error in system.log
main.ERROR: The store that was requested wasn't found. Verify the store and try again.  
Does anyone have experience with this issue?