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 Sandbox server => WDCDYWP21\DY_DBSDX => not connected to BW
DynaSys Development server => wdcslvbd31\slv1_dbdev => connected to WBD
DynaSys Testing server => wdcslvbt31\slv1_dbtst => connected to WBQ
DynaSys Production server => wdcdyap21\dy_dbprd => connected to WBP
Previous one (update given by Abdelmôti 2019/03/22)
Important:
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: ask cache clearance
| BW System | BW System Description | Java Portal |
|---|---|---|
| WBP | BW Production | BPJ |
| WBV | BW Pre-Production | BVP |
| WBQ | BW Quality | BQJ |
| WBD | BW Development | BDJ |
| WB1 | BW Sand Box | B1J |
For WB1/WBD/WBQ/WBV, email directly 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
It concerns structure /BIC/CADTS_EXP 0000300000001".
PS : The structure name must not contain any space
Tip : How to find structure name
1) run infopackage (view must contain records) and get it from the message
2) table RSDS
+ adding 0001 to the Application Structures
| DataSource | For WBD => BDJ | For WBQ => BQJ | For WBP => BPJ |
|---|---|---|---|
| DTS_EXP_FORE_DR_BW | /BIC/CADTS_EXP000360000001 | /BIC/CADTS_EXP000260000001 | /BIC/CADTS_EXP000170000001 |
| DTS_EXP_FORE_BW | |||
| ... |
A Java instance can have several servernodes for process execution (2 are available on BPJ).
Clearance might have been done on servernode 0, and loading is executed on servernode 1 which does still have previous structure definition
1- ask again cache clearance, in case clearance has not been done on both server node
2 - ask reboot of BPJ
For information, : Issue have been faced in nov 2020. Choice 1 has been done, but as BPJ has been reboot the day after, we can not say choice 1 is working
The field Name has to be up to 30c maximum
The field Name in DataSource has to be 16c maximum
Solution:
Ask DynaSys team to respect limits :
=> Table or View Name has to be up to 16c maximum
=> The field Name can be up to 30c but has to be unique on 16 first characters
=> new fields have to be added at the end of table otherwise transports to production have to be closely synchronized.
