Reportnet inserting sections and stored procedures problem

[nnaife]

Hi
Has anyone had problems inserting sections into a list report in Report Studio based on attributes generated from a SQL Server stored procedure. If you have and managed to solve i would be very grateful if you shared your solution/workaround.

thanks in advance
nnaife

here's the error message

An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.

UDA-SQL-0206 The OLEDB driver returned the following value: HRESULT= DB_SEC_E_PERMISSIONDENIED ".

RSV-SRV-0025 Unable to execute this request.

Trace back:

WPBIBusMethod.cpp(176): QSException: CCL_CAUGHT: WPBIBusMethod::run

WPReportExecutionMethod.cpp(180): QSException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

WPExecuteRequestThread.cpp(140): QSException: WPExecuteRequestThread::checkException

WPEngine.cpp(942): QSException:

WPController.cpp(261): QSException: CCL_RETHROW: WPController::executeRendering()

LWDataRetrievalEngine.cpp(760): QSException: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets

Source/QEDmResultSet.cpp(77): QSException: CCL_THROW: QE

 

[nnaife]

Apologies please ignore above the error message it being friday i accidently provided the wrong error message.

Anyway here's correct error message generated by report Studio when i try to insert sections onto a list report based on attributes generated via my stored procedure.


An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.

UDA-SQL-0107 A general exception has occurred during the operation "sqlPrepareWithOptions".

RSV-SRV-0025 Unable to execute this request.

Trace back:

WPBIBusMethod.cpp(176): UDASQLException: CCL_CAUGHT: WPBIBusMethod::run

WPReportExecutionMethod.cpp(180): UDASQLException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions

WPExecuteRequestThread.cpp(140): UDASQLException: WPExecuteRequestThread::checkException

WPEngine.cpp(942): UDASQLException:

WPController.cpp(261): UDASQLException: CCL_RETHROW: WPController::executeRendering()

LWDataRetrievalEngine.cpp(764): UDASQLException: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets

LWDResultSetProcessor.cpp(417): UDASQLException: CCL_RETHROW: LWDResultSetProcessor::getDetailQueryProcessor

Source/QESqlRequest.cpp(649): UDASQLException: CCL_RETHROW:

 

[wvanpeel]

Hi,

I presume you have created a query subject in Framework Manager. Do you get the same error in Framework Manager?

WVP

 

[nnaife]

Thanks for replying Wvanpeel, i don't have any problems executing the stored procedure in the framework manager and testing the query subject.
The query subject works fine in report studio until a section is inserted resulting in the report falling over.

The stored procedure we're trying to use is only slightly more complex than the 'Find Managers' stored procedure in the example Gosales Database but tends to run into a brick wall when we try inserting sections onto the report.

The Find_Managers procedure in the Gosales Database works fine with sections although its a very simple example. We ran this to try and produce a similar error.

Our procedure works fine with Crystal reports (which we're looking to replace with a reportnet version) and i can't see anything in the script that should prevent us from inserting sections into our reports.

Any clues why this might occur is there some crucial step we have overlooked when executing a stored procedure to generate a query subject?

 

[nnaife]

ok its official
"
443698 - Unable to create section on list report which contains columns from stored procedure.

Unable to create section on list report which contains columns from stored procedure.

You can create a report which contains columns from a stored precedure query subject. The report will run successfully even though you get an error message when you verify the report:

QE-DEF-0272 The parameter value 'testValue' of type 'characterLength16' is not valid.
QE-DEF-0330 Invalid parameter for stored procedure 'SalesByCategory' parameter '@OrdYear'.
RSV-RND-0053 Unable to find the item 'ProductID' in the query 'Query1'.
RSV-RND-0053 Unable to find the item 'ProductName' in the query 'Query1'.
RSV-RND-0053 Unable to find the item 'TotalPurchase' in the query 'Query1'.
RSV-RND-0053 Unable to find the item 'ProductID' in the query 'Query1'.
RSV-RND-0053 Unable to find the item 'ProductName' in the query 'Query1'.
RSV-RND-0053 Unable to find the item 'TotalPurchase' in the query 'Query1'.

When you create a section and then try to run the report, you get the following error:

UDA-SQL-0107 A general exception has occurred during the operation "sqlAOpen".
RSV-SRV-0025 Unable to execute this request.
Trace back:
WPBIBusMethod.cpp(176): QSException: CCL_CAUGHT: WPBIBusMethod::run
WPReportExecutionMethod.cpp(180): QSException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions
WPExecuteRequestThread.cpp(140): QSException: WPExecuteRequestThread::checkException
WPEngine.cpp(942): QSException:
WPController.cpp(261): QSException: CCL_RETHROW: WPController::executeRendering()
LWDataRetrievalEngine.cpp(760): QSException: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets
LWDResultSetProcessor.cpp(1024): QSException: CCL_RETHROW: LWDResultSetProcessor::iterateDetailQuery
Source/QEDmResultSet.cpp(77): QSException: CCL_THROW: QE

"


this is a BUG!!!!!!!!