Description of Problem or Question: The database logon information for this report is either incomplete or incorrect.
Product\Version\Service Pack\Fixpack (if applicable): Business Object XI 3.1 (Edge Series)
Relevant Environment Information (OS & version, java or .net & version, DB & version):
Windows Server 2008 (32bits)
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
What has already been tried (where have you searched for a solution to your question/problem):
The information was searched in the product help, SAP forum, internet
a) The services were started with an admin user
b) The connection with the database was checked and it is possible to connect to it by using SQLPlus
c) It is been used Database Type > Select a database driver > ORACLE
d) The u2013trace option was enabled for JobServer. The message below appears in the log file
FAILED: Error message in the language of the server \[The database logon information for this report is either incomplete or incorrect.]
e) The report loads information when it is run from Crystal Reports (designer), which is installed in other workstation.
Steps to Reproduce:
1) Create a report by using Cristal Reports
2) Copy rpt file to server
3) Update Database configuration in report properties (Central Management Console)
4) Run the report
Note: The workstation where the report was designed is addressing to QA database (it does not have access to PRD database). On the other hand, the server is addressing to PRD database (it does not have access to QA database). This configuration has been changed when the report (rpt file) is copied to the server according to the correct database (point 3).
Sorry for the confusion.
A) The PRD database server has Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit.
B) The Business Object XI 3.1 (Edge Series) server has (for client purpose)
1) Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4) for Microsoft Windows (32-Bit)
Enterprise/Standard Edition for Microsoft Windows Vista, Windows Server 2008, Windows 7
2) Oracle Database 10g Release 2 Patch Set 4 10.2.0.5.0
Regarding BO installation path, it is C:\Program Files\Business Objects\
I've installed the whole application, no the driver only.
I had installed the instant client first but I had an error, so by SAP recommendation I installed the whole application.
Go into the CMC navigate to your report (use the Folders link), select it and press the right mouse button. CHoose database configuration and go to the bottom of the window. WHich options is selected there?
Check also on the top of the window the database connect information. Are the user credential for the datbaae login available?
I'm using "Use same database logon as when report is run", but I've tried with the other two options and it thrown the same error.
About the credentians, I'm not using the default ones (due the db used to design the report is not available from this server), I've overwritten the credentials ("Use custom database logon information specified here") for the correct ones for this server (the same used from SQLPlus, which works).