Maximo

 View Only

maximo760 +birt4.3 Why the birt report cannot be displayed

  • 1.  maximo760 +birt4.3 Why the birt report cannot be displayed

    Posted Wed March 22, 2023 09:27 AM

    "I deployed maximo76 on the intranet at 192.168.1.142:7001. Users access the system through proxy addresses (isolation gateways) 10.108.20.30:1701/maximo."

    The question  is:
    On the intranet: Any Windows system and browser can use birt reports normally;
    However, on the Internet: Users can only access reports in the Window7+IE browser environment.
    Other browsers such as Windows 11/10 use IE browser, Google browser, and Microsoft Edge browser do not preview reports, displaying blank !!


    In the weblogic , when the client report displays blank time, the weblogic console does not execute the dataset SQL statement of the report;

      logs:

    Unable to display reports Weblogic console :

    where userid= 'MAXADMIN' )) and wttype like 'HD%' group by wttypedes
    21 三月 2023 15:43:12:810 [INFO] [MXServer] [CID-CRON-8649] Correlation started.
    21 三月 2023 15:43:12:826 [INFO] [MXServer] [CID-CRON-8649] Correlated data: BEGIN InstanceName:AsyncImmediate TaskName:AsyncImmediateJobCron ElapsedTime:16 ms  END
    21 三月 2023 15:43:16:656 [DEBUG] [MXServer] [] --- reportFile: SYrljx.rptdesign
    21 三月 2023 15:43:16:656 [DEBUG] [MXServer] [] --- reportFile: SYrljx.rptdesign
    21 三月 2023 15:43:16:656 [DEBUG] [MXServer] [] --- reportNum: 1440
    21 三月 2023 15:43:16:656 [DEBUG] [MXServer] [] --- reportNum: 1440
    21 三月 2023 15:43:16:656 [DEBUG] [MXServer] [] --- __newrun: true
    21 三月 2023 15:43:16:656 [DEBUG] [MXServer] [] --- __newrun: true
    21 三月 2023 15:43:16:671 [DEBUG] [MXServer] [] --- comments:
    21 三月 2023 15:43:16:671 [DEBUG] [MXServer] [] --- comments:
    21 三月 2023 15:43:16:671 [DEBUG] [MXServer] [] --- reportname: SYrljx.rptdesign
    21 三月 2023 15:43:16:671 [DEBUG] [MXServer] [] --- reportname: SYrljx.rptdesign
    21 三月 2023 15:43:16:687 [DEBUG] [MXServer] [] --- fromEmail: no
    21 三月 2023 15:43:16:687 [DEBUG] [MXServer] [] --- fromEmail: no
    21 三月 2023 15:43:16:687 [DEBUG] [MXServer] [] --- where: %EF%BE%84%EF%BE%8D%EF%BF%87%12Sa%06%EF%BE%A2%EF%BE%88tiF8%EF%BE%89%EF%BF%A5%22%EF%BF%87%0AZ%EF%BF%B0%23%EF%BF%B4%EF%BE%BA
    %EF%BF%81%EF%BF%B7%EF%BF%8C%EF%BE%A4%EF%BE%B4%07DE%EF%BE%A0%EF%BF%82%EF%BF%B2l%EF%BF%96%EF%BF%BD%19%EF%BF%86%EF%BF%85
    21 三月 2023 15:43:16:687 [DEBUG] [MXServer] [] --- where: %EF%BE%84%EF%BE%8D%EF%BF%87%12Sa%06%EF%BE%A2%EF%BE%88tiF8%EF%BE%89%EF%BF%A5%22%EF%BF%87%0AZ%EF%BF%B0%23%EF%BF%B4%EF%BE%BA
    %EF%BF%81%EF%BF%B7%EF%BF%8C%EF%BE%A4%EF%BE%B4%07DE%EF%BE%A0%EF%BF%82%EF%BF%B2l%EF%BF%96%EF%BF%BD%19%EF%BF%86%EF%BF%85
    21 三月 2023 15:43:16:703 [DEBUG] [MXServer] [] --- mroOrg: JYJT
    21 三月 2023 15:43:16:703 [DEBUG] [MXServer] [] --- mroOrg: JYJT
    21 三月 2023 15:43:16:718 [DEBUG] [MXServer] [] --- redir: /maximo/report/?__report=SYrljx.rptdesign&appname=HDRLJX&__requestid=1679384596640&uisessionid=67&csrftoken=snc7423t9bue9
    j25iiknla2nh2
    21 三月 2023 15:43:16:718 [DEBUG] [MXServer] [] --- redir: /maximo/report/?__report=SYrljx.rptdesign&appname=HDRLJX&__requestid=1679384596640&uisessionid=67&csrftoken=snc7423t9bue9
    j25iiknla2nh2
    21 三月 2023 15:43:16:734 [DEBUG] [MXServer] [] --- mroApp: HDRLJX
    21 三月 2023 15:43:16:734 [DEBUG] [MXServer] [] --- mroApp: HDRLJX
    21 三月 2023 15:43:16:734 [DEBUG] [MXServer] [] --- maxPass: %EF%BF%90%EF%BE%A9%28%EF%BF%A6%11%EF%BE%A9%3Ce%EF%BE%A8Ly%EF%BF%B8%EF%BF%9F%EF%BE%8C%EF%BE%82%EF%BE%8D
    21 三月 2023 15:43:16:734 [DEBUG] [MXServer] [] --- maxPass: %EF%BF%90%EF%BE%A9%28%EF%BF%A6%11%EF%BE%A9%3Ce%EF%BE%A8Ly%EF%BF%B8%EF%BF%9F%EF%BE%8C%EF%BE%82%EF%BE%8D
    21 三月 2023 15:43:16:734 [DEBUG] [MXServer] [] --- redirParams: repositoryType=Enterprise
    21 三月 2023 15:43:16:734 [DEBUG] [MXServer] [] --- redirParams: repositoryType=Enterprise
    21 三月 2023 15:43:16:750 [DEBUG] [MXServer] [] --- customrptServerLogonPass:
    21 三月 2023 15:43:16:750 [DEBUG] [MXServer] [] --- customrptServerLogonPass:
    21 三月 2023 15:43:16:750 [DEBUG] [MXServer] [] --- smtpHost: false
    21 三月 2023 15:43:16:750 [DEBUG] [MXServer] [] --- smtpHost: false
    21 三月 2023 15:43:16:765 [DEBUG] [MXServer] [] --- localTZ: Asia/Shanghai
    21 三月 2023 15:43:16:765 [DEBUG] [MXServer] [] --- localTZ: Asia/Shanghai
    21 三月 2023 15:43:16:765 [DEBUG] [MXServer] [] --- locale: zh_CN
    21 三月 2023 15:43:16:765 [DEBUG] [MXServer] [] --- locale: zh_CN
    21 三月 2023 15:43:16:781 [DEBUG] [MXServer] [] --- reportDesc: 
    21 三月 2023 15:43:16:781 [DEBUG] [MXServer] [] --- reportDesc: 
    21 三月 2023 15:43:16:781 [DEBUG] [MXServer] [] --- mroUniqueKey: 230321154316640_427821
    21 三月 2023 15:43:16:781 [DEBUG] [MXServer] [] --- mroUniqueKey: 230321154316640_427821
    21 三月 2023 15:43:16:796 [DEBUG] [MXServer] [] --- extendedFields: false
    21 三月 2023 15:43:16:796 [DEBUG] [MXServer] [] --- extendedFields: false
    21 三月 2023 15:43:16:796 [DEBUG] [MXServer] [] --- Email_Choice: PDF
    21 三月 2023 15:43:16:796 [DEBUG] [MXServer] [] --- Email_Choice: PDF
    21 三月 2023 15:43:16:796 [DEBUG] [MXServer] [] --- emails:
    21 三月 2023 15:43:16:796 [DEBUG] [MXServer] [] --- emails:
    21 三月 2023 15:43:16:812 [DEBUG] [MXServer] [] --- userName: maxadmin
    21 三月 2023 15:43:16:812 [DEBUG] [MXServer] [] --- userName: maxadmin
    21 三月 2023 15:43:16:812 [DEBUG] [MXServer] [] --- ParmUserName: maximo
    21 三月 2023 15:43:16:828 [DEBUG] [MXServer] [] ReportCancelStatusUpdateThread getting cancelled reports from database
    21 三月 2023 15:43:16:812 [DEBUG] [MXServer] [] --- ParmUserName: maximo
    21 三月 2023 15:43:16:828 [DEBUG] [MXServer] [] --- reportFolder: HDRLJX
    21 三月 2023 15:43:16:828 [DEBUG] [MXServer] [] --- reportFolder: HDRLJX
    21 三月 2023 15:43:16:828 [DEBUG] [MXServer] [] --- qbrDisplayWhere: (WORKTICKETID = 45972)
    21 三月 2023 15:43:16:828 [DEBUG] [MXServer] [] --- qbrDisplayWhere: (WORKTICKETID = 45972)
    21 三月 2023 15:43:16:843 [DEBUG] [MXServer] [] --- schema: maximo
    21 三月 2023 15:43:16:843 [DEBUG] [MXServer] [] --- schema: maximo
    21 三月 2023 15:43:16:843 [DEBUG] [MXServer] [] --- reportType: BIRT
    21 三月 2023 15:43:16:843 [DEBUG] [MXServer] [] --- reportType: BIRT
    21 三月 2023 15:43:16:859 [DEBUG] [MXServer] [] --- appname: HDRLJX
    21 三月 2023 15:43:16:859 [DEBUG] [MXServer] [] --- appname: HDRLJX
    21 三月 2023 15:43:16:859 [DEBUG] [MXServer] [] --- ParmPassword: %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    21 三月 2023 15:43:16:859 [DEBUG] [MXServer] [] --- ParmPassword: %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    21 三月 2023 15:43:16:875 [DEBUG] [MXServer] [] --- mroSite: NYDC
    21 三月 2023 15:43:16:875 [DEBUG] [MXServer] [] --- mroSite: NYDC
    21 三月 2023 15:43:16:875 [DEBUG] [MXServer] [] --- paramdelimiter: ||
    21 三月 2023 15:43:16:875 [DEBUG] [MXServer] [] --- paramdelimiter: ||
    21 三月 2023 15:43:16:890 [DEBUG] [MXServer] [] --- paramstring: appHierarchy=HDRLJX,CUSTAPP
    21 三月 2023 15:43:16:890 [DEBUG] [MXServer] [] --- paramstring: appHierarchy=HDRLJX,CUSTAPP
    21 三月 2023 15:43:16:890 [DEBUG] [MXServer] [] --- __scheduleType: immediate
    21 三月 2023 15:43:16:890 [DEBUG] [MXServer] [] --- __scheduleType: immediate
    21 三月 2023 15:43:16:890 [DEBUG] [MXServer] [] --- isDuplex: 0
    21 三月 2023 15:43:16:890 [DEBUG] [MXServer] [] --- isDuplex: 0
    21 三月 2023 15:43:16:906 [DEBUG] [MXServer] [] --- baseTable: WORKTICKET
    21 三月 2023 15:43:16:906 [DEBUG] [MXServer] [] --- baseTable: WORKTICKET
    21 三月 2023 15:43:16:906 [DEBUG] [MXServer] [] --- customserverURL:
    21 三月 2023 15:43:16:906 [DEBUG] [MXServer] [] --- customserverURL:
    21 三月 2023 15:43:16:921 [DEBUG] [MXServer] [] --- __overwrite: new
    21 三月 2023 15:43:16:921 [DEBUG] [MXServer] [] --- __overwrite: new
    Target valueBIRT67
    21 三月 2023 15:43:17:500 [DEBUG] [MXServer] [] Opening report design.
    21 三月 2023 15:43:17:531 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoReportCodePatcherMaximoReportCodePatcher() entering
    21 三月 2023 15:43:17:531 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoReportCodePatcherMaximoReportCodePatcher() exiting
    21 三月 2023 15:43:17:531 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoReportCodePatcherexecute() entering
    21 三月 2023 15:43:17:547 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoReportCodePatcherstart() entering
    21 三月 2023 15:43:17:547 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoReportCodePatcherstart() exiting
    21 三月 2023 15:43:17:547 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoReportCodePatcherprocess() entering
    21 三月 2023 15:43:17:547 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlink DesignBasePatch() entering
    21 三月 2023 15:43:17:562 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlink DesignBasePatch() exiting
    21 三月 2023 15:43:17:562 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlinkexecute() entering
    21 三月 2023 15:43:17:562 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlinkstart() entering
    21 三月 2023 15:43:17:562 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlinkstart() exiting
    21 三月 2023 15:43:17:578 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlinkstart() exiting
    21 三月 2023 15:43:17:578 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlinkprocess() entering
    21 三月 2023 15:43:17:578 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlinkprocess() exiting
    21 三月 2023 15:43:17:578 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlinkprocess() exiting
    21 三月 2023 15:43:17:594 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlinkcomplete() entering
    21 三月 2023 15:43:17:594 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlinkcomplete() exiting
    21 三月 2023 15:43:17:594 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.util.DesignTraversalV232getReportComments() entering
    21 三月 2023 15:43:17:594 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.util.DesignTraversalV232setReportComments() entering
    21 三月 2023 15:43:18:187 [INFO] [MXServer] [] Saved file
    21 三月 2023 15:43:18:187 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlinkcomplete() exiting
    21 三月 2023 15:43:18:187 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesignPatchHyperlinkexecute() exiting
    21 三月 2023 15:43:18:203 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoReportCodePatcherprocess() exiting
    21 三月 2023 15:43:18:203 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoReportCodePatchercomplete() entering
    21 三月 2023 15:43:18:203 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoReportCodePatchercomplete() exiting
    21 三月 2023 15:43:18:203 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoReportCodePatcherexecute() exiting
    21 三月 2023 15:43:18:219 [DEBUG] [MXServer] [] Opening report design.
    21 三月 2023 15:43:18:234 [DEBUG] [MXServer] [] Opening report design.
    21 三月 2023 15:43:18:250 [DEBUG] [MXServer] [] Opening report design.
    21 三月 2023 15:43:18:281 [DEBUG] [MXServer] [] Identified Parameter with name: (where)
    21 三月 2023 15:43:18:281 [DEBUG] [MXServer] [] Identified Parameter with name: (appname)
    21 三月 2023 15:43:18:281 [DEBUG] [MXServer] [] Identified Parameter with name: (paramdelimiter)
    21 三月 2023 15:43:18:281 [DEBUG] [MXServer] [] Identified Parameter with name: (paramstring)
    21 三月 2023 15:43:18:297 [DEBUG] [MXServer] [] Identified Parameter with name: (usepagebreaks)
    21 三月 2023 15:43:18:875 [DEBUG] [MXServer] []

    Report parameters for RequestID = 1679384596640
    encoding=UTF-8
    schema = maximo
    reportNum = 1440
    mroSite = NYDC
    reportFile = SYrljx.rptdesign
    locale = zh_CN
    extendedFields = false
    fromEmail = no
    emails =
    qbrDisplayWhere = (WORKTICKETID = 45972)
    reportType = BIRT
    appname = HDRLJX
    paramstring = appHierarchy=HDRLJX,CUSTAPP
    reportname = SYrljx.rptdesign
    where = ( ( workticket.workticketid  =  45972 ))
    localTZ = Asia/Shanghai
    ParmUserName = maximo
    maxPass = %EF%BF%90%EF%BE%A9%28%EF%BF%A6%11%EF%BE%A9%3Ce%EF%BE%A8Ly%EF%BF%B8%EF%BF%9F%EF%BE%8C%EF%BE%82%EF%BE%8D
    paramdelimiter = ||
    redirParams = repositoryType=Enterprise
    mroOrg = JYJT
    ParmPassword = %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    customserverURL =
    comments =
    __scheduleType = immediate
    mroUniqueKey = 230321154316640_427821
    baseTable = WORKTICKET
    customrptServerLogonPass =
    userName = maxadmin
    mroApp = HDRLJX
    __newrun = true
    reportDesc = xxxxx
    smtpHost = false
    Email_Choice = PDF
    reportFolder = HDRLJX
    isDuplex = 0
    appname = HDRLJX
    appname = HDRLJX
    uisessionid = 67
    isDuplex = 0
    emails =
    customserverURL =
    reportDesc = xxxx
    __scheduleType = immediate
    locale = zh_CN
    localTZ = Asia/Shanghai
    mroUniqueKey = 230321154316640_427821
    __newrun = true
    smtpHost = false
    __overwrite = new
    mroOrg = JYJT
    __report = SYrljx.rptdesign
    customrptServerLogonPass =
    plain text where = ( ( workticket.workticketid  =  45972 ))where = %EF%BE%84%EF%BE%8D%EF%BF%87%12Sa%06%EF%BE%A2%EF%BE%88tiF8%EF%BE%89%EF%BF%A5%22%EF%BF%87%0AZ%EF%BF%B0%23%EF%BF%B4%
    EF%BE%BA%EF%BF%81%EF%BF%B7%EF%BF%8C%EF%BE%A4%EF%BE%B4%07DE%EF%BE%A0%EF%BF%82%EF%BF%B2l%EF%BF%96%EF%BF%BD%19%EF%BF%86%EF%BF%85
    paramdelimiter = ||
    reportname = SYrljx.rptdesign
    redir = /maximo/report/?__report=SYrljx.rptdesign&appname=HDRLJX&__requestid=1679384596640&uisessionid=67&csrftoken=snc7423t9bue9j25iiknla2nh2
    schema = maximo
    reportType = BIRT
    mroApp = HDRLJX
    redirParams = repositoryType=Enterprise
    maxPass = %EF%BF%90%EF%BE%A9%28%EF%BF%A6%11%EF%BE%A9%3Ce%EF%BE%A8Ly%EF%BF%B8%EF%BF%9F%EF%BE%8C%EF%BE%82%EF%BE%8D
    extendedFields = false
    qbrDisplayWhere = (WORKTICKETID = 45972)
    Email_Choice = PDF
    csrftoken = snc7423t9bue9j25iiknla2nh2
    fromEmail = no
    __requestid = 1679384596640
    reportFile = SYrljx.rptdesign
    userName = maxadmin
    ParmUserName = maximo
    reportNum = 1440
    paramstring = appHierarchy=HDRLJX,CUSTAPP
    ParmPassword = %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    comments =
    mroSite = NYDC
    reportFolder = HDRLJX
    baseTable = WORKTICKET

    21 三月 2023 15:43:19:187 [DEBUG] [MXServer] [] Using document = D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\tmp\_WL_user\maximo\vw9y4r\p
    ublic\reportruntime\reports\1679384597453\_output\SYrljx.rptdocument
    21 三月 2023 15:43:19:265 [DEBUG] [MXServer] []

    Report parameters for RequestID = 1679384596640
    encoding=UTF-8
    schema = maximo
    reportNum = 1440
    mroSite = NYDC
    uisessionid = 67
    reportFile = SYrljx.rptdesign
    locale = zh_CN
    extendedFields = false
    fromEmail = no
    redir = /maximo/report/?__report=SYrljx.rptdesign&appname=HDRLJX&__requestid=1679384596640&uisessionid=67&csrftoken=snc7423t9bue9j25iiknla2nh2
    emails =
    qbrDisplayWhere = (WORKTICKETID = 45972)
    reportType = BIRT
    appname = HDRLJX
    appname = HDRLJX
    paramstring = appHierarchy=HDRLJX,CUSTAPP
    reportname = SYrljx.rptdesign
    where = %EF%BE%84%EF%BE%8D%EF%BF%87%12Sa%06%EF%BE%A2%EF%BE%88tiF8%EF%BE%89%EF%BF%A5%22%EF%BF%87%0AZ%EF%BF%B0%23%EF%BF%B4%EF%BE%BA%EF%BF%81%EF%BF%B7%EF%BF%8C%EF%BE%A4%EF%BE%B4%07DE%
    EF%BE%A0%EF%BF%82%EF%BF%B2l%EF%BF%96%EF%BF%BD%19%EF%BF%86%EF%BF%85
    localTZ = Asia/Shanghai
    ParmUserName = maximo
    maxPass = %EF%BF%90%EF%BE%A9%28%EF%BF%A6%11%EF%BE%A9%3Ce%EF%BE%A8Ly%EF%BF%B8%EF%BF%9F%EF%BE%8C%EF%BE%82%EF%BE%8D
    csrftoken = snc7423t9bue9j25iiknla2nh2
    paramdelimiter = ||
    redirParams = repositoryType=Enterprise
    __report = 1679384597453\birtreport\SYrljx.rptdesign
    mroOrg = JYJT
    ParmPassword = %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    customserverURL =
    comments =
    __scheduleType = immediate
    mroUniqueKey = 230321154316640_427821
    baseTable = WORKTICKET
    customrptServerLogonPass =
    userName = maxadmin
    mroApp = HDRLJX
    __locale = zh_CN
    __newrun = true
    __requestid = 1679384596640
    reportDesc = xxxxx
    smtpHost = false
    __document = D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\tmp\_WL_user\maximo\vw9y4r\public\reportruntime\reports\1679384597453\_output\SY
    rljx.rptdocument
    Email_Choice = PDF
    reportFolder = HDRLJX
    isDuplex = 0
    uisessionid = 67
    __report = SYrljx.rptdesign
    csrftoken = snc7423t9bue9j25iiknla2nh2
    __requestid = 1679384596640
    appname = HDRLJX

    21 三月 2023 15:43:19:469 [DEBUG] [MXServer] [] Using document = D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\tmp\_WL_user\maximo\vw9y4r\p
    ublic\reportruntime\reports\1679384597453\_output\SYrljx.rptdocument
    %%%%%%%%%%% FRAMESET FRAGMENT %%%% CONTEXT PATH = /maximo/bridge
    %%%%%%%%%%% FRAMESET FRAGMENT %%%% REQ CONTEXT PATH = /maximo
    Base URL:http://10.20.108.30:17002%%%%%%%% FRAMESET FRAGMENT SOAP URL = http://10.20.108.30:17002/maximo/bridge/frameset?__report=1679384597453%5Cbirtreport%5CSYrljx.rptdesign&__scheduleType=immediate&__locale=zh_CN&__newrun=true&__requestid=1679384596640&__document=D%3A%5COracle%5CMiddleware%5COracle_Home%5Cuser_projects%5Cdomains%5Cbase_domain%5Cservers%5CAdminServer%5Ctmp%5C_WL_user%5Cmax
    imo%5Cvw9y4r%5Cpublic%5Creportruntime%5Creports%5C1679384597453%5C_output%5CSYrljx.rptdocument
    %%%%%%%% FRAMESET FRAGMENT SOAP URL XX = http://localhost:7001/maximo/report?__report=1679384597453%5Cbirtreport%5CSYrljx.rptdesign&__scheduleType=immediate&__locale=zh_CN&__newrun
    =true&__requestid=1679384596640&__document=D%3A%5COracle%5CMiddleware%5COracle_Home%5Cuser_projects%5Cdomains%5Cbase_domain%5Cservers%5CAdminServer%5Ctmp%5C_WL_user%5Cmaximo%5Cvw9y
    4r%5Cpublic%5Creportruntime%5Creports%5C1679384597453%5C_output%5CSYrljx.rptdocument

    21 三月 2023 15:43:22:820 [INFO] [MXServer] [CID-CRON-8650] Correlation started.
    21 三月 2023 15:43:22:836 [INFO] [MXServer] [CID-CRON-8650] Correlated data: BEGIN InstanceName:AsyncImmediate TaskName:AsyncImmediateJobCron ElapsedTime:16 ms  END
    21 三月 2023 15:43:32:833 [INFO] [MXServer] [CID-CRON-8651] Correlation started.
    21 三月 2023 15:43:32:849 [INFO] [MXServer] [CID-CRON-8651] Correlated data: BEGIN InstanceName:AsyncImmediate TaskName:AsyncImmediateJobCron ElapsedTime:16 ms  END
    21 三月 2023 15:43:36:842 [DEBUG] [MXServer] [] ReportCancelStatusUpdateThread getting cancelled reports from database
    21 三月 2023 15:43:38:685 [INFO] [MXServer] [CID-CRON-8652] Correlation started.
    21 三月 2023 15:43:38:685 [INFO] [MXServer] [CID-CRON-8652] Correlated data: BEGIN InstanceName:AsyncScheduled TaskName:AsyncScheduledJobCron ElapsedTime:0 ms  END
    21 三月 2023 15:43:42:845 [INFO] [MXServer] [CID-CRON-8653] Correlation started.
    21 三月 2023 15:43:42:845 [INFO] [MXServer] [CID-CRON-8653] Correlated data: BEGIN InstanceName:AsyncImmediate TaskName:AsyncImmediateJobCron ElapsedTime:0 ms  END
    21 三月 2023 15:43:43:644 [INFO] [MXServer] [] ALNDOMAIN: mbosets (3), mbos (14)
    21 三月 2023 15:43:43:644 [INFO] [MXServer] [] CRONTASKDEF: mbosets (23), mbos (46)
    21 三月 2023 15:43:43:644 [INFO] [MXServer] [] CRONTASKINSTANCE: mbosets (40), mbos (79)
    21 三月 2023 15:43:43:644 [INFO] [MXServer] [] CRONTASKPARAM: mbosets (37), mbos (64)
    21 三月 2023 15:43:43:644 [INFO] [MXServer] [] DEPT: mbosets (34), mbos (66)
    21 三月 2023 15:43:43:644 [INFO] [MXServer] [] DEPTPERSON: mbosets (32), mbos (32)
    21 三月 2023 15:43:43:644 [INFO] [MXServer] [] DMCOLLAPPTOOLBAR: mbosets (1), mbos (1)
    21 三月 2023 15:43:43:644 [INFO] [MXServer] [] DUMMY_TABLE: mbosets (3), mbos (4)
    21 三月 2023 15:43:43:644 [INFO] [MXServer] [] EMAIL: mbosets (8), mbos (8)
    21 三月 2023 15:43:43:644 [INFO] [MXServer] [] MAXAPPS: mbosets (2), mbos (369)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] MAXGROUP: mbosets (5), mbos (86)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] MAXLOGMSGTOOLBAR: mbosets (1), mbos (1)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] MAXRECORDLOCK: mbosets (1), mbos (1)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] MAXSESSION: mbosets (1), mbos (2)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] MAXUSER: mbosets (8), mbos (16)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] PERSON: mbosets (82), mbos (125)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] REPFACAUTH: mbosets (18), mbos (18)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] REPORT: mbosets (8), mbos (16)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] REPORTDEPEND: mbosets (4), mbos (6)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] REPORTDESIGN: mbosets (2), mbos (4)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] REPORTLOOKUP: mbosets (12), mbos (12)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] REPORTPARAMETER: mbosets (1), mbos (2)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] SITE: mbosets (34), mbos (66)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] SITEAUTH: mbosets (66), mbos (66)
    21 三月 2023 15:43:43:657 [INFO] [MXServer] [] SYNONYMDOMAIN: mbosets (2), mbos (4)
    21 三月 2023 15:43:43:673 [INFO] [MXServer] [] TASKSCHEDULER: mbosets (15), mbos (30)
    21 三月 2023 15:43:43:673 [INFO] [MXServer] [] WFAPPTOOLBAR: mbosets (1), mbos (2)
    21 三月 2023 15:43:43:673 [INFO] [MXServer] [] WFTOOLBAR: mbosets (1), mbos (2)
    21 三月 2023 15:43:43:673 [INFO] [MXServer] [] WORKTICKET: mbosets (9), mbos (45)
    21 三月 2023 15:43:43:673 [INFO] [MXServer] [] WORKTICKETKG: mbosets (33), mbos (1)
    21 三月 2023 15:43:43:673 [INFO] [MXServer] [] WORKTICKETLINE: mbosets (256), mbos (11)
    21 三月 2023 15:43:43:673 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:AssetTopoCacheCron.AssetTopoCacheCron01。上次运行:2023-03-2
    1 15:32:19.203
    21 三月 2023 15:43:43:673 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:AsyncImmediateJobCron.AsyncImmediate。上次运行:2023-03-21 1
    5:43:42.845
    21 三月 2023 15:43:43:673 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:AsyncJobCleanupCron.AsyncJobCleanup。上次运行:2023-03-21 09
    :00:29.765
    21 三月 2023 15:43:43:688 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:AsyncScheduledJobCron.AsyncScheduled。上次运行:2023-03-21 1
    5:43:38.685
    21 三月 2023 15:43:43:688 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:BBCron.BBCRON1。上次运行:2023-03-21 15:00:13.894
    21 三月 2023 15:43:43:688 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:ConsignmentInvoiceCronTask.Create consignment invoices.。上
    次运行:2023-03-21 00:00:00.709
    21 三月 2023 15:43:43:688 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:EFileReadCronTask.cron01。上次运行:2023-03-20 14:51:36.181
    21 三月 2023 15:43:43:704 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:ESCALATION.ESC1008。上次运行:2023-03-21 15:32:19.172
    21 三月 2023 15:43:43:704 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:ESCALATION.ESC1017。上次运行:2023-03-21 15:32:19.453
    21 三月 2023 15:43:43:704 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:ESCALATION.ESC1019。上次运行:2023-03-21 15:42:29.361
    21 三月 2023 15:43:43:704 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:ESCALATION.ESCESCBLTNEXP。上次运行:2023-03-20 18:00:08.195
    21 三月 2023 15:43:43:720 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:ESCALATION.ESCOSLCTXN。上次运行:2023-03-21 15:42:29.283
    21 三月 2023 15:43:43:720 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:ESCALATION.ESCPROMOTECOMP。上次运行:2023-03-21 03:00:01.039

    21 三月 2023 15:43:43:720 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:ESCALATION.ESCPROMOTENETD。上次运行:2023-03-21 03:00:01.024

    21 三月 2023 15:43:43:720 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:ESCALATION.ESCPROMOTENETP。上次运行:2023-03-21 03:00:00.899

    21 三月 2023 15:43:43:735 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:InvResResTypeUpdateCronTask.ReservationResTypeUpdate。上次运
    行:2023-03-21 15:00:15.284
    21 三月 2023 15:43:43:735 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:PurgeReportRelatedRecords.instance1。上次运行:2023-03-21 05
    :00:00.961
    21 三月 2023 15:43:43:735 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:REPORTLOCKRELEASE.REPORTLOCKRELEASE1。上次运行:2023-03-21 1
    5:42:44.111
    21 三月 2023 15:43:43:735 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:REPORTOUTPUTCLEANUP.REPORTOUTPUTCLEANUP。上次运行:2023-03-1
    9 18:17:08.574
    21 三月 2023 15:43:43:798 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:REPORTUSAGECLEANUP.REPORTUSAGECLEANUP1。上次运行:2023-03-21
     15:13:56.272
    21 三月 2023 15:43:43:798 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:RemoveDeadSessions.REMOVEDEADSESS。上次运行:2023-03-21 15:4
    2:29.142
    21 三月 2023 15:43:43:813 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:SKDMATRIXCLEANUP.SKDMATRIX。上次运行:2023-03-21 00:00:00.61
    6
    21 三月 2023 15:43:43:813 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:SLROUTECLEANUP.SLROUTE。上次运行:2023-03-21 00:00:00.694
    21 三月 2023 15:43:43:813 [INFO] [MXServer] [] BMXAA6372I - 主机名:192.168.1.142。服务器名称:MXServer。Cron 任务名称:WOMaterialStatusUpdateCronTask.WOMaterialStatusUpdate。上次
    运行:2023-03-21 13:00:30.495
    21 三月 2023 15:43:43:813 [INFO] [MXServer] [] BMXAA8612I - 租户:0。服务器主机:192.168.1.142。服务器名称:MXServer。用户数:1. WebClientSessions: (3)
    21 三月 2023 15:43:43:829 [INFO] [MXServer] [] BMXAA6370I - 已连接到系统的用户总数:1

    Weblogic console when reports can be displayed::


    Report parameters for RequestID = 1679384813299
    encoding=UTF-8
    schema = maximo
    reportNum = 1440
    mroSite = NYDC
    reportFile = SYrljx.rptdesign
    locale = zh_CN
    extendedFields = false
    fromEmail = no
    emails =
    qbrDisplayWhere = (WORKTICKETID = 45972)
    reportType = BIRT
    appname = HDRLJX
    paramstring = appHierarchy=HDRLJX,CUSTAPP
    reportname = SYrljx.rptdesign
    where = ( ( workticket.workticketid  =  45972 ))
    localTZ = Asia/Shanghai
    ParmUserName = maximo
    maxPass = %EF%BF%90%EF%BE%A9%28%EF%BF%A6%11%EF%BE%A9%3Ce%EF%BE%A8Ly%EF%BF%B8%EF%BF%9F%EF%BE%8C%EF%BE%82%EF%BE%8D
    paramdelimiter = ||
    redirParams = repositoryType=Enterprise
    mroOrg = JYJT
    ParmPassword = %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    customserverURL =
    comments =
    __scheduleType = immediate
    mroUniqueKey = 230321154653297_427822
    baseTable = WORKTICKET
    customrptServerLogonPass =
    userName = maxadmin
    mroApp = HDRLJX
    __newrun = true
    reportDesc = 
    smtpHost = false
    Email_Choice = PDF
    reportFolder = HDRLJX
    isDuplex = 0
    appname = HDRLJX
    appname = HDRLJX
    uisessionid = 70
    isDuplex = 0
    emails =
    customserverURL =
    reportDesc = 
    __scheduleType = immediate
    locale = zh_CN
    localTZ = Asia/Shanghai
    mroUniqueKey = 230321154653297_427822
    __newrun = true
    smtpHost = false
    __overwrite = new
    mroOrg = JYJT
    __report = SYrljx.rptdesign
    customrptServerLogonPass =
    plain text where = ( ( workticket.workticketid  =  45972 ))where = %EF%BE%84%EF%BE%8D%EF%BF%87%12Sa%06%EF%BE%A2%EF%BE%88tiF8%EF%BE%89%EF%BF%A5%22%EF%BF%87%0AZ%EF%BF%B0%23%EF%BF%B4%
    EF%BE%BA%EF%BF%81%EF%BF%B7%EF%BF%8C%EF%BE%A4%EF%BE%B4%07DE%EF%BE%A0%EF%BF%82%EF%BF%B2l%EF%BF%96%EF%BF%BD%19%EF%BF%86%EF%BF%85
    paramdelimiter = ||
    reportname = SYrljx.rptdesign
    redir = /maximo/report/?__report=SYrljx.rptdesign&appname=HDRLJX&__requestid=1679384813299&uisessionid=70&csrftoken=e61km1jrq12f8a5g7m8vhk7qsm
    schema = maximo
    reportType = BIRT
    mroApp = HDRLJX
    redirParams = repositoryType=Enterprise
    maxPass = %EF%BF%90%EF%BE%A9%28%EF%BF%A6%11%EF%BE%A9%3Ce%EF%BE%A8Ly%EF%BF%B8%EF%BF%9F%EF%BE%8C%EF%BE%82%EF%BE%8D
    extendedFields = false
    qbrDisplayWhere = (WORKTICKETID = 45972)
    Email_Choice = PDF
    csrftoken = e61km1jrq12f8a5g7m8vhk7qsm
    fromEmail = no
    __requestid = 1679384813299
    reportFile = SYrljx.rptdesign
    userName = maxadmin
    ParmUserName = maximo
    reportNum = 1440
    paramstring = appHierarchy=HDRLJX,CUSTAPP
    ParmPassword = %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    comments =
    mroSite = NYDC
    reportFolder = HDRLJX
    baseTable = WORKTICKET

    21 三月 2023 15:46:55:431 [DEBUG] [MXServer] [] Using document = D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\tmp\_WL_user\maximo\vw9y4r\p
    ublic\reportruntime\reports\1679384813942\_output\SYrljx.rptdocument
    21 三月 2023 15:46:55:461 [DEBUG] [MXServer] []

    Report parameters for RequestID = 1679384813299
    encoding=UTF-8
    schema = maximo
    reportNum = 1440
    mroSite = NYDC
    uisessionid = 70
    reportFile = SYrljx.rptdesign
    locale = zh_CN
    extendedFields = false
    fromEmail = no
    redir = /maximo/report/?__report=SYrljx.rptdesign&appname=HDRLJX&__requestid=1679384813299&uisessionid=70&csrftoken=e61km1jrq12f8a5g7m8vhk7qsm
    emails =
    qbrDisplayWhere = (WORKTICKETID = 45972)
    reportType = BIRT
    appname = HDRLJX
    appname = HDRLJX
    paramstring = appHierarchy=HDRLJX,CUSTAPP
    reportname = SYrljx.rptdesign
    where = %EF%BE%84%EF%BE%8D%EF%BF%87%12Sa%06%EF%BE%A2%EF%BE%88tiF8%EF%BE%89%EF%BF%A5%22%EF%BF%87%0AZ%EF%BF%B0%23%EF%BF%B4%EF%BE%BA%EF%BF%81%EF%BF%B7%EF%BF%8C%EF%BE%A4%EF%BE%B4%07DE%
    EF%BE%A0%EF%BF%82%EF%BF%B2l%EF%BF%96%EF%BF%BD%19%EF%BF%86%EF%BF%85
    localTZ = Asia/Shanghai
    ParmUserName = maximo
    maxPass = %EF%BF%90%EF%BE%A9%28%EF%BF%A6%11%EF%BE%A9%3Ce%EF%BE%A8Ly%EF%BF%B8%EF%BF%9F%EF%BE%8C%EF%BE%82%EF%BE%8D
    csrftoken = e61km1jrq12f8a5g7m8vhk7qsm
    paramdelimiter = ||
    redirParams = repositoryType=Enterprise
    __report = 1679384813942\birtreport\SYrljx.rptdesign
    mroOrg = JYJT
    ParmPassword = %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    customserverURL =
    comments =
    __scheduleType = immediate
    mroUniqueKey = 230321154653297_427822
    baseTable = WORKTICKET
    customrptServerLogonPass =
    userName = maxadmin
    mroApp = HDRLJX
    __locale = zh_CN
    __newrun = true
    __requestid = 1679384813299
    reportDesc = 
    smtpHost = false
    __document = D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\tmp\_WL_user\maximo\vw9y4r\public\reportruntime\reports\1679384813942\_output\SY
    rljx.rptdocument
    Email_Choice = PDF
    reportFolder = HDRLJX
    isDuplex = 0
    uisessionid = 70
    __report = SYrljx.rptdesign
    csrftoken = e61km1jrq12f8a5g7m8vhk7qsm
    __requestid = 1679384813299
    appname = HDRLJ

    21 三月 2023 15:46:55:483 [DEBUG] [MXServer] [] Using document = D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\tmp\_WL_user\maximo\vw9y4r\p
    ublic\reportruntime\reports\1679384813942\_output\SYrljx.rptdocument
    %%%%%%%%%%% FRAMESET FRAGMENT %%%% CONTEXT PATH = /maximo/bridge
    %%%%%%%%%%% FRAMESET FRAGMENT %%%% REQ CONTEXT PATH = /maximo
    Base URL:http://192.168.1.142:7001
    %%%%%%%% FRAMESET FRAGMENT SOAP URL = http://192.168.1.142:7001/maximo/bridge/frameset?__report=1679384813942%5Cbirtreport%5CSYrljx.rptdesign&__scheduleType=immediate&__locale=zh_C
    N&__newrun=true&__requestid=1679384813299&__document=D%3A%5COracle%5CMiddleware%5COracle_Home%5Cuser_projects%5Cdomains%5Cbase_domain%5Cservers%5CAdminServer%5Ctmp%5C_WL_user%5Cmax
    imo%5Cvw9y4r%5Cpublic%5Creportruntime%5Creports%5C1679384813942%5C_output%5CSYrljx.rptdocument
    %%%%%%%% FRAMESET FRAGMENT SOAP URL XX = http://localhost:7001/maximo/report?__report=1679384813942%5Cbirtreport%5CSYrljx.rptdesign&__scheduleType=immediate&__locale=zh_CN&__newrun
    =true&__requestid=1679384813299&__document=D%3A%5COracle%5CMiddleware%5COracle_Home%5Cuser_projects%5Cdomains%5Cbase_domain%5Cservers%5CAdminServer%5Ctmp%5C_WL_user%5Cmaximo%5Cvw9y
    4r%5Cpublic%5Creportruntime%5Creports%5C1679384813942%5C_output%5CSYrljx.rptdocument
    21 三月 2023 15:46:55:748 [DEBUG] [MXServer] []

    Report parameters for RequestID = 1679384813299
    encoding=UTF-8
    schema = maximo
    reportNum = 1440
    mroSite = NYDC
    uisessionid = 70
    reportFile = SYrljx.rptdesign
    locale = zh_CN
    extendedFields = false
    fromEmail = no
    redir = /maximo/report/?__report=SYrljx.rptdesign&appname=HDRLJX&__requestid=1679384813299&uisessionid=70&csrftoken=e61km1jrq12f8a5g7m8vhk7qsm
    emails =
    qbrDisplayWhere = (WORKTICKETID = 45972)
    reportType = BIRT
    appname = HDRLJX
    paramstring = appHierarchy=HDRLJX,CUSTAPP
    reportname = SYrljx.rptdesign
    where = %EF%BE%84%EF%BE%8D%EF%BF%87%12Sa%06%EF%BE%A2%EF%BE%88tiF8%EF%BE%89%EF%BF%A5%22%EF%BF%87%0AZ%EF%BF%B0%23%EF%BF%B4%EF%BE%BA%EF%BF%81%EF%BF%B7%EF%BF%8C%EF%BE%A4%EF%BE%B4%07DE%
    EF%BE%A0%EF%BF%82%EF%BF%B2l%EF%BF%96%EF%BF%BD%19%EF%BF%86%EF%BF%85
    localTZ = Asia/Shanghai
    ParmUserName = maximo
    maxPass = %EF%BF%90%EF%BE%A9%28%EF%BF%A6%11%EF%BE%A9%3Ce%EF%BE%A8Ly%EF%BF%B8%EF%BF%9F%EF%BE%8C%EF%BE%82%EF%BE%8D
    csrftoken = e61km1jrq12f8a5g7m8vhk7qsm
    paramdelimiter = ||
    redirParams = repositoryType=Enterprise
    __report = 1679384813942\birtreport\SYrljx.rptdesign
    mroOrg = JYJT
    ParmPassword = %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    customserverURL =
    comments =
    __scheduleType = immediate
    mroUniqueKey = 230321154653297_427822
    baseTable = WORKTICKET
    customrptServerLogonPass =
    userName = maxadmin
    mroApp = HDRLJX
    __locale = zh_CN
    __newrun = true
    __requestid = 1679384813299
    reportDesc =
    smtpHost = false
    __document = D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\tmp\_WL_user\maximo\vw9y4r\public\reportruntime\reports\1679384813942\_output\SY
    rljx.rptdocument
    Email_Choice = PDF
    reportFolder = HDRLJX
    isDuplex = 0
    __dpi = 96
    __report = SYrljx.rptdesign
    appname = HDRLJX
    uisessionid = 70
    __requestid = 1679384813299
    csrftoken = e61km1jrq12f8a5g7m8vhk7qsm
    __sessionId = 20230321_154655_488

    21 三月 2023 15:46:55:766 [DEBUG] [MXServer] [] Using document = D:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\tmp\_WL_user\maximo\vw9y4r\p
    ublic\reportruntime\reports\1679384813942\_output\SYrljx.rptdocument
    21 三月 2023 15:46:55:869 [DEBUG] [MXServer] [] MXReportScriptContext com.ibm.tivoli.maximo.report.script.MXReportScriptContext@4a1af144 added to MXReportJobCancelThread
    21 三月 2023 15:46:55:875 [DEBUG] [MXServer] [] Added active report thread: [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'], Is this a ScheduledJob
    ? = false, reportJobId = 196836
    21 三月 2023 15:46:55:875 [DEBUG] [MXServer] [] where parameter in ScriptContext:( ( workticket.workticketid  =  45972 ))
    21 三月 2023 15:46:56:124 [INFO] [MXServer] [] DataSet [dataSet] open called.
    21 三月 2023 15:46:56:126 [INFO] [MXServer] [] DataSource [maximoDataSource] getConnection called
    21 三月 2023 15:46:56:127 [INFO] [MXServer] [] DataSource MXReportScriptContext = com.ibm.tivoli.maximo.report.script.MXReportScriptContext@4a1af144
    DataSourceConnectionPool getNewConnection called with user:null
    21 三月 2023 15:46:56:132 [INFO] [MXServer] [] Runtime DataSource [maximoDataSource] connection = com.ibm.db2.jcc.t4.b@5fb50e00
    21 三月 2023 15:46:56:135 [INFO] [MXServer] [] DataSource [maximoDataSource] is connected to the URL jdbc:db2://192.168.1.142:58535/SAMPLE
    21 三月 2023 15:46:56:139 [DEBUG] [MXServer] [] DataSet [dataSet] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:56:147 [INFO] [MXServer] [] DataSet [dataSet]: select wt11,wt23,wt104,wt67,wt69,WT74,WT77,WTNUM,(SELECT DESCRIPTION FROM DEPT WHERE DEPT=WORKTICKET.WT3)WT3,WT4,(
    select displayname from person where personid=workticket.createby) createby,        WT12,WT10,ASSETNUM,ASSET,WT13,WT14,WORKPLACE,        A_WT2,A_WT25,FROMWTNUM,A_DEPT,YQREASON,STAT
    US,        (select displayname from person where personid=WT15)WT15,CHANGEDATE,        (select displayname from person where personid=WT55)WT55,WT16,        (select displayname fro
    m person where personid=WT17)WT17,WT18,        (select displayname from person where personid=WT46)WT46,STATUSDATE,WT19,        QZDATE1,(select displayname from person where person
    id=WT22)WT22,        (select displayname from person where personid=WT30)WT30,        (select displayname from person where personid=WT24)WT24,        (select displayname from pers
    on where personid=WT25)WT25,        (select displayname from person where personid=WT27)WT27,WT26,        (select displayname from person where personid=WT48)WT48,WT31,        (sel
    ect displayname from person where personid=WT38)WT38,WT33,        WT53,WT29,(select displayname from person where personid=WT54)WT54,       (select displayname from person where pe
    rsonid=WT65)WT65,       (select displayname from person where personid=WT2)WT2,       (select displayname from person where personid=WT39)WT39,       (select displayname from perso
    n where personid=WT73)WT73,       (select displayname from person where personid=WT75)WT75,       (select displayname from person where personid=WT76)WT76,       (select displaynam
    e from person where personid=WT63)WT63,        WT37,(select displayname from person where personid=WT78)WT78,       (select displayname from person where personid=WT64)WT64,WT1,A_D
    QWTNUM,       (select displayname from person where personid=WT28)WT28,        DXWTNUM,WT5,LXWTNUM,WT20,WT21,WT110,APPRDATE,        (select displayname from person where personid=W
    T50)WT50,WT51,WT52,(SELECT DESCRIPTION FROM SITE WHERE SITEID=WORKTICKET.SITEID)SITE,        RESULT,REASON,REPORT,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.CHECKBY)
    CHECKBY,CHECKDATE,              (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_XKR)XKR,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.hqby)hqr,
                    (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_ZBR)ZBR from workticket  where ( ( workticket.workticketid  =  45972 )) and WTTYPE='HDRLJX'
    21 三月 2023 15:46:56:273 [INFO] [MXServer] [] DataSet [dataSet] close called.
    21 三月 2023 15:46:56:280 [INFO] [MXServer] [] DataSet [dataSet] open called.
    21 三月 2023 15:46:56:281 [DEBUG] [MXServer] [] DataSet [dataSet] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:56:285 [INFO] [MXServer] [] DataSet [dataSet]: select wt11,wt23,wt104,wt67,wt69,WT74,WT77,WTNUM,(SELECT DESCRIPTION FROM DEPT WHERE DEPT=WORKTICKET.WT3)WT3,WT4,(
    select displayname from person where personid=workticket.createby) createby,        WT12,WT10,ASSETNUM,ASSET,WT13,WT14,WORKPLACE,        A_WT2,A_WT25,FROMWTNUM,A_DEPT,YQREASON,STAT
    US,        (select displayname from person where personid=WT15)WT15,CHANGEDATE,        (select displayname from person where personid=WT55)WT55,WT16,        (select displayname fro
    m person where personid=WT17)WT17,WT18,        (select displayname from person where personid=WT46)WT46,STATUSDATE,WT19,        QZDATE1,(select displayname from person where person
    id=WT22)WT22,        (select displayname from person where personid=WT30)WT30,        (select displayname from person where personid=WT24)WT24,        (select displayname from pers
    on where personid=WT25)WT25,        (select displayname from person where personid=WT27)WT27,WT26,        (select displayname from person where personid=WT48)WT48,WT31,        (sel
    ect displayname from person where personid=WT38)WT38,WT33,        WT53,WT29,(select displayname from person where personid=WT54)WT54,       (select displayname from person where pe
    rsonid=WT65)WT65,       (select displayname from person where personid=WT2)WT2,       (select displayname from person where personid=WT39)WT39,       (select displayname from perso
    n where personid=WT73)WT73,       (select displayname from person where personid=WT75)WT75,       (select displayname from person where personid=WT76)WT76,       (select displaynam
    e from person where personid=WT63)WT63,        WT37,(select displayname from person where personid=WT78)WT78,       (select displayname from person where personid=WT64)WT64,WT1,A_D
    QWTNUM,       (select displayname from person where personid=WT28)WT28,        DXWTNUM,WT5,LXWTNUM,WT20,WT21,WT110,APPRDATE,        (select displayname from person where personid=W
    T50)WT50,WT51,WT52,(SELECT DESCRIPTION FROM SITE WHERE SITEID=WORKTICKET.SITEID)SITE,        RESULT,REASON,REPORT,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.CHECKBY)
    CHECKBY,CHECKDATE,              (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_XKR)XKR,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.hqby)hqr,
                    (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_ZBR)ZBR from workticket  where ( ( workticket.workticketid  =  45972 )) and WTTYPE='HDRLJX'
    21 三月 2023 15:46:56:298 [INFO] [MXServer] [] DataSet [dataSet] close called.
    21 三月 2023 15:46:56:325 [INFO] [MXServer] [] DataSet [dataSet1] open called.
    21 三月 2023 15:46:56:327 [DEBUG] [MXServer] [] DataSet [dataSet1] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:56:333 [INFO] [MXServer] [] DataSet [dataSet1]: select WORKTICKETLINE.LINEID,WORKTICKETLINE.DESC1,WORKTICKETLINE.yorn1,JXZL,WORKTICKETLINE.EXECUTOR,(select count
    (*) from workticketline where tynum=workticket.tynum and type='YL' and desc1!='无')SIGN,WORKTICKET.SIGN1 from workticket  left join WORKTICKETLINE on WORKTICKETLINE.tynum=workticke
    t.tynum and WORKTICKETLINE.type ='YL'  where ( ( workticket.workticketid  =  45972 )) order by WORKTICKETLINE.LINEID asc
    21 三月 2023 15:46:56:441 [INFO] [MXServer] [] DataSet [dataSet1] close called.
    21 三月 2023 15:46:56:457 [INFO] [MXServer] [] DataSet [dataSet1] open called.
    21 三月 2023 15:46:56:459 [DEBUG] [MXServer] [] DataSet [dataSet1] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:56:464 [INFO] [MXServer] [] DataSet [dataSet1]: select WORKTICKETLINE.LINEID,WORKTICKETLINE.DESC1,WORKTICKETLINE.yorn1,JXZL,WORKTICKETLINE.EXECUTOR,(select count
    (*) from workticketline where tynum=workticket.tynum and type='YL' and desc1!='无')SIGN,WORKTICKET.SIGN1 from workticket  left join WORKTICKETLINE on WORKTICKETLINE.tynum=workticke
    t.tynum and WORKTICKETLINE.type ='YL'  where ( ( workticket.workticketid  =  45972 )) order by WORKTICKETLINE.LINEID asc
    21 三月 2023 15:46:56:566 [INFO] [MXServer] [] DataSet [dataSet1] close called.
    21 三月 2023 15:46:56:593 [INFO] [MXServer] [] DataSet [dataSet2] open called.
    21 三月 2023 15:46:56:594 [DEBUG] [MXServer] [] DataSet [dataSet2] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:56:613 [INFO] [MXServer] [] DataSet [dataSet2]: select WORKTICKETLINE.LINEID,WORKTICKETLINE.DESC1,WORKTICKETLINE.YORN1,WORKTICKETLINE.EXECUTOR,JXZL,(select count
    (*) from workticketline where tynum=workticket.tynum and type='YJ' and desc1!='无')SIGN1 from workticket  left join WORKTICKETLINE on WORKTICKETLINE.tynum=workticket.tynum and WORK
    TICKETLINE.type ='YJ'  where ( ( workticket.workticketid  =  45972 )) order by WORKTICKETLINE.LINEID asc
    21 三月 2023 15:46:56:708 [INFO] [MXServer] [] DataSet [dataSet2] close called.
    21 三月 2023 15:46:56:712 [INFO] [MXServer] [] DataSet [dataSet2] open called.
    21 三月 2023 15:46:56:714 [DEBUG] [MXServer] [] DataSet [dataSet2] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:56:717 [INFO] [MXServer] [] DataSet [dataSet2]: select WORKTICKETLINE.LINEID,WORKTICKETLINE.DESC1,WORKTICKETLINE.YORN1,WORKTICKETLINE.EXECUTOR,JXZL,(select count
    (*) from workticketline where tynum=workticket.tynum and type='YJ' and desc1!='无')SIGN1 from workticket  left join WORKTICKETLINE on WORKTICKETLINE.tynum=workticket.tynum and WORK
    TICKETLINE.type ='YJ'  where ( ( workticket.workticketid  =  45972 )) order by WORKTICKETLINE.LINEID asc
    21 三月 2023 15:46:56:803 [INFO] [MXServer] [] DataSet [dataSet2] close called.
    21 三月 2023 15:46:56:817 [INFO] [MXServer] [] DataSet [dataSet3] open called.
    21 三月 2023 15:46:56:819 [DEBUG] [MXServer] [] DataSet [dataSet3] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:56:823 [INFO] [MXServer] [] DataSet [dataSet3]: select WORKTICKETLINE.LINEID,WORKTICKETLINE.DESC1,WORKTICKETLINE.YORN1,WORKTICKETLINE.EXECUTOR,JXZL from worktick
    et  left join WORKTICKETLINE on WORKTICKETLINE.tynum=workticket.tynum and WORKTICKETLINE.type ='YS'  where ( ( workticket.workticketid  =  45972 )) order by WORKTICKETLINE.LINEID a
    sc
    21 三月 2023 15:46:56:876 [INFO] [MXServer] [] DataSet [dataSet3] close called.
    21 三月 2023 15:46:56:891 [INFO] [MXServer] [] DataSet [dataSet4] open called.
    21 三月 2023 15:46:56:892 [DEBUG] [MXServer] [] DataSet [dataSet4] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:56:896 [INFO] [MXServer] [] DataSet [dataSet4]: select WORKTICKETLINE.LINEID,WORKTICKETLINE.DESC1,WORKTICKETLINE.YORN1,WORKTICKETLINE.EXECUTOR,JXZL  from worktic
    ket  left join WORKTICKETLINE on WORKTICKETLINE.tynum=workticket.tynum and WORKTICKETLINE.type ='YB'  where ( ( workticket.workticketid  =  45972 )) order by WORKTICKETLINE.LINEID
    asc
    21 三月 2023 15:46:56:900 [DEBUG] [MXServer] [] ReportCancelStatusUpdateThread getting cancelled reports from database
    21 三月 2023 15:46:56:943 [INFO] [MXServer] [] DataSet [dataSet4] close called.
    21 三月 2023 15:46:56:959 [INFO] [MXServer] [] DataSet [dataSet5] open called.
    21 三月 2023 15:46:56:960 [DEBUG] [MXServer] [] DataSet [dataSet5] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:56:964 [INFO] [MXServer] [] DataSet [dataSet5]: select WORKTICKETLINE.LINEID,WORKTICKETLINE.DESC1,WORKTICKETLINE.YORN1,WORKTICKETLINE.EXECUTOR,JXZL  from worktic
    ket  left join WORKTICKETLINE on WORKTICKETLINE.tynum=workticket.tynum and WORKTICKETLINE.type ='QT'  where ( ( workticket.workticketid  =  45972 )) order by WORKTICKETLINE.LINEID
    asc
    21 三月 2023 15:46:57:005 [INFO] [MXServer] [] DataSet [dataSet5] close called.
    21 三月 2023 15:46:57:017 [INFO] [MXServer] [] DataSet [dataSet] open called.
    21 三月 2023 15:46:57:018 [DEBUG] [MXServer] [] DataSet [dataSet] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:57:021 [INFO] [MXServer] [] DataSet [dataSet]: select wt11,wt23,wt104,wt67,wt69,WT74,WT77,WTNUM,(SELECT DESCRIPTION FROM DEPT WHERE DEPT=WORKTICKET.WT3)WT3,WT4,(
    select displayname from person where personid=workticket.createby) createby,        WT12,WT10,ASSETNUM,ASSET,WT13,WT14,WORKPLACE,        A_WT2,A_WT25,FROMWTNUM,A_DEPT,YQREASON,STAT
    US,        (select displayname from person where personid=WT15)WT15,CHANGEDATE,        (select displayname from person where personid=WT55)WT55,WT16,        (select displayname fro
    m person where personid=WT17)WT17,WT18,        (select displayname from person where personid=WT46)WT46,STATUSDATE,WT19,        QZDATE1,(select displayname from person where person
    id=WT22)WT22,        (select displayname from person where personid=WT30)WT30,        (select displayname from person where personid=WT24)WT24,        (select displayname from pers
    on where personid=WT25)WT25,        (select displayname from person where personid=WT27)WT27,WT26,        (select displayname from person where personid=WT48)WT48,WT31,        (sel
    ect displayname from person where personid=WT38)WT38,WT33,        WT53,WT29,(select displayname from person where personid=WT54)WT54,       (select displayname from person where pe
    rsonid=WT65)WT65,       (select displayname from person where personid=WT2)WT2,       (select displayname from person where personid=WT39)WT39,       (select displayname from perso
    n where personid=WT73)WT73,       (select displayname from person where personid=WT75)WT75,       (select displayname from person where personid=WT76)WT76,       (select displaynam
    e from person where personid=WT63)WT63,        WT37,(select displayname from person where personid=WT78)WT78,       (select displayname from person where personid=WT64)WT64,WT1,A_D
    QWTNUM,       (select displayname from person where personid=WT28)WT28,        DXWTNUM,WT5,LXWTNUM,WT20,WT21,WT110,APPRDATE,        (select displayname from person where personid=W
    T50)WT50,WT51,WT52,(SELECT DESCRIPTION FROM SITE WHERE SITEID=WORKTICKET.SITEID)SITE,        RESULT,REASON,REPORT,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.CHECKBY)
    CHECKBY,CHECKDATE,              (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_XKR)XKR,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.hqby)hqr,
                    (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_ZBR)ZBR from workticket  where ( ( workticket.workticketid  =  45972 )) and WTTYPE='HDRLJX'
    21 三月 2023 15:46:57:034 [INFO] [MXServer] [] DataSet [dataSet] close called.
    21 三月 2023 15:46:57:043 [INFO] [MXServer] [] DataSet [dataSet6] open called.
    21 三月 2023 15:46:57:044 [DEBUG] [MXServer] [] DataSet [dataSet6] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:57:049 [INFO] [MXServer] [] DataSet [dataSet6]: select WORKTICKETLINE.LINEID,WORKTICKETLINE.DESC1,WORKTICKETLINE.YORN1 from workticket  left join WORKTICKETLINE
    on WORKTICKETLINE.tynum=workticket.tynum and WORKTICKETLINE.type ='YX'  where ( ( workticket.workticketid  =  45972 )) order by WORKTICKETLINE.LINEID asc
    21 三月 2023 15:46:57:093 [INFO] [MXServer] [] DataSet [dataSet6] close called.
    21 三月 2023 15:46:57:117 [INFO] [MXServer] [] DataSet [dataSet] open called.
    21 三月 2023 15:46:57:180 [DEBUG] [MXServer] [] DataSet [dataSet] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:57:183 [INFO] [MXServer] [] DataSet [dataSet]: select wt11,wt23,wt104,wt67,wt69,WT74,WT77,WTNUM,(SELECT DESCRIPTION FROM DEPT WHERE DEPT=WORKTICKET.WT3)WT3,WT4,(
    select displayname from person where personid=workticket.createby) createby,        WT12,WT10,ASSETNUM,ASSET,WT13,WT14,WORKPLACE,        A_WT2,A_WT25,FROMWTNUM,A_DEPT,YQREASON,STAT
    US,        (select displayname from person where personid=WT15)WT15,CHANGEDATE,        (select displayname from person where personid=WT55)WT55,WT16,        (select displayname fro
    m person where personid=WT17)WT17,WT18,        (select displayname from person where personid=WT46)WT46,STATUSDATE,WT19,        QZDATE1,(select displayname from person where person
    id=WT22)WT22,        (select displayname from person where personid=WT30)WT30,        (select displayname from person where personid=WT24)WT24,        (select displayname from pers
    on where personid=WT25)WT25,        (select displayname from person where personid=WT27)WT27,WT26,        (select displayname from person where personid=WT48)WT48,WT31,        (sel
    ect displayname from person where personid=WT38)WT38,WT33,        WT53,WT29,(select displayname from person where personid=WT54)WT54,       (select displayname from person where pe
    rsonid=WT65)WT65,       (select displayname from person where personid=WT2)WT2,       (select displayname from person where personid=WT39)WT39,       (select displayname from perso
    n where personid=WT73)WT73,       (select displayname from person where personid=WT75)WT75,       (select displayname from person where personid=WT76)WT76,       (select displaynam
    e from person where personid=WT63)WT63,        WT37,(select displayname from person where personid=WT78)WT78,       (select displayname from person where personid=WT64)WT64,WT1,A_D
    QWTNUM,       (select displayname from person where personid=WT28)WT28,        DXWTNUM,WT5,LXWTNUM,WT20,WT21,WT110,APPRDATE,        (select displayname from person where personid=W
    T50)WT50,WT51,WT52,(SELECT DESCRIPTION FROM SITE WHERE SITEID=WORKTICKET.SITEID)SITE,        RESULT,REASON,REPORT,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.CHECKBY)
    CHECKBY,CHECKDATE,              (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_XKR)XKR,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.hqby)hqr,
                    (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_ZBR)ZBR from workticket  where ( ( workticket.workticketid  =  45972 )) and WTTYPE='HDRLJX'
    21 三月 2023 15:46:57:197 [INFO] [MXServer] [] DataSet [dataSet] close called.
    21 三月 2023 15:46:57:200 [INFO] [MXServer] [] DataSet [dataSet] open called.
    21 三月 2023 15:46:57:201 [DEBUG] [MXServer] [] DataSet [dataSet] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:57:205 [INFO] [MXServer] [] DataSet [dataSet]: select wt11,wt23,wt104,wt67,wt69,WT74,WT77,WTNUM,(SELECT DESCRIPTION FROM DEPT WHERE DEPT=WORKTICKET.WT3)WT3,WT4,(
    select displayname from person where personid=workticket.createby) createby,        WT12,WT10,ASSETNUM,ASSET,WT13,WT14,WORKPLACE,        A_WT2,A_WT25,FROMWTNUM,A_DEPT,YQREASON,STAT
    US,        (select displayname from person where personid=WT15)WT15,CHANGEDATE,        (select displayname from person where personid=WT55)WT55,WT16,        (select displayname fro
    m person where personid=WT17)WT17,WT18,        (select displayname from person where personid=WT46)WT46,STATUSDATE,WT19,        QZDATE1,(select displayname from person where person
    id=WT22)WT22,        (select displayname from person where personid=WT30)WT30,        (select displayname from person where personid=WT24)WT24,        (select displayname from pers
    on where personid=WT25)WT25,        (select displayname from person where personid=WT27)WT27,WT26,        (select displayname from person where personid=WT48)WT48,WT31,        (sel
    ect displayname from person where personid=WT38)WT38,WT33,        WT53,WT29,(select displayname from person where personid=WT54)WT54,       (select displayname from person where pe
    rsonid=WT65)WT65,       (select displayname from person where personid=WT2)WT2,       (select displayname from person where personid=WT39)WT39,       (select displayname from perso
    n where personid=WT73)WT73,       (select displayname from person where personid=WT75)WT75,       (select displayname from person where personid=WT76)WT76,       (select displaynam
    e from person where personid=WT63)WT63,        WT37,(select displayname from person where personid=WT78)WT78,       (select displayname from person where personid=WT64)WT64,WT1,A_D
    QWTNUM,       (select displayname from person where personid=WT28)WT28,        DXWTNUM,WT5,LXWTNUM,WT20,WT21,WT110,APPRDATE,        (select displayname from person where personid=W
    T50)WT50,WT51,WT52,(SELECT DESCRIPTION FROM SITE WHERE SITEID=WORKTICKET.SITEID)SITE,        RESULT,REASON,REPORT,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.CHECKBY)
    CHECKBY,CHECKDATE,              (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_XKR)XKR,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.hqby)hqr,
                    (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_ZBR)ZBR from workticket  where ( ( workticket.workticketid  =  45972 )) and WTTYPE='HDRLJX'
    21 三月 2023 15:46:57:217 [INFO] [MXServer] [] DataSet [dataSet] close called.
    21 三月 2023 15:46:57:220 [INFO] [MXServer] [] DataSet [dataSet] open called.
    21 三月 2023 15:46:57:221 [DEBUG] [MXServer] [] DataSet [dataSet] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:57:224 [INFO] [MXServer] [] DataSet [dataSet]: select wt11,wt23,wt104,wt67,wt69,WT74,WT77,WTNUM,(SELECT DESCRIPTION FROM DEPT WHERE DEPT=WORKTICKET.WT3)WT3,WT4,(
    select displayname from person where personid=workticket.createby) createby,        WT12,WT10,ASSETNUM,ASSET,WT13,WT14,WORKPLACE,        A_WT2,A_WT25,FROMWTNUM,A_DEPT,YQREASON,STAT
    US,        (select displayname from person where personid=WT15)WT15,CHANGEDATE,        (select displayname from person where personid=WT55)WT55,WT16,        (select displayname fro
    m person where personid=WT17)WT17,WT18,        (select displayname from person where personid=WT46)WT46,STATUSDATE,WT19,        QZDATE1,(select displayname from person where person
    id=WT22)WT22,        (select displayname from person where personid=WT30)WT30,        (select displayname from person where personid=WT24)WT24,        (select displayname from pers
    on where personid=WT25)WT25,        (select displayname from person where personid=WT27)WT27,WT26,        (select displayname from person where personid=WT48)WT48,WT31,        (sel
    ect displayname from person where personid=WT38)WT38,WT33,        WT53,WT29,(select displayname from person where personid=WT54)WT54,       (select displayname from person where pe
    rsonid=WT65)WT65,       (select displayname from person where personid=WT2)WT2,       (select displayname from person where personid=WT39)WT39,       (select displayname from perso
    n where personid=WT73)WT73,       (select displayname from person where personid=WT75)WT75,       (select displayname from person where personid=WT76)WT76,       (select displaynam
    e from person where personid=WT63)WT63,        WT37,(select displayname from person where personid=WT78)WT78,       (select displayname from person where personid=WT64)WT64,WT1,A_D
    QWTNUM,       (select displayname from person where personid=WT28)WT28,        DXWTNUM,WT5,LXWTNUM,WT20,WT21,WT110,APPRDATE,        (select displayname from person where personid=W
    T50)WT50,WT51,WT52,(SELECT DESCRIPTION FROM SITE WHERE SITEID=WORKTICKET.SITEID)SITE,        RESULT,REASON,REPORT,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.CHECKBY)
    CHECKBY,CHECKDATE,              (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_XKR)XKR,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.hqby)hqr,
                    (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_ZBR)ZBR from workticket  where ( ( workticket.workticketid  =  45972 )) and WTTYPE='HDRLJX'
    21 三月 2023 15:46:57:237 [INFO] [MXServer] [] DataSet [dataSet] close called.
    21 三月 2023 15:46:57:240 [INFO] [MXServer] [] DataSet [dataSet] open called.
    21 三月 2023 15:46:57:241 [DEBUG] [MXServer] [] DataSet [dataSet] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:57:244 [INFO] [MXServer] [] DataSet [dataSet]: select wt11,wt23,wt104,wt67,wt69,WT74,WT77,WTNUM,(SELECT DESCRIPTION FROM DEPT WHERE DEPT=WORKTICKET.WT3)WT3,WT4,(
    select displayname from person where personid=workticket.createby) createby,        WT12,WT10,ASSETNUM,ASSET,WT13,WT14,WORKPLACE,        A_WT2,A_WT25,FROMWTNUM,A_DEPT,YQREASON,STAT
    US,        (select displayname from person where personid=WT15)WT15,CHANGEDATE,        (select displayname from person where personid=WT55)WT55,WT16,        (select displayname fro
    m person where personid=WT17)WT17,WT18,        (select displayname from person where personid=WT46)WT46,STATUSDATE,WT19,        QZDATE1,(select displayname from person where person
    id=WT22)WT22,        (select displayname from person where personid=WT30)WT30,        (select displayname from person where personid=WT24)WT24,        (select displayname from pers
    on where personid=WT25)WT25,        (select displayname from person where personid=WT27)WT27,WT26,        (select displayname from person where personid=WT48)WT48,WT31,        (sel
    ect displayname from person where personid=WT38)WT38,WT33,        WT53,WT29,(select displayname from person where personid=WT54)WT54,       (select displayname from person where pe
    rsonid=WT65)WT65,       (select displayname from person where personid=WT2)WT2,       (select displayname from person where personid=WT39)WT39,       (select displayname from perso
    n where personid=WT73)WT73,       (select displayname from person where personid=WT75)WT75,       (select displayname from person where personid=WT76)WT76,       (select displaynam
    e from person where personid=WT63)WT63,        WT37,(select displayname from person where personid=WT78)WT78,       (select displayname from person where personid=WT64)WT64,WT1,A_D
    QWTNUM,       (select displayname from person where personid=WT28)WT28,        DXWTNUM,WT5,LXWTNUM,WT20,WT21,WT110,APPRDATE,        (select displayname from person where personid=W
    T50)WT50,WT51,WT52,(SELECT DESCRIPTION FROM SITE WHERE SITEID=WORKTICKET.SITEID)SITE,        RESULT,REASON,REPORT,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.CHECKBY)
    CHECKBY,CHECKDATE,              (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_XKR)XKR,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.hqby)hqr,
                    (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_ZBR)ZBR from workticket  where ( ( workticket.workticketid  =  45972 )) and WTTYPE='HDRLJX'
    21 三月 2023 15:46:57:257 [INFO] [MXServer] [] DataSet [dataSet] close called.
    21 三月 2023 15:46:57:262 [INFO] [MXServer] [] DataSet [dataSet] open called.
    21 三月 2023 15:46:57:263 [DEBUG] [MXServer] [] DataSet [dataSet] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:57:266 [INFO] [MXServer] [] DataSet [dataSet]: select wt11,wt23,wt104,wt67,wt69,WT74,WT77,WTNUM,(SELECT DESCRIPTION FROM DEPT WHERE DEPT=WORKTICKET.WT3)WT3,WT4,(
    select displayname from person where personid=workticket.createby) createby,        WT12,WT10,ASSETNUM,ASSET,WT13,WT14,WORKPLACE,        A_WT2,A_WT25,FROMWTNUM,A_DEPT,YQREASON,STAT
    US,        (select displayname from person where personid=WT15)WT15,CHANGEDATE,        (select displayname from person where personid=WT55)WT55,WT16,        (select displayname fro
    m person where personid=WT17)WT17,WT18,        (select displayname from person where personid=WT46)WT46,STATUSDATE,WT19,        QZDATE1,(select displayname from person where person
    id=WT22)WT22,        (select displayname from person where personid=WT30)WT30,        (select displayname from person where personid=WT24)WT24,        (select displayname from pers
    on where personid=WT25)WT25,        (select displayname from person where personid=WT27)WT27,WT26,        (select displayname from person where personid=WT48)WT48,WT31,        (sel
    ect displayname from person where personid=WT38)WT38,WT33,        WT53,WT29,(select displayname from person where personid=WT54)WT54,       (select displayname from person where pe
    rsonid=WT65)WT65,       (select displayname from person where personid=WT2)WT2,       (select displayname from person where personid=WT39)WT39,       (select displayname from perso
    n where personid=WT73)WT73,       (select displayname from person where personid=WT75)WT75,       (select displayname from person where personid=WT76)WT76,       (select displaynam
    e from person where personid=WT63)WT63,        WT37,(select displayname from person where personid=WT78)WT78,       (select displayname from person where personid=WT64)WT64,WT1,A_D
    QWTNUM,       (select displayname from person where personid=WT28)WT28,        DXWTNUM,WT5,LXWTNUM,WT20,WT21,WT110,APPRDATE,        (select displayname from person where personid=W
    T50)WT50,WT51,WT52,(SELECT DESCRIPTION FROM SITE WHERE SITEID=WORKTICKET.SITEID)SITE,        RESULT,REASON,REPORT,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.CHECKBY)
    CHECKBY,CHECKDATE,              (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_XKR)XKR,(SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.hqby)hqr,
                    (SELECT DISPLAYNAME FROM PERSON WHERE PERSONID=workticket.BCCS_ZBR)ZBR from workticket  where ( ( workticket.workticketid  =  45972 )) and WTTYPE='HDRLJX'
    21 三月 2023 15:46:57:279 [INFO] [MXServer] [] DataSet [dataSet] close called.
    21 三月 2023 15:46:57:285 [INFO] [MXServer] [] DataSet [dataSet7] open called.
    21 三月 2023 15:46:57:286 [DEBUG] [MXServer] [] DataSet [dataSet7] processQuery: Extension view not required; using default query.
    21 三月 2023 15:46:57:291 [INFO] [MXServer] [] DataSet [dataSet7]: select WORKTICKETKG.NUM,WORKTICKETKG.DATE1, (select displayname from person where person.personid=WORKTICKETKG.PE
    RSON1 and person.LOCATIONSITE=WORKTICKETKG.SITEID)person1, (select displayname from person where person.personid=WORKTICKETKG.PERSON2 and person.LOCATIONSITE=WORKTICKETKG.SITEID)pe
    rson2, WORKTICKETKG.DATE2, (select displayname from person where person.personid=WORKTICKETKG.PERSON3 and person.LOCATIONSITE=WORKTICKETKG.SITEID)person3, (select displayname from
    person where person.personid=WORKTICKETKG.PERSON4 and person.LOCATIONSITE=WORKTICKETKG.SITEID)person4  from workticket  left join WORKTICKETKG on WORKTICKETKG.WORKTICKETNUM=worktic
    ket.WTNUM and WORKTICKETKG.siteid=workticket.siteid  where ( ( workticket.workticketid  =  45972 ))
    21 三月 2023 15:46:57:307 [INFO] [MXServer] [] DataSet [dataSet7] close called.
    21 三月 2023 15:46:57:327 [DEBUG] [MXServer] [] close report script context
    21 三月 2023 15:46:57:328 [DEBUG] [MXServer] [] Removed active report thread: [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)']
    21 三月 2023 15:46:57:335 [DEBUG] [MXServer] [] Removed ReportJobId: [196836]
    21 三月 2023 15:46:57:336 [DEBUG] [MXServer] [] MXReportScriptContext com.ibm.tivoli.maximo.report.script.MXReportScriptContext@4a1af144 removed from MXReportJobCancelThread
    21 三月 2023 15:46:57:359 [INFO] [MXServer] [] DataSource [maximoDataSource] connection = com.ibm.db2.jcc.t4.b@5fb50e00  - CLOSED
    21 三月 2023 15:46:59:601 [DEBUG] [MXServer] [] Report Queue Manager about to execute queued Jobs
    21 三月 2023 15:46:59:601 [DEBUG] [MXServer] [] Report Queue Manager is idle
    21 三月 2023 15:47:03:103 [INFO] [MXServer] [CID-CRON-8681] Correlation started.
    21 三月 2023 15:47:03:119 [INFO] [MXServer] [CID-CRON-8681] Correlated data: BEGIN InstanceName:AsyncImmediate TaskName:AsyncImmediateJobCron ElapsedTime:16 ms  END



    ------------------------------
    chen wenming
    ------------------------------



    #MaximoEAM
    #AssetandFacilitiesManagement
    #Maximo