Problem with adding vCentre to chargeback

[Michal_Lukowicz]

Hi

I am having exactly the same issue as:

http://communities.vmware.com/thread/236730

The problem is that when i am trying to recreate DB (i am using Oracle 11g):

SQL> create view VPXV_HIST_STAT_DAILY as
  2       select st.SAMPLE_TIME, st.SAMPLE_INTERVAL, sd.NAME as STAT_NAME,
  3       sd.GROUP_NAME as STAT_GROUP,
  4       case sd.ROLLUP_TYPE
  5       when 0 then 'average'
  6       when 1 then 'maximum'
  7       when 2 then 'minimum'
  8       when 3 then 'latest'
  9       when 4 then 'summation'
10       when 5 then 'none'
11       end as STAT_ROLLUP_TYPE,
12       si.MOID AS ENTITY,
13       d.DEVICE_NAME, hs.STAT_VAL as STAT_VALUE
14       from VPX_SAMPLE_TIME1 st
15       , VPX_DEVICE d
16       , VPX_STAT_COUNTER sc
17       , VPX_STAT_DEF sd
18       , VPX_HIST_STAT1 hs
19       , VPX_STAT_ID si
20       where hs.counter_id=sc.COUNTER_ID
21       and sc.STAT_ID = sd.ID
22       and isnull(sc.DEVICE_ID,1)=isnull(d.DEVICE_ID,1)
23       and hs.TIME_ID = st.TIME_ID
24       and sc.ENTITY_ID=si.ID;
     , VPX_STAT_ID si
       *
ERROR at line 19:
ORA-00942: table or view does not exist

Does anyone know what may be wrong here?

Michał

[HemanthPannem · Accepted solution]

Hi Michał,

These views need to be created on vCenter DB not in the Chargeback DB as mentioned in the http://communities.vmware.com/message/1390029#1390029.

If the Views are already existing in vCenter DB, please check out the permissions to access the vCenter DB.

If the problem still persists, could you please attach the logs of Chargeback?

Regards,

Hemanth

[Michal_Lukowicz]

[quote]

please check out the permissions to access the vCenter DB.

[/quote]

This is it!

Thanks.

Michał