Not Able Run TM Allignment For Internal Division (Doc ID 1488081.1)

Last updated on JANUARY 27, 2017

Applies to:

Siebel Territory Management - Version 7.8.2.14 SIA[19251] and later
Information in this document applies to any platform.

Symptoms

We have created new territories and executed TM process to align the contacts. "RUN Alignment " completed successfully, however when we try to activate the alignment, we are getting error as " Activation failed" each time activation failing at step " moving territory rules". error log says that, ODBC error and U1 violation as null values inserting into S_TERR_CON table:

WfProcMgr_110144.log 7.8.2.14 [19251] ENU

SrmLayerLog Error 1 0 2012-02-09 23:04:48 (smisched.cpp(828) err=3006 sys=0) (smisched.cpp: 828) error code = 3006, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

SrmLayerLog Error 1 0 2012-02-09 23:04:48 (rtieng.cpp(3763) err=3006 sys=2) (rtieng.cpp: 3763) error code = 3006, system error = 2, msg1 = DICInsRowExecStmt, msg2 = (null), msg3 = (null), msg4 = (null)

SrmLayerLog Error 1 0 2012-02-09 23:04:48 (rtieng.cpp(4192) err=3006 sys=0) (rtieng.cpp: 4192) error code = 3006, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

SrmLayerLog Error 1 0 2012-02-09 23:04:48 (rtisrvr.cpp(1444) err=3006 sys=0) (rtisrvr.cpp: 1444) error code = 3006, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

SrmLayerLog Error 1 0 2012-02-09 23:04:48 (rtisrvr.cpp(1369) err=3006 sys=0) (rtisrvr.cpp: 1369) error code = 3006, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

SrmLayerLog Error 1 0 2012-02-09 23:04:48 (rtisrvr.cpp(1110) err=3006 sys=0) (rtisrvr.cpp: 1110) error code = 3006, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

SrmLayerLog Error 1 0 2012-02-09 23:04:48 (rtisrvr.cpp(1601) err=3006 sys=0) (rtisrvr.cpp: 1601) error code = 3006, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

SrmLayerLog Error 1 0 2012-02-09 23:04:48 (smisched.cpp(800) err=3006 sys=0) (smisched.cpp: 800) error code = 3006, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

GenericLog GenericError 1 0 2012-02-09 23:04:48 (srmconn.cpp (3049) err=3006 sys=0) SBL-GEN-03006: (rtieng.cpp: 3763) error code = 3006, system error = 2, msg1 = DICInsRowExecStmt, msg2 = (null), msg3 = (null), msg4 = (null)

GenericLog GenericError 1 0 2012-02-09 23:04:48 (srmconn.cpp (2703) err=3006 sys=0) SBL-GEN-03006: (rtieng.cpp: 3763) error code = 3006, system error = 2, msg1 = DICInsRowExecStmt, msg2 = (null), msg3 = (null), msg4 = (null)

GenericLog GenericError 1 0 2012-02-09 23:04:48 (srmconn.cpp (2303) err=3006 sys=0) SBL-GEN-03006: (rtieng.cpp: 3763) error code = 3006, system error = 2, msg1 = DICInsRowExecStmt, msg2 = (null), msg3 = (null), msg4 = (null)

ObjMgrLog Error 1 0 2012-02-09 23:04:48 (stepexec.cpp (812)) SBL-BPR-00162: Error invoking service 'Alignment Management Service', method 'Move Mappings' at step 'Moving Mappings'.

ObjMgrLog Error 1 0 2012-02-09 23:04:48 (stepexec.cpp (383)) SBL-BPR-00186: Step 'Stop:Process Failed' references non-existent error symbol 'TM_WF_ERR_PROCESS_FAILED'.

GenericLog GenericError 1 0 2012-02-09 23:04:48 Object manager error: ([0] Step 'Stop:Process Failed' references non-existent error symbol 'TM_WF_ERR_PROCESS_FAILED'.(SBL-BPR-00186) (0x80ee))

GenericLog GenericError 1 0 2012-02-09 23:04:48 ( (0) err=4300107 sys=33006) SBL-OMS-00107: Object manager error: ([0] Step 'Stop:Process Failed' references non-existent error symbol 'TM_WF_ERR_PROCESS_FAILED'.(SBL-BPR-00186) (0x80ee))

GenericLog GenericError 1 0 2012-02-09 23:04:48 (bsvcmgr.cpp (1339) err=4300203 sys=0) SBL-OMS-00203: Error 33006 invoking method "RunProcess" for Business Service "Workflow Process Manager"

MajTerrMergeMgr_110145.log 7.8.2.14 [19251] ENU

SQLError Statement 0 0 2012-02-09 23:04:47 SQL Statement:
INSERT INTO SIEBEL.S_TERR_CON (COMMENTS, CONFLICT_ID, CON_ID, CREATED, CREATED_BY, EFF_END_DT, EFF_START_DT, FROM_TERR_ID, LAST_UPD, LAST_UPD_BY, MODIFICATION_NUM, ROW_ID, TERR_ID)

VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SQLError Bind Variables 1 0 2012-02-09 23:04:47 01:
02:0
03:1-1E3-85588
04:2012-02-09 23:04:47
05:0-1
06:
07:2012-02-07 14:00:00
08:
09:2012-02-09 23:03:51
10:0-1
11:0
12:1-MO12-89M
13:1-F8PQWJ


DBCLog DBCLogError 1 0 2012-02-09 23:04:47 [DataDirect][ODBC Oracle driver][Oracle]ORA-00001: unique constraint (SIEBEL.S_TERR_CON_U1) violated

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms