Java Solutions

Thursday, April 13, 2023

Solved-Why Grammarly does not show when I re-open word?

If you have to add Grammarly each time you re-open Microsoft Word or other applications to use Grammarly, this is the solution for you.

1. Right-click the round Grammarly button that appears when you start writing. Select Settings

Tip:

If you don't see the round Grammarly button when you start typing, you can open the Grammarly app by double-clicking the Grammarly icon on your desktop or searching for it in your system. Once it's up, click Settings.

2. In the Settings pane, select the Block List tab, then click the Remove to let Grammarly show in your application.

3. If you want to turn it off, go to step 1. Instead of choosing Settings, select Turn off suggestions in Microsoft Word.

Saturday, March 12, 2022

Solved - Uninstall / Remove Fortinet / FortiClient on Windows

Once the FortiClient was installed on my PC, I could not disable or uninstall it even though I have not used it for about two years. I am so glad that I eventually removed it from my computer by following the instruction on a website.

Click HERE to read the original post.

1. Make sure to disconnect the FortiClient from the server and close the FortiClient.

2. Click the Start and type Command to find the Command Prompt app. Right-click on it and select run as administrator.

3. Execute the command below to ensure it returns what you want to remove.

wmic product where "name like 'Forti%%'"

4. Execute the command below to uninstall FortClient.

wmic product where "name like 'Forti%%'" call uninstall /nointeractive

It may take some time to finish and restart your computer without warning.

Monday, February 14, 2022

Crystal Reports: How to suppress the display of a field / column with a Boolean condition

A. Use Crystal Report Suppress

1. Open the rpt template in SAP Crystal Reports, right click on the field you want to suppress, and select Format Field.

2. Select the Common tab in the Format Editor window, check the Suppress, and click on the corresponding X-2 button.

3. In the popped up window, enter a boolean value to specify when to suppress the field. A true value will suppress the field display and a false value will allow it to display.

4. Click the Save and close to save.

B. Use Crystal Report Formula

1. Click the View menu and select Field Explorer.

2. Right-click the Formula Fields and choose New, enter a formula name, and click OK.

3. Write your condition for displaying the field values.

4. Click the Save and close to save.

Saturday, December 11, 2021

Use the Speak to read aloud your Microsoft Office document - Listen to your Word document

If you would like to know how your Word document sounds, you may follow the steps below to let the Speak read your Microsoft Word document to you.

A. Add Speak to the Quick Access Toolbar

1. Click on the Custom Quick Access Toolbar located in the top-left corner of the Work editor and select More Commands.

2. In the popped-up window, select All Commands from the left, scroll down to select Speak, click the Add button to add Speak to the Customize Quick Access Toolbar on the right side, and click the OK button at the bottom.

3. Check that the Speak selected text icon displays in the top-right corner.

B. Select the text you want to hear and click the Speak to let it read the text aloud.

Monday, December 6, 2021

Solved - java.sql.SQLException: ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.

The issue occurs when the archivlogs or backups ocupy too much space. You can follow the steps below to remove some of the files.

1. Login to your system as the oracle user.

2. Type rman on the command line and hit the enter.

[oracle@linux]$> rman

3. Connect to the target database.

RMAN> connect target

4. Delete the backups or obsolete backups.

RMAN> delete obsolete;

or delete all backups:

RMAN> delete backup;

5. Remove archive logs.

RMAN> delete force copy of archivelog all;

6. RMAN> exit

Wednesday, November 24, 2021

Solved - Your camera has been occupied by other apps, please release the privilege and try again

If you get the message while turning on the video at a Zoom meeting, you may fix it following the steps below.

1. Click Start and select Settings.

2. Click on the Apps to open the Apps & Features window.

3. Click on the Camera to show the Advanced options.

4. Click on the Advanced options to open the Camera window. Scroll down and click on the Reset button to reset the camera.

5. Restart your computer.

Friday, November 5, 2021

Solved - unrecognized project; missing plug-in

After I cloned a web service project, I got a "unrecognized project; missing plug-in" message when I was trying to open it in NetBeans.

I fixed it by installing the Java EE base plug-in by following the steps below.

1. Click the Tools in the top menu of Apache NetBeans IDE and select Plugins.

2. Select the Available Plugins tab in the pop-up Plugins window.

3. Right click on the Java EE base plug-in and install it.

Before you install the Java EE base plug-in, check the nbproject/project.xml file to confirm that the type is <type>org.netbeans.modules.web.project</type>

Sunday, May 2, 2021

Solved - The group policy setting for bitlocker startup options are in conflict and cannot be applied

To fix this problem:

1. Click at the Window icon at the bottom-left corner of your PC, and type regedit. Then, open the regedit window.

2. Delete all the entries in the HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\FVE directory except the first Default entry.

3. Restart your computer.

-----------------------------------------------------------------------------------------------------------------

If you have ever asked the questions below, you will benefit from reading this book.
What is the meaning of life?
Why do I have to suffer?
How can I have the life I like to have?
How can I be the person I want to be?
How can I have good and harmonious relations with others?

What is the true meaning of spiritual practice? Check it out here.

Cannot save to USB drive without BitLocker encryption - Windows

After you insert a USB drive to your computer, the following message pops up.

Since you don't want the drive to be read-only, you select to encrypt the drive. Then, the follow message shows up.

So, you click the Cancel button. Upon you are trying to save a file on the USB drive, it shows the following message.

To fix this problem:

1. Click at the Window icon at the bottom-left corner of your PC, and type regedit. Then, open the regedit window.

2. Delete all the entries in the HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\FVE directory except the first Default entry.

3. Restart your computer.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Monday, April 19, 2021

how to set the default java platform in NetBeans

1. Open the netbeans.conf file located in C:\Program Files\netbeans 11.0\etc directory.

2. Search the file for netbeans_jdkhome.

3. Change the value of the netbeans_jdkhome to the desired java path and save the change.

4. Restart the NetBeans IDE.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Thursday, April 15, 2021

Not copying library C:\MyProjects\ImportantProject , it's a directory.

When I was doing a Clean and Build on the ImportantProject in NetBeans, I got the following messages in the Output.

Created dir: C:\MyProjects\ImportantPorject\build

Updating property file: C:\MyProjects\ImportantPorject\build\built-jar.properties

Created dir: C:\MyProjects\ImportantPorject\build\classes

Created dir: C:\MyProjects\ImportantPorject\build\empty

Created dir: C:\MyProjects\ImportantPorject\build\generated-sources\ap-source-output

Compiling 35 source files to C:\MyProjects\ImportantPorject\build\classes

Copying 21 files to C:\MyProjects\ImportantPorject\build\classes

compile:

Copying 1 file to C:\MyProjects\ImportantPorject\build

Not copying library C:\MyProjects\JRx30 , it's a directory.

Copy libraries to C:\MyProjects\Vendors\lib.

When I expanded the ImportantProject and then the Libraries folder, I saw that the C:\MyProjects\ImportantPorject had been part of the libraries.

After removing the C:\MyProjects\ImportantPorject from the libraries, the red line of message disappeared.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Tuesday, April 13, 2021

ORA-03113: end-of-file on communication channel

When you were trying to start the Oracle database, you had the following on your screen.

SQL> STARTUP

ORACLE instance started.

Total System Global Area 6442450944 bytes

Fixed Size 2938792 bytes

Variable Size 1224738904 bytes

Database Buffers 5200936960 bytes

Redo Buffers 13836288 bytes

ORA-03113: end-of-file on communication channel

Process ID: 13761

Session ID: 237 Serial number: 2961

To fix this problem, first check if it was due to no free memory available for the database. Run the command free -g as the root user.

[root@testMachine]# free -g

total used free shared buff/cache available

Mem: 3 0 2 0 0 2

Swap: 3 3 0

If it is necessary, remove some of the old log files in the directory of $ORACLE_BASE/diag.

Reboot the linux machine to release the memory occupied by processes.

Restart the database.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Monday, March 8, 2021

CrystalReports: ORA-01840: input value not long enough for date format

Error opening CustomerInfo report.

Unexpected database connector error

ORA-01840: input value not long enough for date format

The above error will happen if a date field in the database has a NULL value.

You can fix it by either changing your SQL to replace the NULL value with a valid date value such as using the function nvl(fieldName, ValidDate), or making the date field in the database not null.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Tuesday, February 2, 2021

ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

When you were trying to connect to your Oracle database, you received the following errors.

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3640
Additional information: 2007875791
Process ID: 0
Session ID: 0 Serial number: 0

Here are the steps to fix it.

SQL>sqlplus /NOLOG
SQL> connect / as sysdba;
SQL> SHUTDOWN IMMEDIATE

You may get the error message again.

       ERROR:
        ORA-01034: ORACLE not available
       ORA-27101: shared memory realm does not exist
       Linux-x86_64 Error: 2: No such file or directory
       Additional information: 3640
       Additional information: 2007875791
       Process ID: 0
       Session ID: 0 Serial number: 0
SQL> STARTUP
ORACLE instance started.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Saturday, January 23, 2021

400 Bad Request / request header or cookie too large / nginx

You see this error display on your web browser when you are navigating to some site.

To fix it, you need to delete the cookies specific to the website your trying to open.

In Chrome, click the three verticle dots on the top-right corner and select Settings.

Scroll down to the Privacy and security section and click on the Cookies and other site data.

In the new window, click on See all cookies and site data

Find your website, open it and remove all the cookies.

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Friday, January 15, 2021

sftp in Java

The code below shows how to transfer a file from one machine to another via sftp.

Session session = null;
ChannelSftp sftp = null;

try {
JSch jsch = new JSch();
session = jsch.getSession(username, remoteIPAddress);
session.setPassword(password);
session.setConfig("StrictHostKeyChecking", "no");
session.connect();

com.jcraft.jsch.Channel channel = session.openChannel("sftp");
channel.connect();
sftp = (ChannelSftp) channel;

//Get a file from a remote machine
String path = sftp.pwd(); //remote path

//If the file is located in a different directory, switch to that directory
sftp.cd("<the path>");
sftp.get("<the file>", "<local directory where you want the file to be>");

//Send a file to a remote machine
sftp.lcd("<local directory that has the file>");
sftp.put("<file name>", ".");
sftp.exit();
sftp.disconnect();
session.disconnect():

} catch (JSchException je) {
Log.instance().error(je);
System.out.println("Failed to restart rx30css for the store.");
}

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Execute multiple commands one after another in Java

Let's say you want to execute the commands below on a remote Linux machine using a java program to restart program A.

cd /home/projectA
/home/projectA/stopProgramA
/home/projectA/startProgramA

You can use the code below to get them done.

JSch jsch = new JSch();
session = jsch.getSession(username, remoteIPAddress);
session.setPassword(password);
session.setConfig("StrictHostKeyChecking", "no");
session.connect();

ChannelExec channelExec = (ChannelExec) session.openChannel("exec");
channelExec.setCommand("cd /home/projectA && /home/projectA/stopProgramA && /home/projectA/startProgramA");

channelExec.setErrStream(System.err);
channelExec.connect();

TimeUnit.SECONDS.sleep(10);
channelExec.disconnect();
channelExec = null;

session.disconnect();

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Monday, October 26, 2020

How to find out all the Java versions installed on a linux machine?

Use the command below to get all the java versions installed.

update-alternatives --display java

-----------------------------------------------------------------------------------------------------------------

What is the true meaning of spiritual practice? Check it out here.

Tuesday, October 20, 2020

Crystal Reports: ORA-12170: TNS:Connect timeout occurred [Database Vendor Code: 12170]

In the SAP Crystal Reports editor, you open the Database Expert and trying to view/edit the command, after you have entered your database login credentials you received the following error.

This can be caused by several issues. The following are some of the ways to fix it.

1. ping the database machine to make sure you can access that machine.

2. Check if the database host of your Oracle Instant Client is using the correct IP address. If you are accessing the database on a remote machine, localhost or 127.0.0.1 will not work.

a. Open your Control Panel.

b. Open the Administrative Tools window.

c. Right-click on the ODBC Data Sources and open it.

d. Select the System DSN tab to look for the Driver used by your data source.

e. Select the Drivers tab and locate your driver.

f. Open a file explorer, go to Program Files (x86)\Oracle Instant Client\<your driver>.

g. Open the tnsnames.ora file in a text editor, change the HOST = <the correct database IP address>

3. Make sure the firewall is not blocking the connection.

-----------------------------------------------------------------------------------------------------------------

If you have ever asked yourself these questions, this is the book for you. What is the meaning of life? Why do people suffer? What is in control of my life? Why is life the way it is? How can I stop suffering and be happy? How can I have a successful life? How can I have a life I like to have? How can I be the person I like to be? How can I be wiser and smarter? How can I have good and harmonious relations with others? Why do people meditate to achieve enlightenment? What is the true meaning of spiritual practice? Why all beings are one? Read the book for free here.