Solution: I installed SQL Native Client for the appropriate version of the SQL Server universe tried to access on his machine and it worked. When the user attempts to refresh their report, they would get the following error: “Connection or SQL sentence error: (DA0005)” : When clicking on the "Details>>" button, Add DSN or TNS on all clients' machines that refresh your reports on Desktop Intelligence. As you asked, providing following information. have a peek at this web-site
Query Builder:queries for extract reports refreshed after o before a specific date Query Builder:queries for extract reports refreshed after o before a specific date which could be useful to extract Webi Run DBCC UPDATEUSAGE. Thanks, Jansi Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Categories: SQL Server 1 Comment Manmit says: 10 July, 2013 at 6:47 pm We could figure out that the issue was happening due to incorrect/missing entry in the TNS ora file
OLE DB ODBC Component based specification Procedural based specification Supports all forms of data stores: relational,hierarchical, e-mail and file system stores; text, graphical, and geographical data; custom business objects; and more Will this affect your existing applications? If answer to the second question is yes, the please check if the DSN / TNS to the reporting data source is there and working properly on the server? The Request to fetch the date while refreshing will go via server, that is why the server requires the same connection else you may get the similar error over the web
Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox.com Toolbox for IT on Twitter Toolbox.com on Twitter Toolbox.com on Facebook Topics PCMag Digital Group AdChoices unused Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Jansi replied May 30, 2008 Vinod, 1) The document is based on 2 data sources, One universe from Oracle and another from Teradata. Search for: SQL SERVER DBA DBA is a not a job, it's a diagnosis Search for: Main menu Skip to content About SQLServer DBAContactWhat is DBA Business Objects BOXI3 Desktop Intelligence
Action Re-install the Oracle data access driver Pubblicato da Giuseppe Quinto a 5:38 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Etichette: Errors No comments: Post a Comment Newer Post Thursday, August 29, 2013 Connection or SQL sentence error. (DA0005) - DESKI Connection or SQL sentence error. (DA0005) Cause Connection Server can generate a connection or SQL sentence error after the Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Jansi replied May 27, 2008 Katherine, Thanks for your timely solution.
This error only occurs on one workstation (BO FC 6.5.1). Connection or SQL sentence error: (DA 0005 ) , Exception: CS, Unexpected behaviour Apurba Nayak asked Mar 31, 2010 | Replies (3) Hi, This is an issue in one of the BI 4 - LCMBIAR Overview - LCM Command Line Tool LCMBIAR Overview -LCM Command Line Tool SAP BusinessObjects Business Intelligence 4.0 Version 4.0 SP2 Fixpack 5 Allows to: P... Any help would be appreciated.
Contact your System administrator WIS 30951 -The document can't be retrieved from the File Repository Server. Contact your System administrator Environment BO XI R3... manovijay replied Sep 28, 2007 When you are creating user objects this error(DA0005) will occur. For other error see also: BUSINESS OBJECTS ERRORS LIST Pubblicato da Giuseppe Quinto a 12:53 AM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Etichette: Errors No comments: Post a Comment
Register now while it's still free! Check This Out Now re-open your report. Your will see that it will refresh with out giving you an error, and you can move on to the next thing. Prompt is displaying but when I give the values it is giving error. In Microstrategy, we have Intelligence Server which distinguishes between 2 tier and 3 tier.
Thursday, January 24, 2013 Error DA0005 CONNECTION or SQL SENTENCE ERROR - ORA-12154 Environment: Business Objects XI R 3.1 - Desktop Intelligence/ Rich Client We had this error CONNECTION or SQL This can occur if the format set in the .sbo file does not agree with that set in the database. The recipient should check this email and any attachments for the presence of viruses. http://patricktalkstech.com/business-objects/business-objects-sql-error-da0005.html Contact your System administrator WIS 30951 -The document can't be retrieved from the File Repository Server.
Adnan Alkhouri Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Would you please help me on this more? Close this window and log in.
If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Microsoft’s definition of OLE DB is a strategic system-level programming interface to data across the organization. the way to check for the 2 tier connection information as well as the 3 tier connection information.. Michael McErlain, CBIP replied May 30, 2008 Jansi If you are on version XIR2 consider that there is a problem with the way security is set up on the connection.
Next, open the report's universe file in the Business Objects designer. We used run this report with out any issue earlier, we are running into this issue over the past few days.When SP is executed from query analyzer or from crystal, it The Business Objects Reporting & Analysis group is no longer active. http://patricktalkstech.com/business-objects/business-objects-error-code-da0005.html Jansi replied May 27, 2008 Katherine, How should I check these things?