An error has occurred Detail: (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
(FOC1500) : Microsoft OLE DB Provider for SQL Server: [] Cannot create new (FOC1500) : connection because in manual or distributed transaction mode. L (FOC1406) SQL OPEN CURSOR ERROR. : TBLCOSTCENTERATTRIBUTES
When running the code below:
-*COMPONENT=Join_J001 JOIN VWMILESANALYSIS2.VWMILESANALYSIS2.COSTCENTER IN TRANSMETRIC/VWMILESANALYSIS2 TO UNIQUE TBLCOSTCENTERATTRIBUTES.TBLCOSTCENTERATTRIBUTES.COSTCENTER IN TRANSMETRIC/TBLCOSTCENTERATTRIBUTES TAG J001 AS J001 END
ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD -DEFAULTH &WF_HTMLENCODE=OFF; SET HTMLENCODE=&WF_HTMLENCODE
SET ARGRAPHENGINE=JSCHART -DEFAULTH &WF_EMPTYREPORT=ON; SET EMPTYREPORT=&WF_EMPTYREPORT
SET EMBEDHEADING=ON SET GRAPHDEFAULT=OFF -DEFAULTH &WF_STYLE_UNITS='PIXELS'; -DEFAULTH &WF_STYLE_HEIGHT='405.0'; -DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report'; -DEFAULT &RVP = _FOC_NULL; -DEFAULT &DIRECTOR = _FOC_NULL; -DEFAULT &COSTCENTER = _FOC_NULL; -DEFAULT &Customer = _FOC_NULL; -DEFAULT &Region = _FOC_NULL; -DEFAULT &Market = _FOC_NULL; GRAPH FILE TRANSMETRIC/VWMILESANALYSIS2 -* Created by Info Assist for Graph SUM VWMILESANALYSIS2.VWMILESANALYSIS2.CUST_DISP_TOT_MT/I11C VWMILESANALYSIS2.VWMILESANALYSIS2.CUST_DISP_TOT_LD/I11C COMPUTE MTPct/D12.1%=VWMILESANALYSIS2.VWMILESANALYSIS2.CUST_DISP_TOT_MT/VWMILESANALYSIS2.VWMILESANALYSIS2.CUST_DISP_TOT_TOT * 100 ; BY TOTAL HIGHEST 15 VWMILESANALYSIS2.VWMILESANALYSIS2.CUST_DISP_TOT_MT NOPRINT BY J001.TBLCOSTCENTERATTRIBUTES.COSTCENTER WHERE VWMILESANALYSIS2.DIMDATE.DATE_FYEAR EQ '2019'; ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET GRWIDTH 1 ON GRAPH SET AUTOFIT ON ON GRAPH SET UNITS &WF_STYLE_UNITS ON GRAPH SET HAXIS &WF_STYLE_WIDTH ON GRAPH SET VAXIS &WF_STYLE_HEIGHT ON GRAPH SET LOOKGRAPH BAR ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * *GRAPH_SCRIPT
Can anyone help me what is causing the error/issue?This message has been edited. Last edited by: ryanj,
8.2.02M
May 23, 2019, 06:20 AM
Wep5622
quote:
(FOC1500) : Microsoft OLE DB Provider for SQL Server: [] Cannot create new (FOC1500) : connection because in manual or distributed transaction mode.
The database server refused your connection because the database is in manual or distributed transaction mode.
I suspect that other TABLE requests to the same database fail as well, or that failure with them is intermittent.
You probably need to talk to your DBA.
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :