• 고객센터
  • 교육
  • 매뉴얼
  • 데모
  • 제품소개
글 수 497

Toinb 로그가 남지 않습니다.

박수정
조회 수 : 3917
2007.08.31 (02:03:43)
게시판을 이용해 주셔서 감사합니다.
다음양식에 맞게 입력해주세요.

* 고객시스템명 : SDI 브라운관 SFC
* TOInB 버전 : 4.0.1.2.3
* 서버 Platform : AIX
* 문의 유형(질문/요청/참조) : toinb server log
* 내용 :
toinb 로그가 남지 않습니다.
다른 Service Group은 Group_TB_SE.log 에 모두 로그를 남기고 있지만,
해외법인 한곳에서만 로그가 남지않습니다.
아래와 같은 로그만 계속 남기고 있습니다.
어느부분은 확인해야 하는지 알려주세요..

####### TB_se_ora Started [DYNAMIC] #######
####### TB_se_ora Started [DYNAMIC] #######
####### TB_se_ora Started [DYNAMIC] #######
####### TB_se_ora Started [DYNAMIC] #######
####### TB_se_ora Started [DYNAMIC] #######
####### TB_se_ora Started [DYNAMIC] #######
####### TB_se_ora Started [DYNAMIC] #######
####### TB_se_ora Started [DYNAMIC] #######


[07/08/31-03:04:09 RPSTAC02_S02(119)] [07/08/31-03:04:32 RPSTAC02_S04(95)] [07/08/31-03:04:44 RPSTAC
02_S04(95)] [07/08/31-03:04:49 RPSTAC02_S04(95)] [07/08/31-03:05:17 RPSTAC02_S04(95)] [07/08/31-03:0
5:27 RPSTAC02_S04(95)] [07/08/31-03:05:37 RPSTAC02_S04(95)] [07/08/31-03:06:09 RPSTAC02_S04(95)] [07
/08/31-03:06:18 RPSTAC02_S04(95)] [07/08/31-03:06:58 RPSTAC02_S04(95)] [07/08/31-03:07:18 RPSTAC02_S
04(95)] [07/08/31-03:07:57 RPSTAC02_S04(95)] ####################################################


   toinb 27662 76554   0   Aug 29      -  0:00 TB_se_ora PROC_STATIC 7 unisfc_dev 0 OFF
   toinb 28564 55186   0 03:08:15      -  0:00 TB_som PROC_STATIC 6 unisfc 0 OFF
   toinb 36364 76554   0   Aug 29      -  0:00 TB_se_ora PROC_STATIC 6 unisfc_dev 0 OFF
   toinb 36942 70728   0   Aug 29      -  0:00 TB_som PROC_STATIC 7 unisfc_dev 0 OFF
   toinb 55186     1   0 03:08:15      -  0:00 TB_svcd unisfc SOM
   toinb 57178 88398   0 03:08:13      -  0:01 TB_se_ora PROC_STATIC 10 unisfc 0 OFF
   toinb 65396 68616   2 03:13:44  pts/6  0:00 grep unisfc
   toinb 66136 88398   0 03:08:13      -  0:04 TB_se_ora PROC_STATIC 9 unisfc 0 OFF
   toinb 70728     1   0   Aug 29      -  0:00 TB_svcd unisfc_dev SOM
   toinb 73040 88398  19 03:08:13      -  1:00 TB_se_ora PROC_STATIC 6 unisfc 0 OFF
   toinb 73558 88398   0 03:08:13      -  0:11 TB_se_ora PROC_STATIC 8 unisfc 0 OFF
   toinb 76554     1   0   Aug 29      -  0:00 TB_svcd unisfc_dev SE
   toinb 79434 70728   0   Aug 29      -  0:00 TB_som PROC_STATIC 6 unisfc_dev 0 OFF
   toinb 82004 88398   3 03:08:13      -  0:29 TB_se_ora PROC_STATIC 7 unisfc 0 OFF
   toinb 87190 55186   0 03:08:15      -  0:00 TB_som PROC_STATIC 7 unisfc 0 OFF
   toinb 88398     1   0 03:08:13      -  0:01 TB_svcd unisfc SE



--------------------------------------------------------------------------------------------------
[svc_main]
int service_main (TB_SESSION_PGV *spgv)
{
    /*-----------------------------------------------------------*
     * Starting EVENT
     *-----------------------------------------------------------*/

        if (TB_on_work(spgv) == TB_FAIL) return (TB_on_error(spgv));

        return (TB_SUCC);
}

[event]
/*  상기 프로그램에 대한 저작권을 포함한 지적재산권은 삼성SDS(주)에 있으며,
    삼성SDS(주)가 명시적으로허용하지 않은 사용, 복사, 변경, 제3자에의 공개,
    배포는 엄격히 금지되며, 삼성SDS(주)의 지적재산권 침해에 해당됩니다.
    (Copyright ⓒ 2007 Samsung SDS Co., Ltd. All Rights Reserved| Confidential)
    You are strictly prohibited to copy, disclose, distribute, modify,
    or use  this program in part  or as a whole without the prior written consent
    of Samsung SDS Co., Ltd. Samsung SDS Co., Ltd.,  
    owns the intellectual property rights in and to this program.  
    (Copyright ⓒ 2007 Samsung SDS Co., Ltd. All Rights Reserved| Confidential)  
    
    Program ID         : SVC_PureDirect_Rate.c
    Program Name       : 직통율
    Programer          : Crystal.Park
    Create Date        : 2007.01.02
    Update Date        : 2007.05.17 by Crystal.Park(개발번호 I20070511-003 에 의거)
*/
TB_BOOL SVC_PureDirect_Rate_TB_on_work ( TB_SESSION_PGV *spgv )
{
        EXEC SQL BEGIN DECLARE SECTION;
                double  Temp_rate;
                char sqlstmt[4096];
        EXEC SQL END DECLARE SECTION;
        
        char  Screen_chk, Tube_chk, Coating_chk, Itc_chk, Total_chk;
        
        Q_good_old  = 1;
        S_rate      = 1; T_rate = 1; C_rate = 1; I_rate = 1;
        Screen_chk  = 'N'; Tube_chk = 'N'; Coating_chk = 'N'; Itc_chk = 'N'; Total_chk = 'N';
                        
        memset(sqlstmt, NULL, sizeof(sqlstmt));
        sprintf(sqlstmt,  "%s\n  SELECT  A.I_PROCESS,    ", sqlstmt);
        sprintf(sqlstmt,  "%s\n          C.F_CONTROL_1,    ", sqlstmt);
        sprintf(sqlstmt,  "%s\n          C.S_ORDER,    ", sqlstmt);
        sprintf(sqlstmt,  "%s\n          SUM(Q_GOOD) + SUM(Q_DEFECT)  Q_WORK,   ", sqlstmt);
        sprintf(sqlstmt,  "%s\n          SUM(Q_GOOD_1ST) Q_GOOD,   ", sqlstmt);
        sprintf(sqlstmt,  "%s\n          SUM(Q_INPUT_1ST+Q_INPUT_2ND+Q_INPUT_3RD+Q_INPUT_4TH+Q_INPUT_5TH) Q_INPUT,   ", sqlstmt);
        sprintf(sqlstmt,  "%s\n          ROUND(DECODE(SUM(Q_INPUT_1ST+Q_INPUT_2ND+Q_INPUT_3RD+Q_INPUT_4TH+Q_INPUT_5TH),0,0,SUM(Q_GOOD_1ST) /SUM(Q_INPUT_1ST+Q_INPUT_2ND+Q_INPUT_3RD+Q_INPUT_4TH+Q_INPUT_5TH)) ,4)   ", sqlstmt);
        sprintf(sqlstmt,  "%s\n  FROM RPPOPA02 A, RPMASA24 B, RPMASA05 C   ", sqlstmt);
        sprintf(sqlstmt,  "%s\n  WHERE A.D_WORK_D between '%s' AND '%s' AND   ", sqlstmt,As_start_date,As_end_date);
        sprintf(sqlstmt,  "%s\n        A.I_PLANT = '%s'  AND                  ", sqlstmt,As_plant);
        sprintf(sqlstmt,  "%s\n        A.I_FACTORY = NVL('%s',A.I_FACTORY) AND             ", sqlstmt,As_factory);
        sprintf(sqlstmt,  "%s\n        A.I_LINE = NVL('%s',A.I_LINE) AND                  ", sqlstmt,As_line);
        sprintf(sqlstmt,  "%s\n        B.I_INCH = NVL('%s',B.I_INCH) AND                 ", sqlstmt,As_inch);
        if(strcmp(As_prod_kind,"Z") == 0){
          sprintf(sqlstmt,  "%s\n        B.I_PROD_KIND NOT IN ('M','*') AND                ", sqlstmt,As_prod_kind);
        }else{
          sprintf(sqlstmt,  "%s\n        B.I_PROD_KIND = NVL('%s',B.I_PROD_KIND) AND                ", sqlstmt,As_prod_kind);
        }
        if(strcmp(AS_MULTI_PROD_TYPE,"Y") == 0) {
                sprintf(sqlstmt,  "%s\n        I_PROD_TYPE NOT IN ('%s')        AND      ", sqlstmt,As_prod_type);
        } else{
                sprintf(sqlstmt,  "%s\n        I_PROD_TYPE = NVL('%s', I_PROD_TYPE)        AND      ", sqlstmt,As_prod_type);
        }
        if(strcmp(AS_MULTI_PROD_GRP,"Y") == 0) {
          sprintf(sqlstmt,  "%s\n        B.I_PROD_GRP NOT IN ('%s') AND       ", sqlstmt,As_prod_grp);
        } else{
          sprintf(sqlstmt,  "%s\n        B.I_PROD_GRP = NVL('%s',B.I_PROD_GRP) AND       ", sqlstmt,As_prod_grp);
        }
        sprintf(sqlstmt,  "%s\n        DECODE(I_PROD_TYPE, 'N','N','S','N', 'G','G','P') LIKE NVL('%s','%c') AND   ", sqlstmt,As_s_type,'%');
        sprintf(sqlstmt,  "%s\n        A.I_PLANT = B.I_PLANT AND   ", sqlstmt);
        sprintf(sqlstmt,  "%s\n        A.I_PROCESS = B.I_PROCESS AND   ", sqlstmt);
        sprintf(sqlstmt,  "%s\n        A.I_PRODUCT = B.I_PRODUCT AND    ", sqlstmt);
        sprintf(sqlstmt,  "%s\n        A.I_PLANT = C.I_PLANT AND   ", sqlstmt);
        sprintf(sqlstmt,  "%s\n        A.I_PROCESS = C.I_PROCESS AND   ", sqlstmt);
        sprintf(sqlstmt,  "%s\n        C.F_CONTROL_1 IN ('S','T','C','I')  AND    ", sqlstmt);
        sprintf(sqlstmt,  "%s\n        A.I_PROCESS NOT IN ('039')   ", sqlstmt);
        sprintf(sqlstmt,  "%s\n  GROUP BY A.I_PROCESS, C.F_CONTROL_1, C.S_ORDER   ", sqlstmt);
        sprintf(sqlstmt,  "%s\n  ORDER BY S_ORDER ASC    ", sqlstmt);
        TBL_Prn (tb_stderr, "%s",sqlstmt);
        
        EXEC SQL PREPARE DIRECT FROM :sqlstmt;
        EXEC SQL declare CUR_DIRECT cursor for DIRECT;
        EXEC SQL OPEN CUR_DIRECT;
        
        EXEC SQL FETCH CUR_DIRECT INTO
                :I_process, :F_control, :S_order, :Q_work, :Q_good, :Q_input, :Q_good_r;
                        
        for ( ; ; ) {
                 
            if (TBL_ERROR_CODE != 0) break;
        
                /* Crystal.Park(개발번호 I20070511-003 에 의거)
                   前공정 양품수 대비 당공정의 투입수가 30% 미만일 때는 직통율 산출에서 제외 */
                if ((Q_good_old * 0.3 <= Q_work) && (Q_good > 0)){
                        if((Q_good != 0) && (Q_work != 0)){
                                if(Q_good_r > 1 ) Q_good_r = 1 ;
                                   if (strncmp(F_control, "S", 1) == 0) {
                                                   TBL_Prn (tb_stderr, "111.S_rate:%f Q_good_r:%f\n",S_rate, Q_good_r);
                                        S_rate = S_rate *  Q_good_r;
                                        Screen_chk = 'Y';
                                        TBL_Prn (tb_stderr, "222.S_rate:%f \n",S_rate);
                                } else if (strncmp(F_control, "T", 1) == 0) {
                                        T_rate = T_rate * Q_good_r;
                                        Tube_chk = 'Y';
                                } else if (strncmp(F_control, "C", 1) == 0) {
                                        C_rate = C_rate * Q_good_r;
                                        Coating_chk = 'Y';
                                } else if (strncmp(F_control, "I", 1) == 0) {
                                        I_rate = I_rate * Q_good_r;
                                        Itc_chk = 'Y';
                                }
                                Q_good_old = Q_good;
                        }
                }
                TBL_Prn (tb_stderr, "S_rate:%f , T_rate:%f,  C_rate:%f, I_rate:%f\n",S_rate,T_rate,C_rate,I_rate);
            

        
        
        EXEC SQL FETCH CUR_DIRECT INTO
                :I_process, :F_control, :S_order, :Q_work, :Q_good, :Q_input, :Q_good_r;
        }
        EXEC SQL CLOSE CUR_DIRECT;
        
        
        if ( Screen_chk == 'Y' ) {
                sprintf(Screen_Rate,"%10.2f\n",S_rate * 100);
        } else {
                sprintf(Screen_Rate,"%10.2f\n",0);
        }
        if ( Tube_chk == 'Y' ) {
                sprintf(Tube_Rate,"%10.2f\n",T_rate * 100);
        } else {
                sprintf(Tube_Rate,"%10.2f\n",0);
        }
        if ( Coating_chk == 'Y' ) {
                sprintf(Coating_Rate,"%10.2f\n",C_rate * 100);
        } else {
                sprintf(Coating_Rate,"%10.2f\n",0);
        }
        if ( Itc_chk == 'Y' ) {
                sprintf(Itc_Rate,"%10.2f\n",I_rate * 100);
        } else {
                sprintf(Itc_Rate,"%10.2f\n",0);
        }
        
        /******* SDIB Custom. 2007.05.28 by M.S.A.*****/
        if(S_rate == 0){
                S_rate = 1;
        }else if(T_rate == 0){
                T_rate = 1;
        }else if(C_rate == 0){
                C_rate = 1;
        }else if(C_rate == 0){
                I_rate = 1;
        }                
        /**********************************************/
        sprintf(Total_Direct_Rate,"%10.2f\n",S_rate * T_rate *  C_rate * I_rate * 100);
  
    
    TBL_send_row();
    
        return (TB_SUCC);
}
[log]
GetReq ret[1], svc_name[SVC_Direct_Rate],control[O:output=out], protocol[2220]
COMMIT
COMMUNICATE FINISH
GetReq ret[1], svc_name[SVC_PureDirect_Rate],control[O:output=out], protocol[2220]
[07/08/31-03:30:32 SVC_PureDirect_Rate(77)] [07/08/31-03:30:32 SVC_PureDirect_Rate(135)] [07/08/31-03:30:32 SVC_PureDirect_Rate(138)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] [07/08/31-03:30:32 SVC_PureDirect_Rate(135)] [07/08/31-03:30:32 SVC_PureDirect_Rate(138)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] [07/08/31-03:30:32 SVC_PureDirect_Rate(135)] [07/08/31-03:30:32 SVC_PureDirect_Rate(138)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] [07/08/31-03:30:32 SVC_PureDirect_Rate(135)] [07/08/31-03:30:32 SVC_PureDirect_Rate(138)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] [07/08/31-03:30:32 SVC_Pu
reDirect_Rate(152)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] [07/08/31-03:30:32 SVC_PureDirect_Rate(152)] COMMIT
COMMUNICATE FINISH
이 게시물을...
http://member.shift.co.kr/index.php?document_srl=100197 (*.241.147.16)
댓글 [0]
  목록
 
첫 페이지 1 2 3 4 5 6 7 8 9 10 끝 페이지
Tag List
목록 쓰기
XE Login