12 Replies Latest reply on Apr 5, 2019 8:58 AM by Aleksandar Jelovac

    Simphony 2.10 EMC login errors

    Aleksandar Jelovac

      Hello,

       

      After installing All-In-One Simphony 2.10 in lab (Win 2k8/Ora 11g with 12c client) without any errors during installation I have two types of errors when trying to open EMC:

      1. with secure connection Server:localhost:8080 and micros/micros error is: "ERC_COMM_ERROR"

       

      (2019-03-29 05:41:32.897|Failure to connect to host: localhost:8080

      SendSyncRequest returned with error code: ERC_COMM_ERROR

         at EMC.Data.WebService.EMCClient.Execute(Int32 timeOutSec)

         at EMC.Data.WebService.EMCClient.IsMultiTenantNotAuthenticated()

        at EMC.Framework.Login.ServerLogger.AttemptServerConnection(Boolean isDisplayError))

       

      2. with non-secure connection Server:localhost and micros/micros error is "EMCHandler Failed: ORA-00942: table or view does not exist"

       

      (2019-03-29 05:44:10.763|Failure to connect to host: localhost

      SendSyncRequest returned with error code: ERC_COMM_ERROR

         at EMC.Data.WebService.EMCClient.Execute(Int32 timeOutSec)

         at EMC.Data.WebService.EMCClient.IsMultiTenantNotAuthenticated()

         at EMC.Framework.Login.ServerLogger.AttemptServerConnection(Boolean isDisplayError)

      2019-03-29 05:44:49.493|CompanyName is

      2019-03-29 05:44:49.575|ID is 0

      2019-03-29 05:44:49.588|ID is 14)

       

      Has anybody idea what I missed in pre/post installation process?

       

      Thank you!

       

      Aleksandar

        • 1. Re: Simphony 2.10 EMC login errors
          Valerio Frigerio-Oracle

          Dear Aleksandar,

           

          it's really difficult to answer your question.

          I would suggest you to check the Simphony Installation log file to double check that everything has been installed correctly without any errors.

          Based on the second case, seems that you have some error with the Database, but even in this case it's hard to establish if it's given by an authentication problem or because of a failure during the installation.

          You could also try to restart your Simphony server and check the server egateway log file, to verify that Simphony start correctly or if there are errors that you have to fix before continue.

           

          Have you try to look at the MOS portal to find out if some else has already had the same issue?

           

          Kind regards

          Valerio

          • 2. Re: Simphony 2.10 EMC login errors
            Christian Lupprich-Oracle

            Hi Aleksandar,

             

            I wonder if you have installed the required certificate?

             

            https://docs.oracle.com/cd/E89797_01/doc.210/e89800.pdf Page 6-6  - so the port to communicate will be 443 ..

             

            Another one is to install .Net Framework 4.7 .. one of your colleague from the partner community pointed us to the missing reference.

             

            Hope this helps

            Christian

            • 3. Re: Simphony 2.10 EMC login errors
              Aleksandar Jelovac

              Dear Valerio,

               

              Thank you for your reply!

              I didn't found any error during setup.

              I looked at MOS and found some SR where only was suggested to resatrt WWW service, but no result.

              Can you suggest me which of EGateway logs I should give attention to see is Simphony started correctly?

               

              Regards,

               

              Aleksandar

              • 4. Re: Simphony 2.10 EMC login errors
                Valerio Frigerio-Oracle

                Aleksandar,

                 

                based on the drive where you have installed Simphony (on the Simphony App Server) you should have a folder named:  <drive:>\micros\Simphony2\EgatewayService\EgatewayLog

                 

                There inside you'll find the Log files.

                 

                Check the most recent, after have restarted the Simphony Server or IIS.

                 

                Kind regards

                Valerio

                • 5. Re: Simphony 2.10 EMC login errors
                  Aleksandar Jelovac

                  Dear Valerio,

                   

                   

                   

                  Here are logs from EGaleway log folder:

                   

                   

                   

                  (log_//servername//)

                   

                  Timestamp            |CL|ML|Zone        |ThreadId |Message

                  --------------------------------------------------------------------------------------------------------

                  04/01/19 09:29:07.880, 0, 0,LoadHandlers,        3,Log file rotated: Total size [10485760]‚ File size [1048576]‚ Threshold [10485760] Provider[FullLogger],

                  04/01/19 09:29:08.002, 0, 0,LoadHandlers,        3,Simphony Version: 2.1000.0.0,

                  04/01/19 09:29:08.053, 0, 0,DebugHandler,        3,[2X EGatewayService] found [DbSettings.xml] at fixed path [E:\MICROS\Simphony2\EgatewayService\DbSettings.xml] DefaultRootPath [E:\MICROS\Simphony2\EgatewayService],

                  04/01/19 09:29:08.076, 0, 0,DebugHandler,        3,Debug logger has been run,

                  04/01/19 09:29:08.076, 0, 0,DebugHandler,        3,Default db settings : DatabaseType = Oracle‚

                  DatabaseServer = localhost‚

                  DbCatalog = simphony‚

                  Username = trans‚ Port = 1521‚ Provider = None,

                  04/01/19 09:29:08.581, 0, 0,Security    ,        3,[Security.LegacyAuthSupported] = [True],

                  04/01/19 09:29:08.581, 0, 0,Security    ,        3,[Security.UseCALBootstrap] = [False],

                  04/01/19 09:29:08.581, 0, 0,Security    ,        3,[Security.UseUnauthenticatedMessagesConfig] = [False],

                  04/01/19 09:29:08.581, 0, 0,Security    ,        3,[Security.UseRequestAuth] = [True],

                  04/01/19 09:29:08.606, 0, 0,Security    ,        3,[Security.ReauthMinPeriodHrs] = [24],

                  04/01/19 09:29:08.606, 0, 0,Security    ,        3,[Security.CALTimeSyncEnabled] = [True],

                  04/01/19 09:29:08.606, 0, 0,Security    ,        3,[Security.CALInstallerEnabled] = [True],

                  04/01/19 09:29:08.606, 0, 0,Security    ,        3,[Security.CALManageWSName] = [True],

                  04/01/19 09:29:11.479, 0, 0,Security    ,        3,!!!!!!! Key rotation must be performed in EMC !!!!!!! ERROR_READ_FAULT

                  ,

                  04/01/19 09:29:11.577, 0, 0,Security    ,        3,UnauthenticatedMessages: 0-7‚ 16‚ 2019‚ 3000-3999‚ 5000-5999‚ 6000-6999‚ 7000-7999‚ 9000-9999‚ 10000-10999‚ 11000-11999‚ 12000-12999‚ 13000-13999‚ 15000-15999‚ 16000-16999‚ 17000-17999‚ 18000-18999‚ 20000-24999,

                  04/01/19 09:29:11.635, 0, 0,Security    ,        3,Error when InitSecurityConfiguration: No Passphrase found in MCRSCACHE. Please perform Key Rotation from EMC to set a new Passphrase and create Encryption keys.,

                  04/01/19 09:29:11.639, 0, 0,LoadHandlers,        3,LIC 657562: TaxUtils created but not active,

                  04/01/19 09:29:11.762, 0, 0,CallHandlers,        3,CreatePerformanceLibaryManager initialized successfully: server SIMPH2K8‚ id 21; application EGateway‚ id 1,

                  04/01/19 09:29:11.967, 0, 0,LoadHandlers,        3,=================================================================================================================

                  =================================================================================================================

                  ,

                  04/01/19 09:29:11.983, 0, 0,ToolKit     ,        3, ==== Detecting ToolKit Plugins ====,

                  04/01/19 09:29:13.606, 0, 0,ToolKit     ,        3, 1 - ToolKit Plugin Detected. Name: LogFileTextTriggerPlugin User Friendly Name: Search Log Files Enabled:True,

                  04/01/19 09:29:13.606, 0, 0,ToolKit     ,        3, 2 - ToolKit Plugin Detected. Name: MachineStatsPlugin User Friendly Name: Machine Information Enabled:True,

                  04/01/19 09:29:13.607, 0, 0,ToolKit     ,        3, 3 - ToolKit Plugin Detected. Name: SetLogLevelsPlugin User Friendly Name: Set Log Zone Levels Enabled:True,

                  04/01/19 09:29:13.607, 0, 0,ToolKit     ,        3, 4 - ToolKit Plugin Detected. Name: UploadLogsPlugin User Friendly Name: Get Log Files Enabled:True,

                  04/01/19 09:29:13.607, 0, 0,ToolKit     ,        3, ==== Loaded 4 ToolKit Plugins ====,

                  04/01/19 09:29:13.607, 0, 0,ToolKit     ,        3, No ToolKit Plugins detected or Client Start time not set. Skipping start up.,

                  04/01/19 09:29:13.610, 0, 0,LoadHandlers,        3,-- Start loading message handlers,

                  04/01/19 09:29:14.241, 0, 0,LoadHandlers,        3,Found Message Handler: MICROS.Simphony.Sequencer.AutosequenceHandler,

                  04/01/19 09:29:14.694, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.CashManagement.CMHandler,

                  04/01/19 09:29:14.736, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.CCBatchProcessor.CCBatchHandler,

                  04/01/19 09:29:14.787, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.CheckReprocessor.CheckReprocessorHandler,

                  04/01/19 09:29:14.809, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.ChkPostBackup.ChkPostBackupHandler,

                  04/01/19 09:29:14.988, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.CheckPostingServiceStarter.ChkPostSvcStarterHandler,

                  04/01/19 09:29:15.650, 0, 0,LoadHandlers,        3,Found Message Handler: ChkReprocSvcHost.ChkReprocSvcHost,

                  04/01/19 09:29:15.769, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.CommonServicesHandler.CommonServicesHandler,

                  04/01/19 09:29:15.956, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.SystemConfiguration.ConfigurationHandler,

                  04/01/19 09:29:16.237, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.DbSync.DbSyncServerHandler,

                  04/01/19 09:29:16.395, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.DigitalMedia.MediaMessageHandler,

                  04/01/19 09:29:16.451, 0, 0,LoadHandlers,        3,Found Message Handler: DistributedCALStarter.DistributedCALStarterHandler,

                  04/01/19 09:29:16.483, 0, 0,LoadHandlers,        3,Dll with name EGatewayClientWS.dll IS EXCLUDED,

                  04/01/19 09:29:16.483, 0, 0,LoadHandlers,        3,Dll with name EGatewayDB.dll IS EXCLUDED,

                  04/01/19 09:29:16.483, 0, 0,LoadHandlers,        3,Dll with name EGatewayDefs.dll IS EXCLUDED,

                  04/01/19 09:29:16.483, 0, 0,LoadHandlers,        3,Dll with name EGatewayHandlerUtils.dll IS EXCLUDED,

                  04/01/19 09:29:16.542, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.LES.EGateway.SimphonyTaxUtilsHandler,

                  04/01/19 09:29:16.542, 0,-3,LoadHandlers,        3,Cannot create instance of class Micros.LES.EGateway.SimphonyTaxUtilsHandler,

                  04/01/19 09:29:16.937, 0, 0,LoadHandlers,        3,Found Message Handler: EMC.Data.WebService.EMCHandler,

                  04/01/19 09:29:17.081, 0, 0,LoadHandlers,        3,Found Message Handler: ExtensibilityServiceHandler.ExtensibilityServiceMessageHandler,

                  04/01/19 09:29:17.131, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.Simphony.EGateway.FileDownloadHandler.FileDownloadHandler,

                  04/01/19 09:29:17.308, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.GMSHandler.GMSHandler,

                  04/01/19 09:29:17.369, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.GroupEventHandler.GroupEventHandler,

                  04/01/19 09:29:17.854, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.LES.Interface.InterfaceServiceMessageHandler,

                  04/01/19 09:29:17.854, 0, 0,LoadHandlers,        3,Dll with name InteropHelper.dll IS EXCLUDED,

                  04/01/19 09:29:18.271, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.KdsHandler.KdsServiceHandler,

                  04/01/19 09:29:18.651, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.LocalReporting.LocalReportHandler,

                  04/01/19 09:29:18.917, 0, 0,LoadHandlers,        3,Dll with name Micros.Core.dll IS EXCLUDED,

                  04/01/19 09:29:18.945, 0, 0,LoadHandlers,        3,Dll with name MICROS.myLabor.Communications.dll IS EXCLUDED,

                  04/01/19 09:29:18.957, 0, 0,LoadHandlers,        3,Dll with name MICROS.myLabor.MyLaborInterfaces.dll IS EXCLUDED,

                  04/01/19 09:29:18.957, 0, 0,LoadHandlers,        3,Dll with name MICROS.myLabor.Proxy.dll IS EXCLUDED,

                  04/01/19 09:29:19.429, 0, 0,LoadHandlers,        3,Dll with name MicrosDevices.dll IS EXCLUDED,

                  04/01/19 09:29:19.429, 0, 0,LoadHandlers,        3,Dll with name MicrosDevicesBridge.dll IS EXCLUDED,

                  04/01/19 09:29:19.907, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.LaserPrintHandling.LaserPrintingHandler,

                  04/01/19 09:29:20.175, 0, 0,LoadHandlers,        3,Dll with name Ops.dll IS EXCLUDED,

                  04/01/19 09:29:20.306, 0, 0,LoadHandlers,        3,Dll with name OpsSvcHost.dll IS EXCLUDED,

                  04/01/19 09:29:20.307, 0, 0,LoadHandlers,        3,Dll with name OpsUI.dll IS EXCLUDED,

                  04/01/19 09:29:20.814, 0, 0,LoadHandlers,        3,Exception when retrieving infomation from dll OpsUIHTML.dll : Could not load file or assembly 'OpsUIHTML' or one of its dependencies. An attempt was made to load a program with an incorrect format. :    at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName‚ String codeBase‚ Evidence assemblySecurity‚ RuntimeAssembly locationHint‚ StackCrawlMark& stackMark‚ IntPtr pPrivHostBinder‚ Boolean throwOnFileNotFound‚ Boolean forIntrospection‚ Boolean suppressSecurityChecks)

                     at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef‚ Evidence assemblySecurity‚ RuntimeAssembly reqAssembly‚ StackCrawlMark& stackMark‚ IntPtr pPrivHostBinder‚ Boolean throwOnFileNotFound‚ Boolean forIntrospection‚ Boolean suppressSecurityChecks)

                     at System.Reflection.Assembly.Load(AssemblyName assemblyRef)

                     at Micros.LES.EGateway.MessageHandlerManager.LoadMessageHandlers(String folder‚ Boolean fIsHandheld),

                  04/01/19 09:29:21.699, 0, 0,LoadHandlers,        3,Exception when retrieving infomation from dll Ops_Accessor.dll : Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. :    at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)

                     at System.Reflection.Assembly.GetTypes()

                     at Micros.LES.EGateway.MessageHandlerManager.LoadMessageHandlers(String folder‚ Boolean fIsHandheld),

                  04/01/19 09:29:21.761, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.Payment.Handler.PaymentHandler,

                  04/01/19 09:29:21.806, 0, 0,LoadHandlers,        3,Dll with name PosCommonClasses.dll IS EXCLUDED,

                  04/01/19 09:29:21.806, 0, 0,LoadHandlers,        3,Dll with name PosCore.dll IS EXCLUDED,

                  04/01/19 09:29:21.886, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.Printing.PrintingHandler,

                  04/01/19 09:29:22.215, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.CAL.SimphonyCALHandler,

                  04/01/19 09:29:22.229, 0, 0,LoadHandlers,        3,Supported conversions:,

                  04/01/19 09:29:22.230, 0, 0,LoadHandlers,        3,MsgType 17001 from 1 to 2,

                  04/01/19 09:29:22.230, 0, 0,LoadHandlers,        3,MsgType 17001 from 2 to 1,

                  04/01/19 09:29:22.230, 0, 0,LoadHandlers,        3,Converter added into message table,

                  04/01/19 09:29:22.231, 0, 0,LoadHandlers,        3,Dll with name SimphonyDataStore.dll IS EXCLUDED,

                  04/01/19 09:29:22.307, 0, 0,LoadHandlers,        3,Dll with name SimphonyUtilities.dll IS EXCLUDED,

                  04/01/19 09:29:22.346, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.LES.SIM.ESimSVCMessageHandler,

                  04/01/19 09:29:22.352, 0, 0,LoadHandlers,        3,Dll with name SqlDbHelper.dll IS EXCLUDED,

                  04/01/19 09:29:22.484, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.Statistics.StatisticsHandler,

                  04/01/19 09:29:22.621, 0, 0,LoadHandlers,        3,Dll with name SystemServices.dll IS EXCLUDED,

                  04/01/19 09:29:22.663, 0, 0,LoadHandlers,        3,Dll with name TIFPmsComms.dll IS EXCLUDED,

                  04/01/19 09:29:23.117, 0, 0,LoadHandlers,        3,Found Message Handler: Micros.TotalsPosting.TotalsPostingHandler,

                  04/01/19 09:29:23.265, 0, 0,LoadHandlers,        3,Dll with name WebKitBrowser.dll IS EXCLUDED,

                  04/01/19 09:29:23.265, 0, 0,LoadHandlers,        3,Dll with name WebServiceBase.dll IS EXCLUDED,

                  04/01/19 09:29:23.750, 0, 0,LoadHandlers,        3,-- Initializing system configuration handler,

                  04/01/19 09:29:23.770, 0, 0,LoadHandlers,        3,***** Configuration Handler: This is an enterprise service host,

                  04/01/19 09:29:23.770, 0, 0,LoadHandlers,        3,***** Configuration Handler: Host process is IIS,

                  04/01/19 09:29:23.805, 0, 0,LoadHandlers,        3,***** Configuration Handler: App type Win32,

                  04/01/19 09:29:23.805, 0, 0,LoadHandlers,        3,***** Configuration Handler: This is not a Windows service,

                  04/01/19 09:29:23.805, 0, 0,LoadHandlers,        3,***** Configuration Handler: This is a headless process,

                  04/01/19 09:29:23.805, 0, 0,LoadHandlers,        3,***** Configuration Handler: AppRoot is not defined,

                  04/01/19 09:29:23.812, 0, 0,LoadHandlers,        3,***** Configuration Handler: SFP SFP(s) = E:\MICROS\Simphony2\EgatewayService\SecData.bin;,

                  04/01/19 09:29:23.812, 0, 0,LoadHandlers,        3,***** Configuration Handler: Port 80,

                  04/01/19 09:29:23.813, 0, 0,LoadHandlers,        3,***** Configuration Handler: CAL is NOT active on this service host,

                  04/01/19 09:29:23.813, 0, 0,LoadHandlers,        3,***** Configuration Handler: CAL is not active,

                  04/01/19 09:29:23.814, 0, 0,LoadHandlers,        3,***** Configuration Handler: CAL ActiveHostIpAddres [],

                  04/01/19 09:29:23.814, 0, 0,LoadHandlers,        3,***** Configuration Handler: CAL ActiveHostIpAddressOld [],

                  04/01/19 09:29:23.870, 0, 0,LoadHandlers,        3,***** Configuration Handler: Config file E:\MICROS\Simphony2\EgatewayService\Web.Config,

                  04/01/19 09:29:23.883, 0, 0,LoadHandlers,        3,***** Configuration Handler: Failed to find [ServiceHost.xml] in [C:\].,

                  04/01/19 09:29:23.883, 0, 0,LoadHandlers,        3,***** Configuration Handler: Failed to find [ServiceHost.xml] in [C:\Windows\system32].,

                  04/01/19 09:29:23.884, 0, 0,LoadHandlers,        3,***** Configuration Handler: Failed to find [ServiceHost.xml] in [E:\MICROS\Simphony2].,

                  04/01/19 09:29:23.885, 0, 0,LoadHandlers,        3,***** Configuration Handler: Failed to find [ServiceHost.xml] in [C:\]. [1 occurrence],

                  04/01/19 09:29:23.884, 0, 0,LoadHandlers,        3,***** Configuration Handler: Failed to find [ServiceHost.xml] in [E:\MICROS].,

                  04/01/19 09:29:23.885, 0, 0,LoadHandlers,        3,***** Configuration Handler: Failed to find [ServiceHost.xml] in [E:].,

                  04/01/19 09:29:23.885, 0, 0,LoadHandlers,        3,***** Configuration Handler: Could not find file [ServiceHost.xml] in Simphony tree [E:\MICROS\Simphony2],

                  04/01/19 09:29:23.885, 0, 0,LoadHandlers,        3,***** Configuration Handler: Could not find file [ServiceHost.xml].,

                  04/01/19 09:29:23.896, 0, 0,LoadHandlers,        3,***** Configuration Handler: UseRequestAuth = True,

                  04/01/19 09:29:23.898, 0, 0,LoadHandlers,        3,***** Configuration Handler: ReauthenticateIdentity - using default Url http://localhost:8080/EGateway/EGateway.asmx,

                  04/01/19 09:29:23.898, 0, 0,LoadHandlers,        3,***** Configuration Handler: CAL Auth ServiceHost identity is not configured in registry,

                  04/01/19 09:29:23.898, 0, 0,LoadHandlers,        3,***** Configuration Handler: ServiceHost identity is not configured in web.config.txt,

                  04/01/19 09:29:23.899, 0, 0,LoadHandlers,        3,***** Configuration Handler: Not initialzing DB job pool as no DB validation ouccurred,

                  04/01/19 09:29:23.917, 0, 0,LoadHandlers,        3,***** Configuration Handler: SetServiceHostInfo - not reading ent/prop info on enterise,

                  04/01/19 09:29:23.933, 0, 0,LoadHandlers,        3,***** Configuration Handler: Set service host info to [Service host info Ent= EntHSID=0 Prop= PropHSID=0 WorkstationID=-1 ServiceHostID=0 IP=192.168.1.141] data [W--1|H-0|E-0|P-0|I-192.168.1.141|EN- |PN-?],

                  04/01/19 09:29:23.933, 0, 0,LoadHandlers,        3,***** Configuration Handler: IP address = [192.168.1.141],

                  04/01/19 09:29:23.933, 0, 0,LoadHandlers,        3,-- System configuration handler initialized,

                  04/01/19 09:29:23.943, 0, 0,LoadHandlers,        3,Loaded Handler: Autosequence Handler,

                  04/01/19 09:29:23.955, 0, 0,CashManage  ,        3,CM: Cash Management not configured to run here.,

                  04/01/19 09:29:23.956, 0, 0,LoadHandlers,        3,Did Not Load Handler: CMHandler,

                  04/01/19 09:29:23.956, 0, 0,LoadHandlers,        3,Loaded Handler: CreditCardBatchProcessor,

                  04/01/19 09:29:23.964, 0, 0,EGatewayHand,        3,CheckReprocessor - initialized,

                  04/01/19 09:29:23.964, 0, 0,LoadHandlers,        3,Loaded Handler: CheckReprocessor,

                  04/01/19 09:29:23.968, 0, 0,LoadHandlers,        3,Backup C+P: Exception getting DB info [DatabaseSettings not found for alias: LocalDb],

                  04/01/19 09:29:23.969, 0, 0,LoadHandlers,        3,Loaded Handler: Check And Posting Backup,

                  04/01/19 09:29:23.970, 0, 0,EGatewayHand,        3,Start to initialize ChkPostSvcStarterHandler,

                  04/01/19 09:29:23.977, 0, 0,EGatewayHand,        3,Succeeded kick off a job to initialize ChkPostSvcStarterHandler,

                  04/01/19 09:29:23.977, 0, 0,LoadHandlers,        3,Loaded Handler: ChkPostSvcStarterHandler,

                  04/01/19 09:29:23.984, 0, 0,LoadHandlers,        9,Check Reprocessor will use gateway URL [http://localhost:8080/EGateway/EGateway.asmx],

                  04/01/19 09:29:23.988, 0, 0,LoadHandlers,        3,Loaded Handler: ChkReprocSvcHost,

                  04/01/19 09:29:23.993, 0, 0,EGatewayHand,        3,Starting initialization of CommonServicesHandler,

                  04/01/19 09:29:23.993, 0, 0,EGatewayHand,        3,CommonServicesHandler's ToolKitManagerStartRetryTimes is 0,

                  04/01/19 09:29:23.993, 0, 0,EGatewayHand,        3,CommonServicesHandler's ToolKitManagerStartRetrySecs is 0,

                  04/01/19 09:29:23.993, 0, 0,EGatewayHand,        3,ToolKitManager in not set to start.,

                  04/01/19 09:29:23.993, 0, 0,LoadHandlers,        3,Did Not Load Handler: CommonServices,

                  04/01/19 09:29:23.993, 0, 0,LoadHandlers,        3,Loaded Handler: ConfigurationHandler,

                  04/01/19 09:29:24.051, 0, 0,DbSync      ,        3,DBSyncServer Handler Init().,

                  04/01/19 09:29:24.065, 0, 0,LoadHandlers,        3,Loaded Handler: DbSyncServerHandler,

                  04/01/19 09:29:24.118, 0, 0,LoadHandlers,        3,Loaded Handler: Digital Media Handler,

                  04/01/19 09:29:24.128, 0, 0,LoadHandlers,        3,Did Not Load Handler: DistributedCALStarterHandler,

                  04/01/19 09:29:24.557, 0, 0,EGatewayHand,       10,Start the thread to initialize ChkPostSvcStarterHandler,

                  04/01/19 09:29:24.557, 0, 0,EGatewayHand,       10,ChkPostSvcStarterHandler's CheckPostingServiceStartTryTime is 1,

                  04/01/19 09:29:24.557, 0, 0,EGatewayHand,       10,ChkPostSvcStarterHandler's StartFailureNotificationFrequency is 30,

                  04/01/19 09:29:24.557, 0, 0,EGatewayHand,       10,Try to start Check and Posting service for the 1 time,

                  04/01/19 09:29:24.557, 0, 0,EGatewayHand,       10,CAPS is Configured to Run on IIS.,

                  04/01/19 09:29:24.580, 0, 0,EGatewayHand,       10,Found values for CPServiceId 0 EGatewayURL http://localhost:8080/EGateway/EGateway.asmx,

                  04/01/19 09:29:24.581, 0, 0,EGatewayHand,       10,[Check and Posting service not configured to run here],

                  04/01/19 09:29:24.764, 0, 0,EGatewayHand,       10,Cannot notify Check Posting Service Start failure WorkStationID is invalid,

                  04/01/19 09:29:25.154, 0, 0,LoadHandlers,        3,Loaded Handler: EMC Handler,

                  04/01/19 09:29:25.157, 0, 0,LoadHandlers,        3,ExtensibilityServiceMessageHandler: starting job,

                  04/01/19 09:29:25.158, 0, 0,LoadHandlers,        3,Loaded Handler: ExtensibilityServiceMessageHandler,

                  04/01/19 09:29:25.159, 0, 0,LoadHandlers,        3,Loaded Handler: FileDownloadHandler,

                  04/01/19 09:29:25.164, 0, 0,EGatewayHand,        3,Starting initialization of GMSHandler,

                  04/01/19 09:29:25.164, 0, 0,EGatewayHand,        3,GMSHandler's GMSDataServiceStartRetryTimes is 20,

                  04/01/19 09:29:25.164, 0, 0,EGatewayHand,        3,GMSHandler's GMSDataServiceStartRetrySecs is 30,

                  04/01/19 09:29:25.168, 0, 0,EGatewayHand,        3,Scheduled a DbJob to startup GMSHandler services in 15 seconds,

                  04/01/19 09:29:25.169, 0, 0,LoadHandlers,        3,Loaded Handler: Guest Management System,

                  04/01/19 09:29:25.173, 0, 0,GroupEvent  ,        3,Starting initialization of GroupEventHandler,

                  04/01/19 09:29:25.173, 0, 0,GroupEvent  ,        3,GroupEventServiceStartRetryTimes is 20,

                  04/01/19 09:29:25.173, 0, 0,GroupEvent  ,        3,GroupEventServiceStartRetrySecs is 30,

                  04/01/19 09:29:25.173, 0, 0,GroupEvent  ,        3,Scheduled a DbJob to startup Group Event Service in 15 seconds,

                  04/01/19 09:29:25.174, 0, 0,LoadHandlers,        3,Loaded Handler: Group Event,

                  04/01/19 09:29:25.176, 0, 0,LoadHandlers,        3,Did Not Load Handler: InterfaceServiceMessageHandler,

                  04/01/19 09:29:25.238, 0, 0,KDS         ,        3,Kds Handler Init().,

                  04/01/19 09:29:25.241, 0, 0,KDS         ,        3,KdsControllerServiceID not defined in Application Parameters,

                  04/01/19 09:29:25.241, 0, 0,KDS         ,        3,KdsControllerBackupServiceID not defined in Application Parameters,

                  04/01/19 09:29:25.241, 0, 0,KDS         ,        3,Kds Service Exiting - Unable to read App Parameters.,

                  04/01/19 09:29:25.245, 0, 0,KDS         ,        3,Stopping DataStoreClient,

                  04/01/19 09:29:25.316, 0, 0,LoadHandlers,        3,Did Not Load Handler: KdsHandler,

                  04/01/19 09:29:25.317, 0, 0,LoadHandlers,        3,ReportsHandler: Local Reports Handler: This is an enterprise service host,

                  04/01/19 09:29:25.319, 0, 0,LoadHandlers,        3,Loaded Handler: Local Reporting,

                  04/01/19 09:29:25.319, 0, 0,LoadHandlers,        3,Loaded Handler: LaserPrintHandler,

                  04/01/19 09:29:26.500, 0, 0,EGatewayHand,        7,DigitalMediaHandler - MediaServiceID is not configure. MediaService exiting,

                  04/01/19 09:29:26.896, 0, 0,LoadHandlers,        3,Loaded Handler: Payment,

                  04/01/19 09:29:26.896, 0, 0,LoadHandlers,        3,Loaded Handler: Printing,

                  04/01/19 09:29:26.898, 0, 0,Unknown     ,        3,Initializing CAL Handler. IsDistributedCAL = False,

                  04/01/19 09:29:26.930, 0, 0,CAL         ,        3,CAL Handler initialized,

                  04/01/19 09:29:26.931, 0, 0,LoadHandlers,        3,Loaded Handler: CAL Handler,

                  04/01/19 09:29:26.934, 0, 0,EGatewayHand,        3,ESimSVCMessageHandler.Init: SIMServiceID = 0. Handler will not start,

                  04/01/19 09:29:26.935, 0, 0,LoadHandlers,        3,Did Not Load Handler: SimSVCMessageHandler,

                  04/01/19 09:29:26.935, 0, 0,Statistics  ,        3,StatisticsHandler: Disabled.,

                  04/01/19 09:29:26.936, 0, 0,LoadHandlers,        3,Did Not Load Handler: StatisticsHandler,

                  04/01/19 09:29:26.956, 0, 0,LoadHandlers,        3,Ent: Totals posting: This is an enterprise service host,

                  04/01/19 09:29:26.957, 0, 0,LoadHandlers,        3,Ent: Using EMCHandler DB alias for labor initialization,

                  04/01/19 09:29:27.316, 0, 0,Labor       ,        3,Labor not configured - no WorkstationId or PropertyId settings,

                  04/01/19 09:29:27.316, 0, 0,Labor       ,        3,Labor subsystem not configured in database. Following labor parameters are blank: [MyLabor URL] [MyLabor Logon] [MyLabor Password],

                  04/01/19 09:29:27.318, 0, 0,LoadHandlers,        3,Loaded Handler: Totals Posting,

                  04/01/19 09:29:27.318, 0, 0,LoadHandlers,        3,LIC 657562: Init called,

                  04/01/19 09:29:27.319, 0, 0,LoadHandlers,        3,Loaded Handler: TaxUtilsHandler,

                  04/01/19 09:29:27.319, 0, 0,LoadHandlers,        3,-- Finish loading message handlers,

                  04/01/19 09:29:27.319, 0, 0,Security    ,        3,Initialized Security.DLL.,

                  04/01/19 09:29:27.658, 0, 0,LoadHandlers,        9,Check Reprocessor : Info : Successfully loaded and initialized plug-in.,

                  04/01/19 09:29:30.117, 0, 0,CallHandlers,        6,Not using WSE DIME,

                  04/01/19 09:29:30.117, 0, 0,CallHandlers,        6,EGateway.UEOSH 1,

                  04/01/19 09:29:30.664, 0, 0,LoadHandlers,       19,Check Reprocessor : Info : Successfully loaded and initialized plug-in. [2 occurrences],

                  04/01/19 09:29:30.664, 0, 0,LoadHandlers,       19,Check Reprocessor : Started,

                  04/01/19 09:29:38.251, 0, 0,LoadHandlers,       17,=================================================================================================================

                  =================================================================================================================

                  ,

                  04/01/19 09:29:38.251, 0,-1,LoadHandlers,       17,EMC Login Successful.,

                  04/01/19 09:29:40.691, 0, 0,DebugHandler,       13,Error executing SQL: select lhi.locationid‚ co.ENABLEINVENTORY entinv‚ co.ENABLEENTERPRISELABOR entlab‚ lhi.ENABLEINVENTORYOVERRIDE locinv‚ lhi.ENABLEENTERPRISELABOR loclab

                     from location_hierarchy_item lhi join core_organization co on co.organizationid = lhi.organizationid

                     where co.organizationid =:organizationID,

                  04/01/19 09:29:40.693, 0, 0,CallHandlers,       13,Exception when calling handler for msgType 5001 version 1 remoteIP 127.0.0.1 ,

                  04/01/19 09:29:40.693, 0, 0,CallHandlers,       13,Exception Message: ORA-00942: table or view does not exist,

                  04/01/19 09:29:40.757, 0, 0,CallHandlers,       13,Exception Trace:    at EMC.Data.Sql.SqlSelect.Execute()

                     at EMC.Data.WebService.EMCMessage.DoRead(XmlElement command‚ EMCCommand cmd)

                     at EMC.Data.WebService.EMCMessage.HandleReadCommand(XmlElement command‚ EMCCommand cmd)

                     at EMC.Data.WebService.EMCMessage.HandleMessage(NetDatagram dgIn‚ NetDatagram& dgOut‚ EGatewayAppParams appParams)

                     at EMC.Data.WebService.EMCHandler.HandleMessage(NetDatagram dgIn‚ NetDatagram& dgOut‚ EGatewayAppParams appParams)

                     at Micros.LES.EGateway.MessageHandlerManager.HandleMessage(Int32 msgType‚ Int32 iVersion‚ AuthTokenHelper securityToken‚ NetDatagram dgIn‚ NetDatagram& dgOut‚ String remoteEndpoint‚ String strOrgKey),

                  04/01/19 09:29:41.314, 0, 0,GroupEvent  ,       10,Trying to startup Group Event Service - attempt number 1,

                  04/01/19 09:29:41.315, 0, 0,GroupEvent  ,       10,Group Event Service not started - This is an Enterprise Service Host,

                  04/01/19 09:29:55.151, 0, 0,LoadHandlers,       18,ReadExtensionAppsJob: woke up,

                  04/01/19 09:29:55.221, 0, 0,LoadHandlers,       18,ExtensibilityServicesList: Reading the current level HierStrucID,

                  04/01/19 09:29:55.226, 0, 0,LoadHandlers,       18,ExtensibilityServicesList: Found Enterprise HierStrucID : 14,

                  04/01/19 09:29:55.226, 0, 0,LoadHandlers,       18,ExtensibilityServicesList: on enterprise‚ opening database connection on DbSync settings,

                  04/01/19 09:29:55.303, 0, 0,LoadHandlers,       18,ExtensibilityServicesList: Reading records from EXTENSION_APPLICATION,

                  04/01/19 09:29:55.319, 0, 0,LoadHandlers,       18,ExtensibilityServicesList: extension application [SimVen] ExtensionApplicationID [1] running on enterprise and not enabled‚ ignoring,

                  04/01/19 09:29:55.319, 0, 0,LoadHandlers,       18,ExtensibilityServicesList: extension application [OISClient] ExtensionApplicationID [2] running on enterprise and not enabled‚ ignoring,

                  04/01/19 09:29:55.319, 0, 0,LoadHandlers,       18,ExtensibilityServicesList: extension application [Suites] ExtensionApplicationID [3] running on enterprise and not enabled‚ ignoring,

                  04/01/19 09:29:55.319, 0, 0,LoadHandlers,       18,ExtensibilityServicesList: found 0 records in EXTENSION_APPLICATION,

                  04/01/19 09:29:55.348, 0, 0,LoadHandlers,       18,ExtensibilityServicesList: found 0 active application(s) to inspect,

                  04/01/19 09:29:55.348, 0, 0,LoadHandlers,       18,ReadExtensionAppsJob: initialized successfully‚ stopping job,

                   

                  and

                   

                  (logError)

                   

                  2019-04-01 09:29:07.318: reading seq file

                  2019-04-01 09:29:07.340: parsing seq file

                  2019-04-01 09:29:07.340: moving file [E:\MICROS\Simphony2\EgatewayService\EGatewayLog\Log_SIMPH2K8.txt] to [E:\MICROS\Simphony2\EgatewayService\EGatewayLog\Log_SIMPH2K8_23.txt]

                  2019-04-01 09:29:07.341: saving new sequence number: 24

                  2019-04-01 09:29:07.341: deleting oldest log file: seqToDelete 23 m_NumLogFiles 10

                  2019-04-01 09:29:07.341: rotating out log file: E:\MICROS\Simphony2\EgatewayService\EGatewayLog\Log_SIMPH2K8_13.txt

                   

                  Any idea what I missed?

                   

                  Regards,

                   

                  Aleksandar

                  • 6. Re: Simphony 2.10 EMC login errors
                    Aleksandar Jelovac

                    Dear Christian,

                     

                    I installed certificate and after that I reinstalled Simphony, and configured port 443 in Bindings.

                    Also, .Net framework was 4.6.2 and I upgrade it to 4.7.2, same result.

                     

                    Thanks for your reply!

                     

                    Regards,

                     

                    Aleksandar

                    • 7. Re: Simphony 2.10 EMC login errors
                      Christian Lupprich-Oracle

                      Hi Aleksandar,

                       

                      look at this please:

                       

                      04/01/19 09:29:11.479, 0, 0,Security    ,        3,!!!!!!! Key rotation must be performed in EMC !!!!!!! ERROR_READ_FAULT

                      ,

                      04/01/19 09:29:11.577, 0, 0,Security    ,        3,UnauthenticatedMessages: 0-7‚ 16‚ 2019‚ 3000-3999‚ 5000-5999‚ 6000-6999‚ 7000-7999‚ 9000-9999‚ 10000-10999‚ 11000-11999‚ 12000-12999‚ 13000-13999‚ 15000-15999‚ 16000-16999‚ 17000-17999‚ 18000-18999‚ 20000-24999,

                      04/01/19 09:29:11.635, 0, 0,Security    ,        3,Error when InitSecurityConfiguration: No Passphrase found in MCRSCACHE. Please perform Key Rotation from EMC to set a new Passphrase and create Encryption keys.,

                       

                       

                      https://docs.oracle.com/cd/E89797_01/doc.210/e89808.pdf

                      Appendix D / Key Manager Manual

                       

                      Regards

                      Christian

                      • 8. Re: Simphony 2.10 EMC login errors
                        Aleksandar Jelovac

                        Hi Christian,

                        How can I perform operation from Apendix D?

                        I can't open EMC...

                        Are there something in DB that could be changed?

                         

                        Regards,


                        Aleksandar

                        • 9. Re: Simphony 2.10 EMC login errors
                          Valerio Frigerio-Oracle

                          Dear Aleksandar,

                           

                          seems that you have issue with the Database.

                          The number of variables to qualify the problem is too high to be managed in this forum.

                          I would suggest you to contact the Oracle Consulting to help you with this installation.

                           

                          Maybe my colleague Christian will be able to give you some more support later on.

                           

                          Kind regards

                          Valerio

                          • 10. Re: Simphony 2.10 EMC login errors
                            Aleksandar Jelovac

                            Thank you Valerio for your suggestion!

                            Just to add that basic connecting to transaction and reporting DB (through sqlplus, sqldeveloper,...) seems ok.

                            Probably I missed something in DB configuration.

                            Regards,

                            Aco

                            • 11. Re: Simphony 2.10 EMC login errors
                              Christian Lupprich-Oracle

                              Hi Aleksandar,

                               

                              in addition to Valerios suggestion, I think we cannot provide more useful information for this issue in this forum.

                               

                              Just to be sure, that the documentation we are providing on docs.oracle.com is correct:

                              did you follow the install instructions in the Installation Guide for Simphony 2.10

                               

                              Best regards

                              Christian

                              • 12. Re: Simphony 2.10 EMC login errors
                                Aleksandar Jelovac

                                Dear Christian,

                                 

                                Yes, I used that manual.

                                Thanks anyway!

                                 

                                Regards,

                                Aleksandar