|
POST
|
Also, if you are indeed using SQL Server Express Edition, make sure that it is 64-Bit as 32-Bit databases are not supported at 10.1.
... View more
12-16-2013
09:44 AM
|
0
|
0
|
3596
|
|
POST
|
To add a lil more......the information that I provided is mentioned in the below ESRI Web Help as well: Create Replica (Data Management): http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000016000000 Under Usage, the 7th point discusses about tables while creating replica.
... View more
12-03-2013
02:07 PM
|
0
|
0
|
2299
|
|
POST
|
Dan, Are you working with ArcSDE Personal or ArcSDE Workgroup? Have you enabled the SQL Server Express instance, if you are using any one of the above? On the database server, is the Firewall turned on? If yes, does turning-off the Firewall allow you to connect w/o using the port # ? 1433 and 1434 are the port # used by SQL Server. Try adding them to exceptions on the Database Server, if the firewall is the issue.
... View more
12-03-2013
12:57 PM
|
0
|
0
|
2020
|
|
POST
|
Jamal, Yes, that's true. The second part of my initial post helps in that regard. Also, here is another Forum discussion which you can have a look at: http://forums.arcgis.com/threads/48195-Create-Replica-on-SDE-Table?p=166604#post166604
... View more
12-03-2013
12:51 PM
|
0
|
0
|
2299
|
|
POST
|
Jamal, The "Create Replica" option in the Distributed Geodatabase toolbar is not specifically for tables and is used to replicate Spatial data as well. I'm not quite sure why you are unable to use that. An overview of the Distributed Geodatabase toolset: http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000013000000 The above link mentions that the "Create Replica" tool.. Creates a replica to a personal, file, or SDE geodatabase from a specified list of feature classes, layers, datasets, and/or tables in an ArcSDE geodatabase. Also, here is another Forum discussion which you can have a look at: http://forums.arcgis.com/threads/48195-Create-Replica-on-SDE-Table?p=166604#post166604
... View more
12-02-2013
10:47 AM
|
0
|
0
|
2299
|
|
POST
|
While creating the connection in Desktop 10.2, did you use the syntax "sde: oracle11g:TNSNAME" ? If yes, just try creating the connection with "TNSNAME" in the Instance parameter. http://support.esri.com/en/bugs/nimbus/TklNMDg0OTg3 Regards,
... View more
11-25-2013
12:17 PM
|
0
|
0
|
1231
|
|
POST
|
Adding more to what Vince already mentioned, you were actually hitting a known Bug: NIM096131: Joining a table or a feature class through a field from another joined feature class or table returns ORA-25156 when the geometry storage SDELOB is used. http://support.esri.com/en/bugs/nimbus/TklNMDk2MTMx Glad you found the workaround!! Enjoy the weekend ahead!
... View more
11-22-2013
05:30 PM
|
0
|
0
|
821
|
|
POST
|
Will, I tried the whole process using ArcMap tools and it works as expected. sde 10.2 (oracle 11.2.0.1) Desktop 10.2 My Workflow: 1. Copy the TESTFC and TESTTABLE into the sde 10.2 oracle gdb 2. Register the data as versioned 3. Add both the fc and table to ArcMap. 4. Use the "Make Feature Layer" tool for the testfc layer --> resulting layer is testfc_layer 5. Get Count--> 3 6. Use "Add Join" management tool and create a join b/w testfc_layer and testable based on the 'JOINFIELD'--> Joins successfully 7. Get Count--> 3 For testing sake, I also tested the same tools in ArcCatalog via Model Builder and Script (have attached my script and model) Let me know if you were mentioning the same steps or I'm missing something. Regards,
... View more
11-21-2013
04:22 PM
|
0
|
0
|
2975
|
|
POST
|
Vasil, The issue is occurring because of an older version of SQL Server Native Client installed on that machine. Below is a link for Microsoft® SQL Server® 2008 R2 Feature Pack: http://www.microsoft.com/en-in/download/details.aspx?id=16978 --> Open the above link --> Expand Install Instructions --> Look for "Microsoft® SQL Server® 2008 R2 Native Client" --> If the Operating System of your Desktop machine is 32-Bit, download "X86 Package (sqlncli.msi)" & If the Operating System of your Desktop machine is 64-Bit, download "X64 Package (sqlncli.msi)" --> Install the setup and then try connecting from Desktop Regards,
... View more
11-21-2013
07:08 AM
|
0
|
0
|
485
|
|
POST
|
Hugo, It seems that this is what you are observing: [#NIM088600 Message displayed with a 10.1 ArcGIS Desktop's upgrade dialog is incorrect when connected to ArcSDE database on a 32 bit database architecture since it states that the database is at its newest release. ] http://support.esri.com/en/bugs/nimbus/TklNMDg4NjAw The above NIM was logged for Oracle and Desktop 10.1, but it may be true for Desktop 10.2 and 32-Bit SQL Server as well. Regards,
... View more
11-15-2013
08:06 AM
|
0
|
4
|
3232
|
|
POST
|
Marco, I didn't give those links as solution/workaround for the behavior...those are just for reference.. Regards,
... View more
11-14-2013
10:06 AM
|
0
|
0
|
793
|
|
POST
|
The behavior that you were observing is actually correct!! When Joe resourced the MXD, he must have used his connection (connected as user 'Joe')....the MXD stores this user information along with other connection parameters... The correct way would be for each user to create their own connections with their username/password and then resource their individual MXDs to point to these new connections (which I guess you already figured out). Regards,
... View more
11-14-2013
10:02 AM
|
0
|
0
|
4247
|
|
POST
|
Chad, The behavior you are observing is by design. The below article mentions Feature Datasets, but that seems to be true for Relationship classes as well: http://support.esri.com/es/knowledgebase/techarticles/detail/22721 You can have a look at the below scripts though: �?� http://arcscripts.esri.com/details.asp?dbid=13428 �?� http://arcscripts.esri.com/details.asp?dbid=13886 Regards,
... View more
11-13-2013
06:27 PM
|
0
|
0
|
793
|
|
POST
|
This should work for you: https://customers.esri.com/index.cfm?event=pub.ecpAuthorizations Regards,
... View more
11-08-2013
12:42 PM
|
0
|
0
|
2483
|
|
POST
|
Nathalie, As mentioned in the links: Geodatabase replication allows you to create copies of data across two or more geodatabases such that changes to the data may be synchronized. Replicas and geodatabases: http://resources.arcgis.com/en/help/main/10.1/index.html#//003n000000vp000000 We need atleast two geodatabases for this functionality. Regards,
... View more
11-07-2013
09:10 AM
|
0
|
0
|
792
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 09-14-2015 09:19 AM | |
| 1 | 06-17-2013 11:43 AM | |
| 3 | 03-21-2014 08:24 AM | |
| 1 | 03-22-2016 03:04 PM | |
| 1 | 09-29-2015 09:47 AM |
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:23 AM
|