cognos软件版本是8.2,在query studio中创建报表,通过sdk传入参数跑报表。在分段器设置过滤参数格式如[Tset].[机构].[机构].[机构ID]->?Org?。现在问题是如果将参数在query studio里写死,如[Tset].[机构].[机构].[机构ID]->[11100-1111],运行报表就没有问题,但是通过sdk调用就报错误。
如错误内容如下:
AxisFault
faultCode: {
http://schemas.xmlsoap.org/soap/envelope/}Client
faultSubcode:
faultString: Client Error
faultActor:
faultNode:
faultDetail:
{
http://developer.cognos.com/schemas/bibus/3/}exception:
Error -4000061
OP-ERR-0060 An invalid number of operands was specified for the operator -.
2
RSV-SRV-0042 Trace back:
1
RSReportService.cpp(659): QFException: CCL_CAUGHT: RSReportService::process()
1
RSReportService.cpp(638): QFException: RSAsyncThrowable: RSReportService::process
1
RSASyncExecutionThread.cpp(203): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRun_Request
1
RSASyncExecutionThread.cpp(658): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_Request
1
Execution/RSRenderExecution.cpp(601): QFException: CCL_RETHROW: RSRenderExecution::execute
1
Execution/RSRenderExecution.cpp(875): QFException: CCL_RETHROW: RSRenderExecution::processActiveDocuments
1
Assembly/RSDocAssemblyDispatch.cpp(236): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
1
Assembly/RSLayoutAssembly.cpp(135): QFException: CCL_RETHROW: RSLayoutAssembly::assemble
1
Assembly/RSDocAssemblyDispatch.cpp(309): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
1
Assembly/RSReportPagesAssembly.cpp(113): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble
1
Assembly/RSDocAssemblyDispatch.cpp(255): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
1
Assembly/RSPageAssembly.cpp(247): QFException: CCL_RETHROW: RSPageAssembly::assemble
1
Assembly/RSAssembly.cpp(477): QFException: CCL_RETHROW: RSAssembly::createListIterator
1
RSQueryMgr.cpp(950): QFException: CCL_RETHROW: RSQueryMgr::getListIterator
1
RSQueryMgr.cpp(1010): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator
1
RSQueryMgr.cpp(1172): QFException: CCL_RETHROW: RSQueryMgr::createIterator
1
RSQueryMgr.cpp(1479): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand
1
RSQueryMgr.cpp(1466): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand
1
RSQueryMgrExecutionHandlerImpl.cpp(181): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()
1
RSQueryMgrExecutionHandlerImpl.cpp(173): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()
1
RSQFSession.cpp(216): QFException: CCL_RETHROW: RSQFSession::DoRequest
1
QFSSession.cpp(1496): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
1
QFSSession.cpp(1494): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
1
QFSSession.cpp(1461): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
1
QFSConnection.cpp(771): QFException: CCL_RETHROW: QFSConnection::Execute
1
QFSQuery.cpp(115): QFException: CCL_RETHROW: QFSQuery::Execute v2
1
CoordinationQFSQuery.cpp(3684): QFException: CCL_THROW: CoordinationPlanner
1
Client Error
at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:260)
at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:169)
at org.apache.axis.encoding.DeserializationContextImpl.endElement(DeserializationContextImpl.java:1015)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
at org.apache.axis.encoding.DeserializationContextImpl.parse(DeserializationContextImpl.java:242)
at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:538)
at org.apache.axis.Message.getSOAPEnvelope(Message.java:376)
at org.apache.axis.client.Call.invokeEngine(Call.java:2583)
at org.apache.axis.client.Call.invoke(Call.java:2553)
at org.apache.axis.client.Call.invoke(Call.java:2248)
at org.apache.axis.client.Call.invoke(Call.java:2171)
at org.apache.axis.client.Call.invoke(Call.java:1691)
at com.cognos.developer.schemas.bibus._3.ReportServiceStub.run(ReportServiceStub.java:5386)
请问各位有没有遇到过这个情况,多谢!