Cognos An Error Occurred While Performing Operation Sqlopenresult Status 28
Contents |
status='-28' crash reboot Technote (troubleshooting) Problem(Abstract) User attempts to run any Controller 'standard report' (also known
An Error Occurred While Performing Operation 'sqlopenresult' Status='-28'. Cognos
as 'system report'), for example 'Reconcile - Between Accounts/Opening Balances (Preview)'. an error occurred while performing operation 'sqlopenresult' status='-28'. cognos 10 User receives error message. Symptom Reconcile - Between Accounts/Opening Balances (Preview) Cognos 8 RQP-DEF-0177 An error an error occurred while performing operation 'sqlpreparewithoptions' status='-9'. in cognos occurred while performing operation 'sqlOpenResult' status='-28' Details UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SOR-0001 Unable to allocate memory. RSV-SRV-0042 Trace back: RSReportService.cpp(595): QFException:
An Error Occurred While Performing Operation 'sqlpreparewithoptions' Status='-56'. Cognos
CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(177).... Cause The Controller application server has run out of Windows memory. Therefore, the IBM Cognos 8 BI 'reporting' engine cannot process the report correctly. There are many potential causes for this lack of memory, but if you are running an old/out-of-date version of Controller, it is possible that your system is suffering
An Error Occurred While Performing Operation 'sqlopenresult' Status='-237'
from a memory leak. Resolving the problem Workaround Ensure all Controller users out of the system. Reboot Controller application server. Long-term Fix: Optimise the Cognos 8 BI reporting service environment, by: Ensure that Controller product is upgraded to latest release, to take advantage of memory leak fixes, such as those described inside IBM Technotes #1347915, 1367340 & 1365078. Afterwards, if the problem persists, follow the advice inside separate IBM Technote article #1341779 Related information 1341779 - Intermittent error when running reports: UDA- 1347915 - Error 'CAM-AAA-0027 - The function call to 'C 1367340 - Error 'Insufficient memory to continue the ex 1365078 - Error 'CAM-AAA-0071 An internal error occurre Historical Number 1037276 Document information More support for: Cognos Controller Controller Software version: 8.2, 8.3 Operating system(s): Windows Software edition: Not Applicable Reference #: 1347502 Modified date: 2009-08-03 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy rqp-def-0177 'sqlopenresult' status='-237' Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio
Cognos 'sqlopenresult' Status='-237'
Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < uda-sql-0114 the cursor supplied to the operation "sqlopenresult" is inactive Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag http://www-01.ibm.com/support/docview.wss?uid=swg21347502 maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Richard Locutus DukeGanote Ramnath.Awate Craig Borysowich Dennis Stevenson Nikki Klein AbhaiTripathi mircea_luca bluesguyAZ59 Clinton Jones knowscognosdoi iudithm Iqbalyk COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox for IT Topics Business Intelligence Groups http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/in-cognos-8-an-error-occurred-while-performing-operation-sqlopenresult-status28-5366592 Ask a New Question Cognos 8 The Cognos 8 group is for the discussion of technical issues and concerns related to Cognos version 8, including Cognos 8 migration, configuration, installation, and security. Home | Invite Peers | More Business Intelligence Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. In cognos 8, An error occurred while performing operation 'sqlOpenResult' status='-28'. Kandimalla asked No
and session length News: Stay connected throught Twitter - Avnet Services, Twitter - Avnet Academy, LinkedIn, Facebook, Google+ and YouTube.Check http://www.cognoise.com/index.php?topic=8032.0 out the latest IBM Cognos tips and tricks in the BSP https://communities.bmc.com/thread/59885?tstart=0 Chronicles. Join our Mailing List. Home Help Search Calendar Login Register COGNOiSe.com - The IBM Cognos Community » IBM Cognos 8 Platform » COGNOS 8 » Report Studio » RQP-DEF-0177,'sqlOpenResult' status='-28'. DPR-ERR-2082 An error has occurred « previous next » Print an error Pages: [1] Author Topic: RQP-DEF-0177,'sqlOpenResult' status='-28'. DPR-ERR-2082 An error has occurred (Read 28017 times) JOELIU Associate Join Date: Oct 2009 Posts: 1 Forum Citizenship: +0/-0 RQP-DEF-0177,'sqlOpenResult' status='-28'. DPR-ERR-2082 An error has occurred « on: 22 Oct 2009 09:42:20 am » Hello everyone,I am a new user of the Cognos 8, built one query in report studio, and the query an error occurred passed the validation; however once I start to run it, the query fails with the below message:RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2009-10-22-15:24:27.526-#49Could anyone please help with this? Thanks in advance. Logged blom0344 Teamleader data processing Global Moderator Statesman Join Date: Feb 2007 Posts: 2,408 Forum Citizenship: +102/-2 have to let the first nerd go.. Re: RQP-DEF-0177,'sqlOpenResult' status='-28'. DPR-ERR-2082 An error has occurre « Reply #1 on: 22 Oct 2009 02:16:28 pm » Report validation does not imply all queries are checked!An SQL error will usually be displayed with more details following (open details below the first lines) . You may need to check the cognos server log for more info Logged Oracle9i/11g,DB2/AS400/Busobj 6.5/Powercenter7/Cognos8/10 /SSIS 2005 / SQL SERVER 2008 /SDDM 3.3 / Pentaho 4.4.0 Data Integrator / SSAS 2008 / PostgreSQL 9 RubenvdLinden Community Leader Join Date: May 2009 Posts: 130 Forum Citizenship: +5/-0 Re: RQP-DEF-0177,'sqlOpenResult' status='-28'. DPR-ERR-2082 An error has occurred
AdvocacyBeta ProgramsSupport CommunityIdeas and RFEsAdvocate HubOne BMC Beta Process (BMC)Customer Experience (BMC)HelpCommunities TipsCommunities YouTubeBMC Social Central (BMC Only)CommunitiesFree TrialsLog inRegisterCommunities Free TrialsSupportDocumentationAbout BMCNewsLog inRegister Products Events BMC Engage CommunityAgenda & RegistrationDevelopersDeveloper CommunityDeveloper PortalPartners Partner DirectoriesTechnology Alliance Program (TAP)Solution Provider Portal (SPP)User Groups All groupsLocal User GroupsEvent CalendarCustomer ProgramsBeta ProgramsSupport CommunityIdeas and RFEsAdvocate HubOne BMC Beta Process (BMC)Customer Experience (BMC)Help Communities TipsCommunities YouTubeBMC Social Central (BMC Only)Search the BMC CommunitiesSearch the BMC CommunitiesCancelError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Decision Support for Server Automation All PlacesProductsBladeLogicDecision SupportDecision Support for Server Automation 3 Replies Latest reply on Nov 3, 2014 2:05 PM by Suresh Mendu BBDSSA 8.1: 0177 An error occurred while performing operation 'sqlOpenResult' status='-28' Sudhir More Nov 29, 2011 5:57 AM Hi AllI am getting error while fetching patch repository summary reports, any idea?Below is log entry observed...2011-11-29-16:36:46.891-#13 Original Error: RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0107 A general exception has occurred during the operation "open result". ORA-01722: invalid number RSV-SRV-0042 Trace back: RSReportService.cpp(779): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(265): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_Request RSASyncExecutionThread.cpp(788): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_Request RSASyncExecutionThread.cpp(838): QFException: CCL_RETHROW: RSASyncExecutionThread::processComma