Hi Team,
When i try to view tabular data for one query item which contains the expression as follows:
IF ([Business Layer].[Place of payment].[Department Code] = 'HO' ) THEN
(52)
ELSE
( to_number([Business Layer].[Place of payment].[Department Code]) )
I get error says
UDA-SQL-0107 A general exception has occurred during the operation "open result".ORA-01722: invalid number
RSV-SRV-0042 Trace back:RSReportService.cpp(726): QFException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(259): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(854): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(311): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(910): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestRSRequest.cpp(1697): QFException: CCL_THROW: RSRequest::executeInteractivePrompting()RSQueryMgr.cpp(520): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(587): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(679): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(289): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrBasic.cpp(278): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(175): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(166): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1153): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1151): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1108): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1084): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(800): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4484): QFException: CCL_THROW: CoordinationPlanner
Please suggest me guys , where is mistake.
Regards
Inam
Hi,
Looking at your code ([Business Layer].[Place of payment].[Department Code] = 'HO' )
[Business Layer].[Place of payment].[Department Code] contains alphabetical value and you are trying to convert that to number ..may be because of that you are getting an error.
Hi Inu,
Please use following expression
IF ([Business Layer].[Place of payment].[Department Code] = 'HO' ) THEN
('52')
ELSE
( to_number([Business Layer].[Place of payment].[Department Code]) )
Regards
Bvk
Quote from: bvk.cognoise on 03 Aug 2015 06:26:38 AM
Hi Inu,
Please use following expression
IF ([Business Layer].[Place of payment].[Department Code] = 'HO' ) THEN
('52')
ELSE
( to_number([Business Layer].[Place of payment].[Department Code]) )
Regards
Bvk
Hi Bvk,
Nice catch, I appreciate . I did same thing.