If you’re running macOS, try opening the TIFF in Apple Preview. If that works, you can export to a file format that Photoshop will open (you can drag and drop to the Desktop or a folder as well). If the TiFF has layers, I have found drag and drop to be the quickest way to get the them into PS.
I am getting the same error.
I have just created 3 HDR images using Photoshop's Merge to HDR Pro feature and saved them as 32-bit TIFFs.
The first one opens OK, but the other 2 give the error "Could not complete the request because it is not the right kind of document."
Photoshop CS6 on Windows 7-64
With tif extension these will open in CS4 and earlier, but not in CC.
Here is the file report from the header...
Output from Display Header
File Name: D:\NAME001.tif
Standard : : TIFF File
Format : : JPEG Compressed 24 bit RGB data, Q= 10
Pixels per Line : 20000
Number of Lines : 20000
Samples per pixel : 4
File bits per sample : 8
Actual bits per sample : 8
Tiled file, tile dimension : 128
Number of tiles along a row : 157
Number of tile rows : 157
Number of overviews : 10
Overview sampling method: Subsampled
Scanning device resolution : 2032 : lines/inch
Orientation : 4 : Row major order, origin at top left
NO scan line headers : non-scannable file
Packet size (16-bit words) : 0
Free vlt space (16-bit words) : 2000000000
Free packet space (16-bit words) : 2000000000
Raster to UOR matrix:
Unspecified or All Zero Matrix
They were generated by a microfilm scanner.
I tried opening them in preview, dragging and dropping them into photoshop and copying the file and changing the extension to .JPG. The file size of each of these files is big enough that I would expect a good file to be there.
I don't know what else to try. They were made on a library's microfilm reader and to return to do it again would be a 3-1/2 hour drive.
I'm hoping someone has a suggestion.
Here is a list of TIF files that Photoshop can and cannot read in my tests. The original image is 19200 x 25200 px 8-bit = 1.35 gb uncompressed.
Photoshop CAN read:
ACDSee uncompressed, FastStone LZW, FastStone uncompressed, Gigapixel uncompressed, Photoshop LZW, Photoshop uncompressed, Photoshop ZIP
Photoshop CANNOT read:
ACDSee LZW, ACDSee ZIP, FastStone ZIP, Gigapixel LZW, Gigapixel ZIP
ACDSee and Topaz Gigapixel maybe use the same libraries to create their files, their respective files sizes also match closely.
FastStone Image Viewer has similar problems, albeit partly with different combinations of file source and compression. All these files can be read by various other third party software, like IrfanView, XnViewMp, Paint.Net, ACDSee, Windows Photos and Windows Photo Viewer!
Adobe's support chat is no help and the "wishlist" (feature requests and bug reports) page forwards to this "community" powered support. I have yet to find a support form/ticket system to report the problem, any hint is welcome.