Sync fails to retrieve mappings when trial has been removed and re-setup. The error that shows up in the event log is: Error ORA-01012: not logged on

(Doc ID 1471416.1)

Last updated on JUNE 05, 2014

Applies to:

Oracle Health Sciences InForm Adapter - Version 1.2 and later
Information in this document applies to any platform.
CIS
ODM

Symptoms

 Some of the errors that can appear in the event log on the InForm Adapter server:

Exception Information *********************************************
Exception Type: PhaseForward.InFormAdapter.Framework.Common.Resources.InFormAdapterException MessageId: TRIAL_NOT_FOUND
ResourceArguments: 0: JADA ResourceIdentifier: TRIAL_NOT_FOUND UnformattedParameterString:
Trial {0} Not Found Message: Trial <> Not Found
Severity: Error MachineName: <> CreatedDateTime: 11/11/2010 6:06:02 PM
AppDomainName: /LM/W3SVC/1/Root/informadapterpa004/ODM-1-129339723581342930
AppDomainVersion: 2.0.50727.1433
ThreadId: 1
ThreadIdentityName:
WindowsIdentityName: NT AUTHORITY\NETWORK SERVICE UniqueIdentifier: 65162040
ExceptionId: PhaseForward.InFormAdapter.Framework.Common.Resources.TRIAL_NOT_FOUND
Data: System.Collections.ListDictionaryInternal TargetSite: PhaseForward.Platform.Storage.IDBProvider GetTrialProvider(System.String) HelpLink:
Source: PhaseForward.InFormAdapter.Framework.Common StackTrace Information ********************************************* at
PhaseForward.InFormAdapter.Framework.Common.DataUtilities.GetTrialProvider(String trial) in
D:\InformAdapter\Framework\Common\DataUtilities.cs:line 29 at
PhaseForward.InFormAdapter.Framework.Common.LanguageCodeValidator.GetInFormVersion(String trial) in
D:\InformAdapter\Framework\Common\LanguageCodeValidator.cs:line 262 at
PhaseForward.InFormAdapter.Framework.Common.LanguageCodeValidator.IsInternationalizedTrial(String trial) in
D:\InformAdapter\Framework\Common\LanguageCodeValidator.cs:line 242 at
PhaseForward.InFormAdapter.ODM.ODMEngine.ValidateInputSchemaVersion(String trial) in
D:\InformAdapter\ODM\ODMEngine.cs:line 188 at
PhaseForward.InFormAdapter.ODM.ODMEngine.DownloadAdminDataODM(DownloadAdminDataODM obj) in
D:\InformAdapter\ODM\ODMEngine.cs:line 73 at
PhaseForward.InFormAdapter.ODM.ODMGateway.DownloadAdminDataODM(XmlElement node) in
D:\InformAdapter\ODM\ODMGateway.cs:line 52 at
PhaseForward.Adapter.Framework.Common.WebService.BigBrother.ExecuteWebMethod(WebMethodExecuter method, XmlElement xmlRequest) in
D:\AdapterFramework11SP2\Framework\Common\WebServiceUtils.cs:line 57

Some of the errors that appear on the InForm Server Adapter server (InForm server)

Event Type:    Error
Event Source:    InFormAdapter.ServerAdapter.WebService
Event Category:    None
Event ID:    0
Description:
The description for Event ID ( 0 ) in Source ( InFormAdapter.ServerAdapter.WebService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 2011-08-23 08:15:45,002 [2636] ERROR InFormAdapter.ServerAdapter.WebService
General Information
*********************************************
Additional Info:
UniqueIdentifier: 29744846
ApplicationName: InFormAdapter.ServerAdapter.WebService
PlatformVersion: 1.1.368.0
WindowsIdentity: \ASPNET
UICulture: en-US
ThreadCulture: en-US

1) Exception Information
*********************************************
Exception Type: PhaseForward.Adapter.Framework.Common.Exceptions.Messages.AdapterException
MessageId: GENERAL
Message: A General Error Occured
Severity: Error
MachineName:
WindowsIdentityName: \ASPNET
UniqueIdentifier: 29744846
ExceptionId: PhaseForward.Adapter.Framework.Common.Exceptions.Messages.GENERAL
TargetSite:
HelpLink:
Source:

2) Exception Information
*********************************************
Exception Type: Oracle.DataAccess.Client.OracleException
Errors: Oracle.DataAccess.Client.OracleErrorCollection
Message: ORA-00028: your session has been killed
Procedure:
Source: Oracle Data Provider for .NET
Number: 28
TargetSite: Void HandleErrorHelper(Int32, Oracle.DataAccess.Client.OracleConnection, IntPtr, Oracle.DataAccess.Client.OpoSqlValCtx*, System.Object, System.String)
HelpLink:

StackTrace Information
*********************************************
   at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()
   at PhaseForward.InFormAdapter.ServerAdapter.Database.TransactionXmlTable.TableExists() in E:\InformAdapter\ServerAdapter\Database\TransactionXmlTable.cs:line 60
   at PhaseForward.InFormAdapter.ServerAdapter.Database.TransactionXmlTable.EnsureTableExists() in E:\InformAdapter\ServerAdapter\Database\TransactionXmlTable.cs:line 90
   at PhaseForward.InFormAdapter.ServerAdapter.Service.ServerAdapter.GetTransactions(GetTransactionsRequest request) in E:\InformAdapter\ServerAdapter\Service\ServerAdapter.cs:line 36
   at PhaseForward.InFormAdapter.ServerAdapter.WebService.ServerAdapterHandler.GetTransactions(XmlElement xmlRequest) in E:\InformAdapter\ServerAdapter\WebService\ServerAdapterHandler.cs:line 35
   at PhaseForward.Adapter.Framework.Common.WebService.BigBrother.ExecuteWebMethod(WebMethodExecuter method, XmlElement xmlRequest) in E:\AdapterFramework\Framework\Common\WebServiceUtils.cs:line 57
.
-------------------------------------

Event Type:      Error
Event Source:  InFormAdapter.ServerAdapter.WebService
Event Category:           None
Event ID:         0
Description:
The description for Event ID ( 0 ) in Source ( InFormAdapter.ServerAdapter.WebService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 2011-08-24 06:45:45,627 [2636] ERROR InFormAdapter.ServerAdapter.WebService
General Information
*********************************************
Additional Info:
UniqueIdentifier: 24345580
ApplicationName: InFormAdapter.ServerAdapter.WebService
PlatformVersion: 1.1.368.0
WindowsIdentity: \ASPNET
UICulture: en-US
ThreadCulture: en-US
 
1) Exception Information
*********************************************
Exception Type: PhaseForward.Adapter.Framework.Common.Exceptions.Messages.AdapterException
MessageId: GENERAL
Message: A General Error Occured
Severity: Error
MachineName:
CreatedDateTime: 8/24/2011 6:45:45 AM
AppDomainName: /LM/W3SVC/1/Root/informadapter/ServerAdapter-1-129580367053305469
AppDomainVersion: 1.1.4322.2300
ThreadId: 2636
ThreadIdentityName:
WindowsIdentityName: \ASPNET
UniqueIdentifier: 24345580
ExceptionId: PhaseForward.Adapter.Framework.Common.Exceptions.Messages.GENERAL
TargetSite:
HelpLink:
Source:
 
2) Exception Information
*********************************************
Exception Type: Oracle.DataAccess.Client.OracleException
Errors: Oracle.DataAccess.Client.OracleErrorCollection
Message: ORA-01012: not logged on
Procedure:
Source: Oracle Data Provider for .NET
Number: 1012
TargetSite: Void HandleErrorHelper(Int32, Oracle.DataAccess.Client.OracleConnection, IntPtr, Oracle.DataAccess.Client.OpoSqlValCtx*, System.Object, System.String)
HelpLink:
 
StackTrace Information
*********************************************
   at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()
   at PhaseForward.InFormAdapter.ServerAdapter.Database.TransactionXmlTable.TableExists() in E:\InformAdapter\ServerAdapter\Database\TransactionXmlTable.cs:line 60
   at PhaseForward.InFormAdapter.ServerAdapter.Database.TransactionXmlTable.EnsureTableExists() in E:\InformAdapter\ServerAdapter\Database\TransactionXmlTable.cs:line 90
   at PhaseForward.InFormAdapter.ServerAdapter.Service.ServerAdapter.GetTransactions(GetTransactionsRequest request) in E:\InformAdapter\ServerAdapter\Service\ServerAdapter.cs:line 36
   at PhaseForward.InFormAdapter.ServerAdapter.WebService.ServerAdapterHandler.GetTransactions(XmlElement xmlRequest) in E:\InformAdapter\ServerAdapter\WebService\ServerAdapterHandler.cs:line 35
   at PhaseForward.Adapter.Framework.Common.WebService.BigBrother.ExecuteWebMethod(WebMethodExecuter method, XmlElement xmlRequest) in E:\AdapterFramework\Framework\Common\WebServiceUtils.cs:line 57

Changes

 Trial has been removed and re-setup.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms