nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Reporting

System

I am trying to define an approach for creating a reporting tool using event subsystem. I need some documentation about the tables maintained by Teamsite reporting tool (For which my client does not want a Licenese).

Am using TS 6.5 on Win 2000 Server.

Regards
dixit

Find more posts tagged with

Comments

mstradling

If your looking to build your reporting on top of the event subsystem, then for a start you don't want to be using the default storage (in-memory Db), you will want to be using a 'proper' RDBMS.

Having made that decission, finding out the tables is easy. In /eventsubsystem/conf/ddl you will find a set of create_.sql scripts that you use to set up the event subsystem storage tables on your Db. Take your pick from DB2, mySQL, Oracle or SQL Server.

Migrateduser

Yes i am planning to do this on top of the event subsystem!! I have identified Oracle 9i for this. I saw the DDL and could make out the tables. Thanx.
I have configured the event subsytem in iw.cfg.. as mentioned in admin guide but am not able to move further, the tables are not being created.

I have oracle classes12.0. copied into the iw-home\eventsubsystem\lib directory.

Thanks and Regards
dixit

mstradling

I do not believe the event subsystem creates the tables automatically - it's up to you to execure the create_.sql file (using something like SQL Plus, or Toad), prior to re-starting the event subsystem.

Migrateduser

Hi,

I created the tables. These tables are namely:

1) system_data
2) seeds
3) destinations
4) messages
5) message_handles
6) consumers
7) users

Now when i submit some file none of the tables are populated. And there is one error which gets written in the log file:

OpenJMS 0.7.6.1
The OpenJMS Group. (C) 1999-2004. All rights reserved.
http://openjms.sourceforge.net
org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at org.exolab.jms.persistence.RDBMSAdapter.getSchemaVersion(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.instance(Unknown Source)
at org.exolab.jms.server.JmsServer.registerServices(Unknown Source)
at org.exolab.jms.server.JmsServer.init(Unknown Source)
at org.exolab.jms.server.JmsServer.main(Unknown Source)
!!!!!

I have another query. When TS Reporting is installed and used there is another set of tables that is created. These are :

1) EventsSummary
2) WFEventsSummary
3) Files
4) FileVersions
5) WFTaskEventComments
6) ExtendedAttributes
7) VersionedFileEAs
8) DataCaptureTemplates

Is it possible to create and maintain these these tables without installaing the TS reporting. Someone who has done this kind of thing will be very helpful.

Thanks and regards
Amit Dixit

stefanmaier

Now when i submit some file none of the tables are populated. And there is one error which gets written in the log file:

OpenJMS 0.7.6.1
The OpenJMS Group. (C) 1999-2004. All rights reserved.
http://openjms.sourceforge.net
org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: java.sql.SQLException: ORA-00942: table or view does not exist

Also you said, that you configured event subsystem in iw.cfg...
Did you configure event subsystem in /iw-home/eventsubsystem/conf/jmsconfignew.xml, too.
Perhaps check the element DatabaseConfiguration there...

Stefan

mstradling

Is it possible to create and maintain [the tables created by Reporting] without installaing the TS reporting.

It should be, but you will have to creatre them your self and write your own trigger code to update them.

If you need all the reporting offerd by the Reporting module, you mught be better off just paying for it. If you have specific reporting requirements (say logging workflow), then you can create an external tasks between each workflow task that logs the WF parameters at that point.

Migrateduser

Also you said, that you configured event subsystem in iw.cfg...
Did you configure event subsystem in /iw-home/eventsubsystem/conf/jmsconfignew.xml, too.
Perhaps check the element DatabaseConfiguration there...

Stefan

Yes i did that, first i was trying to connect to a dB on another server, but later i installed oracle on the same server but there is some issue as the TNS listener port is clashing with some port of Temasite, i am not able to identify that. Can somebody help me on this. Or should i un install the oracle from my server(TS server)

Win 2000 sever ts 6.5

Thanks
Amit

port.zip

stefanmaier

If there's a port conflict on your machine,
there should be an error message in one of your logs.
Perhaps you check your TNS listener logs...

Which ports does your TNS listener use?
(I've something like 1521-1540 and 2481-2484 as default ports in my mind)

To see, if the ports are in use, do an "netstat -a"...

Migrateduser

It should be, but you will have to creatre them your self and write your own trigger code to update them.

Hi,

My client is not ready to purchase the license, can you give me little insight as to where i can write or attach the trigger code.. I went through the docs but couldn't get something substantial out! Ur help will be great.

Regards
Dixit

mstradling

Well for logging workflow tasks it's a matter of adding an external logging task between each step that just writes the data you need to capture to the Db via Perl.

For more general logging you can use the iwat CLT triggers. Basically for each even you want to log, say locking a file you can trigger a script which logs to the Db.

iwatlock.ipl logging_script.ipl

When a lock even takes place the logging_script.ipl is executed. The script has variables available to it for the event ("lock"), time, details of user running event (name/role) and the file asset being locked.

Migrateduser

Well for logging workflow tasks it's a matter of adding an external logging task between each step that just writes the data you need to capture to the Db via Perl.

For more general logging you can use the iwat CLT triggers. Basically for each even you want to log, say locking a file you can trigger a script which logs to the Db.

iwatlock.ipl logging_script.ipl

When a lock even takes place the logging_script.ipl is executed. The script has variables available to it for the event ("lock"), time, details of user running event (name/role) and the file asset being locked.

Thanks, This is a good lead.. Will build on this and come back with queries.

Regards
Dixit