Latest Contributions by PramodHarithsa1

‎02-26-2016

I have seen multiple questions on GPS connectivity, Windows Location sensor and ArcGIS for windows(10.2.1) but couldn't get a proper resolution. I am currently testing ArcGIS for Windows Application on a FZ-G1 Panasonic tablet (Windows 8.1 OS) and I am unable to get the GPS working with ArcGIS application. The device I have doesn't have a dedicated GPS sensor. I am utilising the GPS element attached with the 4G Gobi 5000 modem. I figured out ArcGIS for Windows doesn't work with Windows Location API. I tried with GPSReverse as suggested by others in different thread. GPSComplete: GPSDirect,GPSReverse, LocationFixer GPS NMEA Windows 7 Windows 8 Windows 10 Sensor Driver iOS Android TCP B… But can't get it working (It returns 0,0) any leads here? <Update> I was going through this blog post on using Location Platform, ArcGIS for Mobile: ArcGIS Mobile 10.2 and the Windows Sensor and Location Platform Is there a plan to release an extension that works with AGM 10.2.1 . Can anyone from ESRI answer this.

‎01-28-2016

Hi Martin Ameskamp , The DB is Oracle 11g, I had tried my luck with pragma autonomous_transaction earlier, though it solves the mutation table issue when checking the SDE.DEFAULT lineage after insert, it really doesn't help as the post operation is not complete yet. I would probably need an "On Commit" trigger (Which doesn't exist!) I could get this working on some of the ArcFM features by comparing the STATE_ID with that existing in Versions table, but it doesn't seem to work on non-ArcFM features where the edits have not been commited when the After INSERT/UPDATE Trigger is invoked. I had used the below query to get the STATE_ID currently part of the SDE.DEFAULT lineage and compare it with the STATE_ID of the edit to check if the edit was posted. (Not sure if there is an optimised way of doing this) SELECT SDE_STATE_ID FROM ADMIN.AREA b, (SELECT SDE_DELETES_ROW_ID,SDE_STATE_ID FROM ADMIN.D2370 WHERE SDE_STATE_ID = 0 AND SDE.version_util.in_current_lineage (DELETED_AT) > 0) d WHERE b.OBJECTID = d.SDE_DELETES_ROW_ID(+) AND d.SDE_STATE_ID IS NULL AND SDE.version_util.get_lineage_list > 0 UNION ALL SELECT a.SDE_STATE_ID FROM ADMIN.A2370 a,(SELECT SDE_DELETES_ROW_ID,SDE_STATE_ID FROM ADMIN.D2370 WHERE SDE.version_util.in_current_lineage (DELETED_AT) > 0) d WHERE a.OBJECTID = d.SDE_DELETES_ROW_ID(+) AND a.SDE_STATE_ID = d.SDE_STATE_ID(+) AND SDE.version_util.in_current_lineage (a.SDE_STATE_ID) > 0 AND d.SDE_STATE_ID IS NULL AND a.OBJECTID=:new.OBJECTID;

‎01-27-2016

Hi Jake Skinner , I was able to get the record from VERSIONS table using the below query, select count(*) INTO isPost from sde.versions where STATE_ID=:new.SDE_STATE_ID; But there seems to be a delay between the AFTER A table update/insert and the VERSIONS table modification so I am not able to capture the post event. Is there any better way to do this?

‎01-27-2016

Thanks Jake Skinner for the reply. I am actually setting up a trigger on A table to pass data into a different system (non GIS) and I want to consider entries only when they are posted. So all I get to see here is the user who is doing the editing and the SDE_STATE_ID. Are there any tables I can refer using these two values to confirm whether the edit has been posted much like the way its shown in version changes window.

‎01-27-2016

Hi All, Is there a way we can find from the SDE_STATE_ID of A Table whether the edit has been posted to database. (I am currently interested only in Adds) I was trying to look through the multi-version views to keep an eye on this, but I can't as the views are looking back into the same A table and it would result in a mutation table error.

‎01-14-2016

Hi All, I was looking for a way to capture data edits on versioned database to update a non-gis system. (DB Oracle 11G) What I have done so far? I have created after insert or update trigger on the Add table of the featureclass, it checks if the edit is posted, if posted - then the updates are inserted into a temp table (from where its transferred to the other system) create or replace TRIGGER "ADMIN"."TEST_TRG" AFTER INSERT OR UPDATE OF STATE ON A3401 FOR EACH ROW DECLARE isPost NUMBER; BEGIN SELECT COUNT(*) INTO isPost FROM SDE.STATES WHERE SDE.STATES.STATE_ID=:new.SDE_STATE_ID AND SDE.STATES.LINEAGE_NAME=SDE.STATES.STATE_ID; IF INSERTING AND (isPost > 0) AND (:new.STATE=0 OR :new.STATE is NULL) THEN INSERT INTO TEST_TRIGGER (OBJECTID,LOCATION,ID,STATE,TYPE) VALUES ( :new.OBJECTID,:new.LOCATION,:new.ID,'NEW','UPDATED'); ELSE IF UPDATING('STATE') AND (:new.STATE=0) AND (:old.STATE=1) AND (isPost > 0) ) THEN INSERT INTO TEST_TRIGGER (OBJECTID,LOCATION,ID,STATE,TYPE) VALUES ( :new.OBJECTID,:new.LOCATION,:new.ID,'NEW','CREATED'); ELSE null; END IF; END IF; END; The problem I have here is, I want to capture the update only if they are done on specific columns. When the edits are posted, its always an insert and I won't be able to figure out what its previous value was. I tried writing a before insert trigger and compare with the value from Multi-versioned view but that runs into mutating table problem. [Note: The above script is not optimized, I am just trying to check the possibility of capturing the edit] Possibly I am doing something wrong here or there is a better way to achieve this. Request help!

‎01-11-2016

Hi Christian Wells does the details I provided give out any hint?

‎01-06-2016

Hi Christian Wells , Product Version: 10.2.1.3497 No Patch Installed. I have attached a sample XML Schema Dump. Its a ArcFM Feature. Polygon Geometry. The trigger has the date format: to_date('9999/12/31 23:59:59 6:365','YYYY/MM/DD HH24:MI:SS D:DDD') This is the exact error Message: Error report - SQL Error: ORA-01835: day of week conflicts with Julian date ORA-06512: at "ADMIN.V3805_UPDATE", line 1 ORA-04088: error during execution of trigger 'ADMIN.V3805_UPDATE' 01835. 00000 - "day of week conflicts with Julian date" *Cause: *Action:

‎01-06-2016

Hi All, The "Instead of" triggers created on Multi - version views for Updating, Inserting and Deleting records have an issue with the date field. An update or insert command executed using the views throws the below error, ORA-01835: day of week conflicts with Julian date ORA-06512: at "ADMIN.V2356_UPDATE", line 1 ORA-04088: error during execution of trigger 'ADMIN.V2356_UPDATE' ORA-02063: preceding 3 lines from ARCGIS The date format used in these triggers doesn't comply with the format defined in the feature class. The trigger uses the format: 9999/12/31 23:59:59 6:365','YYYY/MM/DD HH24:MI:SS D:DDD as against the format defined for the feature class 31/12/9999 23:59:59','DD/MM/YYYY HH24:MI:SS Is this a know issue/bug? The only way I could fix this was by replacing the date format in all the triggers. Database used: Oracle 11g Geodatabase version: 10.2.1 Regards, Pramod

‎12-18-2015

Glad It worked! Cheers, Pramod

‎11-11-2015

We faced this issue with Search functionality, This becomes even worse when the values are grouped, It displays each value within the group separately and shows them with the same label name making them appear like duplicates. When we raised this with ESRI UK they suggested us to normalise and keep the list to minimal. We tried and brought them down to minimal number and provided layer name in the Label to make them more meaningful (They are still a mess but they are relatively more helpful/meaningful now)

‎11-11-2015

ArcGIS Mobile doesn't support SQL queries, You may want to check on that!

‎11-09-2015

Geospatial World: ArcGIS Collector: Update Error Code 1006 This helped me last time! Go to your ArcGIS Server Admin page, select the Feature Service that is causing the problem and Edit the Feature Service. Select the Capabilities item and select Feature Class within the Capabilities tab. Near the bottom you will see a button labelled Advanced Options Click the Advanced Options button and you will be presented with the following dialog. Uncheck the Filter web content toggle and restart the service and the error should be gone.

‎09-16-2015

Juan, Albeit bit late, we got that working after enabling versioning on the dataset. Regards, Pramod

‎07-10-2015

I know this was being discussed 2 years ago, but it still is messy with ArcGIS Mobile10.2.1 and it can't handle Labels and annotations well Was just curious to know what you did there to get this working? or did someone ever got it working? Thanks, Pramod

Online Status	Offline
Date Last Visited	‎05-18-2023 06:35 PM

My Ideas

Latest Contributions by PramodHarithsa1

GPS connectivity on ArcGIS Mobile 10.2.1

Re: How to know if an edit to A Table has been posted

Re: How to know if an edit to A Table has been posted

Re: How to know if an edit to A Table has been posted

How to know if an edit to A Table has been posted

Trigger on Add table in versioned SDE

Re: Julian date issue with Multi-versioned views

Re: Julian date issue with Multi-versioned views

Julian date issue with Multi-versioned views

Re: Invalid html content in json request body

Re: Removing feature types from the Collect Features - Select Feature Types page

Re: ArcGIS for Windows Mobile not honoring change in definition query on server service layer

Re: Invalid html content in json request body

Re: Unable to sync new features using synchronization task

Re: Multi-line label

Re: Custom extension to transform GPS data from WG...

Re: Attribute window doesn't wrap text

Re: Unable to sync new features using synchronizat...

Re: GPS connectivity on ArcGIS Mobile 10.2.1

Re: GPS connectivity on ArcGIS Mobile 10.2.1