Trigger Policy not returning output and child policy status

Hi,

Im currently having trouble with the opalis server. Recently I have been encountering slowness from the server and as I investigated the cause I noticed the error "Action Server xxxxxxxx2001 is reaching its maximum capacity"

As per my research the cause here is that opalis has a limitation of 50 concurrent policies so I changed the heap and the throttle to 100 and 1024. After changing that I've noticed some weird errors like the trigger policy would not return any result. When I looked at the policy being triggered it ran flawlessly but the child policy status of the trigger is blank. Before I had no issue with this policy but now its getting this issue once in a while.

I really do not know what is happening at this point. Ive checked the logs and Ive noticed an iDispatch Error. It seems that it has something to do with the database but I am not sure if this really is thr root cause.

Process ID: 3304
Version   : 6.2.2.5229
Computer  : xxxxxxxx2001
User      : MANILADC\App.Opalis

2012-11-06 21:21:50 [3904] 1 Exception caught in class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033):
<Exception><Type>_com_error</Type><ErrorMessage>IDispatch error #3105</ErrorMessage><Description>The requested properties cannot be supported.</Description><HResult>-2147217887</HResult></Exception>

2012-11-06 21:21:58 [5992] 1 Exception caught in class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033):
<Exception><Type>_com_error</Type><ErrorMessage>IDispatch error #3105</ErrorMessage><Description>The requested properties cannot be supported.</Description><HResult>-2147217887</HResult></Exception>

2012-11-06 21:21:58 [3904] 1 DBDataStore: ::Exception caught in long __stdcall CODBDataStore::SetExecutionDataBulk(unsigned short *,unsigned short *,long,struct tagVARIANT *,struct tagVARIANT *):
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15588)
<Exception>
<Type>Opalis::Exception</Type>
<Location>
long __thiscall CODBDataStore::internalSetExecutionDataBulk(unsigned short *,unsigned short *,long,const class ATL::CComSafeArray<unsigned short *,8> &,const class ATL::CComSafeArray<struct tagVARIANT,12> &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15928)
</Location>
<MsgCode>Cannot set execution data</MsgCode>
<Prev><Exception>
<Type>Opalis::Exception</Type>
<Location>
class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>IDispatch error #3105</Param>
<Param>The requested properties cannot be supported.</Param>
<Param>-2147217887</Param>
</Params>
</Exception></Prev>
</Exception>

2012-11-06 21:21:58 [3904] 1 DBDataStore: ::Error #-2147217887
Description: The requested properties cannot be supported.
Source: Microsoft OLE DB Provider for SQL Server


2012-11-06 21:21:58 [3904] 1 Exception caught in void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(230):
<Exception>
<Type>Opalis::Exception</Type>
<Location>
void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(228)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>Unspecified error</Param>
<Param></Param>
<Param>-2147467259</Param>
</Params>
</Exception>

2012-11-06 21:21:58 [5992] 1 DBDataStore: ::Exception caught in long __stdcall CODBDataStore::SetExecutionDataBulk(unsigned short *,unsigned short *,long,struct tagVARIANT *,struct tagVARIANT *):
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15588)
<Exception>
<Type>Opalis::Exception</Type>
<Location>
long __thiscall CODBDataStore::internalSetExecutionDataBulk(unsigned short *,unsigned short *,long,const class ATL::CComSafeArray<unsigned short *,8> &,const class ATL::CComSafeArray<struct tagVARIANT,12> &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15928)
</Location>
<MsgCode>Cannot set execution data</MsgCode>
<Prev><Exception>
<Type>Opalis::Exception</Type>
<Location>
class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>IDispatch error #3105</Param>
<Param>The requested properties cannot be supported.</Param>
<Param>-2147217887</Param>
</Params>
</Exception></Prev>
</Exception>

2012-11-06 21:21:58 [5992] 1 DBDataStore: ::Error #-2147217887
Description: The requested properties cannot be supported.
Source: Microsoft OLE DB Provider for SQL Server


2012-11-06 21:21:58 [5992] 1 Exception caught in void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(230):
<Exception>
<Type>Opalis::Exception</Type>
<Location>
void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(228)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>Unspecified error</Param>
<Param></Param>
<Param>-2147467259</Param>
</Params>
</Exception>

2012-11-06 21:22:06 [3432] 1 Opalis Event: Frequent DB errors

2012-11-06 21:30:26 [4680] 1 Exception caught in class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033):
<Exception><Type>_com_error</Type><ErrorMessage>IDispatch error #3105</ErrorMessage><Description>The requested properties cannot be supported.</Description><HResult>-2147217887</HResult></Exception>

2012-11-06 21:30:26 [4680] 1 DBDataStore: ::Exception caught in long __stdcall CODBDataStore::SetExecutionDataBulk(unsigned short *,unsigned short *,long,struct tagVARIANT *,struct tagVARIANT *):
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15588)
<Exception>
<Type>Opalis::Exception</Type>
<Location>
long __thiscall CODBDataStore::internalSetExecutionDataBulk(unsigned short *,unsigned short *,long,const class ATL::CComSafeArray<unsigned short *,8> &,const class ATL::CComSafeArray<struct tagVARIANT,12> &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15928)
</Location>
<MsgCode>Cannot set execution data</MsgCode>
<Prev><Exception>
<Type>Opalis::Exception</Type>
<Location>
class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>IDispatch error #3105</Param>
<Param>The requested properties cannot be supported.</Param>
<Param>-2147217887</Param>
</Params>
</Exception></Prev>
</Exception>

2012-11-06 21:30:26 [4680] 1 DBDataStore: ::Error #-2147217887
Description: The requested properties cannot be supported.
Source: Microsoft OLE DB Provider for SQL Server


2012-11-06 21:30:26 [4680] 1 Exception caught in void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(230):
<Exception>
<Type>Opalis::Exception</Type>
<Location>
void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(228)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>Unspecified error</Param>
<Param></Param>
<Param>-2147467259</Param>
</Params>
</Exception>

2012-11-06 21:30:54 [3904] 1 Exception caught in class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033):
<Exception><Type>_com_error</Type><ErrorMessage>IDispatch error #3105</ErrorMessage><Description>The requested properties cannot be supported.</Description><HResult>-2147217887</HResult></Exception>

2012-11-06 21:30:54 [3904] 1 DBDataStore: ::Exception caught in long __stdcall CODBDataStore::SetExecutionDataBulk(unsigned short *,unsigned short *,long,struct tagVARIANT *,struct tagVARIANT *):
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15588)
<Exception>
<Type>Opalis::Exception</Type>
<Location>
long __thiscall CODBDataStore::internalSetExecutionDataBulk(unsigned short *,unsigned short *,long,const class ATL::CComSafeArray<unsigned short *,8> &,const class ATL::CComSafeArray<struct tagVARIANT,12> &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15928)
</Location>
<MsgCode>Cannot set execution data</MsgCode>
<Prev><Exception>
<Type>Opalis::Exception</Type>
<Location>
class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>IDispatch error #3105</Param>
<Param>The requested properties cannot be supported.</Param>
<Param>-2147217887</Param>
</Params>
</Exception></Prev>
</Exception>

2012-11-06 21:30:54 [3904] 1 DBDataStore: ::Error #-2147217887
Description: The requested properties cannot be supported.
Source: Microsoft OLE DB Provider for SQL Server


2012-11-06 21:30:54 [3904] 1 Exception caught in void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(230):
<Exception>
<Type>Opalis::Exception</Type>
<Location>
void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(228)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>Unspecified error</Param>
<Param></Param>
<Param>-2147467259</Param>
</Params>
</Exception>

2012-11-06 21:30:57 [4680] 1 Exception caught in class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033):
<Exception><Type>_com_error</Type><ErrorMessage>IDispatch error #3105</ErrorMessage><Description>The requested properties cannot be supported.</Description><HResult>-2147217887</HResult></Exception>

2012-11-06 21:30:57 [4680] 1 DBDataStore: ::Exception caught in long __stdcall CODBDataStore::SetExecutionDataBulk(unsigned short *,unsigned short *,long,struct tagVARIANT *,struct tagVARIANT *):
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15588)
<Exception>
<Type>Opalis::Exception</Type>
<Location>
long __thiscall CODBDataStore::internalSetExecutionDataBulk(unsigned short *,unsigned short *,long,const class ATL::CComSafeArray<unsigned short *,8> &,const class ATL::CComSafeArray<struct tagVARIANT,12> &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15928)
</Location>
<MsgCode>Cannot set execution data</MsgCode>
<Prev><Exception>
<Type>Opalis::Exception</Type>
<Location>
class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>IDispatch error #3105</Param>
<Param>The requested properties cannot be supported.</Param>
<Param>-2147217887</Param>
</Params>
</Exception></Prev>
</Exception>

2012-11-06 21:30:57 [4680] 1 DBDataStore: ::Error #-2147217887
Description: The requested properties cannot be supported.
Source: Microsoft OLE DB Provider for SQL Server


2012-11-06 21:30:57 [4680] 1 Exception caught in void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(230):
<Exception>
<Type>Opalis::Exception</Type>
<Location>
void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(228)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>Unspecified error</Param>
<Param></Param>
<Param>-2147467259</Param>
</Params>
</Exception>

2012-11-06 21:31:17 [3432] 1 Opalis Event: Frequent DB errors

2012-11-06 21:31:25 [3904] 1 Exception caught in class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033):
<Exception><Type>_com_error</Type><ErrorMessage>IDispatch error #3105</ErrorMessage><Description>The requested properties cannot be supported.</Description><HResult>-2147217887</HResult></Exception>

2012-11-06 21:31:25 [3904] 1 DBDataStore: ::Exception caught in long __stdcall CODBDataStore::SetExecutionDataBulk(unsigned short *,unsigned short *,long,struct tagVARIANT *,struct tagVARIANT *):
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15588)
<Exception>
<Type>Opalis::Exception</Type>
<Location>
long __thiscall CODBDataStore::internalSetExecutionDataBulk(unsigned short *,unsigned short *,long,const class ATL::CComSafeArray<unsigned short *,8> &,const class ATL::CComSafeArray<struct tagVARIANT,12> &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15928)
</Location>
<MsgCode>Cannot set execution data</MsgCode>
<Prev><Exception>
<Type>Opalis::Exception</Type>
<Location>
class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>IDispatch error #3105</Param>
<Param>The requested properties cannot be supported.</Param>
<Param>-2147217887</Param>
</Params>
</Exception></Prev>
</Exception>

2012-11-06 21:31:25 [3904] 1 DBDataStore: ::Error #-2147217887
Description: The requested properties cannot be supported.
Source: Microsoft OLE DB Provider for SQL Server


2012-11-06 21:31:25 [3904] 1 Exception caught in void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(230):
<Exception>
<Type>Opalis::Exception</Type>
<Location>
void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(228)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>Unspecified error</Param>
<Param></Param>
<Param>-2147467259</Param>
</Params>
</Exception>

2012-11-06 21:31:27 [4680] 1 Exception caught in class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033):
<Exception><Type>_com_error</Type><ErrorMessage>IDispatch error #3105</ErrorMessage><Description>The requested properties cannot be supported.</Description><HResult>-2147217887</HResult></Exception>

2012-11-06 21:31:27 [4680] 1 DBDataStore: ::Exception caught in long __stdcall CODBDataStore::SetExecutionDataBulk(unsigned short *,unsigned short *,long,struct tagVARIANT *,struct tagVARIANT *):
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15588)
<Exception>
<Type>Opalis::Exception</Type>
<Location>
long __thiscall CODBDataStore::internalSetExecutionDataBulk(unsigned short *,unsigned short *,long,const class ATL::CComSafeArray<unsigned short *,8> &,const class ATL::CComSafeArray<struct tagVARIANT,12> &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15928)
</Location>
<MsgCode>Cannot set execution data</MsgCode>
<Prev><Exception>
<Type>Opalis::Exception</Type>
<Location>
class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>IDispatch error #3105</Param>
<Param>The requested properties cannot be supported.</Param>
<Param>-2147217887</Param>
</Params>
</Exception></Prev>
</Exception>

2012-11-06 21:31:27 [4680] 1 DBDataStore: ::Error #-2147217887
Description: The requested properties cannot be supported.
Source: Microsoft OLE DB Provider for SQL Server


2012-11-06 21:31:27 [4680] 1 Exception caught in void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(230):
<Exception>
<Type>Opalis::Exception</Type>
<Location>
void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(228)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>Unspecified error</Param>
<Param></Param>
<Param>-2147467259</Param>
</Params>
</Exception>

2012-11-06 21:31:55 [3904] 1 Exception caught in class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033):
<Exception><Type>_com_error</Type><ErrorMessage>IDispatch error #3105</ErrorMessage><Description>The requested properties cannot be supported.</Description><HResult>-2147217887</HResult></Exception>

2012-11-06 21:31:55 [3904] 1 DBDataStore: ::Exception caught in long __stdcall CODBDataStore::SetExecutionDataBulk(unsigned short *,unsigned short *,long,struct tagVARIANT *,struct tagVARIANT *):
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15588)
<Exception>
<Type>Opalis::Exception</Type>
<Location>
long __thiscall CODBDataStore::internalSetExecutionDataBulk(unsigned short *,unsigned short *,long,const class ATL::CComSafeArray<unsigned short *,8> &,const class ATL::CComSafeArray<struct tagVARIANT,12> &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15928)
</Location>
<MsgCode>Cannot set execution data</MsgCode>
<Prev><Exception>
<Type>Opalis::Exception</Type>
<Location>
class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>IDispatch error #3105</Param>
<Param>The requested properties cannot be supported.</Param>
<Param>-2147217887</Param>
</Params>
</Exception></Prev>
</Exception>

2012-11-06 21:31:55 [3904] 1 DBDataStore: ::Error #-2147217887
Description: The requested properties cannot be supported.
Source: Microsoft OLE DB Provider for SQL Server


2012-11-06 21:31:55 [3904] 1 Exception caught in void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(230):
<Exception>
<Type>Opalis::Exception</Type>
<Location>
void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(228)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>Unspecified error</Param>
<Param></Param>
<Param>-2147467259</Param>
</Params>
</Exception>

2012-11-06 21:31:58 [4680] 1 Exception caught in class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033):
<Exception><Type>_com_error</Type><ErrorMessage>IDispatch error #3105</ErrorMessage><Description>The requested properties cannot be supported.</Description><HResult>-2147217887</HResult></Exception>

2012-11-06 21:31:58 [4680] 1 DBDataStore: ::Exception caught in long __stdcall CODBDataStore::SetExecutionDataBulk(unsigned short *,unsigned short *,long,struct tagVARIANT *,struct tagVARIANT *):
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15588)
<Exception>
<Type>Opalis::Exception</Type>
<Location>
long __thiscall CODBDataStore::internalSetExecutionDataBulk(unsigned short *,unsigned short *,long,const class ATL::CComSafeArray<unsigned short *,8> &,const class ATL::CComSafeArray<struct tagVARIANT,12> &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(15928)
</Location>
<MsgCode>Cannot set execution data</MsgCode>
<Prev><Exception>
<Type>Opalis::Exception</Type>
<Location>
class _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID const _GUID_00000556_0000_0010_8000_00aa006d2ea4> > __thiscall CODBDataStore::OpenRecordsetForBatchUpdate(const class _bstr_t &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(16033)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>IDispatch error #3105</Param>
<Param>The requested properties cannot be supported.</Param>
<Param>-2147217887</Param>
</Params>
</Exception></Prev>
</Exception>

2012-11-06 21:31:58 [4680] 1 DBDataStore: ::Error #-2147217887
Description: The requested properties cannot be supported.
Source: Microsoft OLE DB Provider for SQL Server


2012-11-06 21:31:58 [4680] 1 Exception caught in void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(230):
<Exception>
<Type>Opalis::Exception</Type>
<Location>
void __thiscall ActionServerStorageDB::setExecutionData(const class ExecutionDataBatch &)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\OpalisActionService2\ActionServerStorageDB.cpp(228)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>Unspecified error</Param>
<Param></Param>
<Param>-2147467259</Param>
</Params>
</Exception>

Creating new trace log file

 

November 8th, 2012 4:20pm

Hi Herwin,

You said you have change the number of policies from 50 to 100 - did you use the command line utlity to do on all the action servers ?

Did you restart the action services after the change - without restart of the action service - it wont reflect from 50 to 100 .

Free Windows Admin Tool Kit Click here and download it now
November 9th, 2012 10:23am

Hi,

the log you posted indicates errors communicating with the Opalis Datastore. So you see any errors in the tab Events in the Opalis Client (Designer).

Best regards,

Stefan

November 9th, 2012 10:32am

Hi mukesh,

I used the command line utility to do this as well as the registry. I also restarted the action service as well as server because I also changed the desktop heap.

Free Windows Admin Tool Kit Click here and download it now
November 13th, 2012 7:04am

Hi Stefan,

I studied the db errors I was receiving and I think this is not related to my issue. The db errors I was receiving was due to the schedule log purging I set in opalis.

So I guess Im stuck. It is not happening recently but Im worried. I modularize my policies so it uses a lot of trigger policies. I cannot afford for it to return null when the triggered policy didnt have an issue at all.

November 13th, 2012 7:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics