Sunday, October 28, 2007

Rename a File in Batch File

The Following helps in renaming a file using datatime stamp

// you are creating date stamp variable

FOR /F "tokens=1-4 delims=/ " %%i in ('date/t') do set d=%%k%%j%%l

// you are creating Time stamp variable

FOR /F "tokens=1-9 delims=:. " %%i in ('time/t') do set t=%%i%%j
// Here Renaming

ren abcd.doc new_%d%%t%.doc

Wednesday, September 12, 2007

“The terminal server has exceeded the maximum number of allowed connections”

“The terminal server has exceeded the maximum number of allowed connections” error can be solved and conencted to the computer by entering the following script at run

mstsc /v:11.11.11.11 /console

Replace 11.11.11.11 with your server’s IP Address or server name.

Monday, August 20, 2007

DAC Error Address already in use: JVM_Bind

The Poroblem:

DAC fails with the following error and wont restart!
ANOMALY INFO::: There is already a QSERVER running at the port 3141
Shutting down server...
MESSAGE:::Address already in use: JVM_Bind
EXCEPTION CLASS::: java.net.BindException

java.net.PlainSocketImpl.socketBind(Native Method)
java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
java.net.ServerSocket.bind(ServerSocket.java:319)
java.net.ServerSocket.(ServerSocket.java:185)
java.net.ServerSocket.(ServerSocket.java:141)
com.siebel.etl.net.QServer.bind(Unknown Source)
com.siebel.etl.net.QServer.(Unknown Source)
com.siebel.etl.net.QServer.main(Unknown Source)
6 SEVERE Mon Aug 20 00:11:25 EDT 2007
ANOMALY INFO::: There is already a QSERVER running at the port 3141
Shutting down server...
MESSAGE:::Address already in use: JVM_Bind
EXCEPTION CLASS::: java.net.BindException


Solution

netstat -a -n -o 3141

Then identify the process Id and kill that process using task manager and restart your DAC servre.

Saturday, June 9, 2007

on demand crm why or why not

on demand crm is get popularity as it is simple to impliment and maintain. The other side of the coin are the data security, customozation,integartion as per the client requirements are some of the issues need to be considered.

Richard Smith Vice President of CRM strategy, put together an article arguing why on-premise CRM is better than on-demand CRM. He brings up several good points such as security, cost, integration, and speed as to why on premise CRM is better.

you can visit his complete article at

http://www.crmblogger.com/why-on-premise-crm-is-better-than-on-demand-crm.php

Monday, June 4, 2007

Put to the Test: Oracle BI Enterprise Edition

Very good article from Cindi Howson http://www.intelligententerprise.com/channels/infomanagement/showArticle.jhtml?articleID=199200745

The tool is good at

Meta data layer as three layers number one physical layer, business modeling and mapping layer and presentation layer. Using physical layer, you can connect to any database and BMM layer provides source independence and business logical view of the report requirement. Its very simple tool and creating simple joins is a click away. Simple joiner joins with primary keys.




View blog authority

Thursday, May 24, 2007

Implementing Siebel Analytics – CRM

I would like to explain the implementation methodology for Siebel CRM analytics provided by oracle. I prefer the following methodology for implementing Siebel analytics – Customer Relationship Management (CRM)

Understanding stage:
Identify and understand the following.

How facts are calculated
Who uses them
Frequency
Key facts or measures
what are the dimensions
What are the problems areas for the business to monitor
Identify measures and dimensions
Organize dimensions and measures into subject areas.
Data sources

To know the above we need to understand

Business of the customer,
Business objectives
How the performance is measured and drilldown this measure into subject areas
Users and levels
Types of the reports

Outcome:

Subject areas identified
Facts and measures are identified
User types are identified
Data sources available

Design stage:

Compare the reports available in vanilla Siebel analytics
Start development on 75% and above matching answers and dash boards
Later add new dashboards and answers
Compare Subject areas and identify the subject areas matching with the subject areas identified
Add the subjects new subject areas only when the existing subject areas not meeting the requirements
Align the repository design according to the subject area requirements.
Start either from the presentation layer or business model layer

Validate and testing:

1. Validate and test whether the user requirements are met and then follow from the understanding stage.

Tuesday, May 8, 2007

Practice Linux online

Today I found an excellent web for newbies to Linux. The site offers both tutorials and also online terminals such telnet, ssh or java telnet client. Using one of these clients you can login to remote virtual machine by root user and start practicing your sessions from the tutorials.

The site is http://linuxzoo.net , first you need to
Register and login to account links.

After that join queue
Then switch on the system.

Once you get the run or completed prompt, go to connect and copy the url/ip to your telnet client.
That’s all it so nice.