Question Re: ActivePortals Database in Product Lifecycle Management Q&A

ActivePortals Database

Former Member — Wed, 23 Jul 2008 02:46:08 GMT

I downloaded the ActiveMetrics Sample application for MII 12.0. I am unable to connect to the ActivePortals SQL db provided.

I see a message in the Log about having to add additional permissions in the SLD. I have Admin rights.

Has anyone faced a similar problem ?

Re: ActivePortals Database

Former Member — Wed, 23 Jul 2008 14:07:20 GMT

I am unable to connect to the ActivePortals SQL db provided.

I thought the only thing provided with the download was the script that you run against a database that you create and name it ActivePortal.

I cannnot comment from an SLD point of view but when you say unable to connect can you detail out -

1. Whether the data server ActivePortal is properly configured and running?

2.If yes then are you able to run any queries against it from MII?

Re: ActivePortals Database

Former Member — Wed, 23 Jul 2008 14:18:49 GMT

Hi,

Here are my Db settings. Please can you let me know if anything here needs to be corrected.

Connector IDBC

ConnectorID

ConnectorType SQL

DatePrefix '

DateSuffix '

DaysRetention 7

Description Active Portal Database

Enabled T

InitCommand

InternalDateFormat yyyy-MM-dd HH:mm:ss

JDBCDriver com.inet.tds.TdsDriver

MaxRetryCount 5

Name ActivePortal

PoolMax 100

PoolSize 1

RetryInterval 60000

ServerPackage com.sap.xmii.Illuminator.connectors.IDBC

ServerURL jdbc:inetdae:etcstucd403:1433?database=ActivePortal&SQL2005=true

Timeout 15

UseCount 256

UserName xmii

ValidationQuery SELECT GETDATE()

WaitTime 30

Re: ActivePortals Database

Former Member — Wed, 23 Jul 2008 14:25:08 GMT

Looks good except for the JDBC driver.

This is SQL 2005 right? And you must've uploaded sqljdbc.jar as the JDBC driver.

You probably need to do a search here in the forums for the correct JDBC driver configuration value.

Meanwhile if I find it I'll post it.

Re: ActivePortals Database

Former Member — Wed, 23 Jul 2008 14:30:36 GMT

I have uploaded the SQLJdbc.jar

Re: ActivePortals Database

Former Member — Wed, 23 Jul 2008 14:38:40 GMT

Use

com.microsoft.sqlserver.jdbc.SQLServerDriver

instead of

com.inet.tds.TdsDriver

for the JDBC Driver parameter value

I am sure this'll fix it.

Re: ActivePortals Database

Former Member — Wed, 23 Jul 2008 16:48:13 GMT

JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver

ServerURL jdbc:inetdae:etcstucd403:1433?database=ActivePortal&SQL2005=true

it still does not seem to be wrking ...

I tried changing the ServerURL to be sqlserver instead of inetdae, as well

Re: ActivePortals Database

Former Member — Wed, 23 Jul 2008 17:37:28 GMT

Check in the Netweaver Logs for errors referring to this dataserver.

Also verify---

1. Authentication

2. Does your SQL server allowing TCP/IP requests on port 1433 or is it a different port?You DBA guy can help you with this.

Also for the ServerURL jdbc:inetdae:etcstucd403:1433?database=ActivePortal&SQL2005=true

instead try a

jdbc:inetdae:etcstucd403:1433?database=ActivePortal&sql7=true

Re: ActivePortals Database

Former Member — Mon, 21 Mar 2011 17:21:15 GMT

thanks