I have 2 store views. One is in Chinese and another one is in English. After I import the product information programmatically. Only the store view in the Chinese could display the product detailed page. The store view in English gets 404. I found in url_rewrite table only Chinese store view have rewrite record like the following:
store_id = 1 is the Chinese store view. but there is no record for the English store view whose store_id = 2.