APAR status
Closed as program error.
Error description
Customer has configured the SQL server to run on a different TCP/IP port, when trying to configure a Datasource in the FAP client, they are unable to connect.?
Local fix
- Reconfigure the Source to use a comma instead of a colon (sqls erver,2433) and start it. - Create your datamart, and configure it to use the source, and start it. - The Datamart will be in state "Ready for Publish" - In the log there will be an error "Connecting to source 'sourc ename' Failed" with additional info: "Could not connect to: jdbc:JSQLConnect: //sqlserver,2433/database=databasename" - Close the FAP client. - Stop the FAP service. - In the FAP database, modify and run the following script, with "Result as text": select CCRDBUrl from NRTR_SOURCE where name='SourceName'; - You will get a result that looks like: Provider=SQLNCLI.1;Persist Security Info=True;Data Source=sqlser ver,2433;Initial Catalog=DatabaseName; - Copy this string and modify the comma to a colon, then run the following script using the modified string: update NRTR_SOURCE Set CCRDBUrl='Provider=SQLNCLI.1;Persist Secu rity Info=True;Data Source=sqlserver:2433;Initial Catalog=Databa seName' where name='SourceName'; - Now start the FAP service. - The Datamart will start the Initial Publish, and will start tr ickeling. - There should not be any errors in the log. If the customer wants to change anything in the FAP client, for example adding additional actuality or period to the datamart se tting, they will have to redo the whole procedure.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Controller 10.1.1 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PM48789
Reported component name
COG CONTROLLER
Reported component ID
5724W24CO
Reported release
851
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-09-27
Closed date
2012-06-06
Last modified date
2012-06-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
COG CONTROLLER
Fixed component ID
5724W24CO
Applicable component levels
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
08 August 2024