Solved

Business Objects universe error

Posted on 2014-01-15
6
702 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
  • 3
  • 3
6 Comments
 
LVL 100

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 100

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
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 

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 100

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Is Windows 10 now more stable 43 148
Free employee timeclock 7 54
VTP LOG RUNTTIME ERROR 31 138
Where is Outlook in Paperport 14? 6 25
A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

948 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now