Topic
  • 4 replies
  • Latest Post - ‏2013-01-16T16:21:46Z by SystemAdmin
SystemAdmin
SystemAdmin
294 Posts

Pinned topic "NO Output Table Available " ?

‏2013-01-16T14:04:57Z |
I created a simple data rule but when I wanted to view the test result it didn't show any result ,and it said
"NO Output Table Available (Either the table was deleted or the rule was configured for statistics only)"
Updated on 2013-01-16T16:21:46Z at 2013-01-16T16:21:46Z by SystemAdmin
  • smithha
    smithha
    162 Posts

    Re: "NO Output Table Available " ?

    ‏2013-01-16T14:25:09Z  
    First, if you open your Data Rule, what do you have the output configured to? (e.g. Statistics only will not produce any detail)
    Second, when you open the Results, what do the statistics show? (If all records passed, unless you chose to include all records or those that met the rule, no detail table would be produced.)
    Third, I'm presuming that your project's configuration for the Analysis Database is correct so that the table can be written out successfully, but if the first two indicate you should expect detail, then you may want to verify the database settings.

    Harald
  • SystemAdmin
    SystemAdmin
    294 Posts

    Re: "NO Output Table Available " ?

    ‏2013-01-16T14:40:58Z  
    • smithha
    • ‏2013-01-16T14:25:09Z
    First, if you open your Data Rule, what do you have the output configured to? (e.g. Statistics only will not produce any detail)
    Second, when you open the Results, what do the statistics show? (If all records passed, unless you chose to include all records or those that met the rule, no detail table would be produced.)
    Third, I'm presuming that your project's configuration for the Analysis Database is correct so that the table can be written out successfully, but if the first two indicate you should expect detail, then you may want to verify the database settings.

    Harald
    Thanks Harald for your answer.
    Its not set for Statistics only, It is for those that met the condition rule..
    It was working just fine, but now all the rules that I created in the past has the same problem "NO Output Table Available ..... "
  • smithha
    smithha
    162 Posts

    Re: "NO Output Table Available " ?

    ‏2013-01-16T14:47:13Z  
    Thanks Harald for your answer.
    Its not set for Statistics only, It is for those that met the condition rule..
    It was working just fine, but now all the rules that I created in the past has the same problem "NO Output Table Available ..... "
    That suggests an issue with the database. You may need to:
    • verify that the db password is still valid in the connection to the IADB
    • verify with your DBA that the detail tables (stored in the IADB) are still there and were not archived or deleted

    Harald
  • SystemAdmin
    SystemAdmin
    294 Posts

    Re: "NO Output Table Available " ?

    ‏2013-01-16T16:21:46Z  
    • smithha
    • ‏2013-01-16T14:47:13Z
    That suggests an issue with the database. You may need to:
    • verify that the db password is still valid in the connection to the IADB
    • verify with your DBA that the detail tables (stored in the IADB) are still there and were not archived or deleted

    Harald
    Thanks its working now, The DBA said It was a table space issue. He cleaned it up