POST
|
No I haven't even tried setting this up yet because I wanted to get opinions from folks who have actually gone through it before. What is theoretically possible and what is advisable are often not the same. But in the end this discussion has been overtaken by events. I've just been informed that my organization is phasing out Oracle as its primary RDMS platform and moving towards SQL Server. So it looks like I'll be replicating SQL Server to SQL Server anyhow. Thanks for your reply.
... View more
08-16-2017
07:25 AM
|
0
|
1
|
553
|
POST
|
According to Esri documentation, geodatbaase replication is RDBMS agnostic, meaning that theoretically there is nothing to prevent one from successfully implementing geodatabase replication between Oracle and SQL Server. "Geodatabase replication is built on top of the versioning environment and supports the full geodatabase data model including topologies, networks, terrains, relationships, and so forth. In this asynchronous model, the replication is loosely coupled, meaning that each replicated geodatabase can work independently, and all changes can still be synchronized. Since it is implemented at the geodatabase level, the DBMSs involved can be different. For example, one replica geodatabase could be built on top of SQL Server, and the other can be built on top of Oracle." Has anyone in the community successfully set this up? If so do you have any advice for someone how is considering going down this road?
... View more
08-14-2017
03:40 PM
|
0
|
4
|
940
|
POST
|
This issue has been recorded as a bug. There is no fix for it. I spoke with tech support who basically said that I should keep un-sharing and re-sharing the feature service with the Open Data group, as others have done or simply waiting for up to a day for it to eventually show up. I find this to be an unacceptable. This is probably the most important step in making the Open Data site actually usable and it's buggy. This should be at the top of their list of AGO Open Data bugs. I put in a request to escalate this and encourage others to do the same. Here is the response I got from tech support with the bug number: I'm very sorry for the inconvenience of this issue we discussed which I believe is related to a known bug (see below). In my experience, de-sharing the services and re-sharing to the group has helped as well as waiting a day. I haven't yet tried re-publishing, but that could be an option as well. [BUG-000082415 : New feature services added to an Open Data group takes a very long time to display (sometimes do not display) on an Open Data site, and if they do, they show 0 attributes.] Please also find the blog below which details how to escalate a bug. How To Escalate A Bug http://blogs.esri.com/esri/supportcenter/2012/09/05/how-to-escalate-a-bug/
... View more
01-27-2015
04:24 PM
|
0
|
1
|
1330
|
POST
|
And to add that. We did install the ArcSDE 10 library on the remote Windows server.
... View more
08-05-2011
12:56 PM
|
0
|
0
|
299
|
POST
|
I can successfully kill sde processes when I issue the command on the SDE server itself, but from a remote box, the same command with the correct password generates an invalid DBA password error. What gives?
... View more
08-05-2011
11:44 AM
|
0
|
4
|
1886
|
POST
|
Somewhat related to this thread I'm trying to set my SDEHOME variable but unfortunatley SDEHOME is in Program Files directory and it looks like the space is causing the trouble. E:\Program Files\ArcGIS\ArcSDE\ora11gexe What are my options here?
... View more
04-19-2011
08:40 AM
|
0
|
0
|
713
|
POST
|
Did you change the UNICODE_STRING in the dbtune.sde file or in SDE.DBTUNE? (Or both, by running 'sdedbtune -o import'?) - V I used sdedbtune -o insert, not import. Should I have run import as well?
... View more
04-08-2011
01:26 PM
|
0
|
0
|
390
|
POST
|
An 'sdeimport' *also* maps SE_STRING_TYPE to NVARCHAR2? That's bizarre. How is your character set defined? As SYSTEM: SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET'; and/or SELECT * FROM NLS_DATABASE_PARAMETERS; Did you change the UNICODE_STRING in the dbtune.sde file or in SDE.DBTUNE? (Or both, by running 'sdedbtune -o import'?) - V I just ran some sdeimports from my dev to test environment and the column defs are holding where they should be. My problem was from legacy to dev. I'll check on the NLS CHARACTERSET in a bit and revisit this thread. In the meantime, thanks for your help.
... View more
04-08-2011
12:50 PM
|
0
|
0
|
390
|
POST
|
I have this pesky little problem with my SDE instances (running ArcSDE 9.3 with Oracle 11g). Everytime I load a table or feature class into my geodatabase from a shapefile, an sde export file, or from another file or enterprise geodatabase, all of my varchar2 columns automatically are converted to NVARCHAR2 on the load. I asked Vince Angelo about it and he suggested toggling the UNICODE_STRING DBTUNE parameter in DEFAULTS to FALSE. I didn't have this parameter in my DEFAULTS keyword so I added it an set it to FALSE, restarted SDE, but this did not resolve my issue. Any thoughts?
... View more
04-08-2011
11:09 AM
|
0
|
4
|
598
|