cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1294
Views
0
Helpful
2
Replies

Problems with Collection Manager SCE8000

Hello,

I have a problem, I can generate reports with SCA Reporter, because I get the following error (image attached):

I try to run the following script, but I can not:

[CM-MSO1 scmscm @ bin] $. / jselect-sce-tz.sh - offset =- 300

DURING THE FOLLOWING problem Occurred DB operation:

CONF_SE_TZ_OFFSET not found. Specify or use sp_help owner.objectname to check whether the object exists (sp_help May produce lots of output).

[scmscm@CM-MSO1 bin]$

[scmscm@CM-MSO1 bin]$ ./jselect-sce-tz.sh --status    
The following problem occured during DB operation:
CONF_SE_TZ_OFFSET not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

[scmscm@CM-MSO1 bin]$

I would appreciate if someone could help me.

regards,

Juan

2 Replies 2

usujlana
Cisco Employee
Cisco Employee

This is a BUG that is supposed to be fixed in 3.7.0 BUG is

CSCse06676 . i would suggest opening a TAC case to track and find a workaround.

usujlana
Cisco Employee
Cisco Employee

Also do you even see all the tables in  the

-bash-3.00$ ./dbtables.sh -a output ? if not then did you even try to reinstall the DB again ?

-bash-3.00$ ./dbtables.sh -a  

Executing query ...

                    name|               num_lines|                min_time|                max_time|

------------------------+------------------------+------------------------+------------------------+

                 RPT_SUR|                       0|                    null|                    null|

                 RPT_LUR|                    3537|  2010-03-18 12:22:44.18| 2010-03-23 16:06:11.336|

                RPT_VLUR|                       0|                    null|                    null|

                 RPT_PUR|                    3501|  2010-03-18 12:22:44.18| 2010-03-23 16:06:16.366|

                  RPT_TR|                    6480| 2010-03-21 14:01:55.006| 2010-03-23 16:09:44.233|

               RPT_MALUR|                       0|                    null|                    null|

               RPT_MEDIA|                       0|                    null|                    null|

                 RPT_GUR|                       0|                    null|                    null|

        RPT_TOPS_PERIOD0|                    4785| 2010-03-17 16:00:00.003|  2010-03-23 16:00:00.26|

        RPT_TOPS_PERIOD1|                     198| 2010-03-18 00:00:00.016| 2010-03-23 00:00:00.233|

_TOPS_PERIOD0_CUMULATIVE|                       0|                    null|                    null|

_TOPS_PERIOD1_CUMULATIVE|                       0|                    null|                    null|

              RPT_UVLINK|                       0|                    null|                    null|

              RPT_DVLINK|                       0|                    null|                    null|

    RPT_TOP_HTTP_DOMAINS|                       0|                    null|                    null|

      RPT_TOP_HTTP_HOSTS|                       0|                    null|                    null|

   RPT_TOP_VIDEO_DOMAINS|                       0|                    null|                    null|

     RPT_TOP_VIDEO_HOSTS|                       0|                    null|                    null|

       CONF_SE_TZ_OFFSET|                       1| 2010-03-17 15:33:12.826| 2010-03-17 15:33:12.826|

              INI_VALUES|                    3388|                        |