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.