DSXchange

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?

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

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).

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

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"

Ola Leandro,

Does the following help? https://www-01.ibm.com/support/docview. ... wg21406042

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.

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

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.

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?

At this point, it's probably best to open a PMR...

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

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

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.