AnsweredAssumed Answered

SQL Table view is visable in SSMS but not in ArcCatalog

Question asked by rralbritton on Nov 30, 2015
Latest reply on Nov 30, 2015 by Christian_Wells-esristaff

I am working in SSMS 2012 with a linked database to create views. I have done this successfully with three tables and have been able to see the results of these views in both SSMS and in ArcCatalog (10.3 - Enterprise). I'm all of the suddent having issues with a fourth view that I'm trying to create. I execute the query in SSMS to create the view, and the query is successful. I can see the data in SSMS, however, the table in ArcCatalog is empty. I'm not sure why this one particular view would be different then the others that I've created. Does anyone have any suggestions?

 

Here's my query that I used to create the view that I can successfully query in SSMS but can not see in ArcCatalog:

 

CREATE VIEW dbo.fiber_conduitcapacity_edit_test1  
AS
SELECT CAST(row_number()OVER (ORDER BY CB_ID) AS INT) as ID, cb_id,route, average_fill, max_fill, min_fill, open_conduit, capacity, 
CASE WHEN open_conduit<1 THEN 'no' ELSE 'yes'
END AS 'open'
FROM CAMPDB..INFRASTRUCTURE.CONDUITBANK_CAPACITY_V;

 

What's really odd is that is I take the CASE statement out, thequery runs successfully and I can see the results in ArcCatalog so I'm assuming the issue centers around the CASE statement, but I'm not 100% sure since I can see the results in SSMS.

 

Thanks in advance.

Outcomes