source:
103553 - Internet Explorer crashes when viewing the Webtrends user interface and Java 1.6.0 Update 17 (or later) is installed
For products:
Webtrends Analytics 8.x
Webtrends On Demand
Last modified: 7/22/2010
Situation:
Internet Explorer crashes when viewing the Webtrends user interface on a machine with Java 1.6.0 Update 18 or later installed.
Solution:
In Java 1.6.0 Update 18 and later, a new plug-in process has been introduced which causes Internet Explorer browsers to crash.
This can be disabled by performing the following steps:
1. Open the java control panel.
2. Select the "Advanced" tab
3. Under the "Java Plug-in" section, uncheck "Enable the next-generation Java Plug-in"
4. Restart the browser.
Further information:
This issue can also be avoided by uninstalling any version of Java 1.6.0 Update 18 or later and using an earlier version in its place. 1.6_17 is the version of JRE webtrends currently recommends for version 8.0, 8.1x, 8.5x, and 8.7d.
Thursday, August 26, 2010
Wednesday, August 18, 2010
ORA-12541: TNS no listener
Source: http://www.dba-oracle.com/t_ora_12541_tns_no_listener.htm
ORA-12541: TNS no listener
Cause: Listener for the source repository has not been started.
Action: Start the Listener on the machine where the source repository resides.
Basically the Forms server could not find the listener. First check the tnsnames.ora file and ensure that it points to the correct server and port. If the Forms server is on another machine, test the TNS resolve with tnsping from the command prompt. Finally, check the listener.
First, ensure that your listener service is running.
C:\Documents and Settings\ME>lsnrctl stat
This should show the status of the listener and the services it is listening for. Remember that when you run SQL*Plus on the database server, it does not need the listener to connect unless you specify the database tnsnames.ora entry.
Try to start the listener service using lsnrctl from DOS prompt.
set ORACLE_HOME= cd %ORACLE_HOME%/bin
lsnrctl start LISTENER
If the listener service is not running, re-start the listener service using the Windows task manager or use the DOS command line utility to re-start the Windows service with the "net start" command:
C:\Documents and Settings\ME>net start OracleOraDb10g_home1TNSListener
You can use the lsnrctl status command to verify that the listener is down, and lsnrctl start to start your listener. If you are on Windows, also verify that the listener service is running.
ORA-12541: TNS no listener
Cause: Listener for the source repository has not been started.
Action: Start the Listener on the machine where the source repository resides.
Basically the Forms server could not find the listener. First check the tnsnames.ora file and ensure that it points to the correct server and port. If the Forms server is on another machine, test the TNS resolve with tnsping from the command prompt. Finally, check the listener.
First, ensure that your listener service is running.
C:\Documents and Settings\ME>lsnrctl stat
This should show the status of the listener and the services it is listening for. Remember that when you run SQL*Plus on the database server, it does not need the listener to connect unless you specify the database tnsnames.ora entry.
Try to start the listener service using lsnrctl from DOS prompt.
set ORACLE_HOME= cd %ORACLE_HOME%/bin
lsnrctl start LISTENER
If the listener service is not running, re-start the listener service using the Windows task manager or use the DOS command line utility to re-start the Windows service with the "net start" command:
C:\Documents and Settings\ME>net start OracleOraDb10g_home1TNSListener
You can use the lsnrctl status command to verify that the listener is down, and lsnrctl start to start your listener. If you are on Windows, also verify that the listener service is running.
Wednesday, August 11, 2010
ASP LDAP authentication and retrieve details
strUser = "xxx"
strDN = "cn=" & sUser & ",ou=people,dc=company,dc=com"
strRoot = "LDAP://servername.com/dc=company,dc=com"
Dim objDS: Set objDS= GetObject("LDAP:")
Dim objAuth: Set objAuth = objDS.OpenDSObject(strRoot , strDN , "password", &H0200)
Dim objConn: Set objConn= CreateObject("ADODB.Connection")
objConn.Provider = "ADSDSOObject"
objConn.Open "Ads Provider", strDN , "password"
Dim rs
Set rs = oConn.Execute("<" & sRoot & ">;(uid=" & strUser & ");cn,mail,telephoneNumber;subtree")
Response.write rs("cn").value
Response.write rs("mail").value
Response.write rs("telephoneNumber").value
rs.Close
objConn.Close
Set objConn = nothing
...
strDN = "cn=" & sUser & ",ou=people,dc=company,dc=com"
strRoot = "LDAP://servername.com/dc=company,dc=com"
Dim objDS: Set objDS= GetObject("LDAP:")
Dim objAuth: Set objAuth = objDS.OpenDSObject(strRoot , strDN , "password", &H0200)
Dim objConn: Set objConn= CreateObject("ADODB.Connection")
objConn.Provider = "ADSDSOObject"
objConn.Open "Ads Provider", strDN , "password"
Dim rs
Set rs = oConn.Execute("<" & sRoot & ">;(uid=" & strUser & ");cn,mail,telephoneNumber;subtree")
Response.write rs("cn").value
Response.write rs("mail").value
Response.write rs("telephoneNumber").value
rs.Close
objConn.Close
Set objConn = nothing
...
Monday, August 9, 2010
uncle zack by the beach - park royal penang
Last weekend we had some spare time and decided to check out Uncle Zack by-the-beach, a fairly new dining place in Park Royal hotel. Earlier we had came across a bunch of glowing reviews so... we'll get to that later.
The ambience is first rate if 1) you arrived early around 6-ish, and 2) you've never dined by the beach before. However, given the vast number of insect stings I accumulated, perhaps some insect repellent would be a nice addition :)
Although I do not lay claim to being a foodie expert, I have had sufficient dining experience to be able to point out that the food is mediocre. Not too bad and not too good. Not feeling particularly adventurous, we started out with the gazpacho, continued with the tapas platter, and shared the 800g beef ribs.
I personally felt that the tapas platter was a mixmash of nasi kandar leftovers. But then again, to view it in a sliggggghtly more favorable light - it kinda reminded me of 1Malaysia spirit..
The beef ribs came in a huge serving so sharing is advisable. I prefer my meat to be succulent and juicy - it fell a bit short of my expectations.
Now here is some humble opinion from yours truly: I could only make the deduction that being professional food blogs the floggers had the special TLC and attention from the good hotel folks...
- Serving was real slow although there were about maximum 8 tables occupied (maximum capacity is around 12-16 tables).
- By the time the food arrived at our table it was cold :( gazpacho excluded!
- The serving attendant was very attentive and friendly so I guess this is the silver lining..
Nuff said.
The ambience is first rate if 1) you arrived early around 6-ish, and 2) you've never dined by the beach before. However, given the vast number of insect stings I accumulated, perhaps some insect repellent would be a nice addition :)
 |
| From food pics |
Although I do not lay claim to being a foodie expert, I have had sufficient dining experience to be able to point out that the food is mediocre. Not too bad and not too good. Not feeling particularly adventurous, we started out with the gazpacho, continued with the tapas platter, and shared the 800g beef ribs.
I personally felt that the tapas platter was a mixmash of nasi kandar leftovers. But then again, to view it in a sliggggghtly more favorable light - it kinda reminded me of 1Malaysia spirit..
 |
| From food pics |
The beef ribs came in a huge serving so sharing is advisable. I prefer my meat to be succulent and juicy - it fell a bit short of my expectations.
Now here is some humble opinion from yours truly: I could only make the deduction that being professional food blogs the floggers had the special TLC and attention from the good hotel folks...
- Serving was real slow although there were about maximum 8 tables occupied (maximum capacity is around 12-16 tables).
- By the time the food arrived at our table it was cold :( gazpacho excluded!
- The serving attendant was very attentive and friendly so I guess this is the silver lining..
Nuff said.
Friday, August 6, 2010
SQL 2000 change the owner of a table
For SQL 2000 change the owner on a table:
use DB
EXEC sp_changeobjectowner 'UserName.TableName', 'dbo'
use DB
EXEC sp_changeobjectowner 'UserName.TableName', 'dbo'
Thursday, August 5, 2010
Monday, August 2, 2010
Quick way to migrate DTS packages to SQL Server 2005
Migration is done using the SQL Server Package Migration Wizard.
This works to an extent - more complex packages will require some customizations and code changes.
Go to\Microsoft SQL Server\90\DTS\Binn to locate DTSMigrationWizard.exe. Alternatively, expand the DB server in Management Studio, expand management and then legacy in Object Explorer. Right click on DTS and select the wizard.
Choose source/destination server, and DTS packages. Then click Finish and wait for the wizard to import.
So now the packages are migrated, how do you know whether it works?
In SQL Server Management Studio, connect to Integration Services. (File->Connect Object Explorer).
Expand Stored Packages of the server instance. The migrated packages should be under MSDB.
Start performing test runs and pray for no errors to occur!
There's a great article that shows more details, here.
Part 2:
After successfully importing the DTS packages, we still need to set up the jobs. Script the jobs from SS2000 and just run the queries to create jobs in SS2005 master database.
Some stuff to take note:
Create a new database maintenance plan and let SSIS and SS2005 take care of the rest, as opposed to migrating the job and DTS over from SS2000 and spend time troubleshooting.
If the migrated job failed with an error like this:
Message
Executed as user: XXXXX\SYSTEM. Description: One or more component failed validation. End Error Error: 2010-08-04 01:00:43.37 Code: 0xC0024107 Source: DTSTask_DTSDataPumpTask_1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:00:00 AM Finished: 1:00:43 AM Elapsed: 42.75 seconds. The package execution failed. The step failed.
Try changing the DTS package's protection level as stated here.
For my case I just re-import the package from my local File System and used "Rely on Server Storage and Roles..."
EOS.
This works to an extent - more complex packages will require some customizations and code changes.
Go to
Choose source/destination server, and DTS packages. Then click Finish and wait for the wizard to import.
So now the packages are migrated, how do you know whether it works?
In SQL Server Management Studio, connect to Integration Services. (File->Connect Object Explorer).
Expand Stored Packages of the server instance. The migrated packages should be under MSDB.
Start performing test runs and pray for no errors to occur!
There's a great article that shows more details, here.
Part 2:
After successfully importing the DTS packages, we still need to set up the jobs. Script the jobs from SS2000 and just run the queries to create jobs in SS2005 master database.
Some stuff to take note:
Create a new database maintenance plan and let SSIS and SS2005 take care of the rest, as opposed to migrating the job and DTS over from SS2000 and spend time troubleshooting.
If the migrated job failed with an error like this:
Message
Executed as user: XXXXX\SYSTEM. Description: One or more component failed validation. End Error Error: 2010-08-04 01:00:43.37 Code: 0xC0024107 Source: DTSTask_DTSDataPumpTask_1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:00:00 AM Finished: 1:00:43 AM Elapsed: 42.75 seconds. The package execution failed. The step failed.
Try changing the DTS package's protection level as stated here.
For my case I just re-import the package from my local File System and used "Rely on Server Storage and Roles..."
EOS.
unicode escape formats
For my personal reference only. The original article can be found here.
The following are ASCII representations of Unicode characters known to be used in
various contexts. In a few cases we also include unusual representations of integers
since integers are sometimes converted to characters.
The following are ASCII representations of Unicode characters known to be used in
various contexts. In a few cases we also include unusual representations of integers
since integers are sometimes converted to characters.
| Description | Example | Usage |
|---|---|---|
| raw hex | 00E9 | Unicode Consortium file NamesList.txt |
| prefix 0x hex | 0x00E9 | Yudit keymap source files |
| prefix v decimal | v233 | Perl |
| prefix $ hex | $00E9 | Alex Eulenberg Mac OS X keyboard map source files |
| prefix # with suffix # hex | #00E9# | Mimer SQL |
| prefix #$ hex | #$00E9 | some Pascals including Delphi |
| prefix 16# hex | 16#00E9 | Postscript |
| prefix #x hex | #x00E9 | some Common Lisp implementations |
| prefix #16r hex | #16r00E9 | Common Lisp integer |
| prefix backslash hex [4] | \00E9 | Oracle in unistr function |
| prefix backslash-u decimal | \u0233 | Rich Text Format |
| prefix backslash-u hex [4] | \u00E9 | Java, Ruby |
| prefix backslash-u left brace hex [variable] right brace | \u{E9}, \u{000E9}, multiple codepoints: \u{E9 74 E9} | Ruby |
| prefix backslash-U hex [8] outside BMP, prefix backslash-u hex [4] within BMP | \u00E9 | C#, D, Python, Scheme, Tcl |
| prefix U hex | U00E9 | |
| prefix u hex | u00E9 | |
| prefix u HEX [5-6] | u100E9 | Fontlab Studio outside BMP |
| prefix %u hex | %u00E9 | |
| prefix U+ hex | U+00E9 | Unicode Consortium documents |
| prefix uni HEX [4] | uni00E9 | Fontlab Studio within BMP |
| prefix X with hex in single quotes | X'00E9' | some IBM documentation |
| prefix X with hex in double quotes with optional type postfix character c[har], d[char], w[char] | X"00E9"d | D |
| prefix 16# and suffix # hex | 16#00E9# | Ada |
| prefix U in angle brackets hex | <U00E9> | POSIX locale specifications |
| prefix backslash-x hex | \x00E9 | C wide string, Tcl integer |
| prefix backslash-x hex in braces | \x{00E9} | Perl |
| prefix backslash {U+ hex with suffix } | \{U+E9} | BitC |
| prefix &# with suffix ; decimal | é | HTML, XML, XHTML |
| prefix &#x hex with suffix ; | é | HTML, XML, XHTML |
| prefix &# decimal | é | SGML, HTML (deprecated) |
| prefix &#x hex | é | SGML, HTML (deprecated) |
| prefix backslash-# decimal | \#0233; | SGML |
| prefix backslash-#x hex | \#x00E9; | SGML |
| prefix _x and suffix _ hex | _x00E9_ | OOXML, SQL/XML |
| 3 low bytes each with backslash prefix in big-endian order octal | \000\000\351 | |
| 3 low bytes each with backslash-x prefix in big-endian order hex | \x00\x00\xE9 | |
| 3 low bytes each with backslash-d prefix in big-endian order decimal | \d000\d000\d233 | POSIX locale specifications |
| prefix " hex[4] (UTF16 - use surrogate pairs beyond BMP) | "00E9 | XeTeX |
| hex UTF-8 with each byte's hex preceded by an =-sign | =C3=A9 | RFC 2045 Quoted Printable |
| hex UTF-8 with each byte's hex preceded by a %-sign | %C3%A9 | RFC 2396 URI escape format |
| hex UTF-8 with each byte's hex preceded by a backslash-x | \xC3\xA9 | Apache log format |
| hex UTF-8 with each byte's hex surrounded by angle brackets | <C3><A9> | print format for uninterpreted bytes used by various programs |
| octal UTF-8 with backslash prefixes | \303\251 | print format for uninterpreted bytes used by various programs |
Subscribe to:
Posts (Atom)
