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
Highlighted
Contributor
Posts: 63
Registered: ‎02-22-2016
Accepted Solution

ORA-28001: the password has expired. Even after resetting, reconfiguring

Hi all,

SmartClient gives following error when tried to login through Client. "Administrator works fine"

 

24.08.2016 11:55:03 ERROR - Unexpected exception: ORA-28001: the password has expired
Oracle.DataAccess.Client.OracleException: ORA-28001: the password has expired
   at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
   at Oracle.DataAccess.Client.OracleConnection.Open()
   at Intergraph.Emea.SmartClient.Data.MetadataConverter.QueryEntityMetadata(FeatureMetadata layer)
   at Intergraph.Emea.SmartClient.Data.MetadataConverter.Initialize(FeatureMetadata metadata)
   at Intergraph.Emea.SmartClient.Data.MetadataConverter.ToFeature(DataRow feature, DataRow[] displayRuleDefinition, Boolean initializeFeature)
   at Intergraph.Emea.SmartClient.Data.MetadataConverter.ToQuery(DataRow query, DataTable queryFeatures)
   at System.Collections.Generic.List`1.ConvertAll[TOutput](Converter`2 converter)
   at Intergraph.Emea.SmartClient.Data.MetadataConverter.ToQuery(DataTable queries, DataTable queryFeatures)
   at Intergraph.Emea.SmartClient.Data.DefaultMetadataContext.GetAllQueryMetadata(String projectIdentifier, IUserRoleProvider roleProvider)
   at Intergraph.Emea.SmartClient.Services.SearchService.GetPredefinedQueries(ClientCredentials credentials)
   at SyncInvokeGetPredefinedQueries(Object , Object[] , Object[] )
   at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
   at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

I have reset my password through SqlPlus. Then Administrator started working. But Client still through this log.

  • I have re-configured GMSC.
  • Checked by connecting directly through SQL, Connection works fine.

How to fix this?

 

Version: GMSC 2015 EP01

Contributor
Posts: 63
Registered: ‎02-22-2016

Re: ORA-28001: the password has expired. Even after resetting, reconfiguring

Solved,

It was the other schema that was expired.

 

Silly me!!

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