Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

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
Cisco Employee

Problems with Collection Manager SCE8000

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.

Cisco Employee

Problems with Collection Manager SCE8000

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|                        |                   

680
Views
0
Helpful
2
Replies
CreatePlease login to create content