Connection with UD CONNECT

Dynasys is a MSSQL tool, BW WBP is on an AIX server. No ODBC driver exists between BW and MSSQL server in Linux / AIX.

This problem was solved setting an UD connect connection

User ID for Dynasys connection is Dynasys_Interface / Password  : 791hB6zi8Rk1DBSV3uNG  (Prod/Tst/Dev)

Main servers:

• Dynasys Production server: WDCCLSLVBP01\SLV1_DBPRD => connected to WBP
• Dynasys Development server: WDCSLVBD11\SLV1_DBDEV  => connected to WBD
• Dynasys Testing server: WDCCLSLVBV01\SLV1_DBTST => connected to WBQ

Important:

• Adagio Team is in charge of UD Connect connexions. Admin Change to be created by Guillaume T for any change or issue.
• Wintel Operations is in charge of DynaSys servers (Contact Abdelmôti KHABABA)

Known Issues

Field XXX is not a member of XXX

This is a known problem that has already been encountered. Some explanation in the following sapnote: https://launchpad.support.sap.com/#/notes/1007409

This is linked to the datasource structure being cached in J2EE layer when using preview functionnality.

It can also happen if the size of a field in the datasource is greater than 46 characters.

Solution:

In the first case, you need to contact team Adagio - is-adagio-sap-operations@solvay.com, with the description of the issue. The steps needed for correction are the following:

• Clear the J2EE cache
• Restart the J2EE Engine

In the second case, you juste need to limit the size of the new field to under 46 characters.