For a Query Object in the framework, I added some columns in the database table. When I edit the Query Object in Framework Manager the new column does not show up. Although the SQL I used is “select * from table”. Also validating the object did not work.
In the Project Viewer click once on the object. From the toolbar choose “Tools” > “Update Object”. Framework Manager will start verifying the object with the database. As a result the new column will be added to the Query Object.
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:
At one of my customers I recently got involved in Cognos 10.2.2
During test work it was noticed that the Search & Select Prompt behaves different.
When you are developing a report and run it to test, value are stored from filters or the source connection. This is done so you won’t have to fill them in every time you test.
Sometimes you want to select a different source. For example first you test on DEV connection and now you want to test with QA connection.
To achieve this you want to clear the reports cached values. This can be done in Report Studio by selecting File > Clear Parameter Values
Got some schedules in my Cognos environment who failed with the message:
CNC-SDS-0413 There was a problem in executing the task. The user authentication failed. It may not be possible to rerun the task.
To solve this I followed the next steps:
1. Renew the credentials (see how on this article)
2. Go to System Administration
3. Click on Schedules
4. Find the schedule with the error in the list
5. Click on the small blue triangle
6. Choose modify the schedule
7. Change nothing
8. Click OK to save the schedule
After that you can check the schedule on the next upcomming event.