10 Tips Memenangkan Sebuah Perdebatan

Kita semua suka berdebat , tapi seringkali perdebatan berakhir dengan teriakan dan hinaan serta tidak ada kesimpulan yang bisa ditarik. Saya menemukan tautan dari Listverse berisi 10 kumpulan daftar/tips untuk membantu kita menghadapi perdebatan di masa depan, baik perdebatan di sebuah situs atau offline. Lengkapnya, buka tautannya saja ya…

Soft and Steady,Get Your Opponent On Your Side,Don’t Attack,Don’t Play Dirty,Define The Fundamentals,Stick to the Subject,Ask Questions,Be Silent,Know Your Facts,Know When You’re Beat

*Diditho.com manage by Gagas Lintas Media in partnerhsip with Netfit.id

SAP BW: ABAP dump on Read Master Data

Read Master Data (Master Data Derivation) in SAP BW NW 7 is one of popular Transformation method to fill an InfoObject on a Cube or DSO. I think 99 percent of SAP BW architecture use this method.

Recently we have problem , an ABAP dump (error) occurs just after we finished a modification to a transformation. We are adding another read master data to new InfoObject. usually there is no any obstacle to perform this kind of modification.

The ABAB dump message (i have reduce the log file for important keyword only) :

----------------------------------------------------------------------------------------------------
Runtime Errors         GETWA_NOT_ASSIGNED
Date and Time          12.11.2010 09:53:30
----------------------------------------------------------------------------------------------------
What happened?
The current ABAP program "CL_RSDMD_LOOKUP_MASTER_DATA===CP" had to be terminated because it has come across a statement that unfortunately cannot be executed.
----------------------------------------------------------------------------------------------------
What can you do?
Using Transaction ST22 for ABAP Dump Analysis
----------------------------------------------------------------------------------------------------
Error analysis
You attempted to access an unassigned field symbol
----------------------------------------------------------------------------------------------------
How to correct the error?
If you have access to SAP Notes, carry out a search with the following keywords:
"GETWA_NOT_ASSIGNED" " "
"CL_RSDMD_LOOKUP_MASTER_DATA===CP" or "CL_RSDMD_LOOKUP_MASTER_DATA===CM003"
"PREFETCH"
----------------------------------------------------------------------------------------------------
User and Transaction
Program............. "CL_RSDMD_LOOKUP_MASTER_DATA===CP"
----------------------------------------------------------------------------------------------------
Information on where terminated
Termination occurred in the ABAP program "CL_RSDMD_LOOKUP_MASTER_DATA===CP" - in "PREFETCH".
The main program was "RSBATCH_EXECUTE_PROZESS ".
In the source code you have the termination point in line 73 of the (Include) program "CL_RSDMD_LOOKUP_MASTER_DATA===CM003".
----------------------------------------------------------------------------------------------------
Source Code Extract
63|*Get reference to prefetched data
64|data l_lines type i.
65|data l_tabix like sy-tabix.
66|read table p_th_buffer assigning  with table key iobjnm = i_iobjnm.
67|if sy-subrc = 0.
68|  IF i_reset_prefetched_data = rs_c_true.
69|    l_tabix = sy-tabix.
70|    assign -r_data->* to .
71|    describe table  lines l_lines.
72|    delete p_th_buffer index l_tabix.
|>>>>>|    clear .
74|    unassign .
75|    p_current_buffer_size = p_current_buffer_size - l_lines.
76|  ENDIF.
77|ENDIF.
----------------------------------------------------------------------------------------------------
Active Calls/Events
No: 7
Ty.Name : METHOD CL_RSDMD_LOOKUP_MASTER_DATA=>PREFETCH
Program : CL_RSDMD_LOOKUP_MASTER_DATA===CP
Include: CL_RSDMD_LOOKUP_MASTER_DATA===CM003
Line: 73

According to SAP NOTES , your system might have been implement:

SAP Note 1092539 – Master Data Lookup with prefetch

Which is a feature to speed up a read master data process by enabling “Master Data Lookup with Prefetch”. It can be turned ON by
maintaining a parameter named – MD_LOOKUP_PREFETCH_LOGIC in the table
RSADMIN. A value ‘X’ against this parameter causes the Transformation
program to switch to the new mode of Master Data look-up. It is turned ON
by default with SAP NetWeaver 7.0 BI support package 16.

Other Notes to read:

SAP Note 1175141 – Short Dump in Master Data Lookup in Transformations
SAP Note 1227788 – Reading master data with buffering returns incorrect values
SAP Note 1233535 – Reading master data with prefetch does not work correctly
SAP Note 1236970 – Reading master data returns incorrect data
SAP Note 1239269 – Error during Master Data Lookup in Transformations

Solution

1. Simply turn off the “Master Data Lookup with Prefetch” feature whic is a system-wide setting. Of course this will downgrade the ETL performace significantly
2. Update the BI patch to the latest release, or later than Release 19 . I think this is the best (recomended) option.

Good Luck

*Diditho.com manage by Gagas Lintas Media in partnerhsip with Netfit.id

Spacecraft Photo from NASA Solar Observatory ?

29-11-2010 10-21-57.pngBeberapa hari yang lalu, saya mendapatkan tautan foto dari sebuah milis mengenai benda aneh yang terlihat(terekam) pada foto matahari NASA. Benda tersebut tampak seperti sedang melewati matahari. Bila benda tersebut berupa Komet yang sudah kita kenal bentuknya, maka tidak ada yang perlu diributkan.

Masalahnya, benda (baca: ufo ) yang melintas dekat dengan matahari tersebut berbentuk seperti pesawat ruang angkasa (spacescraft) yang biasa kita lihat pada film hollywood (star wars, star trek, dll). >-)

http://bit.ly/a019Tv

Bila NASA sedang membuat ‘lelucon’, sepertinya agak keterlaluan ya…., btw tautan gambar tersebut berasal dari situs resmi NASA loh..Open-mouthed smile

Update : 29 November 2010

Tiba-tiba, gambar yang berasal dari situs NASA tersebut tidak dapat diakses. Mungkin koneksi lagi jelek atau pada periode tertentu berkas tersebut tidak ditampilkan lagi untuk dijadikan arsip, atau entahlah. Untungnya masih ada cache di webbrowser, saya capture aja screenshotnya… 🙁

*Diditho.com manage by Gagas Lintas Media in partnerhsip with Netfit.id

Get UserName on ASP.NET Membership Provider

If you are using ASP.NET Membership Provider for a website, one simple and practical way how to get ‘username’ for logging activities on CRUD (Create Read Update Delete) implementation is by storing the “username” on a session. Put this little code on Default page, or first landing page after succesfull user login.

using System.Web.Security;

 protected void Page_Load(object sender, EventArgs e)
    {
        //check user login
        if (User.Identity.IsAuthenticated)
        {
            //get username and put into session
            Session["UserName"] = Membership.GetUser().UserName.ToString();
        }
    }

Next example, if you are using DataSet , just put the session name on a parameter for later use on SQL Command.

<InsertParameters>
<asp:SessionParameter DefaultValue="na" Name="UserName" SessionField="UserName" Type="String" />
<InsertParameters>

*Diditho.com manage by Gagas Lintas Media in partnerhsip with Netfit.id

Menentukan Ukuran Frame Sepeda Gunung

Memilih rangka (frame) merupakan salah satu langkah penting dalam membeli atau merakit sepeda gunung (Mountain Bike/ MTB ). Selain pemilihan bahan Aluminium (Al) , faktor terpenting yang harus diperhatikan dalam memilih frame adalah ukuran yang sesuai dengan tinggi badan. Pembahasan mengenai ukuran ini belum (baca:terlewat) pada tulisan sebelumnya. Banyaknya pertanyaan dari komentar yang masuk di blog ini  maupun pertanyaan ketika beberapa teman menanyakan saya secara langsung ‘mendorong’ saya membuat panduan memilih ukuran frame sepeda gunung yang tepat.

Continue reading Menentukan Ukuran Frame Sepeda Gunung

*Diditho.com manage by Gagas Lintas Media in partnerhsip with Netfit.id