Advertisements

failed to initialize container mounts: failed to create overlay fs for container: mounting overlay solution GreenGrass

https://forums.aws.amazon.com/ann.jspa?annID=6954

Greengrass currently doesn’t support Raspbian Buster or the latest kernel update for Raspbian Stretch, kernel 4.19.57. The Greengrass team is investigating what it will take to support kernel 4.19.57.

Before running apt-get upgrade be sure to block the latest kernel:

sudo apt-mark hold raspberrypi-bootloader
sudo apt-mark hold raspberrypi-kernel

 

 

Advertisements

Oracle Query Hint

https://boristyukin.com/qlikview-and-oracle-database-tips-for-performance/

Normally Oracle query hints will be written using /*+ ... */syntax. One day I spent many hours trying to figure out why one of my queries took forever to finish if I ran it from QlikView and took only a minute if I ran it from Oracle SQL Developer. Turned out that QlikView by default would strip out comments from SQL statement and treat /*+ ... */ as a comment.

This “feature” is discussed here.

Solution is easy – just use –+ syntax instead if you need to pass a query hint. Of course it is a very easy thing to forget!

 

Handy tool, Excel-SQLizer/

https://github.com/DeliciousPie/Excel-SQLizer/releases

combine NT security with user name and password #qlikview section access

The trick is in the *

You can add reducing fields after the NTNAME

 

Section Access;

LOAD * INLINE [

     ACCESS, USERID, PASSWORD, NTNAME

      ADMIN, ADMIN, welcome, *

      USER, *, *, DOMAIN\USERNAME

];

Section Application;

 

From https://community.qlik.com/thread/29846

 

Call stored procedure Oracle ODBC

Use

SQL CALL

https://community.qlikview.com/thread/12849

Oracle in OraClient 12Home2, #Qlikview, and case of field names capitalization

This was an annoying one for a bit.

Say you have this Qlikview script

LOAD

Sales_Order

;

Select ORDER_NUMBER as Sales_Order from…. ;

Well, it won’t work because the Oracle ODBC driver uppers all the returned field names, or Oracle does? Who knows?

Anyways, to make it work

LOAD

SALES_ORDER

Dynamic Variable #Qlikview

set vNewVariable = $(vTestName);

let ‘$(vNewVariable)’ = ‘Something’;