iWD datamart issue

[bandorka]

Hi,

The environment:
OS: Redhat Linux Enterprise 64 bit (vmware) 5.9
Tomcat: 6.0.20
Java: 1.6.0.43
GRAT, GRE: 8.1.200.17
iWD DM: 8.1.100.11
DB: Oracle 10g RAC

The issue:
iwd_dm_oracle.sql successfully executed, whereas the last create command is:
create table gtl_stat (
id integer not null,
tenantId varchar2(64),
solutionId varchar2(64),
statServiceId varchar2(64),
dimensionType varchar2(64),
dimensionId varchar2(64),
measureId varchar2(64),
measureValue integer,
primary key (id)
)

I see in the stat server log, that the StatAdapter working:
---------------------------------------------------------------------------------------------
StatServer log:
2013-06-05 10:37:05> Java: \BPR_iWD_Extension>  'Timer-0'  DataUpdateTimerTask::run: executing SQL request: select statServiceId,dimensionId,measureId,measureValue from gtl_stat where statServiceId='STAT_1'
2013-06-05 10:37:05> Java: \BPR_iWD_Extension>  'Timer-0'  DataUpdateTimerTask::run: begin data update
2013-06-05 10:37:05> Java: \BPR_iWD_Extension>  'Timer-0'  DataUpdateTimerTask::run: end data update, total records processed: 0
10:38:02.581 Std 10060 Current load: clients: 0, stats: 0, requests: 0
2013-06-05 10:38:02> Mngmnt: profile( 0 client(s), 0 stat(s) opened, 0 stat(s) reported )
2013-06-05 10:38:02> Mngmnt: jvm_heap ( total=  2.36MB free=  0.57MB )
10:40:02.583 Std 10060 Current load: clients: 0, stats: 0, requests: 0
2013-06-05 10:40:02> Mngmnt: profile( 0 client(s), 0 stat(s) opened, 0 stat(s) reported )
2013-06-05 10:40:02> Mngmnt: jvm_heap ( total=  2.36MB free=  0.57MB )
10:42:02.584 Std 10060 Current load: clients: 0, stats: 0, requests: 0
2013-06-05 10:42:02> Mngmnt: profile( 0 client(s), 0 stat(s) opened, 0 stat(s) reported )
2013-06-05 10:42:02> Mngmnt: jvm_heap ( total=  2.36MB free=  0.57MB )
10:44:02.585 Std 10060 Current load: clients: 0, stats: 0, requests: 0
2013-06-05 10:44:02> Mngmnt: profile( 0 client(s), 0 stat(s) opened, 0 stat(s) reported )
2013-06-05 10:44:02> Mngmnt: jvm_heap ( total=  2.36MB free=  0.57MB )
10:46:02.586 Std 10060 Current load: clients: 0, stats: 0, requests: 0
2013-06-05 10:46:02> Mngmnt: profile( 0 client(s), 0 stat(s) opened, 0 stat(s) reported )
2013-06-05 10:46:02> Mngmnt: jvm_heap ( total=  2.36MB free=  0.57MB )
10:48:02.587 Std 10060 Current load: clients: 0, stats: 0, requests: 0
2013-06-05 10:48:02> Mngmnt: profile( 0 client(s), 0 stat(s) opened, 0 stat(s) reported )
2013-06-05 10:48:02> Mngmnt: jvm_heap ( total=  2.36MB free=  0.57MB )
10:50:02.589 Std 10060 Current load: clients: 0, stats: 0, requests: 0
2013-06-05 10:50:02> Mngmnt: profile( 0 client(s), 0 stat(s) opened, 0 stat(s) reported )
2013-06-05 10:50:02> Mngmnt: jvm_heap ( total=  2.36MB free=  0.57MB )
10:52:02.590 Std 10060 Current load: clients: 0, stats: 0, requests: 0
2013-06-05 10:52:02> Mngmnt: profile( 0 client(s), 0 stat(s) opened, 0 stat(s) reported )
2013-06-05 10:52:02> Mngmnt: jvm_heap ( total=  2.36MB free=  0.57MB )
2013-06-05 10:52:05> Java: \BPR_iWD_Extension>  'Timer-0'  DataUpdateTimerTask::run: executing SQL request: select statServiceId,dimensionId,measureId,measureValue from gtl_stat where statServiceId='STAT_1'
2013-06-05 10:52:05> Java: \BPR_iWD_Extension>  'Timer-0'  DataUpdateTimerTask::run: begin data update
2013-06-05 10:52:05> Java: \BPR_iWD_Extension>  'Timer-0'  DataUpdateTimerTask::run: end data update, total records processed: 0

---------------------------------------------------------------------------------------------

Database service started successfully from iwd_manager, so the db connection is ok

But when I want to start the iWD ETL service, the following error messgae can be seen in the log:
---------------------------------------------------------------------------------------------
05/06/13 10:55:55,548|http-18080-1|INFO|evo.service.manager.ServiceManagerImpl|#21489|stopService(SLT1,DB_1): name=Datamart Database
05/06/13 10:56:03,596|http-18080-1|INFO|evo.service.manager.ServiceManagerImpl|#21483|startService(SLT1,DB_1): name=Datamart Database
05/06/13 10:56:25,337|http-18080-1|INFO|evo.service.manager.ServiceManagerImpl|#21483|startService(SLT1,ETL_1): name=Datamart ETL Service
05/06/13 10:56:25,698|http-18080-1|ERROR|evo.database.DatabaseImpl|#21603|Datamart Database|SLT1-DB_1|evo/gtl/stat/ext: evo/gtl/stat/ext upgrade required (available: 1)
05/06/13 10:56:25,755|http-18080-1|INFO|evo.database.DatabaseImpl|#21659|Executing migrations for evo/gtl/stat/ext
05/06/13 10:56:25,757|http-18080-1|INFO|dbup|#21593|Migrating evo/gtl/stat/ext to version 0001
05/06/13 10:56:25,763|http-18080-1|ERROR|dbup|#21594|SQL error: ORA-00955: name is already used by an existing object

SQL:
create table gtl_stat (
id integer not null,
tenantId varchar2(64),
solutionId varchar2(64),
statServiceId varchar2(64),
dimensionType varchar2(64),
dimensionId varchar2(64),
measureId varchar2(64),
measureValue integer,
primary key (id)
)

05/06/13 10:56:25,764|http-18080-1|ERROR|evo.database.DatabaseImpl|#21660|Datamart Database|SLT1-DB_1|evo/gtl/stat/ext: Error synchronizing database:
---------------------------------------------------------------------------------------------

Any idea?
Thaks for the help,

Bandorka

[Flávio]

Hi,

a few things come in my mind.....

1 - as the DBA to check your database space and your log database space to see if there is something consuming too much space.
2 - see if you have any other ORA errors in the log and send to us.
3 - what is the version of your IWD?

Cheers,

[bandorka]

Hi Flavio,

Thanks for the answer. Unfortunately I forgot that I opened this topic, because there was no response for a long time.
But in the meantime I resolved this issue.
When you start your DM service at the first time the tables automatically created. But before to do this, I created the tables manually with an sql script. And that was the problem.
So this issue was resolved, and thanks again for your effort

Cheers,
Bandorka