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: WDCCLSLBV01\SLV1_DBPRD => connected to WBP
- Dynasys Development server: WDCCLSLBV01\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.