OD Reporting database not getting updated

Our environment :
TeamSite 6.1. SP1.
OD 5.6 SP1
OS : Solaris 8

We recently moved our OpenDeploy Reporting database from Hypersonic database to Oracle database.
Initial after moved the Reporting database , the Oracle database had some contents. After moving to Oracle database, the reporting database tables are not getting updated when any deployment is done. When we access the Reporting details through ODGUI only the initial contents are shown.

After executing every deployment, the log files show the following error:
ENG: 2005-04-15 02:43:18 EDT GMT-04:00 TEventReportingException: com.interwoven.report100.TPublisherNotFoundException

Below is the full OD source log file (src.ods_1Dupont_prod2_dev.compub_udel_1DuPont_images.intw01.to.appd11.log) content
-------------------------------------------------------------------------------------------------------------------
ENG: 2005-04-15 02:43:17 EDT GMT-04:00 Thread-734In MicroDeploy commit 10
ENG: 2005-04-15 02:43:17 EDT GMT-04:00 Thread-734In MicroDeploy commit 0
ENG: 2005-04-15 02:43:17 EDT GMT-04:00 Result after commit 0
ENG: 2005-04-15 02:43:17 EDT GMT-04:00 Thread-734 exiting awaiting-cleanup
ENG: 2005-04-15 02:43:17 EDT GMT-04:00 Thread-734 entering cleanup
LIB: 2005-04-15 02:43:17 Remote status: server-OK
LIB: 2005-04-15 02:43:17 [Fri Apr 15 02:43:17 2005] opendeploy 20050415.732.2 root COMPLETED /default/main/OneDupont/Assets/EDITION .ods_1Dupont_prod2_dev.compub_udel_1DuPont_images.appd11 intw01 appd11.lvs.dupont.com
LIB: 2005-04-15 02:43:17 [Fri Apr 15 02:43:17 2005] 20050415.732.2 STATS DEPLOYMENT /default/main/OneDupont/Assets/EDITION -- .ods_1Dupont_prod2_dev.compub_udel_1DuPont_images.appd11 OK
Directories deployed : 0 Files deployed : 0 Links deployed : 0
Directories failed : 0 Files failed : 0 Links failed : 0
Directories deleted : 0 Files deleted : 0 Links deleted : 0

LIB: 2005-04-15 02:43:17 File Content transferred: 0 bytes
ENG: 2005-04-15 02:43:17 EDT GMT-04:00 Thread-734 After CLEANUP, res=1
ENG: 2005-04-15 02:43:17 EDT GMT-04:00 Thread-734 exiting cleanup
ENG: 2005-04-15 02:43:17 EDT GMT-04:00 Thread-734 entering task-done
ENG: 2005-04-15 02:43:17 EDT GMT-04:00 Thread-734 still waiting for 3
LIB: 2005-04-15 02:43:17 LOGFILE=[/export/apps/intrwvn/iw-home/opendeploy/OpenDeployNG/log/src.ods_1Dupont_prod2_dev.compub_udel_1DuPont_images.intw01.to.appd11.log]
LIB: 2005-04-15 02:43:17 Locale=[English_UnitedStates.US-ASCII@Binary]
ENG: 2005-04-15 02:43:17 EDT GMT-04:00 Thread-734 PostDisConnect Dnr still waiting for 0
ENG: 2005-04-15 02:43:17 EDT GMT-04:00 Thread-734 Deleting the internal config file = /export/apps/intrwvn/iw-home/opendeploy/OpenDeployNG/etc/.ods_1Dupont_prod2_dev.compub_udel_1DuPont_images.appd11
ENG: 2005-04-15 02:43:18 EDT GMT-04:00 TEventReportingException: com.interwoven.report100.TPublisherNotFoundException
ENG: 2005-04-15 02:43:18 EDT GMT-04:00 Thread-734 Job ID=m264 Deployment leg=appd11.compub_udel_1DuPont_images Elapsed Time=16496 ms <<<
ENG: 2005-04-15 02:43:18 EDT GMT-04:00 Thread-734 End logfile [/export/apps/intrwvn/iw-home/opendeploy/OpenDeployNG/log/src.ods_1Dupont_prod2_dev.compub_udel_1DuPont_images.intw01.to.appd11.log]
-------------------------------------------------------------------------------------------------------------------

Pleas help me on this.

Thank you
Nagappan

Find more posts tagged with

Comments

Migrateduser

The Oracle database needs to be initialized for OpenDeploy reporting and the OpenDeploy Admin Server has to be configured to write event data to the new database.

Specifics on initialization and configuration are provided in the OpenDeploy docs.

Todd Scallan
Director of Product Management
Interwoven
t: 408-530-7167
e: tscallan@interwoven.com

nagappan

Hi Todd,
Thanks for your reply.
The Oracle database is initialized by running the required sql scripts. The adminEventReportingConfig.xml file is set for the Oracle database.
We are able to access Reporting details through OD GUI (i.e. no I/O errors). When we access the Reporting details through OD GUI only the initial contents that where set when database was created are shown.
The reporting database tables are not getting updated when any deployment is done.

Regards,
Nagappan

Migrateduser

If tables aren't getting updated, and your database driver is set up properly with the Admin Server, then there may be a problem with the publish-subscribe connection.

Make sure your base server(s) and/or receiver(s) that are supposed to publish events have the feature enabled. Then make sure that the Admin Server is subscribing to those base server(s) and/or receiver(s) through the correct ports. (By default, the port values are set up for you.)

If you restart the base server(s) and/or receiver(s), restart the Admin Server as well to make sure the publish-subscribe connection gets established right away.

Todd Scallan
Director of Product Management
Interwoven
t: 408-530-7167
e: tscallan@interwoven.com