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
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:
http://www.cognoise.com/index.php?topic=4329.0
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.
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.
Follw the next steps to turn on Auditing in Cognos Administration.
1. Open Cognos Configuration
2. Right-click on Logging and from the popup menu select New Resource->Destination.
3. Name the new resource Audit, and leave the type as Database, then click OK.
4. Right-click on the resource Audit, and from the popup menu select New Resource->Database.
5. Name the database resource, and change the type to, then click OK.
6. Select the database above, and enter the database details
7. Right-click on Audit, and from the popup menu select Test.
8. If the Audit database test is successful then click Close, else click Details and investigate the problem.
9. Now restart your cognos server.
1. Login to the Cognos Server with an Administrator Account
2. Select Administer Cognos Content
3. From the small menu on the left select System
4. From the Lower Right panel select Set Properties
5. Select the Category Logging, change all values to Basic, and select the boxes Audit the native query for batch report service and Audit the native query for report service
Steps found in an article on Toolbox.com, posted by Terry Curran
Also find more on the IBM website here
In the same article someone noted that there have been no changes in Cognos 10 regarding Auditing.