Siebel SQLs/Error Messages >  Batch Assignment Component Is No Longer Running with Error SBL-GEN-03006

Batch Assignment Component Is No Longer Running with Error SBL-GEN-03006

APPLIES TO:
Siebel Assignment Manager - Version 7.8.2.14[19251] to 8.2.2.3 SIA [23021] [Release V7 to V8]
Information in this document applies to any platform.
**checked for currency 25-JUNE-2013**
SYMPTOMS
On : 7.8.2.14[19251] version, Assignment Manager

When attempting to run batch assignment, the component job fails
the following error occurs.

ERROR
-----------------------
SBL-GEN-03006


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Start BatchAsgn.
2. Error shows in log and component fails


CAUSE


There was a problem with the number of primary components in the TM Asset Workflow Policy Object. A workflow policy object can only have 1 workflow policy compoennt designated as primary.


The log showed the following error:


ProcReq GenericFatal 0 0 2011-07-11 09:10:22 TM Asset in LoadLink

GenericLog GenericError 1 0 2011-07-11 09:10:22 Message: Multiple primary tables defined for object,
Additional Message: TM Asset

ProcReq GenericFatal 0 0 2011-07-11 09:10:22 TM Asset in LoadLink

GenericLog GenericError 1 0 2011-07-11 09:10:22 Message: Failed to load link information for object,
Additional Message: TM Asset


ProcReq GenericFatal 0 0 2011-07-11 09:10:22 TM Asset in Load

GenericLog GenericError 1 0 2011-07-11 09:10:22 Message: Failed to load object definition,
Additional Message: TM Asset


GenericLog GenericError 1 0 2011-07-11 09:10:22 (attrapi.cpp (733) err=700106 sys=2) SBL-ESC-00106: Error loading Attribute handle for Object TM Asset.

GenericLog GenericError 1 0 2011-07-11 09:10:22 (asgnobj.cpp (345) err=3006 sys=0) SBL-GEN-03006: (asgnobj.cpp: 345) error code = 3006, system error = 0, msg1 = WFObjectOpen, msg2 = (null), msg3 = (null), msg4 = (null)


SOLUTION


1. With Siebel Tools pointed at the server database go to Workflow Policy Object and query for TM Asset
2. Expand on left and go to Workflow Policy Component
3. Examine the component, 2 of the listed components (tables) have the primary column checked, there should only be one checked and there should be 1 active component marked primary. In general the correct one is for table s_asset. Clear the one that is checked as extra or activate the primary if marked inactive.
4. Restart both assignment manager Nd batch assignment components and see if the error clears