We upgraded from 10.2.500 to 10.2.700 and now some of our external baq’s stopped working. We created sql views and now instead of them showing up as a external table, its showing them as a database view. We fields are no longer showing up in the display fields and we are no longer able to create external BAQ’s off of sql views. Is there some setting that we are missing or was there a change between versions?
You created views within your Epicor Db???
You might want to double check your external datasource to make sure that is setup correctly.
Yes, with more complex queries, we create views and run them through external baq’s. We set up an OBDC connection to the epicor database which allows us to do this. It worked great in E9 and E10 but since we upgraded to 10.2.700, we are now seeing that they are being brought in as views instead of a table in which they now have no display fields. the ones we created previously are shown as tables, but when we remove a display field, it doesn’t show back up in the list.
Epicor doesn’t support you creating your own stuff in their database. A lot of times during the upgrade process they will clean up / drop / delete extra stuff they find I would hilight recommend you move these out of the Epicor Db into an external DB (a real external db) to avoid these issues in the future.
I suspect your external data meta data is out of date, you may need to delete it and re-import it to get these views working.
1 Like