Business Objects Error State 42000
SAP BusinessObjects Desktop IntelligenceWhere is this place located?All Places SAP BusinessObjects BI Legacy Products SAP BusinessObjects Desktop Intelligence 10 Replies Latest reply: Nov 10, 2014 12:40 PM by venu malineni Tweet Error trying to modify SQL in Data Provider Emerson Staup Jan 15, 2009 6:14 PM Currently Being Moderated I am attempting to modify the generated SQL in a DESKI 3.1 report and save with the Do Not Generate box checked.If I attempt to modify the generated SQL and check the Do Not Generate box when I click on OK or Verify SQL button I get the following error:Exception: DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.State: 42000Any ideas as to what could be the problem?Thanks. 7062Views Re: Error trying to modify SQL in Data Provider Pratik Basapure Jan 15, 2009 8:40 PM (in response to Emerson Staup) Currently Being Moderated Hi Emerson,There are couple of reasons when users may get this type of error.Cause 1:You have a universe with a connection to Microsoft SQL Server 2005. If you modify some of the characters for the SQL in the object definition from lower case to upper case (or vice-versa), the following error message appears:"Error: Parse Failed: Exception, DBD [Microsoft][ODBC SQL ServerDriver][SQL Server]Statement(s) could not be prepared. State: 42000."CauseThe SQL statement is case sensitive in Business Objects.Follow these steps to Resolve the Problem:1. Test the connection in your universe and click Details.2. From Details, copy and run the path for the PRM file used by your connection which will open the relevant PRM file in Notepad.3. Modify the following parameter (or add to the PRM file if itdoes not exist) as follows:4.
Community team. Close Getting Started Store Skip to content Skip to breadcrumbs Skip to header menu Skip to action menu Skip to quick search Spaces Browse Pages Labels Space Operations Quick Search Help Online Help Keyboard Shortcuts Feed Builder What’s new About Confluence Attachments (2) Page History Restrictions Page Information Link to this Page… View in Hierarchy https://scn.sap.com/thread/1199650 View Source Export to PDF Export to Word Business Intelligence (BusinessObjects) … Home Business Intelligence Business Intelligence (BusinessObjects) Home Parsing Error while creating prompt function in the Universe Skip to end of metadata Created by Pooja Choubey, last modified on Dec 22, 2011 Go https://wiki.scn.sap.com/wiki/display/BOBJ/Parsing+Error+while+creating+prompt+function+in+the+Universe to start of metadata @Prompt : Prompts can beused to restrict the data or to make large value objects easier to use when a user creates a report. You use the statement or WHERE clause for an object. It forces a user to enter one or more values for a restriction when that object is used in a query, or to select a value or a list of values. When the user runs the query, a prompt box appears asking for a value to be entered.Parse failed: Exception: DBD, [stage:Microsoft][stage:ODBC Microsoft Access Driver] Syntax error(missing operator) in query expression '( , ) AND 0=1'. State: 42000 No labels Overview Content Tools Add-ons Pages Labels Space Operations Follow SCN Contact Us SAP Help Portal Privacy Terms of Use Legal Disclosure Copyright
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite http://www.tek-tips.com/viewthread.cfm?qid=1480860 Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec616443.aspx depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste business objects the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects solutions Forum at Tek-Tips HomeForumsProject and Data ManagementData Management Programming ToolsBusiness Objects solutions Forum Universe Joins thread393-1480860 Forum Search FAQs Links MVPs Universe Joins Universe Joins Smithsc (MIS) (OP) 17 Jun 08 06:57 I have got 3 tables in a universe which I'm trying to link. The first is a 'Company' table which holds customer business objects error info. The second is a 'Sales' table which holds all sales for each customer, and the third is a 'Person' table which holds the sales person name connected to the sale.I'm trying to link these tables together so that I can see all customers, what sales they have had and who was responsible for the sale. I want to see all customers (even if they have had no sales), all sales (even if there wasn't a person connected to it) and all persons.I know the fields I need to link by. It's just the cardinality I'm struggling with. I've tried every combination of joins I can think of (including inner and outer joins) and they all produce various error messages.I know the answer is probably very simple but could somebody please help me with this problem as I'm about to throw my desktop out of the window.Many thanks for any help. RE: Universe Joins blom0344 (TechnicalUser) 17 Jun 08 09:08 Your requirement suggest having full outer joins between all tables , which isn't going to be supported.Make sure that you are always sure to have all data returned from the sales fact (which means using an outer join between sales and person)and use seperate
+ productResults.length + resourceResults.length > 0 ? 'See all Search Results' : 'Full site search'}} > CA Support Online > KB Article When creating a custom CA Business Intelligence (CABI) Web Intelligence (WEBI) report and using a Derived Universe, there are issues with reports that contains objects from the OOTB TICKET UNIVERSE CLASS. When creating a custom CA Business Intelligence (CABI) Web Intelligence (WEBI) report and using a Derived Universe, there are issues with reports that contains objects from the OOTB TICKET UNIVERSE CLASS. Document ID:TEC616443 Last Modified Date:9/3/2014 ShowHide Technical Document Details Products CA Service Desk Manager CA Service Desk Releases CA Service Desk Manager:Release:12.6 CA SDM CA Service Desk Manager:Release:12.7 CA SDM CA Service Desk Manager:Release:12.9 CA SDM Components SERVICE DESK BUSINESS OBJECTS Description: When creating a custom WEBI report and using a derived Universe, there are issues with reports that contains objects from the OOTB TICKET UNIVERSE CLASS For example, a simple report that contains the following fields: TICKET-> Open Date TICKET-> Close Date TICKET-> Ref Num TICKET-> Assignee Combo Name TICKET-> Type TICKET-> Group Name Add the GROUP NAME as a filter to the report with IN LIST and PROMPT attributes When you attempt to run the report and do a REFRESH VALUES on the GROUP NAME filter, an error is received A database error occurred. The database error text is: [DataDirect][ODBC OpenAccess SDK Driver] [OpenAccess SDK SQL Engine] AHD12002: Error in QueryHandler in method fetch_response: AHD04199: An unexpected error occurred. Contact your administrator [Microsoft OLE DB Provider for SQL Server] {SQL Code =156 SQL State=42000] Incorrect syntax near keyword 'UNION'.: [Microsoft OLE DB Provider for SQL Server] [SQL Code=156 SQL State=42000] Incorrect syntax near the keyword 'UNION'.. (WIS10901)
Solution:
An ORDER BY clause is being added to the WEBI report query.
This can be resolved by changing the parameter 'FORCE_SORT_LOV' within the Derived Universe
This can be accomplished by:
- Launch the CABI Universe Designer application
- Login with a CABI administrator account
- Open the CABI Derived Universe which the WEBI report(s) are based on
- Select FILE -> PARAMETERS
- Click on the PARAME