SAP Knowledge Base Article - Preview

2918460 - SAP_INFOCUBE_DESIGNS returns "RSDSTSYBFORM hist_data_get_maxtst" or nothing - SAP BW on ASE

Symptom

  • "RSDSTSYBFORM hist_data_get_maxtst" is returned when executing the report "SAP_INFOCUBE_DESIGNS" (SE38)
  • Checking related developer trace file we can see this error is being reported each time the report is executed:

C ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 6164]
C (4002) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Login failed.
C
C Connection 0 failed using DRIVER={Adaptive Server Enterprise};server=<server_name>;port=<port>;uid=sapsa;db=<SID>;pwd=xxxxxxxxxx;TextSize=2
C
B ***LOG BY2=> sql error 4002 performing CON [dbds 989]
B ***LOG BY0=> [ASE Error SQL4002][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Login failed.

  • When testing the +++SYBADM connection from ADBC_CONNECTION_TEST same error is returned:

    Testing a Database Connection Defined in DBCON
    Could not open connection +++SYBADM .
    sql error 4.002 occured:
    [ASE Error SQL4002][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Login failed.#

  • No BW Correction Collection is implemented. In case it is implemented, it might be possible that the report won't return any thing (nor error message), but same "Login failed" will be reported in developer trace file. 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse - All versions 

Product

SAP NetWeaver 7.5

Keywords

"Login failed", DBCO, "+++SYBADM", ADBC_TEST_CONNECTION , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.