Yes, I have retrieved the same output, mutatis mutandis. So, something still doesn't work... Regards, Antun [root@grid root]# /opt/glite/bin/apel-publisher -f /opt/glite/etc/glite-apel- publisher/publisher-config-yaim.xml Tue Sep 6 18:18:53 UTC 2005: apel-publisher - Read-in configuration: [logenabled, j] [DBUsername=accounting, DBURL=jdbc:mysql://grid.phy.bg.ac.yu:3306/accounting, DBPassword=****, site=AEGIS01-PHY-SCL, republish=missing] Tue Sep 6 18:18:53 UTC 2005: apel-publisher - ------ Starting the apel application ------ Tue Sep 6 18:18:54 UTC 2005: apel-publisher - Optimising table: EventRecords Tue Sep 6 18:18:54 UTC 2005: apel-publisher - Optimising table: GkRecords Tue Sep 6 18:18:54 UTC 2005: apel-publisher - Optimising table: MessageRecords Tue Sep 6 18:18:54 UTC 2005: apel-publisher - Optimising table: SpecRecords Tue Sep 6 18:18:54 UTC 2005: apel-publisher - Optimising table: LcgRecords Tue Sep 6 18:18:54 UTC 2005: apel-publisher - **** Combining tables and republishing in LcgRecords **** Tue Sep 6 18:18:54 UTC 2005: apel-publisher - Checking valid CPU spec data exists Tue Sep 6 18:18:54 UTC 2005: apel-publisher - CPU spec values found Tue Sep 6 18:18:57 UTC 2005: apel-publisher - Finding records from: 2005-09- 01 01:11:05 Tue Sep 6 18:18:57 UTC 2005: apel-publisher - Record/s found: 799 Tue Sep 6 18:19:58 UTC 2005: apel-publisher - Unable to retrieve any response while querying the GOC Tue Sep 6 18:19:58 UTC 2005: apel-publisher - WARNING - Received a 'null' result set while querying the 'LcgRecords' table using rgma, this probably means the GOC is currently off-line, will therefore cancel attempt to re- publish Tue Sep 6 18:19:58 UTC 2005: apel-publisher - Completed data check Tue Sep 6 18:19:58 UTC 2005: apel-publisher - Building account records Tue Sep 6 18:19:58 UTC 2005: apel-publisher - Stitching together all accounting records Tue Sep 6 18:19:58 UTC 2005: apel-publisher - Stitching completed Tue Sep 6 18:19:58 UTC 2005: apel-publisher - Storing accounting data into local database Tue Sep 6 18:19:58 UTC 2005: apel-publisher - Build complete Tue Sep 6 18:19:58 UTC 2005: apel-publisher - Publishing data into rgma Tue Sep 6 18:19:59 UTC 2005: apel-publisher - Number of generated accounting records: 82 Tue Sep 6 18:19:59 UTC 2005: apel-publisher - **** Join processing complete **** Tue Sep 6 18:19:59 UTC 2005: apel-publisher - ------ Processing finished --- --- ----- E-mail: [log in to unmask] Web: http://scl.phy.bg.ac.yu/ Phone: +381 11 3160260, Ext. 152 Fax: +381 11 3162190 Scientific Computing Laboratory Institute of Physics, Belgrade Serbia and Montenegro ----- ---------- Original Message ----------- From: Valentin Vidic <[log in to unmask]> To: [log in to unmask] Sent: Tue, 6 Sep 2005 19:29:12 +0200 Subject: Re: [LCG-ROLLOUT] Accounting? > Here is some more info on the subject: > > [[log in to unmask] root]# env RGMA_HOME=/opt/glite > APEL_HOME=/opt/glite /opt/glite/bin/apel-publisher -f > /opt/glite/etc/glite-apel-publisher/publisher-config-yaim.xml > Tue Sep 6 17:25:56 UTC 2005: apel-publisher - Read-in > configuration: [logenabled, j] [DBUsername=accounting, > DBURL=jdbc:mysql://grid2.irb.hr:3306/accounting, > DBPassword=xxxxxxxxx, site=HR-01-RBI, republish=missing] > Tue Sep 6 17:25:56 UTC 2005: apel-publisher - ------ Starting the > apel application ------ > Tue Sep 6 17:25:56 UTC 2005: apel-publisher - Optimising table: EventRecords > > Tue Sep 6 17:25:56 UTC 2005: apel-publisher - Optimising table: GkRecords > > Tue Sep 6 17:25:56 UTC 2005: apel-publisher - Optimising table: MessageRecords > > Tue Sep 6 17:25:56 UTC 2005: apel-publisher - Optimising table: SpecRecords > > Tue Sep 6 17:25:56 UTC 2005: apel-publisher - Optimising table: LcgRecords > > Tue Sep 6 17:25:56 UTC 2005: apel-publisher - **** Combining tables > and republishing in LcgRecords **** > Tue Sep 6 17:25:56 UTC 2005: apel-publisher - Checking valid CPU > spec data exists > Tue Sep 6 17:25:56 UTC 2005: apel-publisher - CPU spec values found > Tue Sep 6 17:25:58 UTC 2005: apel-publisher - Finding records from: > 2005-08-28 01:11:02 > Tue Sep 6 17:25:59 UTC 2005: apel-publisher - Record/s found: 181 > Tue Sep 6 17:26:59 UTC 2005: apel-publisher - Unable to retrieve > any response while querying the GOC > Tue Sep 6 17:26:59 UTC 2005: apel-publisher - WARNING - Received a > 'null' result set while querying the 'LcgRecords' table using rgma, > this probably means the GOC is currently off-line, will therefore > cancel attempt to re-publish > Tue Sep 6 17:26:59 UTC 2005: apel-publisher - Completed data check > Tue Sep 6 17:26:59 UTC 2005: apel-publisher - Building account records > > Tue Sep 6 17:26:59 UTC 2005: apel-publisher - Stitching together > all accounting records > Tue Sep 6 17:26:59 UTC 2005: apel-publisher - Stitching completed > Tue Sep 6 17:26:59 UTC 2005: apel-publisher - No accounting data to > store > Tue Sep 6 17:27:00 UTC 2005: apel-publisher - Build complete > Tue Sep 6 17:27:00 UTC 2005: apel-publisher - Publishing data into rgma > > Tue Sep 6 17:27:00 UTC 2005: apel-publisher - Number of generated > accounting records: 0 > Tue Sep 6 17:27:00 UTC 2005: apel-publisher - **** Join processing > complete **** > Tue Sep 6 17:27:00 UTC 2005: apel-publisher - ------ Processing > finished ------ ------- End of Original Message -------