View Source

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:

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)

$TECHNO - BI TEAM > Connection with UD CONNECT /!\ Obsolete /!\ > image2018-3-30 16:39:4.png$

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.

Solution:

For WBD/WBQ, email Adagio team

For WBP, ask Laure Pichot to create an RFC and email IBM (slvhd@be.ibm.com) + Adagio (is-adagio-sap-operations@solvay.com) with following information :

Title : URGENT - RFC 70000xxxxx - Need to clear JCO metadata caches on BPJ

Mail :

We are about to move BW evolutions on WBP.

We need you to clear ones JCO metadata caches for BPJ now. Operation has to be done by 6pm CET today.

It concerns structure /BIC/CADTS_EXP 000030000001

$TECHNO - BI TEAM > Connection with UD CONNECT /!\ Obsolete /!\ > image2018-3-30 16:40:45.png$

The field Name has to be up to 30c maximum

The field Name in DataSource has to be 16c maximum

$TECHNO - BI TEAM > Connection with UD CONNECT /!\ Obsolete /!\ > image2018-3-30 16:42:44.png$

Solution:

Ask DynaSys team to respect limits :

=> The field Name has to be up to 30c maximum

=> The field Name in DataSource has to be 16c maximum

=> new fields have to be added at the end of table otherwise transports to production have to be closely synchronized.