Orchestrator „Send Platform Event“ Activity with SC2016 UR4 or SC2012R2 UR14

When Update Rollup 4 for System Center 2016 Orchestrator or Update Rollup 14 for System Center 2012 R2 Orchestrator is installed you must ensure that SQL Server Native Client is installed and reconfigure the connection to Orchestrator DB with “Data Store Configuration” in some cases, see: Update Rollup 4 for System Center 2016 Orchestrator is available.

There’s also an issue with the „Send Platform Event“ Activity with SC2016 UR4 or SC2012R2 UR14:
The Activity executes successfully and is green in Log or ‘Log History’, but the Event is not created. Int the tracelog RunbookService (C:\ProgramData\Microsoft System Center 2012\Orchestrator\RunbookService.exe\Logs) there’s something similar as:

Process ID: …
Version : 7.3.185.0
Computer : …
User : Domain\SCOSVC

2017-12-14 16:48:51 [3456] 1 DBDataStore: ::Exception caught in long __stdcall CODBDataStore::ReportEventW(struct tagVARIANT):
ODBDataStore.cpp(4935)
<Exception><Type>_com_error</Type><ErrorMessage>Unknown error 0x800A0E7C</ErrorMessage><Description>Parameter object is improperly defined. Inconsistent or incomplete information was provided.</Description><HResult>-2146824580</HResult></Exception>

2017-12-14 16:48:51 [3456] 1 Exception caught in void __cdecl OpalisEventDeliveryStrategyComposite::sendAndTraceExceptions(const class OpalisEventDeliveryStrategy &,const class OpalisEvent &,const class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> > &)
OpalisEventDeliveryStrategyComposite.cpp(78):
<Exception>
<Type>Opalis::Exception</Type>
<Location>
void __cdecl OpalisEventDeliveryStrategyComposite::sendAndTraceExceptions(const class OpalisEventDeliveryStrategy &,const class OpalisEvent &,const class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> > &)
OpalisEventDeliveryStrategyComposite.cpp(75)
</Location>
<MsgCode>Cannot deliver Opalis Event</MsgCode>
<Params>
<Param>EW</Param>
</Params>
<Prev><Exception>
<Type>Opalis::Exception</Type>
<Location>
void __cdecl StorageCallExecutor::throwChained(const class Opalis::Exception &)
StorageCallExecutor.cpp(42)
</Location>
<MsgCode>SCE: ActionServerStorage call failed</MsgCode>
<Prev><Exception>
<Type>Opalis::Exception</Type>
<Location>
void __thiscall OpalisEventDeliveryStrategyDBDataStore::sendOpalisEvent(const class OpalisEvent &) const
OpalisEventDeliveryStrategyDBDataStore.cpp(75)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>Unknown error 0x800A0E7C</Param>
<Param></Param>
<Param>-2146824580</Param>
</Params>
</Exception></Prev>
</Exception></Prev>
</Exception>

Thanks a lot to PIfM who has replied how to fix this in the Orchestrator Technet Forum:
Alter the Stored Procedure sp_insertevent  Change „@message nvarchar(max)“ to „@message nvarchar(4000)“.

Starten Sie jetzt Ihren Weg zu Azure!

Los geht's

top