Nox Lee

Hi, I have field with following description on Oracle .mas file: FIELDNAME=INV_NUM, ALIAS=INV_NUM, USAGE=P9.2, ACTUAL=P9.2, and my objective is to modify the length of this field to be P11.2 to MS SQL server so that I can have decimal(11.2) in MS SQL server. So the first thing I do is simply modify Oracle .mas file to: FIELDNAME=INV_NUM, ALIAS=INV_NUM, USAGE=P11.2, ACTUAL=P11.2, but as I done a transformation to MS SQL server via Iway and end up with decimal(9.2) in MS SQL server. But sometime I modify other field within Oracle .mas it work as expected and sometime dont, So how can I can set exact length for Packed Decimal NOTE: I check the target MS SQL servers .mas file of that field was: FIELDNAME=INV_NUM, ALIAS=INV_NUM, USAGE=P11.2, ACTUAL=P5,

wep5622: CREATE SYNONY Sorry for interrupt this topic, when there is same synonyms name already located in same directory/path it prompt can not overwritten any idea how to use automate update/replace the synonym

Automated Insights and drill down capabilities caught me attention.

Sorry for late reply, we already open an IBI support case for this issue, we will see what IBI support will suggest to do, thanks everyone.

Hi Toby, Im not so sure for those logs and I did raised a support from IBI tech support, hope I can get a better answer. After some testing with different OS of Reporting Server, that we find out that only Linux Report Server will queued Deferred Report with OPSYS authentication. So on Windows has no problem with OPSYS, I think something might have to so with Linuxs privilege.

Hi, Kinda figure out what cause deferred Report is queued, is because the report server is install on Linux and using OPSYS authentication to access, if I change to PTH everything work as in order. But I still need to know why using OPSYS is queued and how can I set for OPSYS to run deferred Report without queued

Hi @toby.mills , unfortunately both of my recent question came from two different machine. I have open a case with IBI tech support already, but meanwhile that we can try update here as well for future references. I have look through the savediags edaprint.log and all I see at end are: 08/05/2021 10:08:00.644 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:00.645 I connecting cmrpaq000002 tscomid=662,sesid=61532,fctkt=610a5801:1-f009,fcdir=aq0000020155 08/05/2021 10:08:00.662 I disconnect cmrpaq000002 tscomid=662,sesid=61532,fctkt=610a5801:1-f009,fcdir=aq0000020155 08/05/2021 10:08:00.662 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:00.664 I request by t3rp22025 to notify disconnect of sesid=61532 08/05/2021 10:08:00.665 I statistics cmrpaq000002 sesid=61532,cpu=0.010s,dbms=0.000s,srv=0.020s 08/05/2021 10:08:01.302 I accepting cmrpht000086 tcp=192.168.40.200:10139 08/05/2021 10:08:01.306 I request by cmrpht000086 to POST u=OPSYSwf_admin,session=610a5801:1-ebb9, page=WOPTIONSLINK 08/05/2021 10:08:01.666 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:01.668 I connecting cmrpaq000002 tscomid=662,sesid=61533,fctkt=610a5801:1-f00a,fcdir=aq0000020156 08/05/2021 10:08:01.684 I disconnect cmrpaq000002 tscomid=662,sesid=61533,fctkt=610a5801:1-f00a,fcdir=aq0000020156 08/05/2021 10:08:01.685 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:01.687 I request by t3rp22025 to notify disconnect of sesid=61533 08/05/2021 10:08:01.688 I statistics cmrpaq000002 sesid=61533,cpu=0.010s,dbms=0.000s,srv=0.021s 08/05/2021 10:08:02.415 I request by cmrpht000086 to POST u=OPSYSwf_admin,session=610a5801:1-ebb9, xcmd=Traces, page=BLANK 08/05/2021 10:08:02.431 I Default traces turned off for running server 08/05/2021 10:08:02.688 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:02.688 I connecting cmrpaq000002 tscomid=662,sesid=61534,fctkt=610a5801:1-f00b,fcdir=aq0000020157 08/05/2021 10:08:02.690 I disconnect cmrpaq000002 tscomid=662,sesid=61534,fctkt=610a5801:1-f00b,fcdir=aq0000020157 08/05/2021 10:08:02.690 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:02.690 I request by t3rp22025 to notify disconnect of sesid=61534 08/05/2021 10:08:02.690 I statistics cmrpaq000002 sesid=61534,cpu=0.000s,dbms=0.000s,srv=0.003s 08/05/2021 10:08:03.691 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:03.691 I connecting cmrpaq000002 tscomid=662,sesid=61535,fctkt=610a5801:1-f00c,fcdir=aq0000020158 08/05/2021 10:08:03.694 I disconnect cmrpaq000002 tscomid=662,sesid=61535,fctkt=610a5801:1-f00c,fcdir=aq0000020158 08/05/2021 10:08:03.694 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:03.694 I request by t3rp22025 to notify disconnect of sesid=61535 08/05/2021 10:08:03.694 I statistics cmrpaq000002 sesid=61535,cpu=0.000s,dbms=0.000s,srv=0.003s 08/05/2021 10:08:04.695 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:04.695 I connecting cmrpaq000002 tscomid=662,sesid=61536,fctkt=610a5801:1-f00d,fcdir=aq0000020159 08/05/2021 10:08:04.698 I disconnect cmrpaq000002 tscomid=662,sesid=61536,fctkt=610a5801:1-f00d,fcdir=aq0000020159 08/05/2021 10:08:04.698 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:04.698 I request by t3rp22025 to notify disconnect of sesid=61536 08/05/2021 10:08:04.698 I statistics cmrpaq000002 sesid=61536,cpu=0.000s,dbms=0.000s,srv=0.003s 08/05/2021 10:08:04.977 I request by cmrpht000086 to POST u=OPSYSwf_admin,session=610a5801:1-ebb9, page=WKSFRAMES 08/05/2021 10:08:04.983 I request by cmrpht000086 to POST u=OPSYSwf_admin,session=610a5801:1-ebb9, page=WKSRIBBON 08/05/2021 10:08:05.331 I request by cmrpht000086 to POST u=OPSYSwf_admin,session=610a5801:1-ebb9, page=CONFTREE 08/05/2021 10:08:05.335 I request by cmrpht000086 for explicit connect to agent (WC_DEFAULT) 08/05/2021 10:08:05.336 I connecting cmrpht000086 tscomid=649,sesid=61537,fctkt=610a5801:1-ebb9,fcdir=ht000080010 08/05/2021 10:08:05.336 I accepting cmrpht000087 tcp=192.168.40.200:9142 08/05/2021 10:08:05.337 I request by cmrpht000087 to POST u=OPSYSwf_admin,session=610a5801:1-ebb9, page=AGENTS 08/05/2021 10:08:05.339 I processing cmrpht000086 sesid=61537,u=OPSYSwf_admin,g=wf_admin,r=SRV 08/05/2021 10:08:05.459 I disconnect cmrpht000086 tscomid=649,sesid=61537,fctkt=610a5801:1-ebb9,fcdir=ht000080010 08/05/2021 10:08:05.459 I request by t3rp21964 to notify disconnect of sesid=61537 08/05/2021 10:08:05.459 I statistics cmrpht000086 sesid=61537,cpu=0.070s,dbms=0.001s,srv=0.100s 08/05/2021 10:08:05.698 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:05.699 I connecting cmrpaq000002 tscomid=662,sesid=61538,fctkt=610a5801:1-f00e,fcdir=aq0000020160 08/05/2021 10:08:05.701 I disconnect cmrpaq000002 tscomid=662,sesid=61538,fctkt=610a5801:1-f00e,fcdir=aq0000020160 08/05/2021 10:08:05.701 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:05.701 I request by t3rp22025 to notify disconnect of sesid=61538 08/05/2021 10:08:05.701 I statistics cmrpaq000002 sesid=61538,cpu=0.000s,dbms=0.000s,srv=0.003s 08/05/2021 10:08:06.702 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:06.706 I connecting cmrpaq000002 tscomid=662,sesid=61539,fctkt=610a5801:1-f00f,fcdir=aq000002010 08/05/2021 10:08:06.709 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:06.709 I disconnect cmrpaq000002 tscomid=662,sesid=61539,fctkt=610a5801:1-f00f,fcdir=aq000002010 08/05/2021 10:08:06.709 I request by t3rp22025 to notify disconnect of sesid=61539 08/05/2021 10:08:06.709 I statistics cmrpaq000002 sesid=61539,cpu=0.000s,dbms=0.000s,srv=0.008s 08/05/2021 10:08:07.709 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:07.709 I connecting cmrpaq000002 tscomid=662,sesid=61540,fctkt=610a5801:1-f010,fcdir=aq000002011 08/05/2021 10:08:07.712 I disconnect cmrpaq000002 tscomid=662,sesid=61540,fctkt=610a5801:1-f010,fcdir=aq000002011 08/05/2021 10:08:07.712 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:07.712 I request by t3rp22025 to notify disconnect of sesid=61540 08/05/2021 10:08:07.712 I statistics cmrpaq000002 sesid=61540,cpu=0.010s,dbms=0.000s,srv=0.003s 08/05/2021 10:08:08.180 I request by cmrpht000086 to POST u=OPSYSwf_admin,session=610a5801:1-ebb9, page=SDIAG 08/05/2021 10:08:08.713 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:08.713 I connecting cmrpaq000002 tscomid=662,sesid=61541,fctkt=610a5801:1-f011,fcdir=aq000002012 08/05/2021 10:08:08.715 I disconnect cmrpaq000002 tscomid=662,sesid=61541,fctkt=610a5801:1-f011,fcdir=aq000002012 08/05/2021 10:08:08.715 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:08.715 I request by t3rp22025 to notify disconnect of sesid=61541 08/05/2021 10:08:08.715 I statistics cmrpaq000002 sesid=61541,cpu=0.000s,dbms=0.000s,srv=0.003s 08/05/2021 10:08:09.716 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:09.716 I connecting cmrpaq000002 tscomid=662,sesid=61542,fctkt=610a5801:1-f012,fcdir=aq000002013 08/05/2021 10:08:09.718 I disconnect cmrpaq000002 tscomid=662,sesid=61542,fctkt=610a5801:1-f012,fcdir=aq000002013 08/05/2021 10:08:09.719 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:09.719 I request by t3rp22025 to notify disconnect of sesid=61542 08/05/2021 10:08:09.719 I statistics cmrpaq000002 sesid=61542,cpu=0.000s,dbms=0.000s,srv=0.003s 08/05/2021 10:08:10.719 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:10.720 I connecting cmrpaq000002 tscomid=662,sesid=61543,fctkt=610a5801:1-f013,fcdir=aq000002014 08/05/2021 10:08:10.722 I disconnect cmrpaq000002 tscomid=662,sesid=61543,fctkt=610a5801:1-f013,fcdir=aq000002014 08/05/2021 10:08:10.722 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:10.722 I request by t3rp22025 to notify disconnect of sesid=61543 08/05/2021 10:08:10.722 I statistics cmrpaq000002 sesid=61543,cpu=0.000s,dbms=0.000s,srv=0.003s 08/05/2021 10:08:11.723 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:11.723 I connecting cmrpaq000002 tscomid=662,sesid=61544,fctkt=610a5801:1-f014,fcdir=aq000002015 08/05/2021 10:08:11.725 I disconnect cmrpaq000002 tscomid=662,sesid=61544,fctkt=610a5801:1-f014,fcdir=aq000002015 08/05/2021 10:08:11.725 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:11.725 I request by t3rp22025 to notify disconnect of sesid=61544 08/05/2021 10:08:11.725 I statistics cmrpaq000002 sesid=61544,cpu=0.000s,dbms=0.000s,srv=0.003s 08/05/2021 10:08:12.726 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:12.726 I connecting cmrpaq000002 tscomid=662,sesid=61545,fctkt=610a5801:1-f015,fcdir=aq000002016 08/05/2021 10:08:12.728 I disconnect cmrpaq000002 tscomid=662,sesid=61545,fctkt=610a5801:1-f015,fcdir=aq000002016 08/05/2021 10:08:12.728 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:12.729 I request by t3rp22025 to notify disconnect of sesid=61545 08/05/2021 10:08:12.729 I statistics cmrpaq000002 sesid=61545,cpu=0.010s,dbms=0.000s,srv=0.003s 08/05/2021 10:08:13.729 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:13.729 I connecting cmrpaq000002 tscomid=662,sesid=61546,fctkt=610a5801:1-f016,fcdir=aq000002017 08/05/2021 10:08:13.732 I disconnect cmrpaq000002 tscomid=662,sesid=61546,fctkt=610a5801:1-f016,fcdir=aq000002017 08/05/2021 10:08:13.732 W dfm scan failed, postponed for 1 second 08/05/2021 10:08:13.732 I request by t3rp22025 to notify disconnect of sesid=61546 08/05/2021 10:08:13.732 I statistics cmrpaq000002 sesid=61546,cpu=0.000s,dbms=0.000s,srv=0.003s 08/05/2021 10:08:14.732 I request by cmrpaq000002 for explicit connect to agent (DEFAULT) 08/05/2021 10:08:14.733 I connecting cmrpaq000002 tscomid=662,sesid=61547,fctkt=610a5801:1-f017

Hi, When I sent a report via defer run, and it keep as queued and there is no other job is running. It wont go anywhere unless I use Force Rescan on Scheduler Service. when I check on edaprint.log and I keep see " W dfm scan failed, postponed for 1 second" and idea what went wrong

Hi @chuck.wolff, Thanks for the advice , which file should I look into after I have downloaded the trace file from server And we try use the same WebFOCUS to create report from other server it give the same error message, however we using DEMOs environment of WebFOCUS to create report from that same server is working as expected, so assume something went wrong with that particular WebFOCUS not the reporting server

@toby.mills yes as far as I know that I did able to receive Table Request successfully, and everything look fine to me on Administrator Console on Server Connections. any idea else where I should check on

I have configure a Reporting Server at my Administrator console(EDASERVE), and after testing for the Reporting server is successfully, but when I try creating a Report and select for Servers Application Paths, it show this message. anyone got an idea what went wrong

yes I do have folder in application path

Ok, Thanks everyone for your information.

On InfoAssist we can select output format for the report, possible for select excel with encrypted using password to actually open the Excel file (Try avoid using AHTML and Report Caster)

I try to configure properties.json file within com.ibi.datatables folder for changing fontFamily, and no matter how I change the value for fontFamily it still not apply to the chart, wander where I miss for this configuration below is the default properties for this chart: { info: { version: 1.1.0, implements_api_version: 2.0, author: Information Builders, copyright: Information Builders Inc., url: https://github.com/ibi/wf-extensions-chart/tree/master/com.ibi.datatables, icons: { medium: icons/datatables.png } }, "properties": { "paging": true, "pageLength": 10, "lengthMenu": "[ 10, 25, 50, 100 ]", "ordering": true, "info": true, "searching": true, "lengthChange": false, "colReorder": true, "responsive": true, "scroller": false, "scrollY": 370, "showTotal": false, "color": "#555", "padding": "8px", "border": "1px solid #ddd", "fontFamily": "'Helvetica Neue',Helvetica,Arial,sans-serif", "fontSize": "14px", "title": { "fontWeight": "bold", "color": "inherit", "backgroundColor": "transparent" }, "data": { "fontWeight": "normal", "color": "inherit", "backgroundColorOdd": "#f9f9f9", "backgroundColorEven": "transparent", "selected": { "color": "inherit", "border": "1px solid #99cfff", "backgroundColor": "#cde8ff" } }, "crossTabs": { "fontWeight": "bold", "color": "inherit", "backgroundColorOdd": "#f9f9f9", "backgroundColorEven": "transparent" } }, "propertyAnnotations": { "paging": "bool", "pageLength": "number", "lengthMenu": "str", "ordering": "bool", "info": "bool", "searching": "bool", "lengthChange": "bool", "colReorder": "bool", "responsive": "bool", "scroller": "bool", "scrollY": "number", "showTotal": "bool", "color": "str", "padding": "str", "border": "str", "fontFamily": "str", "fontSize": "str", "title": { "fontWeight": "str", "color": "str", "backgroundColor": "str" }, "data": { "fontWeight": "str", "color": "str", "backgroundColorOdd": "str", "backgroundColorEven": "str", "selected": { "color": "str", "border": "str", "backgroundColor": "str" } }, "crossTabs": { "fontWeight": "str", "color": "str", "backgroundColorOdd": "str", "backgroundColorEven": "str" } }, "dataBuckets": { "tooltip": false, "matrix": false, "data_page": false, "series_break": false, "buckets": [ { "id": "measure", "type": "measure", "count": { "min": 1, "max": 16 } }, { "id": "row", "type": "dimension", "count": { "min": 0, "max": 16 } }, { "id": "column", "type": "dimension", "count": { "min": 0, "max": 16 } } ] }, "translations": { "en": { "name": "Datatables Grid", "description": "Datagrid using the Datatables JS plug-in with support for sorting, column reordering, searching and responsive capabilities.", "icon_tooltip": "Datagrid using the Datatables JS plug-in with support for sorting, column reordering, searching and responsive capabilities.", "measure_name": "Measures", "measure_tooltip": "Drop a measure here", "row_name": "Rows", "row_tooltip": "Drop a dimension here", "column_name": "Columns", "column_tooltip": "Drop a dimension here" } } }