cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to configure BI Java Connectors for NW04s SP06

Former Member
0 Kudos
69

Hello,

_____________________________________________

system info:

SAP NetWeaver 2004s SP06 with AS-JAVA, AS-ABAP, BI, BI-Java and EP.

database:

Oracle 10.2.0.2

Action:

Unable to configure the correct Visual administrator parameters with the BI_JDBC_CONNECTOR.

______________________________________________

There a many posts on SDN about the parameters to fill on Visual admin for SDK_JDBC connector, but I am not able to configurate correctly.

My main parameters are:

1) JDBC Connectors -> Drivers -> ORACLE -> Classes12.zip

2) Connection Container -> Connector 1.0 -> SDK_JDBC -> Managed COnnection Factory -> Properties -> URL=jdbc:oracle:thin@myserver:1527?database=SID

To test, http://myserver:50000/TestJDBC_Web/TestJDBCPage2.jsp?sys_jdbc=SDK_JDBC

and the error: page not found.

What is the exact parameters for installation procedure for Oracle JDBC-Driver config?

Thanks for your help.

Regards,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Alex, que tal.

We have new install the BI7 using AS in ABAP & JAVA and EP7, BI JAVA is intalled to.

You can help me in Steps for customizing and activate the WEB area in BI7 ?

And you can Help in Oracle JDBC-Driver Steps ?

Thank you.

Muchas Gracias, creo tu tambien hablas español.

Former Member
0 Kudos

Now I am in this point:

com.sap.ip.bi.sdk.exception.BIConnectionFailedException: No se puede establecer la conexión

It will try to advance during the day...

Regards,

Former Member
0 Kudos

Run the Log Viewer and put the logs from the output of the connection test in this forum. Then I'll check out the detailed logs... I want the logs from defaultTrace.trc

Former Member
0 Kudos

Hi Prakash, we have similar problem.

Is posible you send me email for reply you the steps to steps in setting, for get little help from you ?

vfigueroa@cl.soluziona.com

<b>We have firts time error :</b>

Cannot open the connection

<b>So in Log file :</b>

SQLException: ORA-01017: invalid username/password; logon denied

<b>Now error is :</b>

com.sap.ip.bi.sdk.exception.BIConnectionFailedException: Cannot open the connection

TOAD SQL working good.

In Trace File we have :

#1.5#001125E675A3005C000000CA0005B126000432AA3E7CDABE#1181606681041#/Applications/BI/UDI#sap.com/com.sap.ip.bi.sdk.dac.connector.checkj#com.sap.ip.bi.sdk.dac.connector.relational.CommonConnection#J2EE_GUEST#0####8461b410187811dcbff3001125e675a3#SAPEngine_Application_Thread[impl:3]_52##0#0#Error#1#/Applications/BI/UDI#Plain###java.sql.SQLException: Io exception: The Network Adapter could not establish the connection#
#1.5#001125E675A3005C000000CD0005B126000432AA3E7CE285#1181606681043#/Applications/BI/UDI#sap.com/com.sap.ip.bi.sdk.dac.connector.checkj#com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection#J2EE_GUEST#0####8461b410187811dcbff3001125e675a3#SAPEngine_Application_Thread[impl:3]_52##0#0#Error#1#/Applications/BI/UDI#Plain###com.sap.ip.bi.sdk.exception.BIResourceException: Cannot connect to JDBC data source#

What about the : J2EE_GUEST ??

Thank you.