ISALite - Getting validation Failed

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
anajitKS
Premium Member
Premium Member
Posts: 28
Joined: Thu Dec 18, 2014 7:57 pm
Location: Kansas City

ISALite - Getting validation Failed

Post by anajitKS »

We are in the process of installing Infosphere 11.5. As a first step we ran
ISALite. It produced PrereqChecker-Failures.html. This document has the following messages with "Failed" Status:

Code: Select all

Ensure that user xmeta can connect to the database xmeta on host infosphere02v at port number 50000 and has create table, create view, create function, create procedure, create index, and create trigger rights where they apply. 
Resolution: Ensure that user xmeta can connect to database xmeta on host infosphere02v at port number 50000 and has create table, create view, create function, create procedure, create index, and create trigger rights where they apply.

Ensure that user dsodb can connect to the database dsodb on host infosphere02v at port number 50000 and has create table, create view, create function, create procedure, create index, and create trigger rights where they apply. 
Resolution: Ensure that user dsodb can connect to database dsodb on host infosphere02v at port number 50000 and has create table, create view, create function, create procedure, create index, and create trigger rights where they apply.

Ensure that user iauser can connect to the database iadb on host infosphere02v at port number 50000 and has create table, create view, create function, create procedure, create index, and create trigger rights where they apply. 
Resolution: Ensure that user iauser can connect to database iadb on host infosphere02v at port number 50000 and has create table, create view, create function, create procedure, create index, and create trigger rights where they apply.
As we are planning to use SQL Server for all thses databases, we selected the option to skip this validation. But we are still getting these messages.
What do we need to do, so that these messages are not included in the report ?
ABHIJIT DUTTA
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Did you run all the scripts to set up SQL Server repository, in particular the one that includes the GRANT statements?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply