New Columns Not Showing Up in Framework

Problem:

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.

Solution:

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.

 

 

Email this to someoneShare on FacebookShare on LinkedInTweet about this on TwitterShare on Google+Pin on Pinterest

PRS-TRS-0906 after copy paste text

Issue PRS-TRS-0906

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”

Cause

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.

Solution

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

 

 

Email this to someoneShare on FacebookShare on LinkedInTweet about this on TwitterShare on Google+Pin on Pinterest

Clear Parameter Values

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

Email this to someoneShare on FacebookShare on LinkedInTweet about this on TwitterShare on Google+Pin on Pinterest

CNC-SDS-0413

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.

 

 

Email this to someoneShare on FacebookShare on LinkedInTweet about this on TwitterShare on Google+Pin on Pinterest