StorageScope 6.0 Oddity

To caveat this even further, every selection for output except for Screen>>HTML results in the alert "Error was encountered running the query"

Message was edited by:
VerizonEd

Hi VerizonEd,

Can you check the following Knowledgebase articles to see if they are applicable or not:

- emc169823
- emc183871

It's also possible that you are running out of temp space. This can be verified by checking the ECC\Repository\admin\emcstsdb\bdump\alert_emcstsdb.log for failed tablespace extent allocation errors. If that is the case, then you need to simplify the query.


Regards,
Séamus Coffey
EMC Global Services

Seamus;

I looked at the 2 Primus cases to no avail, and the temp space is fine, no alerts. The oddest thing about this is, if I use the exact same SQL queries and select Screen>>HTML it works like a charm. Its only when you select File >>>'and any format'. I need to look at my infrastructure since it now does it in 2 different instances in 2 different Data Centers. I feel this might be the cusp of the issue.

Thanks

I found the issue, seems like the user had one field in the SQL for "BLANK" ..seems like the functionality on the file>>>csv does not like that now. I removed that column and the query runs fine.