"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