POST
|
Hello, I am trying to solve an issue for one of my customers. We have a legacy desktop application VB.NET that is only getting bug fixes & ArcGIS Engine Runtime updates at the current time. In our 1.01 version they are receiving an error when they perform an address search for the first time. All subsequent searches work correctly. The full error is below. The only references I can find to the specific error are for ArcMap & ArcCatalog, but this machine has neither. It only has our software installed on it right now. I have tried to repair the Engine Runtime, reinstall the Engine Runtime, repair all the Visual C++ runtimes, run sfc.exe /scannow to see if it detects anything, use procmon to see if it comes up with anything and so far I have not come up with a solution. Any suggestions on what to try next? [ATTACH=CONFIG]27763[/ATTACH]
... View more
09-25-2013
01:29 PM
|
0
|
0
|
361
|
POST
|
UseAcceleratedDisplay = false solved the unmanaged memory leak for me. Ok, I have more work to do then, I already have UseAcceleratedDisplay set to false. I am able to work around the memory leak some by changing the way I get the Tile URLs so that should be good enough for now.
... View more
05-30-2013
10:42 AM
|
0
|
0
|
356
|
POST
|
In my usage, the AcceleratedDisplay leaks unmanaged memory at a very high rate when automated operations occur on it at a high rate (i.e. a DispatcherTimer doing something to the map or layers therein every n milliseconds). Disabling the AcceleratedDisplay solved this issue for me. Are you talking about the UseAcceleratedDisplay property or the AcceleratedDisplay property on the map control? I already have UseAcceleratedDisplay set to false.
... View more
05-30-2013
04:53 AM
|
0
|
0
|
356
|
POST
|
I have a WPF application using the Runtime SDK that is suffering from a major memory leak. My app is designed to automatically pan & zoom around the map, use the tileloading event to get the URL for an ArcGIS Server map tile, and download it using a standard .NET WebClient through a proxy server. However, even when I disable all my logic and manually pan & zoom the map control I still see a memory leak. Is this a known issue with the Runtime SDK for WPF? Another project where I work uses the Runtime SDK and they are also experiencing a memory leak when panning & zooming, just not as fast as they are not automating it.
... View more
05-29-2013
12:55 PM
|
0
|
4
|
2465
|
POST
|
Just a quick update on this. It also appears that STATUS as a field name causes an issue. Removing the STATUS field from address_location & fire_hydrants fixes the following "Error: Invalid SQL syntax (-42)."
... View more
04-17-2012
08:38 AM
|
0
|
0
|
157
|
POST
|
Shawn, Per your original post; I am able to reproduce your experience, on 10.0 sde for postgres, I am not able to create a mv view, with the table definitions given in your post. The issue is not reproducable in 10.1. It is up to you if you want to pursue this to be fixed for 10 sp5 or will you be migrating to 10.1? Most Sincerely, Kasia Tuszynska ArcSDE Product Engineer Kasia, My understanding is that we will be migrating to 10.1 but I am not sure on the time frame. I believe it will be after we have released the product I was creating the views for. However, the views were just a means to an end for extracting the deltas out of a SDE. Using the views I was able to create, I figured out how to extract the views out using Npgsql & C# so I do not see the need to pursue it for 10.0 SP5 at this time.
... View more
03-19-2012
12:56 PM
|
0
|
0
|
911
|
POST
|
You will need to set the version to query. For example, execute the following first: SELECT sde.sde_set_current_version('VECTOR.Version1'); This will set the version to a versioned named 'Version1'. Then you will be able to query the edits that exist in the version. Here is some more info: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/in_PostgreSQL/006z0000001q000000/ That did it, and now I feel stupid.
... View more
03-15-2012
10:31 AM
|
0
|
0
|
911
|
POST
|
Looks like the problem lies with the fields of type 'timestamp'. I ran a quick test and added a field called 'Date_Modified' of type 'timestamp' to the feature class. I registered the feature class as versioned and then attempted to create the multiversion view. I received a similar error within my log file: Unable to create IMV insert trigger for view airports_mv for table VECTOR.AIRPORTS I then deleted the timestamp field and was able to successfully create the multiversion view. You may want to consider logging a tech support incident regarding this matter to see if there is a workaround. I will do that. Of course, I just ran into another issue. Trying to select the data from one of the views I have created only returns the original records and nothing I've added or deleted. Only if I copy & paste the view creation query using pgAdmin III and modify it to not include the last WHERE NOT EXISTS clause do I get the new records. Any ideas on that? Basically SELECT b.objectid, b.source, b.user_id, b.date_modified, b.versionname, b.cnty_unique_id, b.county_name, b.county_fips, b.globalid, b.objectid - b.objectid AS sde_state_id, b.shape
FROM county b
WHERE NOT (EXISTS ( SELECT d.sde_deletes_row_id, d.sde_state_id
FROM d16 d
WHERE d.sde_state_id = 0 AND sde_in_current_lineage(d.deleted_at::integer::bigint) = true AND b.objectid = d.sde_deletes_row_id AND d.sde_state_id = 0))
UNION ALL
SELECT a.objectid, a.source, a.user_id, a.date_modified, a.versionname, a.cnty_unique_id, a.county_name, a.county_fips, a.globalid, a.sde_state_id, a.shape
FROM a16 a
WHERE NOT (EXISTS ( SELECT d.sde_deletes_row_id, d.sde_state_id
FROM d16 d
WHERE sde_in_current_lineage(d.deleted_at::integer::bigint) = true AND a.objectid = d.sde_deletes_row_id AND a.sde_state_id = d.sde_state_id AND sde_in_current_lineage(a.sde_state_id::integer::bigint) = true)) AND sde_in_current_lineage(a.sde_state_id::integer::bigint) = true; does not work but SELECT b.objectid, b.source, b.user_id, b.date_modified, b.versionname, b.cnty_unique_id, b.county_name, b.county_fips, b.globalid, b.objectid - b.objectid AS sde_state_id, b.shape
FROM county b
WHERE NOT (EXISTS ( SELECT d.sde_deletes_row_id, d.sde_state_id
FROM d16 d
WHERE d.sde_state_id = 0 AND sde_in_current_lineage(d.deleted_at::integer::bigint) = true AND b.objectid = d.sde_deletes_row_id AND d.sde_state_id = 0))
UNION ALL
SELECT a.objectid, a.source, a.user_id, a.date_modified, a.versionname, a.cnty_unique_id, a.county_name, a.county_fips, a.globalid, a.sde_state_id, a.shape
FROM a16 a; does work.
... View more
03-15-2012
10:19 AM
|
0
|
0
|
911
|
POST
|
address_location is as follows
objectid integer NOT NULL,
source character varying(35),
user_id character varying(35),
date_modified timestamp without time zone,
versionname character varying(74),
site_unique_id character varying(74),
add_number integer,
add_pre character varying(2),
add_name character varying(35),
add_type character varying(4),
add_suf character varying(2),
add_fullname character varying(75),
add_building character varying(35),
add_unit character varying(12),
add_floor integer,
add_room character varying(35),
add_seat character varying(35),
add_loc_notes character varying(74),
supp_info character varying(255),
lastname character varying(52),
firstname character varying(52),
areacode integer,
phone character varying(15),
p_sub character varying(255),
p_block character varying(255),
p_lot character varying(255),
mail_add character varying(75),
mail_city character varying(30),
mail_state character varying(2),
mail_zip integer,
add_hist_a character varying(75),
rr_add character varying(75),
alias_add character varying(75),
address_class integer,
stru_type character varying(35),
stru_mat1 character varying(35),
stru_mat2 character varying(35),
stru_color1 character varying(35),
stru_color2 character varying(35),
stru_height smallint,
stru_fence character varying(42),
stru_notes1 character varying(255),
stru_notes2 character varying(255),
date_create timestamp without time zone,
zip5 integer,
exchange character varying(35),
telco character varying(15),
msag_comm character varying(35),
comm_name character varying(35),
postal_comm character varying(35),
esn smallint,
mapgrid character varying(5),
prec character varying(5),
vote character varying(5),
collect_method character varying(35),
geocode_level character varying(35),
parcel_uid character varying(38),
segment_uid character varying(38) DEFAULT '{00000000-0000-0000-0000-000000000000}'::character varying,
c1_exception integer,
status character varying(35),
globalid character varying(38) NOT NULL DEFAULT '{00000000-0000-0000-0000-000000000000}'::character varying,
shape geometry
fire_hydrants is as follows objectid integer NOT NULL,
source character varying(35),
user_id character varying(35),
date_modified timestamp without time zone,
versionname character varying(74),
hydrant_unique_id character varying(74),
notes character varying(255),
psi integer,
maintenance_date timestamp without time zone,
status character varying(35),
globalid character varying(38) NOT NULL DEFAULT '{00000000-0000-0000-0000-000000000000}'::character varying,
shape geometry
Neither is showing any reserved names being used as a field name.
... View more
03-15-2012
09:45 AM
|
0
|
0
|
911
|
POST
|
I have a PostgreSQL + PostGIS ArcSDE (PostgreSQL 8.4 & ArcSDE 10.0) that I need to create mv_views in. I'm able to create 16 of the 18 I need just fine. For the first feature class I use the following command sdetable -o create_mv_view -T address_location_mv -t address_location -i sde:postgresql:192.168.7.24 -D staging -u sde -p ******* -s 192.168.7.24 and I get the following as CLI output ArcSDE 10.0 for PostgreSQL Build 1343 Thu Feb 17 11:45:42 2011
Attribute Administration Utility
-----------------------------------------------------
Error: Invalid SQL syntax (-42).
Error: Unable to create MV view address_location_mv for table address_location. For the second table I use the following command sdetable -o create_mv_view -T fire_hydrants_mv -t fire_hydrants -i sde:postgresql:192.168.7.24 -D staging -u sde -p ******* -s 192.168.7.24 and I get the following as CLI output ArcSDE 10.0 for PostgreSQL Build 1343 Thu Feb 17 11:45:42 2011
Attribute Administration Utility
-----------------------------------------------------
Error: Invalid SQL syntax (-42).
Error: Unable to create MV view fire_hydrants_mv for table fire_hydrants. My C:\Program Files (x86)\ArcGIS\ArcSDE\pgexe\etc\sdedc_PostgreSQL.log file contains the following for the two commands above SHOW SEARCH_PATH = '"$user", public, sde'
Instance initialized . . .
[Thu Mar 15 10:49:07 2012] [56] [PROV-MASTER] ev.SQLstate = 42601
SDE DBMS Error: -42 ERROR: syntax error at or near "$1"
LINE 1: ...de_level, parcel_uid, segment_uid, c1_exception, $1 , globa...
^
QUERY: INSERT INTO staging.sde.a20(objectid, source, user_id, date_modified, versionname, site_unique_id, add_number, add_pre, add_name, add_type, add_suf, add_fullname, add_building, add_unit, add_floor, add_room, add_seat, add_loc_notes, supp_info, lastname, firstname, areacode, phone, p_sub, p_block, p_lot, mail_add, mail_city, mail_state, mail_zip, add_hist_a, rr_add, alias_add, address_class, stru_type, stru_mat1, stru_mat2, stru_color1, stru_color2, stru_height, stru_fence, stru_notes1, stru_notes2, date_create, zip5, exchange, telco, msag_comm, comm_name, postal_comm, esn, mapgrid, prec, vote, collect_method, geocode_level, parcel_uid, segment_uid, c1_exception, $1 , globalid, sde_state_id, shape) VALUES ((Select (Base_ID) From staging.sde.i20), $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 , $13 , $14 , $15 , $16 , $17 , $18 , $19 , $20 , $21 , $22 , $23 , $24 , $25 , $26 , $27 , $28 , $29 , $30 , $31 , $32 , $33 , $34 , $35 , $36 , $37 , $38 , $39 , $40 , $41 , $42 , $43 , $44 , $45 , $46 , $47 , $48 , $49 , $50 , $51 , $52 , $53 , $54 , $55 , $56 , $57 , $58 , $59 , $60 , $61 , staging.sde.SDE_get_current_state(), $62 )
CONTEXT: SQL statement in PL/PgSQL function "v20_insert" near line 8
[Thu Mar 15 10:49:07 2012] [56] [PROV-MASTER] Unable to create IMV insert rule function for view address_location_mv for table sde.address_location[Thu Mar 15 10:49:08 2012] [56] [PROV-MASTER] In DB_instance_close...
[Thu Mar 15 10:49:08 2012] [56] [PROV-MASTER]
Describe Cache...
[Thu Mar 15 10:49:08 2012] [56] [PROV-MASTER]
Cache Size............................. 200
[Thu Mar 15 10:49:08 2012] [56] [PROV-MASTER]
Number of Table Objects Cached (0)
[Thu Mar 15 10:49:08 2012] [56] [PROV-MASTER]
Number of Selects Cached (0)
[Thu Mar 15 10:49:08 2012] [56] [PROV-MASTER]
Number of Joins Cached (DBMS-described) (0)
[Thu Mar 15 10:49:08 2012] [56] [PROV-MASTER]
Cached Cached
Hits Statements
---------------------
[Thu Mar 15 10:49:08 2012] [56] [PROV-MASTER]
[Thu Mar 15 10:49:08 2012] [56] [PROV-MASTER] SELECT's DBMS Described: [0][0]
SHOW SEARCH_PATH = '"$user", public, sde'
Instance initialized . . .
[Thu Mar 15 10:50:40 2012] [57] [PROV-MASTER] ev.SQLstate = 42601
SDE DBMS Error: -42 ERROR: syntax error at or near "$1"
LINE 1: ...hydrant_unique_id, notes, psi, maintenance_date, $1 , globa...
^
QUERY: INSERT INTO staging.sde.a11(objectid, source, user_id, date_modified, versionname, hydrant_unique_id, notes, psi, maintenance_date, $1 , globalid, sde_state_id, shape) VALUES ((Select (Base_ID) From staging.sde.i11), $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , staging.sde.SDE_get_current_state(), $12 )
CONTEXT: SQL statement in PL/PgSQL function "v11_insert" near line 8
[Thu Mar 15 10:50:40 2012] [57] [PROV-MASTER] Unable to create IMV insert rule function for view fire_hydrants_mv for table sde.fire_hydrants[Thu Mar 15 10:50:40 2012] [57] [PROV-MASTER] In DB_instance_close...
[Thu Mar 15 10:50:40 2012] [57] [PROV-MASTER]
Describe Cache...
[Thu Mar 15 10:50:40 2012] [57] [PROV-MASTER]
Cache Size............................. 200
[Thu Mar 15 10:50:40 2012] [57] [PROV-MASTER]
Number of Table Objects Cached (0)
[Thu Mar 15 10:50:40 2012] [57] [PROV-MASTER]
Number of Selects Cached (0)
[Thu Mar 15 10:50:40 2012] [57] [PROV-MASTER]
Number of Joins Cached (DBMS-described) (0)
[Thu Mar 15 10:50:40 2012] [57] [PROV-MASTER]
Cached Cached
Hits Statements
---------------------
[Thu Mar 15 10:50:40 2012] [57] [PROV-MASTER]
[Thu Mar 15 10:50:40 2012] [57] [PROV-MASTER] SELECT's DBMS Described: [0][0] Does anyone have some suggestions on what I can try to get these views created?
... View more
03-15-2012
07:51 AM
|
0
|
10
|
2010
|
POST
|
That is just what I need. Thank you. And I'm glad my search fu is failing me 😞
... View more
05-25-2010
10:00 AM
|
0
|
0
|
256
|
POST
|
Hi, I'm wondering if its possible (and my searches didn't turn up directions on how) to replicate a SDE from one server to "n" servers. Basically, I need to replicate data from an admin servers to the servers that actually process the requests from clients. The data changes on the admin server will be occuring from a web app, so it would be best if it could be done automatically, but running a python script from a button on the app would be fine.
... View more
05-25-2010
08:53 AM
|
0
|
3
|
388
|
POST
|
Ok, I am able to easily store my data using the PG_GEOMETRY type if I am using PostgresSQL on Windows. However, we are looking into using linux (specifically RHEL) for one of our projects so I am trying ot store my data using the PG_GEOMETRY type with linux as the server OS (CentOS 5.4 as we do not currently have a license of RHEL). I am able to get the data into the SDE with ArcCatalog, but when I do a select on the data it looks nothing like it does on the Windows DB. Does anyone have a clue what I need to do to get this working right? I have wiped and reloaded the server 4 times to try and get this working.
... View more
04-21-2010
11:56 AM
|
0
|
3
|
421
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|