Wednesday, November 28, 2018

Windows command prompt tips


View command history  type this line
C:\doskey /history

You can also view history by pressing the F7 key on current command windows.

Copy doskey history in text file

C:\doskey /history >C:\commands.txt

Set parameter command prompt to not remember any command history

C:\doskey /listsize=0

Keyboard shortcut for clear command history   alt + F7
On current command windows.

Friday, November 23, 2018

Tomcat Error for Port number already in use

Exception :
org.apache.catalina.LifecycleException: Protocol handler start failed
at org.apache.catalina.connector.Connector.startInternal(Connector.java:960) ~[tomcat-embed-core-9.0.12.jar:9.0.12]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) ~[tomcat-embed-core-9.0.12.jar:9.0.12]
at org.apache.catalina.core.StandardService.addConnector(StandardService.java:225) [tomcat-embed-core-9.0.12.jar:9.0.12]
at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.addPreviouslyRemovedConnectors(TomcatWebServer.java:259) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
at org.springframework.boot.web.embedded.tomcat.TomcatWebServer.start(TomcatWebServer.java:197) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.startWebServer(ServletWebServerApplicationContext.java:300) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.finishRefresh(ServletWebServerApplicationContext.java:162) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) [spring-context-5.1.2.RELEASE.jar:5.1.2.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:316) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1260) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1248) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
at com.mkyong.springbootwebjsp.SpringBootWebJspApplication.main(SpringBootWebJspApplication.java:16) [classes/:na]
Caused by: java.net.BindException: Address already in use: bind
at sun.nio.ch.Net.bind0(Native Method) ~[na:1.8.0_191]
at sun.nio.ch.Net.bind(Unknown Source) ~[na:1.8.0_191]
at sun.nio.ch.Net.bind(Unknown Source) ~[na:1.8.0_191]
at sun.nio.ch.ServerSocketChannelImpl.bind(Unknown Source) ~[na:1.8.0_191]
at sun.nio.ch.ServerSocketAdaptor.bind(Unknown Source) ~[na:1.8.0_191]
at org.apache.tomcat.util.net.NioEndpoint.initServerSocket(NioEndpoint.java:236) ~[tomcat-embed-core-9.0.12.jar:9.0.12]
at org.apache.tomcat.util.net.NioEndpoint.bind(NioEndpoint.java:210) ~[tomcat-embed-core-9.0.12.jar:9.0.12]
at org.apache.tomcat.util.net.AbstractEndpoint.start(AbstractEndpoint.java:1108) ~[tomcat-embed-core-9.0.12.jar:9.0.12]
at org.apache.coyote.AbstractProtocol.start(AbstractProtocol.java:550) ~[tomcat-embed-core-9.0.12.jar:9.0.12]
at org.apache.catalina.connector.Connector.startInternal(Connector.java:957) ~[tomcat-embed-core-9.0.12.jar:9.0.12]
... 14 common frames omitted


Solution:
Use command prompt using Window + R then type CMD

Friday, November 2, 2018

Unable to connect to the remote server

This error come when Report Server is not active.

Start report server for this error.

Tuesday, October 30, 2018

Send Excel Report through Excel mail service

Follow these steps to have Excel e-mail the reports for you:
Step1: Open the workbook containing the report you want to send.
Step2: Press [Alt][F11].
Step3: In the Project-VBA Project pane, double-click ThisWorkbook.
Step4: Go to Insert --> Procedure ,Click in the Name text box and enter TestReportEmail. Click OK.
Step5: Add this code in added method for send email.
Dim DistList As Variant
DistList = Array("test1@company_name.com", "test1@company_name.com", "test1@company_name")
ActiveWorkbook.Sendmail Recipients: = DistList
Step6: Press [Alt]Q.
Step7: Press [Alt][F8].
Step8: Click TestReportEmail in the Macro list.
Step9: Click the Options button.
Step10: In the Ctrl+ box, enter m. Click OK.

Django Application

Site to follow for Django Python application
1. a-complete-beginners-guide-to-django-part-4

Saturday, October 13, 2018

Tomcat 9 showing error for maven application deployment

Showing below error message when start tomcat 9 with maven onlinetest  application installed on server.




Unable to acquire the state change lock for the module osgi identity in Eclipse Neon 3

Follow these step to resolve this issue in Eclipse Neon.3
Go to this path and delete .fileTableLock

D:\eclipseneon\eclipse\configuration\org.eclipse.osgi\.manager



No goals have been specified for this build. You must specify a valid lifecycle phase or a goal.

c:\spring\demo>mvn -P pom.xml

Activate new pom.xml profile.

use this command
c:\spring\demo>mvn clean

No goals have been specified for this build. You must specify a valid life cycle phase or a goal in the format

For this issue use this command

c:\spring\demo>mvn package