商云方的技术博客 (沪ICP备14046774号-1)

/*******************************************************************************
date : 2007-04-25
处理者: yunfang.shang
*******************************************************************************/

现象：

在 INV-〉SETUP-〉Transactions ->Interface Manager 中把Material transaction启动
Material transaction 变成有效状态
但是 Material transaction 在运行一次后又自动失效了。

由于 Material transaction 未能始终处于有效状态，所以导致很多接口数据未能被处理。
用户需要在启动Material transaction时，让并发请求处于周期运行的方式。
用户觉得比较怪。因为正常情况是启动管理器以后，管理器就应该始终处于有效状态。不需要人为的把并发请求设置为周期运行的。

分析：
查Metalink, 关键词： Material transaction inactive
所查到的都是2004年及以前的与此类似的现象，都是说要打个patch 1734240 解决此问题。
但现在是11.5.10.2版本，这个patch肯定早已经包含在某个patch set中了，故肯定不是这个问题。

 

在 INV-〉SETUP-〉Transactions ->Interface Manager
选择Material transaction  再选择 tools->启动。
出现一个pengding的并发请求：处理事务处理接口
查其管理器是：库存管理员
查库存管理员的管理器日志：

***********************************************************************
This concurrent manager cannot run the following registered, immediate
concurrent programs
because they are not linked to this concurrent
manager’s library “INVLI BR”
Cause:  The immediate concurrent programs listed have been registered
th
***********************************************************************
 
Application          Concurrent Program           

  
INV                  INCDCM                       
  
BOM                  CMCCTM                       

+—————————————————————————+

在Metalink 中查关键词：
This concurrent manager cannot run the following registered, immediate
concurrent programs because they are not linked to this concurrent
manager’s library “INVLIBR”

Note:149664.1 有关于此问题的描述：

 TIP:  Click help for a detailed explanation of this page.
 Bookmark Go to End

Subject:  Cost And Material Transaction Managers Switching Off Occasionally
  Doc ID:  Note:149664.1 Type:  PROBLEM
  Last Revision Date:  11-AUG-2007 Status:  ARCHIVED
Checked for relevance 11-AUG-2007
fact: Oracle Cost Management 11.5.2
fact: INCDCM – Process demand interface
fact: CMCCTM – Resource Cost Manager
fact: INVMGR – Concurrent Manager
fact: INVLIBR – Inventory Manager
symptom: Cost and Material Transaction managers switching off occasionally
symptom: This concurrent manager cannot run the following registered,
immediate
concurrent programs because they are not linked to this concurrent
manager’s library &’;INVLIBR&’;
change: NOTE ROLE:

Concurrent log file have following error

+—————————————————————————+
Application Object Library: Concurrent Processing version 11.5
Copyright (c)1979, 1999, Oracle Corporation. All rights reserved.
INVMGR Concurrent Manager started : 13-DEC-2000 13:13:57
+—————————————————————————+
***********************************************************************
This concurrent manager cannot run the following registered, immediate
concurrent programs because they are not linked to this concurrent
manager’s library “INVLIBR”

cause:  The immediate concurrent programs listed have been registered th
***********************************************************************
Application          Concurrent Program           
   INV                  INCDCM                       
   BOM             CMCCTM

 

fix:

Apply patch 1400569.

但是查patch 1400569 发现此patch 已经被包含在11.5.10和11.5.10.2的patch set中了，而目前是11.5.10.2
理论上这个patch已经被应用过了。

况且这篇Note的最后更新日期是2007-8-11。为什么还建议我们打patch 1400569；难道是在这些patchset中，没有真的包括进去？

找个测试环境先打了再说

打过以后再试，没有用，还是老样子。

 
 
Note:369225.1 对此类问题也有描述

SolutionTo implement the solution, please execute the following steps in a Test environment first:

1) Log into Applications and choose the Application Developer responsibility
2) Navigate to Concurrent > Library
3) From the Toolbar View > Query by Example > Enter
4) Enter Library Name = INVLIRB
5) Hit Ctrl F11
6) Highlight the row with Program = INCDCM
7) From the Toolbar Edit > Delete
8) Highlight the row with Program = CMCCTM
9) From the Toolbar Edit > Delete
10) Click the Save icon
11) Click the Rebuild Library button
12) From the OS level as the applmgr user, use the adadmin utility, choose
option 2 ‘Maintain Applications Files menu’, then choose option 3 ‘Relink
Application Programs’, at the prompt ‘Enter list of products to link’ enter
INV, at the prompt ‘Generate specific executables for each selected product’
enter Yes, at the prompt ‘Enter executables to relink’ enter INVLIRB,
otherwise use all of the defaults
13) Cycle the concurrent managers

操作第11步的时候，报错：

Cannot rebuild program library with missing subroutine names. One or more concurrent programs assigned to this program library are not registered with subroutine name

Assign subroutine names for all then concurrent programs assigned to this program library from “Define Concurrent Program Excutable” form

在可执行定义出查:
并发程序 CMCOCW 对应的可执行是CMCCTW。
CMCOCW：制造成本事务处理工作流程
CMCCTW：资源成本事务处理工作流程

而这个程序库中已经包含了一个CMCCTW的并发程序，这个并发程序对应的可执行是CMCCTW

难道是CMCOCW这个并发程序对应的可执行选错了？

先不管它。执行12步
12步执行成功，再试，还是老样子。库存接口管理器中的物料事务处理器还是不能自动变成有效（如果你不把”处理事务处理接口”并发程序设置成周期运行的话。

不过查看并发管理器“库存管理员”的日志，发现已经没有错误了。只可惜解决这个问题对我们没有什么帮助。

因为我们要解决的是让“库存接口管理器中的物料事务处理器始终处于有效状态”

Metalink对此问题没有更好的方法。有些文档也是建议在提交“物料事务处理器”并发请求的时候做计划。

Note:204379.1 是2004年的贴子，建议打个Patch : 1734240  来解决问题。

查Patch 1734240 ,发现其已经被最新的Patch 5473858 替代。Patch 5473858 是个大Patch.