Beautiful, thanks.

Note: In addition to your directions, I also had to set "Delay Validation" to true for the pipeline object that led to the Destination object.

The above errors were from the RSPortal log. In the RSManagement log, I see this:

2018-09-19 11:25:02.1936|ERROR|13|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to...

I do use IE. The errors are not UI-based, but are browser agnostic.
In general, 2017 RS seems much more cross-browser compatible than were 2005 and 2008 R2.

Thanks, I got this sorted. Could not use the ? and set parameter because when you use an sql variable as the sql source that option isn't available.

But...

oops, wrong forum, sorry.

I was, by the way, able to update and deploy a datasource from VS2017, and thus change the datasource from one database to another, with success. But cannot access that...

The fix for this was to modify some values in the gateway init.ora file (an Oracle config file)

Particularly, give values to HS_DB_NAME and HS_DB_DOMAIN parameters and then use...

I didn't realize this was under Sql Server 2005. I reposted the question in the 2014 dev area.

Thanks

Thanks, Sue. These are good directions, but they resolve the issue in the context of Oracle to Oracle db link. It is pretty straightforward to obtain or set global names...

Yes - this is the first time we used SQL user on the db in the availability group. I do know how to migrate users to retain SID, just hadn't...

Glad to hear it. I'm not the person who is touching the Confluence set up. It's new here, and I don't know that the application connection string is definitely pointing...

Thanks to all for your responses.

We did focus on MultiSubnetFailovers value, but though issues there provided similar symptoms, our cluster doesn't span multiple subnets, so playing with those values both...

Yes - take a look at "OPENQUERY"

OpenQuery is a function that takes two parameters - the database link name and the query against the remote database. It essentially creates a...

Thanks, Evil Kraig F.

I see your points.

I had thought to avoid some of that by having a column in the main table which would hold the current (i.e. max) history_id...

Thanks for your thoughts. I'm not sure I agree - with proper indices and queries, don't think that getting the current record data from the history table has to be...