Error in Bi Publsiher while creating SQL Query in a Data Set.

Srishti Rawat01

Summary

Error in Bi Publsiher while creating SQL Query in a Data Set.

Content

Hi,

 

I have created two data sets in BI Publisher using SQL query.

One of the Data set is working fine whereas the other data set is showing Error when I insert SQL query in that particular Data Set.

 

Error:  oracle.xdo.servlet.data.DataException: java.sql.SQLException: Connect: Unable to open connection to server.

 

Thanks & Regards

Srishti

YGUTTIKONDA

Srishti,

I assume in the Dataset the datasource may have been defaulted to demo by mistake. Point it to the correct data source

Hope this helps

--YG

Venkat Thota - BIP

try to check each data set working separate then test two data sets ,still find issue , please post screen shots. Does both data sets were joined using link ?

Dswope

I am out of the office until Wednesday May 16th. If you have an emergency, please contact the help desk. X3688

>>> community-admin <community-prod-admin_ww@oracle.com> 05/14/18 20:36 >>>

Venkat-BIP created the discussion

"Error in Bi Publsiher while creating SQL Query in a Data Set."

To view the discussion, visit: https://community.oracle.com/message/14815599#14815599