Error Number - 239
Adding additional error number 239 cognos calculations which referenced previous calculations resulted in the error below. Such calculation would be: Calc2: If Calc1 >= Value Then
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < 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 maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre bracke Locutus PCMag Dennis Stevenson Craig Borysowich http://www-01.ibm.com/support/docview.wss?uid=swg21349949 DukeGanote Richard mircea_luca iudithm Nikki Klein AbhaiTripathi knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 COMPANIES Thawte Oracle CloudLock Epicor Software ... View All Topics View All Members View All Companies Toolbox for IT Topics Business Intelligence Groups Ask a New Question Cognos The Cognos group is for the discussion of technical issues that arise during the implementation, configuration, administration, http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos-l/error-number-239dmsegeneral-a-general-exception-has-occurred-during-operation-prepare-request-with-options-435245 or daily use of Cognos software. 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. Error number -239:DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'. malikh asked Mar 16, 2004 | Replies (8) I have a report that is generating the following error: Error number -239: DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'. The only change to the report was the following code: if (upper (Per Nm)
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos-l/cognosi-how-to-resolve-error-number-239-957206 Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back http://www.cognoise.com/index.php?topic=18686.0 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 maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre bracke Locutus Dennis Stevenson Craig Borysowich DukeGanote Richard PCMag mircea_luca Nikki Klein iudithm AbhaiTripathi knowscognosdoi Clinton Jones Iqbalyk bluesguyAZ59 error number COMPANIES Thawte Oracle CloudLock Epicor Software ... View All Topics View All Members View All Companies Toolbox for IT Topics Business Intelligence Groups Ask a New Question Cognos The Cognos group is for the discussion of technical issues that arise during the implementation, configuration, administration, or daily use of Cognos software. Home | Invite Peers | More Business Intelligence Groups Your account error number 239 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. [Cognos-I] How to Resolve Error Number -239 urbhanu1983 asked Mar 18, 2006 | Replies (2) Hi how to implement the conditional Formats in the "Stored Procedure" Reports. Also how to rectify the following error. Error number -239: DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'. DMS-N-NOCOMMUNICATION, A non-recoverable transport layer error has occurred during operation 'prepare request'. [Client Library] ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect Join this group Popular White Paper On This Topic Business Intelligence with SharePoint 2010 2Replies Best Answer 0 Ma
and session length News: Stay connected throught Twitter - Avnet Services, Twitter - Avnet Academy, LinkedIn, Facebook, Google+ and YouTube.Check out the latest IBM Cognos tips and tricks in the BSP Chronicles. Join our Mailing List. Home Help Search Calendar Login Register COGNOiSe.com - The IBM Cognos Community » Legacy Business Intelligence » COGNOS Impromptu » Error number -239 « previous next » Print Pages: [1] Author Topic: Error number -239 (Read 3811 times) rucerius Associate Join Date: May 2007 Posts: 4 Forum Citizenship: +0/-0 Error number -239 « on: 06 Mar 2012 11:56:47 am » Running Cognos Impromptu 7.4 and getting the following error:Error number -239:DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.DMS-E-RBI_SUBQCONTEXTLIMIT, The maximum number of subqueries or derived tables in a request has been exceeded.when trying to run a report.This report worked last year. It does call a dataset report for filtering, which in turn calls another dataset report for filtering, …This occurs 5 times.This last report does not call any other Cognos reports and returns 6801 records (6068 unique ID’s).Each dataset (sub report) runs fine. It is only the main report which returns this error. Logged Fate gives us the hand, and we play the cards.-- Arthur Schopenhauer Grim Honorary Master of IBM Links Statesman Join Date: Nov 2011 Posts: 688 Forum Citizenship: +58/-7 Re: Error number -239 « Reply #1 on: 06 Mar 2012 01:34:17 pm » What DB vendor and version are you querying?Has the DB changed?Has the driver or DB version changed?Grab the SQL (Report | Query | Profile | SQL, copy and past the SQL code) and run it against the DB directly, does it return? Logged "Honorary Master of IBM Links"- MFGFCertified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.<-Applaud if my rant helped! Print Pages: [1] « previous next » COGNOiSe.com - The IBM Cognos Community » Legacy