Investigate Reports

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
prasad v
Participant
Posts: 174
Joined: Mon Mar 30, 2009 2:18 am

Investigate Reports

Post by prasad v »

Hi,

I am new to QualityStage, So i just started learning by using the IBM QualityStage Tutorial and dsx with the given csv file.

I ran Investigate job which does investigation on Name, Geographical details (City, Stage, Zip, etc.). Job has run successfully and it has created 3 csv reports.

So I want to see the same in IIS reports. I tried creating a report in IIS and ran but it is not outputting any data.

It just says Error! No data available or invalid data collection parameter.

Can some one advise how to see the reports?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Let's start by getting you in the actual QualityStage forum, hold on a sec... there you go.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Which particular report did you try to create, of the templates that are provided? Did you actually run the report?

To be honest, and without checking, I'm not sure that Investigation outputs are available through the reports mechanism. Look at the available report templates to verify this (certainly what I said is true in version 8.5).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
leandrohmvieira
Participant
Posts: 44
Joined: Wed Sep 02, 2015 7:19 am
Location: Brasilia, Brazil

Post by leandrohmvieira »

Im just having the same problem now, can someone help me? :cry:

Further information, i designed a job like this:


Oracle Connector------->Investigate------->Sequential file

Writing into a txt file.
write mode set to overwrite.
Write method set to specific files
clean on fail true
column names true(as mentioned here https://www.ibm.com/developerworks/comm ... 0013974225)
reject mode continue
comma delimmiter
double quotes
Doing a discrete investigate.

SQA reports are working fine...


Here a sample of my file:

"qsInvColumnName","qsInvPattern","qsInvSample","qsInvCount","qsInvPercent"
"CPF","nnnnnnnnnnn","00006713041","7,59500000000000000E+03","1,0000000E+02"
"TELEFONE_CELULAR","n","0","5,97000000000000000E+02","7,8604345E+00"
"TELEFONE_CELULAR","nnnn","8142","1,00000000000000000E+00","1,3166557E-02"
"TELEFONE_CELULAR","nnnnnnn","3847487","1,00000000000000000E+00","1,3166557E-02"
"TELEFONE_CELULAR","nnnnnnnn","11942022","6,99600000000000000E+03","9,2113235E+01"

but when i execute the report i got the same "invalid data collection parameter"
Leandro Vieira

Data Expert - Brasilia, Brazil
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Ola Leandro,

Does the following help? https://www-01.ibm.com/support/docview. ... wg21406042
Regards,
Robert
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Hmmm. How about locale? What is the locale of the machine? I see , instead of . as a decimal separator. I wonder if the locale is causing the issue? It shouldn't if everything is set correctly.
Regards,
Robert
leandrohmvieira
Participant
Posts: 44
Joined: Wed Sep 02, 2015 7:19 am
Location: Brasilia, Brazil

Post by leandrohmvieira »

Thank you very much rjdickson, it was a locale problem, we are using PT_BR NLS, so decimal separators are comma separated, i changed the file separators mannualy and the report worked just fine.

But this opens another question, there is a way to change IIS NLS Settings?So i dont need to change every file and because im also having problems on doing any operation on my Information Analyzer project, and i think this is for the same reason, our database runs on PT-BR NLS too, and all analysis(columns, keys, etc) output as error.

But anyway thanks again for the help. :D
Leandro Vieira

Data Expert - Brasilia, Brazil
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You should be able to change NLS default settings system-wide using the DataStage and QualityStage Administrator client, selecting the NLS button on the General page.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
leandrohmvieira
Participant
Posts: 44
Joined: Wed Sep 02, 2015 7:19 am
Location: Brasilia, Brazil

Post by leandrohmvieira »

NLS configurations in Administrator client match our locale.

Should i open another thread do discuss this matter? Since is about another problem related to IIS console Information Analyzer project?
Leandro Vieira

Data Expert - Brasilia, Brazil
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

At this point, it's probably best to open a PMR...
Regards,
Robert
frolen
Participant
Posts: 7
Joined: Sat Feb 22, 2020 12:03 pm

Post by frolen »

Let's start by getting you in the actual QualityStage forum, hold on a sec... there you go.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:?

Four years later, copied text from my post... why does this seem like a prelude to spam?
-craig

"You can never have too many knives" -- Logan Nine Fingers
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

frolen - rather than shotgun multiple conversations here with fragments, you'd be much better off if you start a new post - your own post - and let us know what's going on, detail your issues / questions. Thanks.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply