Prob in Metric\Alert Services

[Former Member]

Hi friends,

I have some problem in using Metric\Alert Services.when i am using datasets -> AddNew button it is showing some error message like " unable to add dataset , Server is currently Diasabled (activateportal) . I don't know where i have to activate. Please guide me.

Vijaya

[Former Member]

Hi Vijaya,

In xMII, to stroe the metrics and alerts information it needs a database. First you need to create a database named Active Portal and for that database you can get the Tables and fields info from C:/Lighthammer/Illuminator/Active Portal folder. There you can find the SQL script for the tables generation for ORACLE and MSSQL databases. Copy and RUN the script in the query analyzer, then your database is ready. After that you have to make connection between the xMII server and Active Portal database. For that you need to go and chnage the database details for the Active portal connector.

Thanks,

Rajesh.

[Former Member]

Sushma ,

Also for quality portal scripts are there for SQL and oracle. You can also run these scripts to rum u r quality portal.

Thanx & Regards

Vinod

[Former Member]

Hi Friends,

When I am using Metric/Alert Services-- > Categories, I am getting an error saying:

Unable to add Category A SQL Error has occured on query, OR-00942: table or view does not exist

AS given in the help, I’ve created ActivePortal & QualityPortal

<InstallationDrive>:\Illuminator\ActivePortal\ directory\CreateActivePortalTables_ORACLE.sql.

<InstallationDrive>:\Illuminator\QualityPortal\CreateQualityPortalTables_ORACLE.sql

Still I am getting an Error; please tell me where the problem is.

Thanks & Regards

Vijaya

[Former Member]

Hi Rekha,

After creation of Active portal database. Make a connection between the database and xMII server in Data Servers tab. There ActiveProtal type connector is already avilable. Just edit the information of the server connection.

Thanks,

Rajesh.

[Former Member]

Hi Rajesh,

I edited and enabled that ActivePortal in DataServer.

Regards

Vijaya

[Former Member]

Hi Rekha,

You said that you connected, but you didnt mention whether it is working fine or not.

Thanks,

Rajesh.

[Former Member]

Hi Rajesh,

In Dataservers --> Status of ActivePortal -->Connections Available

is showing 1

I thought that it is working fine

When I am creating Metrics-->Categories

It is showing error.

Please Give proper answer for this.

Regards

Vijaya

[Former Member]

Hi Rekha,

You need to have SQL server installed on your xMII machine.The active portal feature is not going to work when SQL server is not there on your xMII server.

Thanx & Regards

Vinod

[Former Member]

Hi Vinod,

I think we can use Oracle insteadof sqlserver.we installed xMII server in oracle server machine.

Regards

Vijaya

[Former Member]

Hi Ryan,

Can u pls. tell tell me where can i find the "QualityPortal" server in xMII??

Regards,

Sushma.

[Former Member]

You'll need to enable the "ActivePortal" Data Server to use Active Portal (Metric/Alert Services). Refer to this in the help docs:

http://<<severname>>/LighthammerCMS/Help/Advanced_Topics/optional_application_configuration

[Former Member]

Hi,

that page can not be displayed when i open the above mentioned link.

Vijaya

[Former Member]

Try this:

http://<servername>/LighthammerCMS/Help/Advanced_Topics/optional_application_configuration.htm#Activ...

And if that doesn't work, open the help docs and Navigate to:

Advanced Topics --> Initialization of Additional Applications --> ActivePortal Configuration for SQLServer.