Tech Doc Search Tech Support User Forums WebFOCUS Newsletter Summit Education

IB - Developer Center    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Building A Report from SQL Server Stored Proc
Go
New
Search
Notify
Tools
Reply
  
Building A Report from SQL Server Stored Proc
 Login/Join
 
Member
posted
This is the first time anyone from my group has tried to build a report of a sql server stored proc. the procedure and the report are very simple. The error I am getting makes no sense.

here is the acx:

NAME=INPUT, CONNECTION=kmssqlprod2-bireportprod,
STPNAME=dbo.kms_credit_exposures_report, $
SEGNAME=OUTPUT, STPRESORDER=0, $
SEGNAME=ANSWERSET1, STPRESORDER=1, $

Here is the mas:

FILENAME=KMS_CREDIT_EXPOSURES_REPORT, SUFFIX=SQLMSS , $
SEGMENT=INPUT, SEGTYPE=S0, $
FIELDNAME=, ALIAS=DUMMY, USAGE=A1, ACTUAL=A1,
MISSING=ON, $
SEGMENT=OUTPUT, SEGTYPE=S0, PARENT=INPUT, $
FIELDNAME=@RETURN_VALUE, ALIAS=P0000, USAGE=I11, ACTUAL=I4, $
SEGMENT=ANSWERSET1, SEGTYPE=S0, PARENT=INPUT, $
FIELDNAME=COUNTERPARTY_NAME, ALIAS='Counterparty Name', USAGE=A50V, ACTUAL=A50V,
TITLE='Counterparty Name', $
FIELDNAME=PARENT_NAME, ALIAS='Parent Name', USAGE=A50V, ACTUAL=A50V,
TITLE='Parent Name', $
FIELDNAME=CREDIT_RATING, ALIAS='Credit Rating', USAGE=A10V, ACTUAL=A10V,
TITLE='Credit Rating', $
FIELDNAME=HIGH_RISK, ALIAS='High Risk', USAGE=A1, ACTUAL=A1,
MISSING=ON,
TITLE='High Risk', $
FIELDNAME=SMALL_COAL_PRODUCER, ALIAS='Small Coal Producer', USAGE=I11, ACTUAL=I4,
MISSING=ON,
TITLE='Small Coal Producer', $
FIELDNAME=NET_EXPOSURE, ALIAS='Net Exposure', USAGE=P33.6, ACTUAL=P16,
MISSING=ON,
TITLE='Net Exposure', $
FIELDNAME=CREDIT_LIMIT, ALIAS='Credit Limit', USAGE=I11, ACTUAL=I4,
MISSING=ON,
TITLE='Credit Limit', $



Here is the fex:

TABLE FILE KMS_CREDIT_EXPOSURES_REPORT
PRINT
'KMS_CREDIT_EXPOSURES_REPORT.ANSWERSET1.COUNTERPARTY_NAME'
'KMS_CREDIT_EXPOSURES_REPORT.ANSWERSET1.PARENT_NAME'
'KMS_CREDIT_EXPOSURES_REPORT.ANSWERSET1.CREDIT_RATING'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.500000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END



Here is the error:

(FOC1400) SQLCODE IS 4060 (HEX: 00000FDC) XOPEN: 42000
: Microsoft OLE DB Provider for SQL Server: [42000] Cannot open database r
: equested in login 'poddev'. Login fails.
L (FOC1406) SQL OPEN CURSOR ERROR.


poddev is a database that exists on a seperate server from what I am connecting to. I can't find anything in any of my code that has anything to do with poddev. Has anyone ever seen anything like this?

Thanks.


Release 7.6.6
Windows 2003 Server
 
Posts: 1 | Registered: November 06, 2008Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Go to the reporting servers admin console.

Click Step 2
Right Click your adapter and choose "properties".

Click the Test button.

If this test fails then the problem is not in your report. The problem is with the database permissions/connection.

From you error it looks like your fex is trying to connect to the database with the username 'poddev'.


prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL

 
Posts: 132 | Location: Orlando, FL | Registered: August 04, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

IB - Developer Center    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Building A Report from SQL Server Stored Proc

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