Pinned topic Couldn't generate reports
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
I'm using version 8.0. I created a QS job: source file -> copy -> investigat -> target file. It's compiled and ran with no problem. I can even use the View Data on the target file to view the result. When I tried to creat a report through the information server web console and ran it. I got message like this: "Error! No data available or invalid data collection parameter". Can someone please shed some lights on this? What could go wrong? I followed the IBM's manually closely when created the report in web console. I suspected it has something to do with some sort of set-ups...
Updated on 2008-07-07T12:23:00Z at 2008-07-07T12:23:00Z by SystemAdmin
Ray.Wurlod 12000063JK18 Posts
Re: Couldn't generate reports2008-06-06T02:56:29ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
Re: Couldn't generate reports2008-07-07T12:23:00ZThis is the accepted answer. This is the accepted answer.Hopefully this will help.
Users have to follow the following steps in order to generate the reports:
1) Within the Target Seq File Stage of your job, the "First Line is Column Names" property must be set to "True".
2) For Column frequency report and Frequency pattern report, there must be 5 columns and their names must be:
qsInvColumnName, qsInvPattern, qsInvSample, qsInvCount, qsInvPercent
3) For Frequency word report, there must be 3 columns and their names must be:
qsInvCount, qsInvWord, qsInvClassCode
4) Within the Target Seq File Stage of your job, Under Format -> Field defaults, "Delimter" field must be set to "comma", and "Quote" field must be set to "double".
Please let me know if this doesn't help.