Qe-def-0359 Error In Cognos
Contents |
Environment Technote (troubleshooting) Problem(Abstract) After refreshing an OpenPages environment (ie: development) from using an OPBackup of another environment (ie: production), some Cognos reports are qe-def-0030 expression parsing error no longer working and the following error is occurring: QE-DEF-0030 Expression parsing error.QE-DEF-0359
Qe-def-0030 Expression Parsing Error Dpr-err-2082
The query contains a reference to at least one object Symptom Cognos is generating a sample message such as:
Qe-def-0459 Cclexception Parsing Error
QE-DEF-0030Expression parsing error.QE-DEF-0359The query contains a reference to at least one object '[AUD2_REL].[AUDITABLEENTITY].[AE_ENTITY_OWNER]' that does not exist. QE-DEF-0030Expression parsing error.QE-DEF-0359The query contains a reference to at least one object '[AUD2_REL].[AUDITABLEENTITY].[AE_RISK_OWNER]' that
Rqp-def-0149
does not exist. The message is stating a field could NOT be found in the reporting framework. Cause The OpenPages framework that is published in Cognos does not align with reports that is being executed. This can occur if the reporting framework was not regenerated during an environment refresh. Diagnosing the problem To diagnose the issue, an OpenPages administrator should: Open a supported browser. qe-def-0459 cclexception cognos 10 Go to the OpenPages URL. Login with an administrator id. Using the navigation menubar, go to: Reporting -> Cognos Report Studio. Open the report within Report Studio. Validate the report. If the report doesn't validate, review the reporting framework from within Report Studio to see if the field(s) exists. If the field doesn't exist, regenerate the reporting framework from within the OpenPages UI. If the report does validate successfully, save the report and try to run the report again. Resolving the problem To resolve the issue, an OpenPages administrator should regenerate the reporting framework and verify that the field does exist in framework. To regenerate the reporting framework, an OpenPages administrator can: Open a supported browser. Go to the OpenPages URL. Login with an administrator id. Using the navigation menubar, go to: Administration -> Reporting Framework -> Generation. Click on the 'Update...' button. Select the appropriate check boxes. Click on the 'Submit' button. Once the reporting framework generates successfully, retest the report and/or re-validate the report in Cognos Report Studio. Related information Reporting Framework Troubleshooting Steps Document information More support for: OpenPages GRC Platform Software version: 6.0, 6
that has caf-wrn-2082 a union. crosstab chart union Technote (troubleshooting) Problem(Abstract) QE-DEF-0030 Expression rqp-def-0177 parsing error is returned when running a crosstab or a chart report that has a union, running http://www-01.ibm.com/support/docview.wss?uid=swg21643675 the same report as a list using the union has no problem. Symptom QE-DEF-0030 Expression parsing error QE-DEF-0359 The query contains a reference to at least one object '[Union1].[Margin]' that does not exist. RSV-SRV-0042 http://www-01.ibm.com/support/docview.wss?uid=swg21340011 Resolving the problem Change the aggregate function from automatic to a specific type that applies like average or total. Another alternative is to change the measure to contain a calculation to cast the measure as a specific data type. For exammple cast([Union1].[Margin] as double precision). Historical Number 1021741 Document information More support for: Cognos 8 Business Intelligence Report Studio Software version: 8.1, 8.2 Operating system(s): Solaris, Windows Reference #: 1340011 Modified date: 19 April 2016 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 Java Knowledge Management http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/qedef0359-error-while-running-a-report-4114526 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 http://cognos.error.qe.def.0359.winadvice.org/ GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-CRM Inside-ERP VoIP_News I_am_the_dragon MacProTX maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker parsing error Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke AbhaiTripathi Adrian_Grigoriu Nikki Klein Iqbalyk blrvenkat numbersguyPA COMPANIES Compuware ZOHO Corporation Cisco HighJump Software View All Topics View All Members View All Companies Toolbox for IT Topics Business Intelligence Groups Ask a New Question Cognos 8 The Cognos 8 qe-def-0030 expression parsing 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. QE-DEF-0359 error while running a report sunil kumar asked Mar 28, 2011 | Replies (3) QE-DEF-0359 The query contains a reference to at least one object '[GL Period]' that does not