I was creating a report schedule for the user. The user provided text to add to the email body of the scheduled report. After pasting the text and clicking OK, it resulted in Error PRS-TRS-0906 The “VALIDATE” transform instruction could not validate the given XML content”
The issue was caused by copy/paste of text from the users email. This text was copied from the users email and seems to contain attributes that cognos can’t handle.
Paste the users text to notepad and copied from notepad to the body of the email. Then switched the setting to “Change to HTML format”.
The requested styling could be provided now such as bold and underlined.
Similar solution was descibed on Cognoise.com:
A customer has a report with some areas that need more explanation about the data or graphic. This is possible to just simple add a text item to the report with some text, but then there is a problem that it is always visible.
With this code it is possible to place the text in a popup window. If they click on the header name, defined in the script, a popup window will show. Click again on the header name to make it invisible again.
How to use:
This error occurred while running a report.
The IBM site says:
While running the report, Cognos 8 server will temporarily store all data sets in the Cognos8_install_directory/temp directory. If the disk is out of the space, the error message will be generated.
Assign more disk space on the Cognos 8 server machine.
The other solution is to search in the cognos log files what query is running for the report and look if there are full outer joins in the query.
Perhaps a solution is to make an other selection for the report to avoid the full outer joins.
When you are working in report studio and you want to test a report, the windows that opens has a small size. You have to click on the top of the screen (maximize) to get a full size window. Continue reading