- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- Web Intelligence Rich Client Problems
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Web Intelligence Rich Client Problems
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 08-13-2008 3:00 PM
Hi,
We have the folliwng error in Web Intelligence Rich Client. I can log on
and select a Universe as a data source. I can build a query, but if I
try to run the query, I get the following error:
"A database error occurred. The database error text is: (CS) "COM
Provider CLSID not specified or erroneous" . (WIS 10901)"
Using registry scanning software, I have found that there are various
missing folders, dll's and invalid CLSID's. I have manually created the
missing folders but this does not work. Obviously there isn't much I can
do about the invalid dll's or CLSID's.
I have tried uninstalling all BusinessObjects and Crystal Reports
applications on my PC, and reinstalling the Rich Client, but to no
avail. I can run queries successfully against a local data source.
Garreth
- SAP Managed Tags:
- SAP BusinessObjects - Web Intelligence (WebI)
Accepted Solutions (0)
Answers (8)
Answers (8)
P13119501
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
I was getting this same error. My laptop had SQL Server 2008 R2 and the database I was connecting to is SQL Server 2008 on a BusinessObjects 3.1 SP3.
When trying to parse the new DATE field in SQL Server 2008 was giving me "CS: COM Provider CLSID not specified or erroneous".
After realizing that SQL Server 2008 R2 DATE function is not supported on BOE 3.1. Then i downloaded the Microsoft SQL Server 2008 Native Client from (http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16177).
Make sure when you run this package do not have anything open, after this install completes then restart you system. You may have to restart twice to sync up the drivers.
Open up BusinessObjects Universe and parse a field that uses the DATE variable.
You should not have to update the oledb.sbo file the new drives wil take care of the update.
please let me know if this does not work for you can i can help find the problem
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi experts,
After I install the SQL Native client the WebI Aplication present the following problem:
Database error: [Microsoft SQL Server Native Client 10.0] : SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. . (IES 10901) (WIS 10901)
Aparently, the problem is solved, but this new error appear, how can I solved
Henry_Banks
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi,
Please open a new Thread for your specific purposes - this one started in 2008, and was updated in 2011..
I will now lock this thread.
For what it is worth, You should check/test you Universe Connection to your database. It may be a problem with your client or server side DSN .
Also, try doing a Google on error text : SQL Server Network Interfaces: Error Locating Server/Instance Specified
Regards,
H
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
I also had the issues outlined in this thread, and installing the native client helped.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi,
Today i faced same issue and I resolved it by making changes in connection parameter. If I connect database on one of the server it throws this error. But when I connect it to similar database but on another server, it works fine. All objects gets parsed properly on both serevr but query runs only on one server. I don't see the need of uninstalling BO or registry. It is with SQL native connection on server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi Garreth,
Did you ever get this issue resolved? We got an user having the same issue on his PC, but the installation on my PC works fine.
Thanks,
Steven
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
This is usually because the universe contains an object which is not correctly defined.
Try:
In Designer, identify the object that does not parse.
- run an integrity check
- check for parsing error for the object
- modify the SQL definition of the object so that it parses ok.
After modifying the object SQL definition, you can now run the query successfully in Infoview.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Has anybody found a resolution for this issue. I am running into the same problem in a clean BOXI release 3 installation.
CS: COM Provider CLSID not specified or erroneous
If I create an ODBC connection to the SQL Server 2005 database it works fine. However, if I create an OLEDB connection to the same database it gives me the error mentioned above.
Please advice.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
There's an ADAPT out for this.
The relevant SAP NOTE is below:
SAP NOTE 1204488 - Error: "CS:COM Provider CLSID not specified or erroneous" trying to create SQL Server 2005 OLEDB connection in Designer.
Symptom
When trying to create SQL Server 2005 OLEDB connection in the Designer, an error message appears:
"CS:COM Provider CLSID not specified or erroneous"
Cause
The issue has been identified and tracked under ID ADAPT00736944.You need to first install the SQL Native Client driver or modify parameters in the oledb.sbo file.
Resolution
Choose one of two work arounds to resolve this issue:
*
Install the SQL Native Client driver.
*
Modify parameters in the oledb.sbo file as follows:
1.
Open the oledb.sbo file located in the oledb directory under the connectionServer install directory.
2.
Under the <DataBase Active="Yes" Name="MS SQL Server 2005"> section of the file, change the following two parameters:
Parameter Provider CLSID " change value to: SQLOLEDB
Parameter Enumerator CLSID " change value to: SQLOLEDB Enumerator
3.
In the oledb.sbo file, locate the <DataBase Active="Yes" Name="MS SQL Server 2000"> section. The parameters you set in the the <DataBase Active="Yes" Name="MS SQL Server 2005"> section should be the same as the corresponding values in <DataBase Active="Yes" Name="MS SQL Server 2000"> section.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi,
This is the lastest from the affected user, based on your last suggestions :-
Yeah, tried that, also tried using a Registry Scanner to remove any
orphaned keys, but that didn't work. I think it may well be something to
do with a dodgy previous installation, but I can't find it. I have new PC
with no previous installation on it.
The ODBC thing is not relevant as we are not using ODBC in this
instance.
I have just tried it again and noticed this entry in the Windows
Security Log. I don't think it is the cause of the problem, but it might
be worth looking into:
Event Type: Failure Audit
Event Source: Security
Event Category: Detailed Tracking
Event ID: 861
Date: 14/08/2008
Time: 11:35:30
User: OLYMPUS\****
Computer: *****
Description:
The Windows Firewall has detected an application listening for incoming
traffic.
Name: -
Path: C:\Program Files\Business Objects\BusinessObjects Enterprise
12.0\win32_x86\WebIRichClient.exe
Process identifier: 2456
User account: User
User domain: DOMAIN
Service: No
RPC server: No
IP version: IPv4
IP protocol: TCP
Port number: 2821
Allowed: No
User notified: No
-
I have uninstalled The Webi Rich Client and carried out a registry scan which found loads of errors. I cleaned up these errors so that I had a good registry with zero errors. I then reinstalled the client and scanned the registry again with came up with the problems in the attached list.
Scanning Date: Friday, August 15, 2008 - 12:43 PM
Total Problems
Found:
21
Scanning Section: Activex, OLE, COM sections
Entries Found: 4
Entries:
Entry: HKEY_CLASSES_ROOT\CLSID\{735BA095-0A44-4f5f-ABD6-
43318CC4CEAF}\TypeLib
Valuename:
Value: {30765683-9EDE-4c37-B4B5-A60EC686B53C}
Reason: ( The HKEY_CLASSES_ROOT\CLSID\{735BA095-0A44-4f5f-
ABD6-43318CC4CEAF}\TypeLib key points to the missing Type Library
{30765683-9EDE-4c37-B4B5-A60EC686B53C} )
Entry: HKEY_CLASSES_ROOT\CLSID\{767BF29F-561C-40D4-89FE-
029BE975B7F9}\TypeLib
Valuename:
Value: Reason: ( The HKEY_CLASSES_ROOT\CLSID\{767BF29F-561C-40D4- 89FE-029BE975B7F9}\TypeLib key points to the missing Type Library )
Entry: HKEY_CLASSES_ROOT\CLSID\{8C771AC6-F28B-4995-8462-
63DD207D8735}\TypeLib
Valuename:
Value: Reason: ( The HKEY_CLASSES_ROOT\CLSID\{8C771AC6-F28B-4995- 8462-63DD207D8735}\TypeLib key points to the missing Type Library )
Entry: HKEY_CLASSES_ROOT\CLSID\{C32127ED-B57E-4A48-9724-
2602EAB100EA}\TypeLib
Valuename:
Value: Reason: ( The HKEY_CLASSES_ROOT\CLSID\{C32127ED-B57E-4A48- 9724-2602EAB100EA}\TypeLib key points to the missing Type Library )
Scanning Section: Invalid File associations
Entries Found: 1
Entries:
*Entry: HKEY_CLASSES_ROOT\xdefman\CLSID*
Valuename:
Value:
Reason: ( The HKEY_CLASSES_ROOT\xdefman key points to the missing
CLSID )
Scanning Section: User software settings
Entries Found: 0
Entries:
Scanning Section: System software settings
Entries Found: 16
Entries:
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\CLASSID\vASTools_Ibo
Valuename: InprocServer
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\win32_x86\vASTools_Ibo.dll
Reason: ( The Key vASTools_Ibo under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\CLASSID contains a bad path InprocServer for the value
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86
\vASTools_Ibo.dll )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\CLASSID\VB4INITOR
Valuename: InprocServer
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\c3_vb4init.dll
Reason: ( The Key VB4INITOR under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\CLASSID contains a bad path InprocServer for the value
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\c3_vb4init.dll )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General\Directories
Valuename: Archives
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\archives\
Reason: ( The Key Directories under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General contains a bad path Archives for the value C:\Program
Files\Business Objects\BusinessObjects Enterprise 12.0\archives\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General\Directories
Valuename: Distribution
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\distribution\
Reason: ( The Key Directories under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General contains a bad path Distribution for the value
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\distribution\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General\Directories
Valuename: Installed Documents
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\demo\documents\
Reason: ( The Key Directories under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General contains a bad path Installed Documents for the value
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\demo\documents\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General\Directories
Valuename: Installed Universes
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\demo\universes\
Reason: ( The Key Directories under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General contains a bad path Installed Universes for the value
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\demo\universes\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General\Directories
Valuename: Logs
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\logs\
Reason: ( The Key Directories under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General contains a bad path Logs for the value C:\Program
Files\Business Objects\BusinessObjects Enterprise 12.0\logs\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General\Directories
Valuename: Nodes
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\nodes\
Reason: ( The Key Directories under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General contains a bad path Nodes for the value C:\Program
Files\Business Objects\BusinessObjects Enterprise 12.0\nodes\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General\Directories
Valuename: Private License
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\license\
Reason: ( The Key Directories under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General contains a bad path Private License for the value
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\license\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General\Directories
Valuename: Tools
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\tools\
Reason: ( The Key Directories under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\Shared\General contains a bad path Tools for the value C:\Program
Files\Business Objects\BusinessObjects Enterprise 12.0\tools\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\WebIntelligence\BlobManager
Valuename: Root
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\win32_x86\BRepository\
Reason: ( The Key BlobManager under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\WebIntelligence contains a bad path Root for the value C:\Program
Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86
\BRepository\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\WebIntelligence\BlobManager
Valuename: MapDirBoImg
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\win32_x86\BRepository\temp\
Reason: ( The Key BlobManager under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\WebIntelligence contains a bad path MapDirBoImg for the value
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86
\BRepository\temp\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\WebIntelligence\KLog
Valuename: LogDirectory
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\win32_x86\Log\
Reason: ( The Key KLog under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\default\WebIntelligence contains a bad path LogDirectory for the value
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86
\Log\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\Enterprise\InstallRoot
Valuename: TempFiles
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\Data\
Reason: ( The Key InstallRoot under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0\Enterprise
contains a bad path TempFiles for the value C:\Program Files\Business
Objects\BusinessObjects Enterprise 12.0\Data\ )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\MDA\Log
Valuename: LogFile
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\Logging\MDA.log
Reason: ( The Key Log under HKEY_LOCAL_MACHINE\Software\Business
Objects\Suite 12.0\MDA contains a bad path LogFile for the value C:\Program
Files\Business Objects\BusinessObjects Enterprise 12.0\Logging\MDA.log )
Entry: HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0
\WebIntelligence Report Server
Valuename: AuditLogFilesDirectory
Value: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0
\Auditing
Reason: ( The Key WebIntelligence Report Server under
HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 12.0 contains a
bad path AuditLogFilesDirectory for the value C:\Program Files\Business
Objects\BusinessObjects Enterprise 12.0\Auditing )
Scanning Section: Shared DLLs section
Entries Found: 0
Entries:
Scanning Section: File extensions
Entries Found: 0
Entries:
Scanning Section: Startup section
Entries Found: 0
Entries:
Scanning Section: Sound and App Events
Entries Found: 0
Entries:
Scanning Section: Uninstall sections
Entries Found: 0
Entries:
Scanning Section: Fonts section
Entries Found: 0
Entries:
Scanning Section: Help section
Entries Found: 0
Entries:
Scanning Section: Application paths
Entries Found: 0
Entries:
Scanning Section: System drivers
Entries Found: 0
Entries:
Scanning Section: Shared Folders
Entries Found: 0
Entries:
Scanning Section: Invalid Shortcut
Entries Found: 0
Entries:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Thanks for the response, I will look at this.
Garreth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi Garreth,
After uninstalling, did you try and clean out the registry. Search for "Business Objects" and remove as many entries as possible and then try to reinstall.
Sounds like the installation did not go well the first time round.
Also something on the WIS 10901 error to check is if your are using ODBC connections for your universes then you may want to delete them on your machine and just recreate them.
Hope this helps
Jacques
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- New Machine Learning features in SAP HANA Cloud in Technology Blogs by SAP
- Unify your process and task mining insights: How SAP UEM by Knoa integrates with SAP Signavio in Technology Blogs by SAP
- Top Picks: Innovations Highlights from SAP Business Technology Platform (Q1/2024) in Technology Blogs by SAP
- Harnessing the Power of SAP HANA Cloud Vector Engine for Context-Aware LLM Architecture in Technology Blogs by SAP
- UNVEILING THE INNOVATIONS OF ARTIFICIAL INTELLIGENCE in Technology Q&A
| User | Count |
|---|---|
| 86 | |
| 10 | |
| 10 | |
| 10 | |
| 7 | |
| 6 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.