2447414 - The relationship between Page size and Index width you should know when choose Sybase ASE as SAP Data Services repository

• You may need to know what the relationship is between Page size and Index width for Sybase ASE database.
• You may need to know how you should set the SAP ASE database page size before you create SAP Data Services repository.

• BODI-300026: Creating repository...
  BODI-320001: Reading SQL file <C:\Program Files (x86)\SAP BusinessObjects\Data Services\admin\repo\sybase\sybase.sql>.
  BODI-320002: Executing SQL file <C:\Program Files (x86)\SAP BusinessObjects\Data Services\admin\repo\sybase\sybase.sql>.
  BODI-320004: Error or warning in executing the SQL statement <
  
  Create index AL_RELATION_INDX1 on AL_RELATION
  (SRCTAB_DATASTORE, SRCTAB_OWNER, SRCTAB_NAME, SRCTAB_COLUMN,
  TRGTAB_DATASTORE, TRGTAB_OWNER, TRGTAB_NAME, TRGTAB_COLUMN)
  >. The message from the underlying database is: <Sybase SQL Server <SERVER> error message for operation <ct_results>: <Sybase Server message number <1903> State <1> Severity <16> From Server <SERVER>: Message Text is: 2600 is the maximum allowable size of an index. Composite index specified is 2816 bytes.
  >.>.
  An error occurred during creation of the local repository. Please make sure to create %DS_COMMON_DIR%/log/Admin/repo directory and create repository again. (BODI-300054)

• SAP Data Services 4.2
• Sybase ASE Server 15.5 or higher

DS, repository, repoman, repository manager, ASE, SAP ASE, limitation, bytes , KBA , EIM-DS-DEP , Deployment, Installation, Upgrade , EIM-DS-SVR , Administration/Server , Problem