Hardik’s Info

One can enable user level trace using following steps for any Self Service Web Applications…

1. Change profile value ‘Initialization SQL Statement - Custom’ at user level to below string,

BEGIN FND_CTL.FND_SESS_CTL('','', '', 'TRUE','','ALTER SESSION SET TRACEFILE_IDENTIFIER='||''''||'your_identifier' ||''''||' EVENTS ='||''''||' 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12 '||''''); END;

2. Reproduce the issue 3. Trace file can be found at the location given by following query,

SQL> select name, value from v$parameter where name like 'user_dump_dest';

4. Search for the file name having ‘your_identifier’
5. Remove the profile value once you are done
6. Generate tkprof for the given trace file

For more details, please refer Metalink Note 296559.1

- Hardik

Share This

Recently I come across Debashish Chakrabarty’s site and found interesting Archive page. I downloaded Extended Live Archive plugin and followed all the installation steps. But somehow I cold not get similar page on my Wordpress 2.1 blog!

After digging a lot in Google, I found some discussion at Flickr. After reading all the comments, somehow I could hack the problem by adding one link in af-extended-live-archive.js.php file.

If you are facing similar issue, try your luck by adding following code in \includes\af-extended-live-archive.js.php file…

Old code:

...
	} else {
	    	header("Cache-Control: public");
		header("Pragma: cache");
...

New code:

...
	} else {
	    	header('HTTP/1.1 200 OK');
	    	header("Cache-Control: public");
		header("Pragma: cache");
...

Njoy…

Hardik

Share This

I was looking for support for Java Applet and ActiveX control on various Mobile device browsers.

Here are my findings…

Tech  Browsers   |  PIE   |  Opera |  BB |  NetFront
------------------------------------------------------
Java Applet       |  Y     |  N     |  N  |  Y
------------------------------------------------------
ActiveX           |  Y     |  N     |  N  |  N 

PIE: Pocket Internet Explorer
BB: BlackBerry
Note: NetFront comes with inbuilt JVM

Share This

The most common problem we face while downloading a CAB file using PIE (Pocket PC Internet Explorer) is, it renders the content of the CAB file instead of downloading it to local Main Memory.

The reason for this is very simple: the servers don’t set one of the returning HTTP response headers, Content-Type, correctly, but leave it at the default text/plain type.

Solution to this problem is to set proper MIME type in code.

Option 1: Set proper MIME type setting at Web Server.

For example, in Tomcat one can specify the same at web.xml file for extension .CAB

<mime-mapping>
   <extension>CAB</extension>
   <mime-type>application/vnd.ms-cab-compressed</mime-type>
</mime-mapping>

Option 2: For a specific link use ‘type’ attribute of <a>

For example,

...
<a type="application/vnd.ms-cab-compressed" href="./file.CAB">Download</a>
... 

MIME type “application/x-msdownload” can also be used for this purpose.

Share This

I recently upgraded to WordPress 2.1 and ran into a bug with my Subscribe to Comments plugin. Error I get is,

Warning: in_array() [function.in-array]: Wrong datatype for second argument in
  LOCAL ADDRESS/wp-content/plugins/subscribe- to-comments.php on line
  438Warning: Cannot modify header information - headers already sent by
  (output started at
  LOCAL ADDRESS/wp-content/plugins/subscribe-to-comments.php:438)
  in LOCAL ADDRESS/wp-includes/pluggable.php on line 275

To fix the issue, open up the subscribe-to-comments.php file, go to line 438 and change what’s there to this:

$previously_subscribed = ( $wpdb->get_var("SELECT comment_subscribe
       from $wpdb->comments WHERE comment_post_ID = '$postid' AND
       LCASE (comment_author_email) = '$email' AND
       comment_subscribe = 'Y' LIMIT 1") || in_array(stripslashes($email),
       array(get_post_meta($postid, '_sg_subscribe-to-comments'))))
       ? true : false; 

Also, newer version 2.1 of Subscribe to Comments has fixed this issue.

Thanks Ben!

Share This