Symptom
-
Attempting to view and refresh a Lumira document based on "Query with SQL" option from the Business Intelligence (BI) Platform causes an error.
- Configured JDBC driver according to the BI Platform Data Access guide
- Other document formats (Crystal Reports for Enterprise, Web Intelligence) based on the same Oracle JDBC connection refresh successfully.
- Lumira Server logs show the following errors:
ENTER [unknown|unknown|ID:0]com.sap.connectivity.cs.java.ConnectionServer{com.businessobjects.connectionserver.Environment}.CreateJob:
connectionString "ConnectionString[Error on generating traces]"
networkLayer "JDBC"
dataBase "Oracle 11"
EXCEPTION [unknown|unknown|ID:0]com.sap.connectivity.cs.java.ConnectionServer{com.businessobjects.connectionserver.Environment}.CreateJob: []
com.sap.connectivity.cs.java.drivers.CSDriverError: oracle.jdbc.OracleDriver. Database: Oracle 11
Call to service 'createFHSQLConnection' failed
com.sap.teamserver.server.wrapper.VIServiceException - The following error occurs when providing the credentials to the database: "Unable to connect. Check your data access driver"
Read more...
Environment
-
SAP Lumira 1.0, server version for the SAP BusinessObjects BI Platform (LS4BIP), version 1.25 and above
- SAP BusinessObjects Business Intelligence Platform 4.x
- Supported Oracle JDBC data sources
Product
SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP Lumira 1.0, server version for the SAP BusinessObjects BI platform
Keywords
bi, bip, boe, bi41, bi4, 4.1, bobi, bobj, lum, srv, ls4bip, team, server, java, db, conn, connect, access, sql, relational, data, base, rdbms, can, not, can't, unable, failed, error, issue, defect, bug, working, fix, generic jdbc, oracle, sap, oracle12, oracle11, ojdbc, ojdbc6, ojdbc7, oraclepki, jar, sbo, oracle.sbo, data access, check driver, fhsql, freehand sql, free hand, , KBA , BI-LUM-SRV-ADM , Lumira Server BI Platform Admin, Auth, Security , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.