Hexagon Geospatial
MENU

GeoMedia Smart Client

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Showing results for 
Search instead for 
Do you mean 
Reply
Contributor
Posts: 66
Registered: ‎11-12-2015

GMSC opening WF ORA-00001: unique constraint (GMSC.PK_SESSION) violated

Hi all, 

 

our customer complains, that very often he gets error like below. The steps he does:

  1. Open GMSC
  2. Try to open workflow -> it usually return error, but not always
  3. Close worklfow with error
  4. Open workflow again -> then it works fine for the rest of the session

 

21.01.2019 07:02:07 ERROR - Controller List has raised an exception in Action Select.
Oracle.DataAccess.Client.OracleException: ORA-00001: unique constraint (GMSC.PK_SESSION) violated
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at Intergraph.Emea.Security.SessionPersistence.PersistNewOrUpdatedItems(DbCommand cmd, IEnumerable`1 newOrUpdatedSessionItems)
at Intergraph.Emea.Security.SessionPersistence.PersistSessionState(SessionState sessionState)
at Intergraph.Emea.SmartClient.Workflows.SmartClientWorkflowSessionProvider.Persist(SessionState sessionState)
at Intergraph.Emea.Workflows.WorkflowControllerBase.OnActionExecuted(ActionExecutedContext filterContext)
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.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

 

I have two session triggers with action="before" in workflow. Could this be the reason? Or is it something else? Can I prevent this error?

 

Thanks,

Tereza

Staff
Posts: 589
Registered: ‎11-12-2015

Re: GMSC opening WF ORA-00001: unique constraint (GMSC.PK_SESSION) violated

[ Edited ]

Hi Tereza,

 

Do the trigger(s) have the 'Select' action that is being complained about here?

Knowing what the triggers do would help know if they could be the cause of the issue.

 

A similar error was discussed and resolved here: https://community.hexagongeospatial.com/t5/GeoMedia-Smart-Client/ORA-00001-unique-constraint-violate...

You may find it helpful to your case.

Contributor
Posts: 66
Registered: ‎11-12-2015

Re: GMSC opening WF ORA-00001: unique constraint (GMSC.PK_SESSION) violated

[ Edited ]

Hi sclow,

 

thanks for your prompt reply. I know about that post, unfortunately, it is a bit different from my case and I cannot use it, because I get the error before the form is loaded.

 

The session triggers I use are simple,select is only in condition:

 

<WorkflowTrigger name="iTypKontrolyTrigger" type="SessionTrigger" method="before">
<Param name="Key" value="KONTROLY.ID_OPERACE"/>
<Param name="Value" value="120"/>
</WorkflowTrigger>

<WorkflowTrigger name="CheckSingleSignOnUserName" type="SessionTrigger" method="before" condition="SQL[select decode(count(*),0,'true','false') from GMSC.sec_session where SESSIONID = {SESSION.SESSIONID} AND NAME like 'SingleSignOnUserName']">
<Param name="Key" value="SSO"/>
<Param name="Value" value="FALSE"/>
</WorkflowTrigger>

Workflow form looks like this:

 

<Form name="FmSeznamDiluDokumentaci" idfield="ID" label="Seznam dílů dokumentací" table="V_ELTM_DOK_DIL" order="SQL[ORDER BY ROK desc,PUVCIS desc]" filter="SQL[PUVOD not in ('PGP','VFK','VFR','MC','ADS','IPR') and ID &gt; 0]" customscript="seznamDiluDokumentaciFilter.js" customstyle="jobStatus.css">
		<FormReport name="Seznam_dil" label="Seznam dílů dokumentací" format="xls,pdf,csv" type="overview"/>
		<FormTab name="FtbSeznamDokumentaci" label="Seznam dokumentací">
			<FormGroup name="FgpSeznamPSK" label=" " help="Seznam PSK na daném území">
				<FormField name="ID" type="textfield" visible="list" datatype="number"/>
				<FormField name="ID_DOK" type="textfield" visible="hidden" datatype="number"/>
				<FormField name="ZAMEK_TYP" label="Typ zámku" type="combobox" sqlselect="SQL[select TYP from GMSC_CIS_ZAMEKTYP where ID = V_ELTM_DOK_DIL.ZAMEK_TYP]" lov="SQL[select ID,TYP from GMSC_CIS_ZAMEKTYP where ID != 3]" datatype="string" visible="list, filter" />
				<FormField name="JOB_STATUS" label="Status" type="combobox" lov="SQL[select ID,JOBSTATUSTEXT from GMSC_CIS_DIL_JOBSTATUS]" datatype="number" visible="list, filter" />
				<FormField name="JOB_STATUS_TEXT" label="Status popis" type="combobox" sqlselect="SQL[select JOBSTATUSTEXT from GMSC_CIS_DIL_JOBSTATUS where ID = V_ELTM_DOK_DIL.JOB_STATUS]" lov="SQL[select ID,JOBSTATUSTEXT from GMSC_CIS_DIL_JOBSTATUS]" datatype="string" visible="list" />	
			</FormGroup>
		</FormTab>
		<!--ROWACTIONS-->
		<FormAction name="fmaUkazVMape" action="SCRIPT[IG.setActiveFeature('61');IG.setSelectedElements({ROW.ID});IG.fitSelectedElements({ROW.ID});IG.list.refreshList()]" help="Ukaž zámek v mapě" label="Zobrazí vybraný zámek dílu dokumentace v mapě" type="row" visible="list[SQL[Select case when ZAMEK_GEOMETRY is not null then 1 else 0 end From ELTM_DOK_DIL Where ID = {ROW.ID}]]" image="custom-icon-zoom"/>
	</Form>

 

Tereza

Staff
Posts: 589
Registered: ‎11-12-2015

Re: GMSC opening WF ORA-00001: unique constraint (GMSC.PK_SESSION) violated

Hi Tereza,

 

The triggers and form look fine from here.

I would recommend opening a support ticket for further investigation if no resolution is forth coming in the community.

 

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.