APAR status
Closed as Permanent restriction.
Error description
MS-E-RDS_NOGWERRMSG, The database or data source did not return an error message (TR1907) Transformer can't gain access to database '<dbname>' with signon information '<userid>'
Local fix
replace length function with hard coded value in the IQD, or use Cognos report and DQM connection instead of IQD
Problem summary
**************************************************************** * USERS AFFECTED: * * One client * **************************************************************** * PROBLEM DESCRIPTION: * * CALCULATION IN INFORMIX CQM IQD RESULTS IN TR1907 * * TRANSFORMER CAN'T GAIN ACCESS TO DATABASE ERROR * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
We are not able to provide code change to address this issue due to the complexity of it. We recommend customers to continue using the workaround we provided in the support ticket. Workaround: Hard coding the length in the expression allows the execution to go through.
Temporary fix
Comments
APAR Information
APAR number
PH54244
Reported component name
COGNOS ANALYTIC
Reported component ID
5724W12XX
Reported release
B0D
Status
CLOSED PRS
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-05-01
Closed date
2023-05-25
Last modified date
2023-05-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B0D","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
29 May 2023