Our deployed application accessing WebService that are hosted on two Servers, one of the server is showing following error when we try to access "Aspose" workflow tasks. 

Whereas all ODP calls to database is ok.

DB is Oracle 10.2.0.2  with Asp.Net 2.0 (C#).

System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.at System.Data.OracleClient.OCI.DetermineClientVersion()
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at x1013827b5529bb7d.x0368c6134b66b24e.get_NewConnection()
at x10763278ed98d245.x0699372cbdd3fd55.xe3d58c58e9aafdfd()
at x10763278ed98d245.x0699372cbdd3fd55.Configure(xc1ab63db0ba527a3 cus)
at x1013827b5529bb7d.x0368c6134b66b24e.x20aee281977480cf(IEngineConfiguration x14ca24feee6ac4ad)
at x1013827b5529bb7d.x0368c6134b66b24e.xd586e0c16bdae7fc()
at x1013827b5529bb7d.x0368c6134b66b24e.Configure(IEngineConfiguration engineConfiguration, EngineManager engineManager)
at Aspose.Workflow.Engine.EngineManager.Configure(IEngineConfiguration engineConfig)
at Aspose.Workflow.Engine.EngineManager.Configure(String[][] propertyArray)
at TP.HRMS.WebService.Workflow.EngineManagerPool.ConfigureEngine(EngineManager engineManager)
at TP.HRMS.WebService.Workflow.EngineMain.GetAllTasks(String UserId, String Password, String Process, Int32 FromTaskNo, Int32 ToTaskNo)
at TP.HRMS.WebService.Workflow.WorkflowTest.GetAllTasks(String UserId, String Password)

 

Hello,

I found an interesting post with the same error. Check it out

http://thedotnet.com/nntp/451661/showpost.aspx

Thanks,

---

Team Lead
Aspose Guangzhou Team
About Us
Contact Us

Hello,

we are already implement/check your provided address/post. My webservice application is working fine but when i am going to perfome workflow related task this error is occuring and other areas of the application is working fine.

 

Thanks.

As per my previous discussion with your technical support department (Mr.Guangzhou) we got new dll from following links.

http://www.aspose.com/products/Aspose.Workflow/Fixes/oracle-dataaccess-beta.zip

but after deployment this dll at development enviornment we got following error .
could you send me bug free DLL to solve my urgent bases problem.

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidCastException: Unable to cast object of type 'Oracle.DataAccess.Types.OracleDecimal' to type 'System.IConvertible'.
  at System.Convert.ToInt32(Object value)
  at Aspose.Workflow.Internal.Persistence.Impl.DataDirect.InstancePersistenceImpl.InitActivityAndProcessStatesTable()
  at Aspose.Workflow.Internal.Persistence.Impl.DataDirect.InstancePersistenceImpl.Configure(ICallbackUtilities cus)
  at Aspose.Workflow.Internal.Core.AsposeWorkflowEngineManager.Initialize(IEngineConfiguration engineConfiguration)
  at Aspose.Workflow.Internal.Core.AsposeWorkflowEngineManager.Init()
  at Aspose.Workflow.Internal.Core.AsposeWorkflowEngineManager.Configure(IEngineConfiguration engineConfiguration, EngineManager engineManager)
  at Aspose.Workflow.Engine.EngineManager.Configure(IEngineConfiguration engineConfig)
  at Aspose.Workflow.Engine.EngineManager.Configure(String[][] propertyArray)
  at TP.HRMS.WebService.Workflow.EngineManagerPool.ConfigureEngine(EngineManager engineManager) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\ObjectPooling.cs:line 201
  at TP.HRMS.WebService.Workflow.EngineManagerPool.addEngineManager() in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\ObjectPooling.cs:line 135
  at TP.HRMS.WebService.Workflow.EngineManagerPool.getEngineManager() in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\ObjectPooling.cs:line 143
  at TP.HRMS.WebService.Workflow.EngineMain.GetAllTasks(String UserId, String Password, String Process, Int32 FromTaskNo, Int32 ToTaskNo) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\EngineMain.cs:line 1399
  at TP.HRMS.WebService.Workflow.EngineMain.GetAllTasks(String UserId, String Password, Int32 FromTaskNo, Int32 ToTaskNo) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\EngineMain.cs:line 516
  at TP.HRMS.WebService.Workflow.WorkflowMain.GetAllTasks(String uid, Int32 SessionId, String Password, Int32 FromTaskNo, Int32 ToTaskNo) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\WorkflowMain.asmx.cs:line 26
  --- End of inner exception stack trace ---
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidCastException: Unable to cast object of type 'Oracle.DataAccess.Types.OracleDecimal' to type 'System.IConvertible'.
  at System.Convert.ToInt32(Object value)
  at Aspose.Workflow.Internal.Persistence.Impl.DataDirect.InstancePersistenceImpl.InitActivityAndProcessStatesTable()
  at Aspose.Workflow.Internal.Persistence.Impl.DataDirect.InstancePersistenceImpl.Configure(ICallbackUtilities cus)
  at Aspose.Workflow.Internal.Core.AsposeWorkflowEngineManager.Initialize(IEngineConfiguration engineConfiguration)
  at Aspose.Workflow.Internal.Core.AsposeWorkflowEngineManager.Init()
  at Aspose.Workflow.Internal.Core.AsposeWorkflowEngineManager.Configure(IEngineConfiguration engineConfiguration, EngineManager engineManager)
  at Aspose.Workflow.Engine.EngineManager.Configure(IEngineConfiguration engineConfig)
  at Aspose.Workflow.Engine.EngineManager.Configure(String[][] propertyArray)
  at TP.HRMS.WebService.Workflow.EngineManagerPool.ConfigureEngine(EngineManager engineManager) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\ObjectPooling.cs:line 201
  at TP.HRMS.WebService.Workflow.EngineManagerPool.addEngineManager() in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\ObjectPooling.cs:line 135
  at TP.HRMS.WebService.Workflow.EngineManagerPool.getEngineManager() in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\ObjectPooling.cs:line 143
  at TP.HRMS.WebService.Workflow.EngineMain.GetAllTasks(String UserId, String Password, String Process, Int32 FromTaskNo, Int32 ToTaskNo) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\EngineMain.cs:line 1399
  at TP.HRMS.WebService.Workflow.EngineMain.GetAllTasks(String UserId, String Password, Int32 FromTaskNo, Int32 ToTaskNo) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\EngineMain.cs:line 516
  at TP.HRMS.WebService.Workflow.WorkflowMain.GetAllTasks(String uid, Int32 SessionId, String Password, Int32 FromTaskNo, Int32 ToTaskNo) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\WorkflowMain.asmx.cs:line 26
  --- End of inner exception stack trace ---

Source Error:


Line 51:             catch (Exception ex)
Line 52:             {
Line 53:                 throw new Exception(ex.Message);
Line 54:             }
Line 55:         }
 

Source File: D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Website\ascx_files\mytask.ascx.cs    Line: 53

Stack Trace:


[Exception: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidCastException: Unable to cast object of type 'Oracle.DataAccess.Types.OracleDecimal' to type 'System.IConvertible'.
   at System.Convert.ToInt32(Object value)
   at Aspose.Workflow.Internal.Persistence.Impl.DataDirect.InstancePersistenceImpl.InitActivityAndProcessStatesTable()
   at Aspose.Workflow.Internal.Persistence.Impl.DataDirect.InstancePersistenceImpl.Configure(ICallbackUtilities cus)
   at Aspose.Workflow.Internal.Core.AsposeWorkflowEngineManager.Initialize(IEngineConfiguration engineConfiguration)
   at Aspose.Workflow.Internal.Core.AsposeWorkflowEngineManager.Init()
   at Aspose.Workflow.Internal.Core.AsposeWorkflowEngineManager.Configure(IEngineConfiguration engineConfiguration, EngineManager engineManager)
   at Aspose.Workflow.Engine.EngineManager.Configure(IEngineConfiguration engineConfig)
   at Aspose.Workflow.Engine.EngineManager.Configure(String[][] propertyArray)
   at TP.HRMS.WebService.Workflow.EngineManagerPool.ConfigureEngine(EngineManager engineManager) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\ObjectPooling.cs:line 201
   at TP.HRMS.WebService.Workflow.EngineManagerPool.addEngineManager() in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\ObjectPooling.cs:line 135
   at TP.HRMS.WebService.Workflow.EngineManagerPool.getEngineManager() in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\ObjectPooling.cs:line 143
   at TP.HRMS.WebService.Workflow.EngineMain.GetAllTasks(String UserId, String Password, String Process, Int32 FromTaskNo, Int32 ToTaskNo) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\EngineMain.cs:line 1399
   at TP.HRMS.WebService.Workflow.EngineMain.GetAllTasks(String UserId, String Password, Int32 FromTaskNo, Int32 ToTaskNo) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\EngineMain.cs:line 516
   at TP.HRMS.WebService.Workflow.WorkflowMain.GetAllTasks(String uid, Int32 SessionId, String Password, Int32 FromTaskNo, Int32 ToTaskNo) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Service\Workflow\WorkflowMain.asmx.cs:line 26
   --- End of inner exception stack trace ---]
   TP.HRMS.Website.ascx_files.mytask.Load_Control() in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Website\ascx_files\mytask.ascx.cs:53
   TP.HRMS.Website.ascx_files.mytask.Page_Load(Object sender, EventArgs e) in D:\Development\Telenor\Source\TP.HRMS\TP.HRMS.Website\ascx_files\mytask.ascx.cs:20
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061