Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dowens
Yak Posting Veteran
82 Posts |
 Posted - 2005-10-10 : 15:28:54
|
| I have two db's db1 db2db1 is the active dbNightly the inactive db (in this case db2) is refreshed and becomes the active db once refresh completes.Each db has duplicate views (UNION).Users are receiving error 'failed row set' (crystal).If I open the active view (Union) and save it the error goes away and the data is selected.What am I doing wrong? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-10 : 15:40:57
|
| Post the view code.Tara |
 |
|
|
dowens
Yak Posting Veteran
82 Posts |
Posted - 2005-10-10 : 15:43:29
|
| CREATE VIEW dw_v_GroupMaster ASSELECT fl1stDwProd1.dbo.dw_GroupMaster.* FROM fl1stDwProd1.dbo.dw_GroupMaster , dbo.dw_ControlWHERE activeDbName = 'prod1'UNIONSELECT fl1stDwProd2.dbo.dw_GroupMaster.* FROM fl1stDwProd2.dbo.dw_GroupMaster , dbo.dw_ControlWHERE activeDbName = 'prod2' |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-10 : 16:31:40
|
| I suspect this has to do with the * in your view. Try modifying the view so that it uses an explicit column list in both select statements. If this fixes it, then it has to do with how you are performing the refresh.Tara |
|
|
|
dowens
Yak Posting Veteran
82 Posts |
Posted - 2005-10-11 : 08:37:27
|
| I'm not clear as to what you mean by explicit column list.Perhaps listing each data field of the table?I use DTS to pull the data in and sp to normalize the data.Once all tables are built a control table is updated to point to the refreshed db. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-11 : 10:01:05
|
| "I'm not clear as to what you mean by explicit column list"Instead of usingfl1stDwProd2.dbo.dw_GroupMaster.*list each column in the tableKristen |
|
|
|
|
|
|
View error