2019-10-31

the minifi can not be installed as a service or the service do not start

error in the log file of the minifi, when trying to run install-service.bat in order to run minifi as a service

Exception in thread "main" on: .\conf\config.yml (The system cannot find the path specified)


solution:
edit bootstrap.conf and edit the config file folder as a full path  (see below) 
Double the \ if you are on windows !

# The location for the configuration file
# When running as a Windows service use the full path to the file
nifi.minifi.config=C:\\minifi-0.5.0\\conf\\config.yml


from the manual
https://nifi.apache.org/minifi/system-admin-guide.html


Running as a Windows Service

MiNiFi can run as a Windows service. To do so, you must modify the conf/bootstrap.conf to set absolute paths for some properties. The properties are:
  • lib.dir (e.g. C:\\minifi-x.x.x\\lib)
  • conf.dir (e.g. C:\\minifi-x.x.x\\conf)
  • nifi.minifi.config (e.g. C:\\minifi-x.x.x\\conf\\config.yml)
You can now install the MiNiFi service by running the install-service.bat script. To remove the service run the delete-service.bat file.
The minifi.exe in MiNiFi bin directory is used to run MiNiFi Windows service. The bundled one is for 64 bit architecture and requires 64 bit JRE. If you have to use 32 bit JRE for some reason, you need to replace the minifi.exe file with the one for 32 bit to make MiNiFi service runs successfully. To do so, go to Commons Daemon project download page, download the binary (e.g. commons-daemon-1.1.0-bin.zip), extract it and replace bin/minifi.exe by copying commons-daemon-x.x.x-bin/prunsrv.exe into MiNiFi bin directory as minifi.exe to overwrite the 64 bit exe with the 32 bit one.

2019-10-25

microstrategy list of graphical commands

Please notice that you need to open your “<HOME_PATH>/bin” to find these files: 
MicroStrategy Command Manager – mstrcmdmgrw
MicroStrategy Configuration Wizard – mstrcfgwiz
MicroStrategy Connectivity Configuration Wizard – mstrconnectwiz
MicroStrategy DB Query Tool – mstrdbquerytool
MicroStrategy Diagnostics and Performance Logging – mstrdiag
MicroStrategy Health Center Configuration Wizard – mstrsuppappcfgwiz
MicroStrategy Health Center Center Console – mstrsuppappgui
MicroStrategy License Manager – mstrlicmgr
MicroStrategy ODBC Administrator – mstrodbcadx
MicroStrategy Service Manager – mstrsvcmgr


2019-09-30

postgresql partitions partition of table from to inclusive

When creating a range partition, the lower bound specified with FROM is an inclusive bound, whereas the upper bound specified with TO is an exclusive bound.

So in fact in
CREATE TABLE parsel_2014_10 PARTITION OF parsel_part 
     FOR VALUES FROM ('2014-10-01') TO ('2014-10-31');
the date 2014-10-31 is not included in this partition, and hence nowhere in all your partition tables (and same for all ending dates)

6 doctors

“Six Best Doctors in the World…
  • Sunlight
  • Rest
  • Exercise
  • Diet
  • Self Confidence
  • Friends”

2019-09-10

ora-00604 ORA-01882: timezone region not found

ORA-604 and ORA-01882 With JDBC Connections to Database 11.2.0.3 (Doc ID 2291718.1)

SOLUTION


Apply patch:13417321   DST 18 : HALF YEARLY DST PATCHES, MAY 2012  to the 11.2.0.3 database.
The timezone Etc/UTC support for Oracle database 11.2.0.3.0 is added via DSTv18 Patch 13417321.
Refer to:
Bug 13417321    - DST 18 : HALF YEARLY DST PATCHES, MAY 2012
Applying the DSTv18 update for the Oracle Database (Doc ID 1448706.1)

Or

As a workaround, set the TZ variable to UTC ($ export TZ=UTC) or use -Duser.timezone=UTC to change it in the JVM. Then, restart the application.

Or

set the connection property oracle.jdbc.timezoneAsRegion to "false".

(This option is not recommended as it will revert to sending a fixed offset on the connection and can reintroduce incorrect DST related behavior, which is why the change in JDBC to use timezone name/region directly if it is a known Oracle one rather than convert to a GMT offset was done in the first place).