SAP Knowledge Base Article - Preview

3467190 - Error: "The maximum number of connections have already been opened" occurs when running tasks - SAP Information Steward

Symptom

  • All of the IS tasks based on Sybase ASE DB repository fail with error
  • Error: "Sybase connection error: <Sybase CS Library message number:  Message Text is: ct_connect(): user api layer: external error: The maximum number of connections have already been opened.>.layer: external error: The maximum number of connections have already been opened.>." 
  • In Sybase ASE DB side, even though the parameter of <number of user connections> has been increased to value 10000, still can find below entries in IS task log
    [TaskUtility][main] Property MaxConnections value is 10. (COR-10002)
    [TaskUtility][main] Property ConnectionTimeout value is 3600 seconds. (COR-10002)
    [TaskUtility][main] Property PoolTime value is 300 seconds. (COR-10002) 


Read more...

Environment

  • SAP Information Steward
  • Sybase ASE

Product

SAP Information Steward 4.2 ; SAP Information Steward 4.3

Keywords

Sybase ASE, connection, numbers, max, IS, tasks, repository, value, Information Steward, ct_connect , KBA , EIM-IS-DI , Information Steward - Data Insight , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.