Sitemap

Amicuk Programming Answers

ABAP MDM Connection Pool

-0001-11-30   Views:2

Advertisement

Hi, I'm trying to write a report that extracts information from MDM. Everytime it's called, it has to establish a new connection to MDM where the hand-shake takes about 20-30 secs. I was wondering if ABAP MDM Connection Pooling exist. In Java MDM, yo

Hi,
I'm trying to write a report that extracts information from MDM. Everytime it's called, it has to establish a new connection to MDM where the hand-shake takes about 20-30 secs.
I was wondering if ABAP MDM Connection Pooling exist.
In Java MDM, you can configure J2EE with connection pool, so that you can reuse a connection rather than re-establishing a new connection on every call.
I've read Thomas Jung's WIKI on "How do you implement a MDM Connection Help Class?", however I cannot reuse this class. The static attribute in the class is not persisted.
Did I do something wrong?
I tried turning it into a shared memory root class, however it complains about an object reference still exist and would not allow me to do "dettach_commit( )".
Don't know any other ways to store the connection handle in memory.
Export/Import, SPA/GPA are not OO friendly.
Cheers
Michael

The replay answer
Advertisement
Hi Andreas,
Thanks for your reply, it is good to confirm my understanding of the ABAP API connection.
For your interest, I have changed part of the connection code to increase the speed of the connection significantly.
Firstly to clarify, the connection from the ABAP stack to MDM is actually quite fast.
Upon the first call, the method CL_MDM_PROVIDER_SP04_PL03->_LOAD_FIELD_INFORMATION is called which reads the META-DATA from MDM for every table and every field. This could normally take 1 minute in our system landscape. I've changed to code to buffer the meta-data.
In a production/stable environment, it is unlikely for the META-DATA to change rapidly. Hence reading this on every connection is a waste of time.
This could be useful only if we are in implementation phase where this changes all the time.
1) In transaction MDMAPIC, I've added the ABAP implementation for MDM Version Support as my own MDM provider class ZSP04_PL03 with provider type ZCL_MDM_PROVIDER_SP04_PL03.
ZCL_MDM_PROVIDER_SP04_PL03 is a copy of CL_MDM_PROVIDER_SP04_PL03.
2) In ZCL_MDM_PROVIDER_SP04_PL03, the method LOADFIELD_INFORMATION is changed to read from buffer first before calling MDM. If the buffer is empty, it will read from MDM and store result into buffer etc.
I'm storing the information in a transparent table at the moment.
I buffer the three class attributes:
- mt_field_meta_data,
- mt_mdm_field_meta_data,
- mt_field_code2id_map.
As MT_FIELD_META_DATA is a complex structure (i.e. tables within table), I had to split it up into many different tables.
I can provide the code if you are interested.
Cheers,
Michael.

Go to See the other 5 answers

ABAP MDM Connection Pool

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm trying to write a report that extracts information from MDM. Everytime it's called, it has to establish a new connection to MDM where the hand-shake takes about 20-30 secs. I was wondering if ABAP MDM Connection Pooling exist. In Java MDM, yo[More]

ABAP MDM Connection Pool concept? Slow Performance in call

Category:DefaultRelease time:2015-10-11Views:130

Hi, I'm playing around with the MDM ABAP API, and I found the performance a bit disappointing. I followed the guide "How To identify master data records using SAP MDM 5.5 ABAP API's" and wrote a test program. The program makes a connection, trig[More]

Connection Pool establishment problem

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, we have one application with JCo mechanism. For this application, we are using one properties file, which holds ABAP connection information. From this connection information(sapconn.props), we created connection pool and fetching data fro[More]

Connection pool exausted

Category:DefaultRelease time:2015-10-11Views:130

Dear all, I am new to j2ee environment. RFC from PI Java stack to PI ABAP stack failing intermittently. Error message: Error while lookupProblem when calling an adapter by using communication channel CC_RFC_LookUp (Party: , Service: PPICLNT900, Objec[More]

Connection pool -  api

Category:DefaultRelease time:-0001-11-30Views:130

Hi, the following code try to connect mdm with connection pool : <i> Context ctx = new InitialContext(); IConnectionFactory connFactory =    (IConnectionFactory) ctx.lookup("deployedAdapters/MDM Factory/shareable/MDM Factory"); IConnection[More]

Java Documentation to Connection Pooling?

Category:DefaultRelease time:-0001-11-30Views:130

Hello, is there any Java API documentation to the Connection Pooling available? It is not listed in the SP03-Docu, but the classes exist. I don't know how to use them, so any help would be appreciated. Ah, and the Weblogs by Uri Katz are good, but no[More]

How to download ABAP(report,module pool...etc) source code to client PC?

Category:DefaultRelease time:-0001-11-30Views:130

hi guys, please advise how can i download/export ABAP(report,module pool...etc) source code to client PC? thanks.hi this report is to export to another server... PROGRAM ZDOWNLOAD_SAP LINE-SIZE 132 LINE-COUNT 62 NO STANDARD PAGE HEADING. This program[More]

RFC_FAILURE affects Connection Pool

Category:DefaultRelease time:2015-10-11Views:130

Using VB.NET (2003) with .Net Connector 2.0. An intermittent problem causes a RFC Call to fail, and an exception is raised in the .NET code. The Exception message is:      See RFC trace file or SAP system log for more details The Trace file shows: ER[More]

Connection pool / db failure

Category:DefaultRelease time:2015-10-11Views:130

WLS6.0 sp2 / Win2k Oracle 8.1.7 / Solaris 8 problem is if DB fails, the connection pool fails, and will not restart. If I run a java weblogic.Admin EXISTS_POOL command, it says the pool doesnt exist. If i run a RESET_POOL, using the system user passw[More]

RFC_ERROR_SYSTEM_FAILURE: Time limit exceeded. Connection Pool - JCO api

Category:DefaultRelease time:2015-10-11Views:130

Hi Everyone My Connection  Pool parameters JCO api. client=300 user=SISGERAL_RFC passwd=****** ashost=14.29.3.120 sysnr=00 size=10 I have these parameters on my Connection Pool and sometimes appear these wrongs in my application: 1. 2006-01-07 13:20:[More]

Connection Pool Failure: "No suitable driver"

Category:DefaultRelease time:2015-10-11Views:130

Hi, Upon server startup, I get the following result: <Nov 7, 2001 4:18:32 PM CST> <Error> <JDBC> <Cannot startup connection pool "ora cleTrufflePool" No suitable driver> I assumed it was a path problem, but in the startWe[More]

Hot
How can you check a different iCloud account in safari in an iPad?As currently designed, you cannot. Once iCloud detects you are on mobile Safari, it switches you to the iPad screen. If you had another browser that would allow you to pretend you were [More]
I installed FontPack Pro.  I was successful in loading them into the font book.  However, when I open pages and attempt to select a font, quite a number of them have an "A" with a box around the A.  In the document it comes up as a box with a gr [More]
Hello, we are in the process of upgrading ERP6.0 EHP5 to EHP6 which is also an upgrade to NW702 to NW731. We made a system copy of the productive system and called it XXX and did all the post-systemcopy works that need to be done including creating t [More]
Sce the changeover i have had 'no service' on the top left of phone.  I have an email to say it has been unlocked by Apple from my local Vodafone store.Read this http://support.apple.com/kb/HT5014Read other 2 answers [More]
Hi, I am having a weird problem. recently client migrated the server and we started getting all possible errors in XI which we are able to fix. Now we have a strange problem in quality system alone where the bapi calls are made from QA11 and MIGO. Th [More]
Broken Recordset: I have created a Form with a table that includes 15 textfields and a recordset that polls data based on a login page. I have mapped specific fields from the database to return the data under the textfields that are labeled First Nam [More]
My tool bar has disappeared - tried hide toolbar/show toolbar customize toolbar etc.  Still no toolbar.You may be using full screen mode. Try Control + Command + FRead other 4 answers [More]
Hi, on 8.1.7 There is a DBLINK in my DB (with connect ) for userA. When userB wants to use it he can not and receive ORA-02019). How make userB able to use it ? Or how to modify DBLINK so that userB can use it ? Thanks.I do not think you can create a [More]
My dear friend, a Windows XP user would like all of her music on my iPod. I realize I can't just plug and sync because of different disk formats. She is purchasing a new iMac; what will we need to do so that all of the music goes to her iTunes? Is th [More]
Apologizes for all the typos in a previous email on the multi-take recording audio missing. I have since done some research and have better terminology to use so I'll restate. I believe this could be a bug and want folks to be aware of it at the very [More]