I can break the layers out into separate services, 1 SQL Server and 1 Oracle, publish and display the data with no issues. When I combine the layers I to a single service the data does not display. Using 10.4.1 sp1 on Windows 2008 Server R2.
What are the versions of SQL Server and Oracle?
Microsoft SQL Server database requirements for ArcGIS 10.4.x
Oracle database requirements for ArcGIS 10.4.x
Oracle is at version 12c, SDE version is at 10.4
SQL Server is at 2012, SDE version is at 10.4
All data is in (NAD_1983_HARN_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl)
The map service is cached and I'm looking at the cache now to determine if it has been created correctly.
If the map service is cached, make sure the cache status is "100% completed"
Hi Jayanta,
I had to recreate the cache which resolved the issue.
Thank You,
Marvin Martinez
GIS and Data Manager
Street Transportation / Technical Services
602-534-1552
You can set the service to draw dynamically and see if both layers show up. If they do, then it's a problem with the caching tools. If they don't then that's the reason why they don't show up in the cache. Once you can determine if it's a problem with Serve drawing the data, (either when displayed dynamically or when creating the tiles), the logs should be able to give you an idea of whats wrong.
Jonathan,
Thank You for the info.
The issue was related to the cache which I had to rebuild to resolve the issue.
Thanks again,
Marvin Martinez
GIS and Data Manager
Street Transportation / Technical Services
602-534-1552
I would suggest taking a look at the Server logs under at least Verbose to figure out why both data can't be displayed. Do they display in ArcMap fine? Typically, if everything works in ArcMap, it'll work in a service. The Server logs should give you a good idea of what's going on. If you want to dive a bit deeper, you can run an SDEINTERCEPT to see all of the communication between the Server and the databases to make sure that communication looks good.