Reports with Master-Detail Relationship fail with Teradata 13

Reports with Master/Detail relationships failed after the Teradata was upgraded from version 12 to version 13. The reports fail with the following error.
 
Symptom
"An error occurred while performing operation 'sqlPrepareWithOptions' status='-239'. UDA-SQL-0460 A general exception has occurred during local
processing.UDA-EE-0036 The operator must be an expression, not "".
 

Resolving the problem
Backup and edit the original cognos/c8/bin/cogdmod_td.ini file and insert the following line at the bottom:
[DRIVER:TDATA32.DLL VERSION:13.00]
SQL_API_SQLDESCRIBEPARAM="FALSE"

Save and restart the cognos service(s)
If multi-server install, then add the above line to all Dispatcher Machines as well and restart.
Note: This is also true of Teradata 13.10. The Driver version number must specify 13.10.
Example:

[DRIVER:TDATA32.DLL VERSION:13.10]
SQL_API_SQLDESCRIBEPARAM="FALSE"

Comments

Post a Comment

Popular posts from this blog

Cognos 10 Active Report - Swipe Gesture

In order to create a user experience that takes advantage of standard touch interface interactions, the swiping gesture can be implemented on Decks or Data Decks. This functionality is complemented by the Iterator control, which can be configured to appear as page dots to indicate the current selection. The following high-level procedure can be followed to enable swiping and obtain the corresponding page indicator dot look and feel for the Iterator control: •    Ensure that the Iterator and the Deck are driven by the same values •    Create a variable to be used to control the selection •    Configure the Interactive Behaviour of both the Iterator and the Deck so that each control sets (Set Variable Values) and is selected by (Container Select) the same variable •    Enable the desired Slide Animation Direction effect on the Deck •    For the Iterator control, ensure that the Iterator First, Iterator Previous, ...
Read more

Cognos 8 Macro functions list

We have seen that cognos macro functions available in framework manager are also available in report studio. Here is a simple list of existing Cognos Macro with description. This list contains functions that can be used within a macro. A macro may contain one or more macro functions. A macro is delimited by a number sign (#) at the beginning and at the end. Everything between the number signs is treated as a macro expression, which is executed at run time. + value1 + value2 Concatenates two strings. Example: # '{' + $runLocale + '}'# Result: {en-us} CAMIDList CAMIDList ( [ separator_string ] ) Returns the pieces of the user's identity (account name, group names, role names) as a list of values separated by commas. Example: #CAMIDList ( )# Result: CAMID("::Everyone"), CAMID(":Authors"), CAMID(":Query Users"), CAMID(":Consumers"), CAMID(":Metrics Authors") CAMIDListForType CAMIDListForType ( identit...
Read more