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
|