Search found 13 matches

by infodfs
Wed Aug 27, 2014 7:32 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Deployed data rules have lost data source connection
Replies: 1
Views: 4353

Deployed data rules have lost data source connection

Hi, I have deployed two projects from development to testing environment. All the data rules deployed in testing environment have lost data source connection. When I run the rules, they stopped right way, without showing in Infosphere Director. To resolve this issue, I have to drop the data source a...
by infodfs
Wed Jul 30, 2014 8:41 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: IAADMIN returns Error 401 when importing a project
Replies: 7
Views: 8779

Yes, it's intermittent. I could do Import/Export this early morning, but I got Error 401 afterward. I just heard that our InfoSphere development environment had logon issues on BG and MW tools. Could it be related because of the issue on BG/MW tools?
by infodfs
Tue Jul 29, 2014 6:56 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: IAADMIN returns Error 401 when importing a project
Replies: 7
Views: 8779

The IA version is 8.7 and command line is as below:
iaadmin -user XXXXXXX -password XXXXXXXXXXX -host [host.name] -port 9080 -xml -getProject -projectName [project_name] -output C:\IBM\InformationServer87\temp\[file_name.xml]
by infodfs
Fri Jul 25, 2014 7:31 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: IAADMIN returns Error 401 when importing a project
Replies: 7
Views: 8779

IAADMIN returns Error 401 when importing a project

When I'm importing a project back to IA DEV via IAADMIN, it returns Error 401, but no description with it. Could anyone tell me what the reason is to cause this error? I restarted my PC and also Ping the server with no problem. Thanks for help in advance.
by infodfs
Thu Jun 12, 2014 12:23 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to retrieve data from IA DB and load it into Cognos DB
Replies: 2
Views: 6582

How to retrieve data from IA DB and load it into Cognos DB

Hi,
I'm trying to run data rules in IA and then push the data into Reporting DB, so I can generate reports from Cognos. Is there anyone could tell me the scripts and how to make it happen? Thanks in advance for your help.
by infodfs
Tue Mar 04, 2014 3:00 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA 8.7 - ODBC Connector VS. Oracle Connector
Replies: 1
Views: 4079

IA 8.7 - ODBC Connector VS. Oracle Connector

I've a question about the connectors of ODBC and Oracle. Could anyone tell me which connector I should choose to have better performance in IA? What is the difference between ODBC Connector vs. Oracle Connector?
by infodfs
Tue Mar 04, 2014 2:41 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: No rows exist for the selected Rule Set
Replies: 1
Views: 3851

Thanks for the reply and you are right, there is no exception from the last output. One thing I learned is that if the data rule output fields are changed, it has to rerun the rule before getting any record in the standard report.
by infodfs
Thu Jan 30, 2014 7:05 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to use IA function: Count(field)
Replies: 4
Views: 6160

Sorry for unclear statement in my question. I want to use the rule to count total record of a column if the record's value equals 9999. Rule logic is as below. Source Data: Count(CUST_SCORE) Type of Check: = Reference Data: 9999 Here is the description of this function from IA User guide: count(colu...
by infodfs
Wed Jan 29, 2014 10:49 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to use IA function: Count(field)
Replies: 4
Views: 6160

How to use IA function: Count(field)

Hi, I create a data rule to count distinct value in a column (data type is NUMBER) as below COUNT(CUST_SCORE) = 9999 The Output Records was "Meet Rule Conditions". The result returns Not Meet 100%, but Oracle DB shows there are at least 6400 cust_score = 9999. I've also checked the not mee...
by infodfs
Tue Jan 21, 2014 7:29 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to retrieve the content of a complete project as an XML
Replies: 5
Views: 6140

Re: How to retrieve the content of a complete project as an

Thanks all for the helps. The URL of reference IBM article I went is at: http://www.ibm.com/developerworks/data/library/techarticle/dm-1010infoanalyzeruse/index.html?ca=dat Now I understand that I need use IAAdmin to retrieve the project. Should I use istool to run commands? If it is, should I use c...
by infodfs
Fri Jan 17, 2014 9:20 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to retrieve the content of a complete project as an XML
Replies: 5
Views: 6140

How to retrieve the content of a complete project as an XML

Hi, I'm end user and working on IA client. I'm trying to retrieve the content of a complete project as an XML file, so that I could change the project name in XML file and then importing the project with a different name back to IA. I tried using the URL: http://myserver:9080/InformationAnalyzer/pro...
by infodfs
Mon Dec 23, 2013 8:17 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Can't see complete Error message from ActivityStatus Summary
Replies: 2
Views: 4381

Re: Can't see complete Error message from ActivityStatus Sum

Thanks for reply. I was running a standard report from IA Reports, e.g. Column Profile - Post Review; because running standard report doesn't create a job in DataStage, so I can't see the job log in DataStage Director, and I can't see the complete error message from window either. I'm an end user, s...