Hexagon Geospatial

M.App Enterprise Discussions

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Do you mean 
Reply
nthakor
Staff
nthakor
Posts: 8
Registered: ‎03-17-2016

inserting multiple geometries

‎05-09-2017 08:17 PM

Hi everyone, below is my simple workflow

 

<?xml version="1.0"?>
<FormList xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Form name="NewForm1" idfield="ID" table="tbl_plumber_capture">
    <FormTab name="NewTab1" visible="true">
      <FormGroup name="NewGroup1" editable="true" visible="true">
        <FormField name="ID" visible="hidden" datatype="number" defaultvaluemode="onload" persisted="true" />
        <FormField name="PIC" persisted="true" />
        <FormAction name="Capture" editable="true" visible="true" action="SCRIPT[SC.digitize('plumber_capture', {commands: ['GE_NEWPOINT','GE_NEWTEXT','GE_NEWPOLYLINE','GE_NEWPOLYGON','GE_MOVE','GE_ROTATE']})]" />
      </FormGroup>
    </FormTab>
  </Form>
</FormList> 

 If I click Capture Action - Add any single Geometry - Click Save - the geometry gets inserted and record is saved in the database.

 

All works fine.

 

However, If I click Capture Action - Add multiple Geometries (2-3 lines or 2-3 points or 1 polygon and 1 line etc.) - Click Save - then below exception is thrown

 

at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1070)
	at com.intergraph.web.plugin.edit.persistence.AbstractPersitenceProvider.persistChanges(AbstractPersitenceProvider.java:110)
	at com.intergraph.web.plugin.edit.persistence.WorkflowPersitenceProvider.persistChanges(WorkflowPersitenceProvider.java:62)
	at com.intergraph.web.plugin.edit.EditPlugin.save(EditPlugin.java:318)
	at com.intergraph.web.plugin.edit.EditActions.GE_SAVE(EditActions.java:242)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.intergraph.tools.utils.disptach.MiniDispatcher.dispatch2Method(MiniDispatcher.java:93)
	at com.intergraph.tools.utils.disptach.MiniDispatcher.dispatch(MiniDispatcher.java:79)
	at com.intergraph.tools.utils.disptach.RPAction.dispatch(RPAction.java:577)
	at com.intergraph.tools.utils.disptach.RPAction.actionPerformed(RPAction.java:514)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$500(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)

Maybe, I need to set the Geometry type as done in SmartClient, where do I set the type of geomerty to GeometryCollection?

 

Thanks,

Nrupesh

Report Inappropriate Content
Message 1 of 7 (1,774 Views)
Reply
0 HexPoints
sturcato
Staff
sturcato
Posts: 1,038
Registered: ‎10-18-2015

Re: inserting multiple geometries

‎05-11-2017 11:41 PM

Hi Nrupesh,

 

it is not clear how you manage the primary key. I guess that may be one problem, because inserting 1 geometry with 1 value for the ID may work, but loading more than one can cause an error. If you are managing the increment into the database directly just set the defaultvaluemode="onsave", this way the values get generated while posting the data.

 

Another problem may be the geometry type. This depends on the database and actual content of your table.

 

Please check anyway logs in Studio.

 

Regards,

Stefano

Stefano Turcato
Presale Engineer
Hexagon Geospatial
Report Inappropriate Content
Message 2 of 7 (1,761 Views)
Reply
0 HexPoints
nthakor
Staff
nthakor
Posts: 8
Registered: ‎03-17-2016

Re: inserting multiple geometries

‎05-15-2017 06:47 PM

Hi Stefano, I have changed defaultvaluemode="onsave" as directed.

my table is as below


CREATE TABLE [dbo].[tbl_plumber_capture](
[ID] [int] IDENTITY(1,1) NOT NULL,
[PSP] [nvarchar](max) NULL,
[PIC] [nvarchar](max) NULL,
[PLUMBER_LIC] [nvarchar](max) NULL,
[NOTES] [nvarchar](max) NULL,
[GEOMETRY_SPA] [geometry] NULL,
[GEOMETRY] [varbinary](max) NULL,
CONSTRAINT [PK_tbl_plumber_capture] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

The log in studio has below exception

System.ArgumentException: An item with the same key has already been added.
[Details]
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at MApp.Workflows.DesktopClientWorkflowController.<SaveGeometries>d__12.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Mvc.Async.TaskAsyncActionDescriptor.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass37.<BeginInvokeAsynchronousActionMethod>b__36(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
at System.Web.HttpApplication.CallHandlerExecutionStep.OnAsyncHandlerCompletion(IAsyncResult ar)

inserting single geometry is fine, this only occures while inserting multiple geometries

Best Regards,
Nrupesh

Report Inappropriate Content
Message 3 of 7 (1,716 Views)
Reply
0 HexPoints
sturcato
Staff
sturcato
Posts: 1,038
Registered: ‎10-18-2015

Re: inserting multiple geometries

‎05-16-2017 10:13 AM

which version of M.App Enterprise are you running?

 

Stefano

Stefano Turcato
Presale Engineer
Hexagon Geospatial
Report Inappropriate Content
Message 4 of 7 (1,712 Views)
Reply
0 HexPoints
nthakor
Staff
nthakor
Posts: 8
Registered: ‎03-17-2016

Re: inserting multiple geometries

‎05-16-2017 06:56 PM

M.App Enterprise 16.1.702.0

Report Inappropriate Content
Message 5 of 7 (1,702 Views)
Reply
0 HexPoints
sturcato
Staff
sturcato
Posts: 1,038
Registered: ‎10-18-2015

Re: inserting multiple geometries

‎05-17-2017 02:39 AM

It should be solved in the new version.

 

Stefano

Stefano Turcato
Presale Engineer
Hexagon Geospatial
Report Inappropriate Content
Message 6 of 7 (1,700 Views)
Reply
0 HexPoints
nthakor
Staff
nthakor
Posts: 8
Registered: ‎03-17-2016

Re: inserting multiple geometries

‎05-18-2017 07:54 PM

Hi Stefano,

 

we have installed version 16.1.872.0

we still get the same error.

 

Regards,

Nrupesh

 

System.ArgumentException: An item with the same key has already been added.
   [Details]
   Href: https://52.62.4.37:443/Workflows/Form/SaveGeometries/?workflow=property_capture&lang=en-US&sessionid=82144fa8-7559-4fb0-8f51-0c9a296ad1f0&tenant=SQLTrainingUser1&nodeid=Root&srid=3857&layer=plumber_capture&debugMode=true
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at MApp.Workflows.FormController.<SaveGeometries>d__66.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Mvc.Async.TaskAsyncActionDescriptor.EndExecute(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass37.<BeginInvokeAsynchronousActionMethod>b__36(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult)
   at System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
   at System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
   at System.Web.HttpApplication.CallHandlerExecutionStep.OnAsyncHandlerCompletion(IAsyncResult ar)

 

Report Inappropriate Content
Message 7 of 7 (1,697 Views)
Reply
0 HexPoints
Users online (127)