Not able to refresh metrics

We have metrices that are already refreshed for the time period 1/1/2007 to 01/12/2008.

Now we are trying to refresh them for extended time up to 01/12/2009.

We are facing lot of problem while refeshing the metrics (all connection is proper , and repository connection is proper checked)

  • while refreshing some of the metrics, it not giving but not locking the time period(gray out time period)

  • some of throwing Oracle error like "ORA 00978", "ORA 00978" but the there no problem in universe level . object generating query sucessfully.

  • some time metrics refreshing successfully but data is not showing in analytics , (data is avilable in database)

  • some time giving invalid identifier for the "date column" but there is no problem in column name and data type.

Kindly suggest the resolution for these immediately. This is very important.