Author Archives: Robins

ERROR 1714. THE OLDER VERSION OF BIOVIA LICENSE PACK 2020 CANNOT BE REMOVED. CONTACT YOUR TECHNICAL SUPPORT GROUP.

The following error appears during the installation of MS2020, as shown in the following figure:

After clicking OK, the installation is complete! Finally, it can run normally under the test. I don’t know why Error 1714 is caused. Please record it for the time being. Anyone who knows it can leave a comment, thank you!

Yaml is installed, and the error YAMLLoadWarning is reported as soon as the code runs: calling yaml.load() without Loader=… is deprecated, as the default Loader is unsafe.

Yaml is installed and the old code runs as soon as the error is reported
YAMLLoadWarning: calling yaml.load() without Loader=… is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details .

solve

You don’t need to change a lot of code and add a sentence. Just yaml.load(list, Loader=yaml.FullLoader) add Loader=yaml.FullLoader. But there are more usages. See below

Then no more errors

Configure the node environment under Linux, internal/modules/cjs/loader.js:583 throw err; solution

When installing node using the direct deployment method, internal/modules/cjs/loader.js:583 appears

After downloading the node package and decompressing it, establish a soft connection

Configure node
ln -s /root/node-v10.16.3-linux-x64/bin/node /usr/local/bin/node

Configure npm
ln -s /root/node-v10.16.3-linux-x64/bin/npm /usr/local/bin/npm

But when using npm install “XX”, I got a crazy error. I saw that it was an error when establishing a soft connection on the Internet.
Error: Cannot find module’/root/install’

Solution:
ln -sf /root/node-v10.16.3-linux-x64/bin/npm /usr/local/bin/npm

OK, solve

ORA-29913 ORA-06512 external table query prompt: error

exp:

SQL> select * from T_TEMP_LZY_QYDJ_1;

ORA-29913: an error occurred when calling out ODCIEXTTABLEFETCH ORA-30653: the
rejection limit has been reached
ORA-06512: in “SYS.ORACLE_LOADER”, line 14
ORA-06512: in line 1

Check the external table log T_TEMP_LZY_QYDJ_1_2696_1384.log, which indicates an error:

error processing column ZCLX in row 63 for datafile e: mplsbd.txt
ORA-01401: inserted value too large for column

It turns out that the column width of the table is insufficient!!

Runtime error occurred: 1843 (ORA-01843: invalid month)

1) When we use the following SQL statement
INSERT INTO “temptable” (DELIVER_DATE) VALUES (TO_DATE(’27-Jun-2007 15:57:30′,’DD-MON-YYYY HH24:MI: SS’))
Runtime error occurred: 1843 (ORA-01843: invalid month) The 
database will report an ORA-01843 error. This is because the client is in a Chinese environment, and the format mon cannot be written in English. It must be written in Chinese
If you don’t want to modify the sql statement to run in June , you need to use the alter session command to modify nls_date_language to american before executing the statement, as follows:
alter session set nls_date_language=’american’ –display the date in English
2)
Today An error of ORA-01843 has occurred. This error represents an invalid month, which is usually prompted when the date is converted. 
Solution 
alter session set NLS_DATE_FORMAT=’DD-MON-YY’; 

Redis cannot double-click redis-server.exe to start normally

Redis error: Creating Server TCP listening socket 127.0.0.1:6379: bind: No error shutdowncan not be solved

redis error message
First use redis-cli.exeand then use the shutdownfollowing error message and can not quit is:
(error) NOAUTH Authentication required.
this time redis need to enter the password set before.
127.0.0.1:6379> auth password
Enter after entering the correct password shutdownto
final execution exit
and then enter redis-server.exe redis.windows.conf to normal operation
image

fatal error C1189: #error : WINDOWS.H already included. MFC apps must not #include

fatal error C1189: #error: WINDOWS.H already included. MFC apps must not #include <windows.h>

About fatal error C1189: #error: WINDOWS.H already included. MFC apps must not #include

guitao_w 2010-03-18 21:55:00 3791 Collection
classification column: C/C++ Article Tags: mfc c
copyright
program has this problem:

fatal error C1189: #error: WINDOWS.H already included. MFC apps must not #include <windows.h>

 

The solution is as follows, under Mark

  1. Add in the stdafx.h file: #include “afx.h”  
  2. Delete in the stdafx.h file: #include <windows.h>  

[Solved] Cannot open .xlsx file, xlrd.biffh.XLRDError: Excel xlsx file; not supported

The reason is that xlrd has recently been updated to version 2.0.1 and only supports .xls files. So it x1 = xlrd.open_workbook("data.xlsx")will report an error.

You can install the old version of xlrd and run it in cmd:
it is recommended to uninstall the new version directly and download the old version of xlrd

pip uninstall xlrd
pip install xlrd==1.2.0

You can also use openpyxl instead of xlrd to open .xlsx files:

df=pandas.read_excel(‘data.xlsx’,engine=’openpyxl’)

If you are willing to be mediocre, please shoot yourself!

Java parsing xml file encounters special symbols & will be abnormal solutions

Text/Zhu Jiqian

In the development process of a Java parsing xml file, when using SAX parsing, such an exception message appeared:

Error on line 60 of document : References to the entity "xxx" must end with a ';' separator;

After I opened the xml file, I found that the “xxx” symbol was followed by an “&” symbol. Later, I learned that this type of symbol is a special symbol in xml, and if the special symbol is not represented by an escape character, it is used directly In the xml file, there will be strange exceptions when using SAX and other methods for parsing.

In fact, this is all caused by these special characters.

Special symbols in XML include <> & ‘”, etc. They are not allowed as PCDATA in xml files. If you want to use them, you need to use escape characters instead:

&lt;    <
&gt;    >
&amp;   &
&quot;  "
&apos;  '

So, if you want to read the xml file data normally, how should you use the escape character to replace it?

At the beginning, I was thinking about how to solve Baidu, but found that many posts were several years ago, and there was no clear way to solve it. Most of them mentioned that the analysis abnormality caused by special symbols, but how to filter it out, it seems It’s vague, so I can only make a fool of myself and come up with a more appropriate solution for filtering special characters.

The realization idea is actually very simple. We can read the xml file through the Reader before reading the xml file and use SAX to parse it, and then read it out by line and concatenate it into a String string, and then use the string replacement method replaceAll() After replacing the special symbols, you can directly convert the xml in the form of a string into a Document object for xml parsing:

  String xmlStr=s.replaceAll("&","&amp;");

The conversion method code is as follows:

  StringBuffer buffer = new StringBuffer();
  BufferedReader bf= new BufferedReader(new FileReader("D:\\测试.xml"));
  String s = null;
     while((s = bf.readLine())!=null){
     buffer.append(s.trim());
  }

  String str = buffer.toString();
  //In this step character replacement is performed, replacing them with legal escaped characters
  String xml=str.replaceAll("&","&amp;");

  //Here the processed xml file can be read and parsed
  Document document =  DocumentHelper.parseText(xml);

So far, you can solve the problem of special symbols & abnormalities encountered in Java parsing xml files.