Sunday, November 10, 2013

Sharepoint 3.0 , Search not working

One of our sharepoint 3.0 which comes with the Project server has a search problem, some users cannot search at all . After testing at UAT we find that to resolve it need to run the sharepoint update (infrastructureupdateforwindowssharepointservices3.0-kb951695-fullfile-x86)

This is how we do it,

Backup the sharepoint using stadm
Run the Sharepoint Update ( at this point we have the error that it cannot upgrade due to the the The B2B upgrader timer job failed ) which is at the steps 8.

To resolve this we follow the link here , at this part

Here is what I did:

I copied web.config file from 12\CONFIG to 12\TEMPLATE\LAYOUTS.

The I did run:
psconfig -cmd upgrade -inplace b2b -force -wait

That's it.
After this, we manage to upgrade we find that the search is working fine. But then we have the exception error in SQL server 2005
the mssql dump looks like due from sharepoint search sql

From the sql server logs,
SqlDumpExceptionHandler: Process 71 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION

SQLDUMPER_UNKNOWN_APP.EXE, ValidateModule: Potential image problem at 0x77E64841: read 0xE9 instead of 0x8B (module C:\WINDOWS\system32\kernel32.dll)

From the sharepoint logs,
CSqlCrawl::ExecuteCommand fails Error 0x80004005 - File:d:\office\source\search\search\gather\server\gathersql.cxx Line:408

Based on the error , suspect due to the SQL Server 2005. We upgrade it to SP4 and the issue resolve perfectly.

Tuesday, January 03, 2012

Linux, finding out the hidden process that is using the port

Follow this link,

netstat -tapn

Active Internet connections (servers and established)

Local Address Foreign Address State PID/Program name
*:printer *:* LISTEN 988/inetd
bigcat:8000 *:* LISTEN 1064/junkbuster
*:time *:* LISTEN 988/inetd
*:x11 *:* LISTEN 1462/X
*:http *:* LISTEN 1078/httpd
bigcat:domain *:* LISTEN 956/named
bigcat:domain *:* LISTEN 956/named
*:ssh *:* LISTEN 972/sshd
*:631 *:* LISTEN 1315/cupsd
*:smtp *:* LISTEN 1051/master

which will be able to show the process

Sunday, July 17, 2011

Windows 7, 32bit/64bit running Virtual Box and VPN

If you're using a virtual Machine under virtual box and using the software cisco checkpoint VPN-
1 Secure Client NGX R60 to connect to your office vpn
1. First you need to setup your VM network connection as bridge connection.
2. If facing problem in the phase 1 of the vpn connection while defining your site you can do this. From another PC with good working VPN connection, export out the registry including subfolder
then shutdown the good vpn client services. After that copy the folder C:\Program files\CheckPoint\SecureRemote\database
Then , in the VM while shutting down the vpn client services register the reg that you copy from the good PC and also replace the original database folder in the VM
After that restart back the secureremote services. The site now exists for you to run.

Tuesday, January 04, 2011

Resolving ORA-24005 Queue error ,when dropping a schema or a table

Follow this link,

SQL> execute DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => ‘DECIPHER_AQ_DEMO’, force => true);

Same can be used on getting ORA-24005 while dropping table

Sunday, November 28, 2010

Resolving tempdb log file is full in SQL2000

In SQL 2000, if you have the error,

"The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space."

To resolve this you need to truncate the log file by using

dump log tempdb with truncate_only

the normal backup log command won't work in this case

Thursday, October 28, 2010

sendmail, Solving ‘host name lookup failure’ at name server

To solve the problem of 'host name lookup failure’ on sendmail, first you need to determine if it's really this problem.

check the /var/log/maillog , there should be entry such as below

xxxxxx sendmail[30685]: o9T3l3Pe030683: to=, ctladdr= (0/0), delay=00:00:00, xdelay=00:00:00, mailer=relay, pri=120354,, dsn=4.0.0, stat=Deferred: Name server: host name lookup failure

Then we try to nslookup the mail server, by dig It should show that the connection is time out.

; <<>> DiG 9.3.4-P1 <<>>
;; global options: printcmd
;; connection timed out; no servers could be reached

Next, we can resolved this by setting up name server or put the mail server into the /etc/mail/mailertable .

First by checking the /etc/nsswitch.conf to see if we are using hosts file.
#hosts: files dns

Then do the following to create the entry in the mailertable. smtp:[]

then we hash the file to the mailertable.db
makemap hash /etc/mail/mailertable < /etc/mail/mailertable

after that, restart the sendmail by running service sendmail restart

Reference link

Wednesday, September 29, 2010

Logical Standby with Apply Process Fails With ORA-308

Recently, we encounter the Logical Standby Apply Process Fails With ORA-308 while testing the logical standby. Due to the archive log in Logical is automatically delete after a while.

To solve it, we first stop the automatically delete archivelog
exec dbms_logstdby.apply_set('LOG_AUTO_DELETE', 'FALSE');

Then, We check the ASM diskspace for the archivelog that is needed by standby.
Then we copy the archive log to the local folder for transfering it to standby by issuing below . The FLASH_DIR and EXPORT_DUMP_DIR is oracle directory, FLASH_DIR is the ASM disk space like +FLASHGRP/TESTDB/archivelog/


After copying the file to standby, then we need to register the archivelog using below method.

Register the log file in standby

SQL> alter database register logfile '/TESTDB/archive/1_3470_694714878.dbf';

alter database register logfile '/TESTDB/archive/1_3470_694714878.dbf'


ERROR at line 1:

ORA-01289: cannot add duplicate logfile

If failed , then we have to update the logmnr table manually,

Stopped the logical standby.

SQL> alter database stop logical standby apply;

SQL> select file_name from system.logmnr_log$ where sequence#=3470;





FILE_NAME= 2 '/TESTDB/archive/1_3470_694714878.dbf' where sequence#=3470;

1 row updated.

SQL> commit;

Commit complete.

SQL> alter database start logical standby apply;

Database altered.

Logical Standby Apply Process Fails With ORA-308 [ID 274676.1]