Solved

Business Objects universe error

Posted on 2014-01-15
6
715 Views
Last Modified: 2014-01-30
I have 5 identical universes in Business Objects V.4.0. Four of them work, but 1 doesn't. This is a query statement for one that works:

SELECT
  RUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Number,
  sum(RUSSDW4618.dbo.RUS_INVOICE_STANDARD_COST.Cost_Price),
  sum(RUSSDW4618.dbo.RUS_INVOICE_STANDARD_COST.Quantity * RUSSDW4618.dbo.RUS_INVOICE_STANDARD_COST.Cost_Price),
  RUSSDW4618.dbo.PRODUCT.Product_Code_Unpacked
FROM
  RUSSDW4618.dbo.PRODUCT INNER JOIN RUSSDW4618.dbo.INVOICE_DETAIL ON (RUSSDW4618.dbo.INVOICE_DETAIL.Product_Code_Packed=RUSSDW4618.dbo.PRODUCT.Product_Code_Packed and RUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Date >= RUSSDW4618.dbo.PRODUCT.Start_Date and RUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Date < RUSSDW4618.dbo.PRODUCT.End_Date)
   INNER JOIN RUSSDW4618.dbo.RUS_INVOICE_STANDARD_COST ON (RUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Number=RUSSDW4618.dbo.RUS_INVOICE_STANDARD_COST.Invoice_Number  AND  RUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Date=RUSSDW4618.dbo.RUS_INVOICE_STANDARD_COST.Invoice_Date  AND  RUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Number=RUSSDW4618.dbo.RUS_INVOICE_STANDARD_COST.Invoice_Number and RUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Date=RUSSDW4618.dbo.RUS_INVOICE_STANDARD_COST.Invoice_Date and RUSSDW4618.dbo.INVOICE_DETAIL.DbCr_Line_Number=RUSSDW4618.dbo.RUS_INVOICE_STANDARD_COST.DbCr_Line_Number)
GROUP BY
  RUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Number,
  RUSSDW4618.dbo.PRODUCT.Product_Code_Unpacked

This is the statement created in the one that doesn't work:

  SELECT
    PUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Number,
    sum(PUSSDW4618.dbo.PUS_INVOICE_STANDARD_COST.Quantity * PUSSDW4618.dbo.PUS_INVOICE_STANDARD_COST.Cost_Price),
    sum(PUSSDW46184.dbo.PUS_INVOICE_STANDARD_COST.Cost_Price),
    PUSSDW4618.dbo.PRODUCT.Product_Code_Unpacked
  FROM
    PUSSDW4618.dbo.INVOICE_DETAIL
  GROUP BY
    PUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Number


I've checked all the joins, and they're identical in all universes. Can you advise me in what else to check?
0
Comment
Question by:ked2000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 39785455
What error do you get?

mlmcc
0
 

Author Comment

by:ked2000
ID: 39786214
Sorry, this is the error message:

Error:
[] <com.businessobjects.dsl.commons.exception.NestedException: Failed to execute: SELECT
  PUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Number,
  sum(PUSSDW4618.dbo.PUS_INVOICE_STANDARD_COST.Quantity * PUSSDW4618.dbo.PUS_INVOICE_STANDARD_COST.Cost_Price),
  sum(PUSSDW46184.dbo.PUS_INVOICE_STANDARD_COST.Cost_Price),
  PUSSDW4618.dbo.PRODUCT.Product_Code_Unpacked
FROM
  PUSSDW4618.dbo.INVOICE_DETAIL
GROUP BY
  PUSSDW4618.dbo.INVOICE_DETAIL.Invoice_Number
>

Cause of Error
[Microsoft][SQL Native Client][SQL Server]Statement(s) could not be prepared.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39786471
Can you look at the SQL in the report when you edit the query?

DId you install the services packs for B) 4.0?

mlmcc
0
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

 

Author Comment

by:ked2000
ID: 39786553
Yes, the service packs are installed. I can't get as far as a report. When I create the query I receive an error message. If I paste the query generated by BO into SQL Server, I get an error. Only one table is referenced in the BO query, when I'm using fields from 3 different tables.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39786710
Have you tried doing an integrity check in the universe?

mlmcc
0
 

Author Closing Comment

by:ked2000
ID: 39821733
Sorry for the delay in getting back here. I received a new laptop at work and was unable to log in to the server for a couple of weeks. The data foundation was fine, but the business layer was somehow disconnected from the database. I had to bring each element in again.
0

Featured Post

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A list of useful business intelligence software.
All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
Viewers will learn how to use the Hootsuite Dashboard.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question