Follow on from setting up Publisher in a clustered environment, I’ve found a nasty little bug in the scheduling element of Publisher, Quartz. Looking at the oc4j log file /opmn/logs/default_group~home~default_group~1.log I can see OC4J starting up, and then a whole load of repeated messages: 09/03/30 11:28:43 Oracle Containers for J2EE 10g (10.1.3.3.0) initialized - ClusterManager: detected 1 failed or restarted instances. - ClusterManager: Scanning for instance “myserver.fqdn.company.net1238408921404”’s failed in-progress jobs.

Continue Reading

We’re getting this error in the Presentation Services plug-in [analytics]. Log file: /j2ee/home/application-deployments/analytics/home_default_group_1/application.log 09/03/30 13:16:38.75 analytics: Servlet error java.net.ConnectException: Connection refused (errno:239) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:517) at java.net.Socket.connect(Socket.java:467) at java.net.Socket.(Socket.java:364) at java.net.Socket.(Socket.java:178) at com.siebel.analytics.web.sawconnect.ConnectionPoolSocketFactoryImpl.createSocket(ConnectionPoolSocketFactoryImpl.java:63) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.siebel.analytics.web.sawconnect.ConnectionPoolSocketFactoryImpl.createSocket(ConnectionPoolSocketFactoryImpl.java:70) at com.siebel.analytics.web.sawconnect.ConnectionPool.createNewConnection(ConnectionPool.java:314) at com.siebel.analytics.web.sawconnect.ConnectionPool.getConnection(ConnectionPool.java:133) at com.siebel.analytics.web.SAWBridge.processRequest(SAWBridge.java:299) at com.siebel.analytics.web.SAWBridge.doGet(SAWBridge.java:325) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind[Oracle Containers for J2EE 10g (10.

Continue Reading

I’m installing ODI agent on our database server using OUI. I selected the “Server” option at install time to get the Agent only, but looking in oracledi/bin odiparams.sh is missing: $ls -l *.sh -rwxrwxrwx 1 odiadm dba 685 Nov 21 15:58 agent.sh -rwxrwxrwx 1 odiadm dba 908 Nov 21 15:58 agentscheduler.sh -rwxrwxrwx 1 odiadm dba 707 Nov 21 15:58 agentstop.sh -rwxrwxrwx 1 odiadm dba 941 Nov 21 15:58 agentweb.sh -rwxrwxrwx 1 odiadm dba 724 Nov 21 15:58 jython.

Continue Reading

If you work with a file in Windows and Unix at some point you might end up with windows line feed characters in your Unix file. It’ll look like this: one line of text ^M next line ^M and next line with more ^M To remove the ^M character, load the file into vi on unix and enter as a line command the following: :1,$s/^M// but instead of typing ^M do Ctrl-V Ctrl-M to get the charaters

Continue Reading

We’re getting problems with an instance of Informatica / out-of-the-box OBIA on a new set of servers. When we run the execution plan we get this error soon after starting: MAPPING> DBG_21075 Connecting to database [TNSENTRY], user [MYUSER] MAPPING> CMN_1761 Timestamp Event: [Tue Mar 24 18:56:33 2009] MAPPING> CMN_1022 Database driver error… CMN_1022 [ Database driver error… Function Name : Logon ORA-12537: TNS:connection closed Database driver error… Function Name : Connect

Continue Reading

The Oracle BI Publisher Enterprise Cluster Deployment doc which I just found through Metalink highlighted a couple of points: - Report repository should be shared - The scheduler should be configured for a cluster Report Repository Through Admin>System Maintenance>Report Repository I changed the path from the default, /xmlp/XMLP to a NFS mount data/shared/xmlp and restarted the xmlpserver application in OAS. On coming back up Publisher complained because all its config files (in xmlp/Admin), had disappeared.

Continue Reading

Delicious Bookmarks FireGestures FoxyProxy Greasemonkey HttpFox Screengrab User Agent Switcher

Continue Reading

I’m learning about a lot of the Oracle BI stack through reading manuals and trial-and-error. One thing I’ve realised is that Metalink holds a whole heap of useful information. For example, simply searching on “publisher cluster” throws up these two very pertinent docs: OBIEE Clustered Installation with BI Publisher (Doc ID 744515.1) BI Publisher does not accept cluster jdbc connection strings (Doc ID 559795.1) The first one is a publically available PDF, the second one is the answer to the problem I spent more time than I needed to scratching my head over yesterday.

Continue Reading

In setting the scheduler in Publisher I discovered a useful difference in jdbc drivers. Our repository is on Oracle 11g. According to the manual oracle.jdbc.driver.OracleDriver should be used, but previous installations have used oracle.bi.jdbc.AnaJdbcDriver so I tried this too. In experimenting with both I found you get more useful feedback from the second one. Here’s the same problem reported by both drivers: · Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.

Continue Reading

Following my previous work on configuring Publisher, I wanted to note down where the changes were written to. The -mname syntax of the unix find command comes in handy here: find /app/oracle/product/obiee -mtime -1 Shows me all files under the specified path which were modified in the last 1 day and helpfully throws up: /app/oracle/product/obiee/xmlp/XMLP/Admin/DataSource/datasources.xml

Continue Reading

I’m setting up a clustered OBIEE 10.1.3.4 production environment. There are four servers; two BI Server + Cluster Controller + Scheduler and two OAS + Presentation Services + Publisher. Clustering of BI is configured, now I’m setting up the other bits. Today is Publisher. On publisher instance A connections to the BI Servers directly work fine: jdbc:oraclebi://serverA.fqdn.company.net:9703/ jdbc:oraclebi://serverB.fqdn.company.net:9703/ both work individually as Connection Strings (with database driver class of oracle.bi.jdbc.AnaJdbcDriver) - verified with “Test Connection” button.

Continue Reading

As I explore the current world of data & analytics engineering, one of the things I’m trying to grok is the idea of a Metric Layer (described by Drew Banin in this keynote: https://www.youtube.com/watch?v=MdSMSbQxnO0 and Benn Stancil here https://benn.substack.com/p/metrics-layer). It strikes me as conceptually similar to what #OBIEE did in its logical layer with measures. Admittedly it was almost always exposed through the tool’s front end itself, but there was an ODBC and JDBC (https://rmoff.

Continue Reading

See talks

Continue Reading

You can find all my recent talks on Notist at https://talks.rmoff.net/. Older ones are on Speaker Deck. I have a variety of talks, around several different aspects of Apache Kafka and related technologies. Kafka 101 / introductory talk : “Kafka as a Platform: the Ecosystem from the Ground Up” Introduction to ksqlDB and stream processing principles and semantics - with lots of live demos. “An introduction to ksqlDB” Live demo showing use of Kafka Connect and ksqlDB: “Apache Kafka in Action : Let’s Build a Streaming Data Pipeline!

Continue Reading