Latest Contributions by QuinnMcCarthy

‎07-29-2013

I have a raster FC in a SQL server based GDB that I can't delete. It haust be corrupt because it says that the raster data set is not valid and I cannot delete the raster. What is the best way to do that? thanks Quinn

‎07-24-2013

It is part of a topology. DIdn't even think of that. Thanks Quinn

‎07-24-2013

I have a FC in a in a file GDB that I can't belete. When I use the context menu delete and rename options are grayed out. I tried the delete button the the same thing. I tried getting out of arc catalog and getting back in and still the same problem. I tried rebooting twice and still can't delete. I am not sure what I should try next? thanks Quinn

‎03-14-2013

Sorry about the confusion. We are using a 2 way replica. Both saides are in SDE based sql server 2008 databases. I am using to files GDB to copy features from the file gdb to the child GDB. Then I synchronize the child and all of the features make it through except it doesn't delete the existing feature sin the parent. I have a process I need to do once a month for one of the department. To do that I copy the data sets to a file GDB do the steps to that FC and put it back in the 2 way replica while it is down. I was trying to come up with a way to get the feature from the file GDB into the child and then synchronize the child and have them show up in the parent without any errors. Thanks Quinn

‎03-14-2013

Hi, We have a SQL base 2 way replica. Version 10. Whenever I add data in a certian way the synchronize fails. I was trying to come up with a way to add new data from a file GDB the sychozation fails. I had x features in the FC of the child DB. I deleted those features and added the feature that were in the file GDB. Saved the data. compressed the data and synchronized the replica. Every tiome that I do it this way I get the new features plus the existing features in the parent GDB. Is the way I did that incorrect? Must be because it didn't work. In the past I created the new file GDB and then brought the replica down added the data to both side and rebuilt the replica. It always worked fine but caused downtime for all users. The 911 system is using that replica. Is there a way to do this without bringing the system down? Thanks. Quinm

‎10-29-2012

Thanks Richard and Anthony. I will give them a try. I think Richards answer might be what I am looking for. We will see. Quinn

‎10-26-2012

To make this more clear I need to extract everything to the right of the rihjt most space. Becasue some roads are 1E or 1S. Thanks Quinn

‎10-26-2012

using vb script is there a way to extract the number 1 from a field in the attribute table that has 'County Road 1'? I hope that is not confusing. Thanks much. Quinn Koochiching County MN

‎04-02-2012

jnderose, I was thinking about my problem and using multiversioned views. Can I get by with not using a MV view if I add all of the records from that layer and did a join field in arctoolbox? I have fields that I need to delete first and then do a join field to get the data field I need filled in? Then syncronize and to update the parent. Would you need to do the schema changes first? Thanks Quinn

‎03-26-2012

jnderose, Can MV Views be used in a 2 way replica? Thanks Quinn

‎03-23-2012

Thanks I will look into that. Quinn

‎03-23-2012

So the next time I take the replica down for work can I do it to the parent then and have it work? Or should I just buck up and get to work? Thanks Quinn

‎03-23-2012

I have 400 polygons that need a attribute update and not looking forward to doing it 1 by 1. OUr data is based in SQL Server 2008 and I am wondering if anybody uses SQL update command to update FC? I need to update the GIS fc from data in another table. So I am looking at something like this. update VectorReplica.dbo.PARCELS set PARCEL_ID = new_pid from Ranieranneaxparcels where VectorReplica.dbo.PARCELS.PARCEL_ID = Ranieranneaxparcels.NEW_PID I have done some updates on small basis but nothing like this. I am working on the child of the replica with a file GDB backup too for safety reasons. Thanks Quinn

Re: SDE user password. · ‎03-14-2012

Thanks eryan. I will give that a try.

Re: SDE user password. · ‎03-13-2012

Vince, We are on windows server 2008 SP2 and SQLserver 2008 sp2 How do you get to the service startup utility? Thanks Quinn

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by QuinnMcCarthy

Can't delete raster FC from gdb

Re: Can't delete a featureclass in file GDB

Can't delete a featureclass in file GDB

Re: Replica practice question

Replica practice question

Re: Label expression formula question

Re: Label expression formula question

Label expression formula question

Re: Using SQL update to update featureclass

Re: Using SQL update to update featureclass

Re: Using SQL update to update featureclass

Re: Using SQL update to update featureclass

Using SQL update to update featureclass

Re: SDE user password.

Re: SDE user password.