PM48789: UNABLE TO CONFIGURE FAP SOURCE ON SQL SERVER USING NON STANDARD PORT.

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 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