Latest Contributions by PaulHuffman

Well, I talked to ESRI Support, and did a screen sharing session.  We didn't actually solve the original problem of having these 16 bit raster datasets displaying poorly in database connections or Image Services.  ESRI suggested that I copy the individual 16 bit tiffs to local storage, then create a moasic dataset and load in the tiffs, build overviews and analyze, and share as an image service.  So far, the database connection and the image service have been performing just fine.   ... View more

Stranger still.  I previewed the raster datasets and image services with ArcCatalog on my 10.3.1 client machine in early afternoon, and they looked like random color pixels as above.  I looked at them with ArcCatalog 10.2.2 on my laptop, and they looked fine.  I went back to my 10.3.1 client again in late afternoon, and they previewed just fine.  Something is unstable, intermittent here.  ... View more

Yeah, that was it.  I didn't think there would be locks because I just loaded the data, but I guess I forgot that I was looking at it in ArcMap trying to make the join which created locks. ... View more

This is getting stranger.  I started up Desktop 10.3.1 to take a look at these images services again,  but both looked like random color value pixels.  I investigated back to the source raster datasets in SDE.  Same thing.  I went back to the source individual tifs in standard disk storage.  Same scrambled mess.  Same when added to ArcMap as in ArcCatalog previews.  Same on my ArcServer machine.  What changed since April 25?  Wasn't I still running Desktop 10.3.1?  I hooked up a laptop that is still running Desktop 10.2.2 to my network, navigated my network, and AC previews of the raster datasets, image services, and source images look fine,  grayscale black and white air photos as before. ... View more

The old black and white photos look fine when I copied them to a new version, 8-bit and scaled pixels, but when I loaded them into a new SDE raster dataset,  it previews like this:    Very strange. ... View more

My output looks good but I see the concern.  I'll have to try ScalePixelValue to see if I lost some data the way I did it. ... View more

Thanks. But when I got started with this in SSMS, I got "huf******* is not a valid Windows NT name.  Give a complete name :<domain\username>. Microsoft SQL Server, Error 15407)  "   I'm not running a Windows Domain at this location.  I've tried adding my Workgroup e.g. workgroup.local\huf*****, but haven't guessed at the correct syntax.  Is it possible to have Windows authentication without a domain? I tried an idea to create a login with the same password on the SQL machine as suggested at  http://dba.stackexchange.com/questions/8151/windows-authentication-for-a-non-local-non-domain-login    But got the same error message. ... View more

Although I was able to load them into an SDE raster dataset as 16 bit unsigned,  the image service from this raster dataset was all one value gray.  I just went ahead and Copy Rastered them to 8 bit unsigned in order to make an acceptable image service,  same as I had to in 9.3.1.  Maybe this python script will be useful to someone faced with the same issue. # -*- coding: utf-8 -*- # --------------------------------------------------------------------------- # Copyto8bit.py # Created on: 2016-04-21 10:25:28.00000 #   (generated by ArcGIS/ModelBuilder) #  Edited by PH # Description: Copies WIP photos to another folder, converting to 8 bit unsigned, and building pyramids with bilateral # --------------------------------------------------------------------------- # Import arcpy module import arcpy import os from arcpy import env # Local variables: InputFolder = "G:\\DOQ_photos\\wip\\FullSetTifs" Outputfolder = "G:\\DOQ_photos\\wip\\FullSetTifs\\8Bit" #workspace  env.workspace = "G:\\DOQ_photos\\wip\\FullSetTifs"       #List all features in  gp.workspace  rasters = arcpy.ListRasters("*", "TIF")  #raster = rasters.Next() #print "\n".join(rasters) for raster in rasters:     # Process: Copy Raster     Copyname = os.path.splitext(raster)[0] + "-8bit.tif"     arcpy.CopyRaster_management(raster, (os.path.join(Outputfolder,Copyname)), "", "0", "0", "NONE", "NONE", "8_BIT_UNSIGNED", "NONE", "NONE")     print Copyname + " is copied."     arcpy.BuildPyramids_management((os.path.join(Outputfolder,Copyname)),-1,"NONE","BILINEAR", "DEFAULT", "75", "")     print Copyname + " pyramids built." ... View more

It looks like the Password Policies on these two servers were defaulted to "Minimum password length   0 characters".  I kept trying longer and longer passwords but even out at 20 characters,  I would get a "password too short" error.  When I changed this minimum password length to something other than 0,  like 8,  I could set user passwords successfully and still leave the option "Password must meet complexity requirements" enabled.  ... View more

Yes, should have listened to you. But why didn't my test of turning windows firewall off for incoming and outgoing correct the problem? ... View more

After all that, I think I got it fixed.  I started to look into why I couldn't make a connection with SSMS either.  I found some directions that port 1433 had to be open on the SQL server machine.  I made a new firewall rule on my SQL Server machine for port 1433 incoming.  Finally client machines can create a database connection with ArcCatalog. I don't know why taking the Windows firewall down for incoming and outgoing temporarily didn't work.  Got mislead by that test. ... View more

Yes, it appears ESRI Tech support for enterprise geodatabases is backed up.  I got a response from BIA's OTSGS that I was assigned a ticket number early in April.  ... View more