Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Maximo7.6; When accessing the birt report through VPN network, the application is normal, but the birt report is blank

    Posted Tue March 14, 2023 11:02 AM

    Hello, I have deployed the maximo system in the intranet. 114. The address is mapped to 10.20.108.30:17001 through the data exchange platform. The user accesses the address by dialing the vpn service http://10.20.108.30:17001/maximo Access the maximo76 system. The application system works normally, but most of the win10  win11 preview reports appear blank; Only a few Windows 7 systems can use IE browser to preview reports; Other browsers cannot access

     it;

    However, it is reported that everything is normal through internal network access;

    @The preview report is as follows: display nothing#
    ###The console input is as follows:

    V232setReportComments() entering
    14 三月 2023 19:17:47:723 [INFO] [MXServer] [] Saved file
    14 三月 2023 19:17:47:723 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesi
    gnPatchHyperlinkcomplete() exiting
    14 三月 2023 19:17:47:723 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.ReportDesi
    gnPatchHyperlinkexecute() exiting
    14 三月 2023 19:17:47:723 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoRepo
    rtCodePatcherprocess() exiting
    14 三月 2023 19:17:47:723 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoRepo
    rtCodePatchercomplete() entering
    14 三月 2023 19:17:47:723 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoRepo
    rtCodePatchercomplete() exiting
    14 三月 2023 19:17:47:723 [DEBUG] [MXServer] [] com.ibm.tivoli.maximo.report.birt.patcher.MaximoRepo
    rtCodePatcherexecute() exiting
    14 三月 2023 19:17:47:723 [DEBUG] [MXServer] [] Opening report design.
    14 三月 2023 19:17:47:800 [DEBUG] [MXServer] [] Opening report design.
    14 三月 2023 19:17:47:804 [DEBUG] [MXServer] [] Opening report design.
    14 三月 2023 19:17:47:822 [DEBUG] [MXServer] [] Identified Parameter with name: (where)
    14 三月 2023 19:17:47:823 [DEBUG] [MXServer] [] Identified Parameter with name: (appname)
    14 三月 2023 19:17:47:823 [DEBUG] [MXServer] [] Identified Parameter with name: (paramdelimiter)
    14 三月 2023 19:17:47:823 [DEBUG] [MXServer] [] Identified Parameter with name: (paramstring)
    14 三月 2023 19:17:47:823 [DEBUG] [MXServer] [] Identified Parameter with name: (commoditygroup)
    14 三月 2023 19:17:47:823 [DEBUG] [MXServer] [] Identified Parameter with name: (vendor)
    14 三月 2023 19:17:47:823 [DEBUG] [MXServer] [] Identified Parameter with name: (buyer)
    14 三月 2023 19:17:47:823 [DEBUG] [MXServer] [] Identified Parameter with name: (glaccount)
    14 三月 2023 19:17:47:823 [DEBUG] [MXServer] [] Identified Parameter with name: (startdate)
    14 三月 2023 19:17:47:823 [DEBUG] [MXServer] [] Identified Parameter with name: (enddate)
    14 三月 2023 19:17:47:952 [DEBUG] [MXServer] []

    Report parameters for RequestID = 1678792667212
    encoding=UTF-8
    schema = maximo
    reportNum = 481
    mroSite = NYDC
    commoditygroup =
    reportFile = commodity_anlys.rptdesign
    startdate = 1990-03-01
    locale = zh_CN
    fromEmail = no
    emails =
    qbrDisplayWhere =
    reportType = BIRT
    appname = ITEM
    paramstring = appHierarchy=ITEM
    reportname = commodity_anlys.rptdesign
    vendor =
    where = 1=1
    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
    __islocale = startdate||enddate
    mroOrg = JYJT
    ParmPassword = %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    customserverURL =
    comments =
    __scheduleType = immediate
    mroUniqueKey = 230314191747209_421456
    baseTable = ITEM
    customrptServerLogonPass =
    userName = maxadmin
    mroApp = ITEM
    buyer =
    __newrun = true
    reportDesc = 商品分析
    smtpHost = false
    glaccount =
    enddate = 2023-03-01
    Email_Choice = PDF
    reportFolder = ITEM
    isDuplex = 0
    vendor =
    qbrDisplayWhere =
    isDuplex = 0
    emails =
    customserverURL =
    reportDesc = 商品分析
    __scheduleType = immediate
    locale = zh_CN
    localTZ = Asia/Shanghai
    reportFile = commodity_anlys.rptdesign
    buyer =
    mroUniqueKey = 230314191747209_421456
    __newrun = true
    schema = maximo
    csrftoken = ps5cos4f2gh5qh0f6gh4p815r9
    mroApp = ITEM
    __report = commodity_anlys.rptdesign
    customrptServerLogonPass =
    plain text where = 1=1where = %EF%BF%88%EF%BF%B0%EF%BF%94%40%EF%BE%B18%EF%BF%86%EF%BF%B6
    glaccount =
    smtpHost = false
    reportname = commodity_anlys.rptdesign
    redir = /maximo/report/?__report=commodity_anlys.rptdesign&appname=ITEM&__requestid=1678792667212&ui
    sessionid=8407&csrftoken=ps5cos4f2gh5qh0f6gh4p815r9
    enddate = 2023-03-01
    reportType = BIRT
    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
    redirParams = repositoryType=Enterprise
    commoditygroup =
    appname = ITEM
    appname = ITEM
    startdate = 1990-03-01
    __islocale = startdate
    __islocale = enddate
    Email_Choice = PDF
    __overwrite = new
    fromEmail = no
    mroOrg = JYJT
    __requestid = 1678792667212
    paramdelimiter = ||
    uisessionid = 8407
    userName = maxadmin
    ParmUserName = maximo
    reportNum = 481
    paramstring = appHierarchy=ITEM
    ParmPassword = %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    comments =
    mroSite = NYDC
    reportFolder = ITEM
    baseTable = ITEM

    14 三月 2023 19:17:47:952 [DEBUG] [MXServer] [] Using document = D:\oracle\Middleware\Oracle_Home\us
    er_projects\domains\base_domain\servers\AdminServer\tmp\_WL_user\maximo\vw9y4r\public\reportruntime\
    reports\1678792667524\_output\commodity_anlys.rptdocument
    14 三月 2023 19:17:48:017 [DEBUG] [MXServer] []

    Report parameters for RequestID = 1678792667212
    encoding=UTF-8
    mroSite = NYDC
    startdate = 1990-03-01
    redir = /maximo/report/?__report=commodity_anlys.rptdesign&appname=ITEM&__requestid=1678792667212&ui
    sessionid=8407&csrftoken=ps5cos4f2gh5qh0f6gh4p815r9
    reportType = BIRT
    appname = ITEM
    appname = ITEM
    reportname = commodity_anlys.rptdesign
    localTZ = Asia/Shanghai
    csrftoken = ps5cos4f2gh5qh0f6gh4p815r9
    ParmPassword = %23%EF%BE%83%EF%BF%A8%EF%BE%83%EF%BE%89l%07u
    mroUniqueKey = 230314191747209_421456
    mroApp = ITEM
    __locale = zh_CN
    buyer =
    __newrun = true
    enddate = 2023-03-01
    Email_Choice = PDF
    reportFolder = ITEM
    schema = maximo
    reportNum = 481
    uisessionid = 8407
    commoditygroup =
    reportFile = commodity_anlys.rptdesign
    locale = zh_CN
    fromEmail = no
    emails =
    qbrDisplayWhere =
    paramstring = appHierarchy=ITEM
    vendor =
    where = %EF%BF%88%EF%BF%B0%EF%BF%94%40%EF%BE%B18%EF%BF%86%EF%BF%B6
    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
    __report = 1678792667524\birtreport\commodity_anlys.rptdesign
    __islocale = startdate
    __islocale = enddate
    mroOrg = JYJT
    customserverURL =
    comments =
    __scheduleType = immediate
    baseTable = ITEM
    customrptServerLogonPass =
    userName = maxadmin
    __requestid = 1678792667212
    reportDesc = 商品分析
    smtpHost = false
    glaccount =
    __document = D:\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\
    tmp\_WL_user\maximo\vw9y4r\public\reportruntime\reports\1678792667524\_output\commodity_anlys.rptdoc
    ument
    isDuplex = 0
    uisessionid = 8407
    __report = commodity_anlys.rptdesign
    csrftoken = ps5cos4f2gh5qh0f6gh4p815r9
    __requestid = 1678792667212
    appname = ITEM

    14 三月 2023 19:17:48:017 [DEBUG] [MXServer] [] Using document = D:\oracle\Middleware\Oracle_Home\us
    er_projects\domains\base_domain\servers\AdminServer\tmp\_WL_user\maximo\vw9y4r\public\reportruntime\
    reports\1678792667524\_output\commodity_anlys.rptdocument
    %%%%%%%%%%% FRAMESET FRAGMENT %%%% CONTEXT PATH = /maximo/bridge
    %%%%%%%%%%% FRAMESET FRAGMENT %%%% REQ CONTEXT PATH = /maximo
    Base URL:http://10.20.108.30:17001
    %%%%%%%% FRAMESET FRAGMENT SOAP URL = http://10.20.108.30:17001/maximo/bridge/frameset?__report=1678
    792667524%5Cbirtreport%5Ccommodity_anlys.rptdesign&__islocale=startdate&__scheduleType=immediate&__l
    ocale=zh_CN&__newrun=true&__requestid=1678792667212&__document=D%3A%5Coracle%5CMiddleware%5COracle_H
    ome%5Cuser_projects%5Cdomains%5Cbase_domain%5Cservers%5CAdminServer%5Ctmp%5C_WL_user%5Cmaximo%5Cvw9y
    4r%5Cpublic%5Creportruntime%5Creports%5C1678792667524%5C_output%5Ccommodity_anlys.rptdocument
    %%%%%%%% FRAMESET FRAGMENT SOAP URL XX = http://localhost:7001/maximo/report?__report=1678792667524%
    5Cbirtreport%5Ccommodity_anlys.rptdesign&__islocale=startdate&__scheduleType=immediate&__locale=zh_C
    N&__newrun=true&__requestid=1678792667212&__document=D%3A%5Coracle%5CMiddleware%5COracle_Home%5Cuser
    _projects%5Cdomains%5Cbase_domain%5Cservers%5CAdminServer%5Ctmp%5C_WL_user%5Cmaximo%5Cvw9y4r%5Cpubli
    c%5Creportruntime%5Creports%5C1678792667524%5C_output%5Ccommodity_anlys.rptdocument
    14 三月 2023 19:17:55:172 [INFO] [MXServer] [CID-CRON-60294] Correlation started.
    14 三月 2023 19:17:55:180 [INFO] [MXServer] [CID-CRON-60294] Correlated data: BEGIN InstanceName:Asy
    ncImmediate TaskName:AsyncImmediateJobCron ElapsedTime:8 ms  END
    14 三月 2023 19:18:02:208 [DEBUG] [MXServer] [] ReportCancelStatusUpdateThread getting cancelled rep
    orts from database
    14 三月 2023 19:18:05:175 [INFO] [MXServer] [CID-CRON-60295] Correlation started.
    14 三月 2023 19:18:05:186 [INFO] [MXServer] [CID-CRON-60295] Correlated data: BEGIN InstanceName:Asy
    ncImmediate TaskName:AsyncImmediateJobCron ElapsedTime:11 ms  END
    14 三月 2023 19:18:09:778 [INFO] [MXServer] [] ACTION: mbosets (33), mbos (66)
    14 三月 2023 19:18:09:780 [INFO] [MXServer] [] ACTIONGROUP: mbosets (7), mbos (32)
    14 三月 2023 19:18:09:781 [INFO] [MXServer] [] ALNDOMAIN: mbosets (113), mbos (366)
    14 三月 2023 19:18:09:782 [INFO] [MXServer] [] ALTITEM: mbosets (1), mbos (1)
    14 三月 2023 19:18:09:783 [INFO] [MXServer] [] APPLICATIONAUTH: mbosets (null), mbos (148)
    14 三月 2023 19:18:09:784 [INFO] [MXServer] [] ASSET: mbosets (6), mbos (8)
    14 三月 2023 19:18:09:784 [INFO] [MXServer] [] BULLETINBOARD: mbosets (3), mbos (6)
    14 三月 2023 19:18:09:785 [INFO] [MXServer] [] COMMODITIES: mbosets (4), mbos (5)
    14 三月 2023 19:18:09:787 [INFO] [MXServer] [] COMMTEMPLATE: mbosets (291), mbos (295)
    14 三月 2023 19:18:09:788 [INFO] [MXServer] [] COMPLETEWF: mbosets (2), mbos (4)
    14 三月 2023 19:18:09:789 [INFO] [MXServer] [] CRONTASKDEF: mbosets (45), mbos (90)
    14 三月 2023 19:18:09:790 [INFO] [MXServer] [] CRONTASKINSTANCE: mbosets (90), mbos (180)
    14 三月 2023 19:18:09:791 [INFO] [MXServer] [] CRONTASKPARAM: mbosets (89), mbos (158)
    14 三月 2023 19:18:09:792 [INFO] [MXServer] [] CUSTCZP: mbosets (9), mbos (162)
    14 三月 2023 19:18:09:793 [INFO] [MXServer] [] CUSTCZPLINE: mbosets (371), mbos (130)
    14 三月 2023 19:18:09:794 [INFO] [MXServer] [] CUSTDQECACP: mbosets (82), mbos (1)
    14 三月 2023 19:18:09:796 [INFO] [MXServer] [] DEPT: mbosets (462), mbos (849)
    14 三月 2023 19:18:09:797 [INFO] [MXServer] [] DEPTPERSON: mbosets (388), mbos (554)
    14 三月 2023 19:18:09:798 [INFO] [MXServer] [] DMCOLLAPPTOOLBAR: mbosets (3), mbos (3)
    14 三月 2023 19:18:09:799 [INFO] [MXServer] [] DUMMY_TABLE: mbosets (112), mbos (112)
    14 三月 2023 19:18:09:800 [INFO] [MXServer] [] EFILEREADCFG: mbosets (null), mbos (2289)
    14 三月 2023 19:18:09:801 [INFO] [MXServer] [] EMAIL: mbosets (4), mbos (5)
    14 三月 2023 19:18:09:802 [INFO] [MXServer] [] EVENTRESPONSE: mbosets (2), mbos (2)
    14 三月 2023 19:18:09:803 [INFO] [MXServer] [] FACONFIG: mbosets (10), mbos (71)
    14 三月 2023 19:18:09:805 [INFO] [MXServer] [] IMGLIB: mbosets (1), mbos (1)
    14 三月 2023 19:18:09:806 [INFO] [MXServer] [] INBXCONFIG: mbosets (5), mbos (26)
    14 三月 2023 19:18:09:806 [INFO] [MXServer] [] INITIATEWORKFLOW: mbosets (1), mbos (2)
    14 三月 2023 19:18:09:807 [INFO] [MXServer] [] INVBALANCES: mbosets (22), mbos (30)
    14 三月 2023 19:18:09:809 [INFO] [MXServer] [] ITEM: mbosets (4), mbos (26)
    14 三月 2023 19:18:09:810 [INFO] [MXServer] [] ITEMCONDITION: mbosets (1), mbos (1)
    14 三月 2023 19:18:09:811 [INFO] [MXServer] [] LAYOUT: mbosets (5), mbos (37)
    14 三月 2023 19:18:09:812 [INFO] [MXServer] [] LONGDESCRIPTION: mbosets (293), mbos (293)
    14 三月 2023 19:18:09:813 [INFO] [MXServer] [] MAXAPPS: mbosets (9), mbos (348)
    14 三月 2023 19:18:09:814 [INFO] [MXServer] [] MAXGROUP: mbosets (20), mbos (126)
    14 三月 2023 19:18:09:816 [INFO] [MXServer] [] MAXLABELS: mbosets (null), mbos (2381)
    14 三月 2023 19:18:09:817 [INFO] [MXServer] [] MAXLOGMSGTOOLBAR: mbosets (3), mbos (3)
    14 三月 2023 19:18:09:818 [INFO] [MXServer] [] MAXRECORDLOCK: mbosets (1), mbos (1)
    14 三月 2023 19:18:09:819 [INFO] [MXServer] [] MAXROLE: mbosets (6), mbos (12)
    14 三月 2023 19:18:09:820 [INFO] [MXServer] [] MAXSESSION: mbosets (1), mbos (3)
    14 三月 2023 19:18:09:821 [INFO] [MXServer] [] MAXUSER: mbosets (338), mbos (4688)
    14 三月 2023 19:18:09:822 [INFO] [MXServer] [] METER: mbosets (2), mbos (2)
    14 三月 2023 19:18:09:823 [INFO] [MXServer] [] METERGROUP: mbosets (2), mbos (2)
    14 三月 2023 19:18:09:824 [INFO] [MXServer] [] PERSON: mbosets (1830), mbos (2992)
    14 三月 2023 19:18:09:825 [INFO] [MXServer] [] PERSONTITLE: mbosets (2), mbos (18)
    14 三月 2023 19:18:09:826 [INFO] [MXServer] [] PHONE: mbosets (24), mbos (35)
    14 三月 2023 19:18:09:827 [INFO] [MXServer] [] QUERY: mbosets (32), mbos (44)
    14 三月 2023 19:18:09:828 [INFO] [MXServer] [] REPFACAUTH: mbosets (36), mbos (36)
    14 三月 2023 19:18:09:829 [INFO] [MXServer] [] REPORT: mbosets (2), mbos (4)
    14 三月 2023 19:18:09:830 [INFO] [MXServer] [] REPORTJOB: mbosets (1), mbos (1)
    14 三月 2023 19:18:09:831 [INFO] [MXServer] [] REPORTLIST: mbosets (1), mbos (2)
    14 三月 2023 19:18:09:832 [INFO] [MXServer] [] REPORTSCHED: mbosets (1), mbos (1)
    14 三月 2023 19:18:09:833 [INFO] [MXServer] [] RESULTSETCOLS: mbosets (null), mbos (1)
    14 三月 2023 19:18:09:834 [INFO] [MXServer] [] RSCONFIG: mbosets (12), mbos (38)
    14 三月 2023 19:18:09:835 [INFO] [MXServer] [] SCCONFIG: mbosets (5), mbos (10)
    14 三月 2023 19:18:09:836 [INFO] [MXServer] [] SITE: mbosets (231), mbos (396)
    14 三月 2023 19:18:09:837 [INFO] [MXServer] [] SITEAUTH: mbosets (89), mbos (89)
    14 三月 2023 19:18:09:838 [INFO] [MXServer] [] SYNONYMDOMAIN: mbosets (696), mbos (1384)
    14 三月 2023 19:18:09:839 [INFO] [MXServer] [] TASKSCHEDULER: mbosets (32), mbos (64)
    14 三月 2023 19:18:09:840 [INFO] [MXServer] [] THREEPLINE: mbosets (2), mbos (143)
    14 三月 2023 19:18:09:841 [INFO] [MXServer] [] WFACTION: mbosets (27), mbos (78)
    14 三月 2023 19:18:09:842 [INFO] [MXServer] [] WFAPPTOOLBAR: mbosets (51), mbos (95)
    14 三月 2023 19:18:09:843 [INFO] [MXServer] [] WFASGNGROUP: mbosets (19), mbos (13)
    14 三月 2023 19:18:09:844 [INFO] [MXServer] [] WFASSIGNMENT: mbosets (320), mbos (995)
    14 三月 2023 19:18:09:845 [INFO] [MXServer] [] WFCALLSTACK: mbosets (9), mbos (23)
    14 三月 2023 19:18:09:845 [INFO] [MXServer] [] WFCONDITION: mbosets (8), mbos (16)
    14 三月 2023 19:18:09:846 [INFO] [MXServer] [] WFINPUT: mbosets (2), mbos (4)
    14 三月 2023 19:18:09:847 [INFO] [MXServer] [] WFINSTANCE: mbosets (15), mbos (18)
    14 三月 2023 19:18:09:848 [INFO] [MXServer] [] WFINTERACTION: mbosets (1), mbos (2)
    14 三月 2023 19:18:09:849 [INFO] [MXServer] [] WFNODE: mbosets (27), mbos (742)
    14 三月 2023 19:18:09:850 [INFO] [MXServer] [] WFNOTIFICATION: mbosets (36), mbos (36)
    14 三月 2023 19:18:09:851 [INFO] [MXServer] [] WFPROCESS: mbosets (5), mbos (31)
    14 三月 2023 19:18:09:852 [INFO] [MXServer] [] WFSTOP: mbosets (2), mbos (4)
    14 三月 2023 19:18:09:853 [INFO] [MXServer] [] WFTASK: mbosets (36), mbos (67)
    14 三月 2023 19:18:09:854 [INFO] [MXServer] [] WFTOOLBAR: mbosets (51), mbos (102)
    14 三月 2023 19:18:09:855 [INFO] [MXServer] [] WFTRANSACTION: mbosets (16), mbos (53)
    14 三月 2023 19:18:09:856 [INFO] [MXServer] [] WORKTICKET: mbosets (126), mbos (402)
    14 三月 2023 19:18:09:857 [INFO] [MXServer] [] WORKTICKETKG: mbosets (225), mbos (29)
    14 三月 2023 19:18:09:858 [INFO] [MXServer] [] WORKTICKETLINE: mbosets (1826), mbos (660)
    14 三月 2023 19:18:09:859 [INFO] [MXServer] [] WORKTKZY: mbosets (409), mbos (29)
    14 三月 2023 19:18:09:861 [INFO] [MXServer] [] BMXAA6372I - 主机名：127.0.0.1。服务器名称：MXServer
    。Cron 任务名称：AssetTopoCacheCron.AssetTopoCacheCron01。上次运行：2023-03-14 19:07:10.336

    The report can be previewed through the IE browser (ie9) of the windows7 system. The background log is as follows:

    eportDesc = 操作票
    smtpHost = false
    __document = D:\oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\AdminServer\
    tmp\_WL_user\maximo\vw9y4r\public\reportruntime\reports\1678786062890\_output\czp_report.rptdocument

    Email_Choice = PDF
    reportFolder = OPERATION
    isDuplex = 0
    uisessionid = 8246
    __report = czp_report.rptdesign
    csrftoken = 8akt93fuhr4624ccb6vgjhas7s
    __requestid = 1678786057380
    appname = OPERATION

    14 三月 2023 17:27:43:586 [DEBUG] [MXServer] [] Using document = D:\oracle\Middleware\Oracle_Home\us
    er_projects\domains\base_domain\servers\AdminServer\tmp\_WL_user\maximo\vw9y4r\public\reportruntime\
    reports\1678786062890\_output\czp_report.rptdocument
    %%%%%%%%%%% FRAMESET FRAGMENT %%%% CONTEXT PATH = /maximo/bridge
    %%%%%%%%%%% FRAMESET FRAGMENT %%%% REQ CONTEXT PATH = /maximo
    Base URL:http://10.20.108.30:17001
    %%%%%%%% FRAMESET FRAGMENT SOAP URL = http://10.20.108.30:17001/maximo/bridge/frameset?__report=1678
    786062890%5Cbirtreport%5Cczp_report.rptdesign&__scheduleType=immediate&__locale=zh_CN&__newrun=true&
    __requestid=1678786057380&__document=D%3A%5Coracle%5CMiddleware%5COracle_Home%5Cuser_projects%5Cdoma
    ins%5Cbase_domain%5Cservers%5CAdminServer%5Ctmp%5C_WL_user%5Cmaximo%5Cvw9y4r%5Cpublic%5Creportruntim
    e%5Creports%5C1678786062890%5C_output%5Cczp_report.rptdocument
    %%%%%%%% FRAMESET FRAGMENT SOAP URL XX = http://localhost:7001/maximo/report?__report=1678786062890%
    5Cbirtreport%5Cczp_report.rptdesign&__scheduleType=immediate&__locale=zh_CN&__newrun=true&__requesti
    d=1678786057380&__document=D%3A%5Coracle%5CMiddleware%5COracle_Home%5Cuser_projects%5Cdomains%5Cbase
    _domain%5Cservers%5CAdminServer%5Ctmp%5C_WL_user%5Cmaximo%5Cvw9y4r%5Cpublic%5Creportruntime%5Creport
    s%5C1678786062890%5C_output%5Cczp_report.rptdocument
    <2023-3-14 下午05时27分46,038秒 CST> <Warning> <Socket> <BEA-000449> <Closing the socket, as no data
     read from it on 10.78.245.1:1,165 during the configured idle timeout of 5 seconds.>
    14 三月 2023 17:27:47:046 [INFO] [MXServer] [CID-CRON-59186] Correlation started.
    14 三月 2023 17:27:47:054 [INFO] [MXServer] [CID-CRON-59186] Correlated data: BEGIN InstanceName:REP
    ORTLOCKRELEASE1 TaskName:REPORTLOCKRELEASE ElapsedTime:8 ms  END
    14 三月 2023 17:27:47:058 [INFO] [MXServer] [CID-CRON-59187] Correlation started.
    14 三月 2023 17:27:47:070 [INFO] [MXServer] [CID-CRON-59187] Correlated data: BEGIN InstanceName:Asy
    ncScheduled TaskName:AsyncScheduledJobCron ElapsedTime:12 ms  END
    [DESCRIPTION_LONGDESCRIPTION, OBJECTNAME, DISPLAYONE, USERSQL, ISCUSTOMCLASS, OWNERDESCRIPTION, HOST
    NAME, LASTMEMO, CURRENTMEMO, ISOWNERLOCKED, OWNERLOCKEDBY, APPNAME, SQBM, SQDW]
    14 三月 2023 17:27:49:337 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG QUERY OBJECT FOUND =(WORKTICKETID)
    14 三月 2023 17:27:49:337 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG QUERY OBJECT FOUND =(WORKTICKETID)
    14 三月 2023 17:27:49:341 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG UNIQUEID FOR 'WORKTICKET' FIRST PAS
    S =(WORKTICKETID)
    14 三月 2023 17:27:49:341 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG UNIQUEID FOR 'WORKTICKET' FIRST PAS
    S =(WORKTICKETID)
    14 三月 2023 17:27:49:367 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG UNIQUEID  'WORKTICKET'  SECOND PASS
     AFTER COUNT =(WORKTICKETID)
    14 三月 2023 17:27:49:367 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG UNIQUEID  'WORKTICKET'  SECOND PASS
     AFTER COUNT =(WORKTICKETID)
    14 三月 2023 17:27:49:373 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG  FINAL RESULT QUERY=((year(createda
    te)= year(sysdate) and month(createdate)= month(sysdate) and type='普通'  and wtnum is not null and
    status
    not in ('已作废','取消') and siteid in (select siteid from siteauth where groupname in (select group
    name from groupuser
    where userid= '000402169' )) and wttype like 'HD%') AND (exists ((select siteid from siteauth a1,gro
    upuser b1,maxgroup m1,applicationauth  t1  where  b1.userid =  '000402169'    and b1.groupname=a1.gr
    oupname  and b1.groupname=m1.groupname and m1.independent = 1  and a1.groupname = t1.groupname and
    t1.app =  'WTICKET_HD'  and a1.siteid = workticket.siteid )  union all (select siteid from siteauth
    a,groupuser b,maxgroup m  where  b.userid =  '000402169'    and b.groupname=a.groupname  and b.group
    name=m.groupname and m.independent = 0  and  a.siteid = workticket.siteid and ( exists (select 1 fro
    m  maxgroup m2,applicationauth c,groupuser d where  d.userid =  '000402169'  and d.groupname = m2.gr
    oupname and d.groupname = c.groupname and  m2.independent = 0 and c.app =  'WTICKET_HD' ))) )))
    14 三月 2023 17:27:49:373 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG  FINAL RESULT QUERY=((year(createda
    te)= year(sysdate) and month(createdate)= month(sysdate) and type='普通'  and wtnum is not null and
    status
    not in ('已作废','取消') and siteid in (select siteid from siteauth where groupname in (select group
    name from groupuser
    where userid= '000402169' )) and wttype like 'HD%') AND (exists ((select siteid from siteauth a1,gro
    upuser b1,maxgroup m1,applicationauth  t1  where  b1.userid =  '000402169'    and b1.groupname=a1.gr
    oupname  and b1.groupname=m1.groupname and m1.independent = 1  and a1.groupname = t1.groupname and
    t1.app =  'WTICKET_HD'  and a1.siteid = workticket.siteid )  union all (select siteid from siteauth
    a,groupuser b,maxgroup m  where  b.userid =  '000402169'    and b.groupname=a.groupname  and b.group
    name=m.groupname and m.independent = 0  and  a.siteid = workticket.siteid and ( exists (select 1 fro
    m  maxgroup m2,applicationauth c,groupuser d where  d.userid =  '000402169'  and d.groupname = m2.gr
    oupname and d.groupname = c.groupname and  m2.independent = 0 and c.app =  'WTICKET_HD' ))) )))
    14 三月 2023 17:27:49:403 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG  FINAL QUERYORDER BY=(siteid)
    14 三月 2023 17:27:49:403 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG  FINAL QUERYORDER BY=(siteid)
    14 三月 2023 17:27:49:405 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG  QUERYATTRIBUTES=([SITEDES, WTTYPED
    ES, WORKTICKETID])
    14 三月 2023 17:27:49:405 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG  QUERYATTRIBUTES=([SITEDES, WTTYPED
    ES, WORKTICKETID])
    14 三月 2023 17:27:49:492 [DEBUG] [MXServer] [] **** GRAPH GROUP BY QUERY **** select wttypedes, cou
    nt(*) from WORKTICKET where (year(createdate)= year(sysdate) and month(createdate)= month(sysdate) a
    nd type='普通'  and wtnum is not null and status
    not in ('已作废','取消') and siteid in (select siteid from siteauth where groupname in (select group
    name from groupuser
    where userid= '000402169' )) and wttype like 'HD%') AND (exists ((select siteid from siteauth a1,gro
    upuser b1,maxgroup m1,applicationauth  t1  where  b1.userid =  '000402169'    and b1.groupname=a1.gr
    oupname  and b1.groupname=m1.groupname and m1.independent = 1  and a1.groupname = t1.groupname and
    t1.app =  'WTICKET_HD'  and a1.siteid = workticket.siteid )  union all (select siteid from siteauth
    a,groupuser b,maxgroup m  where  b.userid =  '000402169'    and b.groupname=a.groupname  and b.group
    name=m.groupname and m.independent = 0  and  a.siteid = workticket.siteid and ( exists (select 1 fro
    m  maxgroup m2,applicationauth c,groupuser d where  d.userid =  '000402169'  and d.groupname = m2.gr
    oupname and d.groupname = c.groupname and  m2.independent = 0 and c.app =  'WTICKET_HD' ))) )) group
     by wttypedes
    14 三月 2023 17:27:49:492 [DEBUG] [MXServer] [] **** GRAPH GROUP BY QUERY **** select wttypedes, cou
    nt(*) from WORKTICKET where (year(createdate)= year(sysdate) and month(createdate)= month(sysdate) a
    nd type='普通'  and wtnum is not null and status
    not in ('已作废','取消') and siteid in (select siteid from siteauth where groupname in (select group
    name from groupuser
    where userid= '000402169' )) and wttype like 'HD%') AND (exists ((select siteid from siteauth a1,gro
    upuser b1,maxgroup m1,applicationauth  t1  where  b1.userid =  '000402169'    and b1.groupname=a1.gr
    oupname  and b1.groupname=m1.groupname and m1.independent = 1  and a1.groupname = t1.groupname and
    t1.app =  'WTICKET_HD'  and a1.siteid = workticket.siteid )  union all (select siteid from siteauth
    a,groupuser b,maxgroup m  where  b.userid =  '000402169'    and b.groupname=a.groupname  and b.group
    name=m.groupname and m.independent = 0  and  a.siteid = workticket.siteid and ( exists (select 1 fro
    m  maxgroup m2,applicationauth c,groupuser d where  d.userid =  '000402169'  and d.groupname = m2.gr
    oupname and d.groupname = c.groupname and  m2.independent = 0 and c.app =  'WTICKET_HD' ))) )) group
     by wttypedes
    14 三月 2023 17:27:49:633 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG QUERY OBJECT FOUND =(WORKTICKETID)
    14 三月 2023 17:27:49:633 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG QUERY OBJECT FOUND =(WORKTICKETID)
    14 三月 2023 17:27:49:637 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG UNIQUEID FOR 'WORKTICKET' FIRST PAS
    S =(WORKTICKETID)
    14 三月 2023 17:27:49:637 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG UNIQUEID FOR 'WORKTICKET' FIRST PAS
    S =(WORKTICKETID)
    14 三月 2023 17:27:49:656 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG UNIQUEID  'WORKTICKET'  SECOND PASS
     AFTER COUNT =(WORKTICKETID)
    14 三月 2023 17:27:49:656 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG UNIQUEID  'WORKTICKET'  SECOND PASS
     AFTER COUNT =(WORKTICKETID)
    14 三月 2023 17:27:49:663 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG  FINAL RESULT QUERY=((siteid=(selec
    t locationsite from person where personid= '000402169'  ) and status not in ('草稿','驳回','待签发',
    '已终结','已作废','已取消','待接票') and type='普通' and wtnum is not null and wttype like 'HD%') AN
    D (exists ((select siteid from siteauth a1,groupuser b1,maxgroup m1,applicationauth  t1  where  b1.u
    serid =  '000402169'    and b1.groupname=a1.groupname  and b1.groupname=m1.groupname and m1.independ
    ent = 1  and a1.groupname = t1.groupname and  t1.app =  'WTICKET_HD'  and a1.siteid = workticket.sit
    eid )  union all (select siteid from siteauth a,groupuser b,maxgroup m  where  b.userid =  '00040216
    9'    and b.groupname=a.groupname  and b.groupname=m.groupname and m.independent = 0  and  a.siteid
    = workticket.siteid and ( exists (select 1 from  maxgroup m2,applicationauth c,groupuser d where  d.
    userid =  '000402169'  and d.groupname = m2.groupname and d.groupname = c.groupname and  m2.independ
    ent = 0 and c.app =  'WTICKET_HD' ))) )))
    14 三月 2023 17:27:49:663 [DEBUG] [MXServer] [] **RSCONFIG-DEBUG  FINAL RESULT QUERY=((siteid=(selec
    t locationsite from person where personid= '000402169'  ) and status not in ('草稿','驳回','待签发',
    '已终结','已作废','已取消','待接票') and type='普通' and wtnum is not null and wttype like 'HD%') AN
    D (exists ((select siteid from siteauth a1,groupuser b1,maxgroup m1,applicationauth  t1  where  b1.u
    serid =  '000402169'    and b1.groupname=a1.groupname  and b1.groupname=m1.groupname and m1.independ
    ent = 1  and a1.groupname = t1.groupname and  t1.app =  'WTICKET_HD'  and a1.siteid = workticket.sit
    eid )  union all (select siteid from siteauth a,groupuser b,maxgroup m  where  b.userid =  '00040216
    9'    and b.groupname=a.groupname  and b.groupname=m.groupname and m.independent = 0  and  a.siteid
    = workticket.siteid and ( exists (select 1 from  maxgroup m2,applicationauth c,groupuser d where  d.
    userid =  '000402169'  and d.groupname = m2.groupname and d.groupname = c.groupname and  m2.independ



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

    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Maximo7.6; When accessing the birt report through VPN network, the application is normal, but the birt report is blank

    Posted Tue March 14, 2023 07:49 PM

    Hi Chen,

    Have you checked these 2 system properties?

    mxe.report.birt.proxyurlredirect

    mxe.report.birt.viewerurl

    The viewer url should be used if you have a different server to run the birt report, but with your logs, it seems to be trying to redirect to localhost:7001.

    Cheers



    ------------------------------
    Maycon Belfort
    Consultant
    BPD Zenith
    Melbourne
    Australia
    ------------------------------

    Original Message


  • 3.  RE: Maximo7.6; When accessing the birt report through VPN network, the application is normal, but the birt report is blank

    Posted Thu March 16, 2023 12:30 AM
    thanks,  



    Original Message


  • 4.  RE: Maximo7.6; When accessing the birt report through VPN network, the application is normal, but the birt report is blank

    Posted Thu March 16, 2023 12:53 AM
    Thank you for your reply. I will try it now. I can't access the report after modification.
    My report server and application server are deployed together in an ear package.
    My system access address is converted by address: currently, there are three address segments to access:
    1. The internal network is accessed by the same network segment deployed by the maximo application server;
    2. Through the company's enterprise wide area network, this address is converted to i: 10.68.242.141:7001/maximo, and access to this address is also normal;
    3. The other is to access through VPN. The address directly accessed by VPN is: http://10.30.102.30:17001/maximo/ui/ The report is also at this address. It is normal to access the application at this address, but the report cannot be previewed and is blank. Unable to return the data. On the weblogic server console, you can see that the dataset is not executed



    ------------------ 原始邮件 ------------------
    发件人:
    发送时间: 2023年3月15日(星期三) 上午7:51
    收件人: "Avanti"<sacox@qq.com>;
    主题: RE: Maximo : Maximo7.6; When accessing the birt report through VPN network, the application is normal, but the birt report is blank

    Hi Chen, Have you checked these 2 system properties? mxe.report.birt.proxyurlredirect mxe.report.birt.viewerurl The viewer url should... -posted to the "Maximo" group

    Maximo

    Post New Message
    Re: Maximo7.6; When accessing the birt report through VPN network, the application is normal, but the birt report is blank
    Reply to Group Reply to Sender
    Mar 14, 2023 7:49 PM
    Maycon Belfort

    Hi Chen,

    Have you checked these 2 system properties?

    mxe.report.birt.proxyurlredirect

    mxe.report.birt.viewerurl

    The viewer url should be used if you have a different server to run the birt report, but with your logs, it seems to be trying to redirect to localhost:7001.

    Cheers



    ------------------------------
    Maycon Belfort
    Consultant
    BPD Zenith
    Melbourne
    Australia
    ------------------------------
      Reply to Group Online   View Thread   Recommend   Forward   Flag as Inappropriate  

    Original Message



     
    You are receiving this notification because %%FollowingReason%%. If you do not wish to follow this, please click here.

    Update your email preferences to choose the types of email you receive

    Unsubscribe from all participation emails



    Original Message:
    Sent: 3/14/2023 7:49:00 PM
    From: Maycon Belfort
    Subject: RE: Maximo7.6; When accessing the birt report through VPN network, the application is normal, but the birt report is blank

    Hi Chen,

    Have you checked these 2 system properties?

    mxe.report.birt.proxyurlredirect

    mxe.report.birt.viewerurl

    The viewer url should be used if you have a different server to run the birt report, but with your logs, it seems to be trying to redirect to localhost:7001.

    Cheers



    ------------------------------
    Maycon Belfort
    Consultant
    BPD Zenith
    Melbourne
    Australia
    ------------------------------


  • 5.  RE: Maximo7.6; When accessing the birt report through VPN network, the application is normal, but the birt report is blank

    Posted Sun April 02, 2023 09:07 AM




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

    Original Message