Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] FOC1400,1500,1406 Errors
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] FOC1400,1500,1406 Errors
 Login/Join
 
Member
posted
I get this error:


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

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis(1), $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis(1), $
TYPE=DATA, COLUMN=N5, BUCKET=y-axis(2), $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);
setDataTextDisplay(true);
setPieFeelerTextDisplay(1);
setZeroValueDataTextStackedTotalOnTopDisplay(false);
setSeriesType(2,2);
setDisplay(getDataTextStackedTotalOnTop(),false);
setFontSizeAbsolute(getDataText(),true);
setAutofit(getDataText(),false);
setFontSizeInPoints(getDataText(),12);
setPlaceResize(getDataText(),0);
setTextRotation(getO1Label(),3);
setFillColor(getDataText(),new Color(2,2,2));
setScaleMaxAuto(getY2Axis(),false);
setScaleMax(getY2Axis(),100.0);
setFontSizeInPoints(getY2Title(),14);
setFontSizeInPoints(getY2Label(),14);
setFontSizeAbsolute(getLegendText(),true);
setAutofit(getLegendText(),false);
setFontSizeInPoints(getLegendText(),14);
setPlaceResize(getLegendText(),0);
setLabelStagger(getO1Label(),false);
*GRAPH_JS_FINAL
"xaxis": {
"title": {
"font": "14pt Sans-Serif"
},
"labels": {
"font": "14pt Sans-Serif"
}
},
"pieProperties": {
"holeSize": "0%"
},
"introAnimation": {
"enabled": true
},
"blaProperties": {
"seriesLayout": "stacked"
},
"yaxis": {
"title": {
"font": "14pt Sans-Serif"
},
"labels": {
"font": "14pt Sans-Serif"
}
},
"agnosticSettings": {
"dual": true,
"chartTypeFullName": "Bar_Stacked_Dual_Axis"
}

*END
ENDSTYLE
END

-RUN


Can anyone help me what is causing the error/issue?

This message has been edited. Last edited by: ryanj,


8.2.02M
 
Posts: 4 | Registered: March 21, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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 :
 
Posts: 1643 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Member
posted Hide Post
That seems to be the issue.

Thanks for the help!


8.2.02M
 
Posts: 4 | Registered: March 21, 2019Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] FOC1400,1500,1406 Errors

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.