[XML/Saxon7] Saxon could not evaluate XQuery: Error on line xyz A sequence of more than one item is not allowed as the 19th argument of concat()

I wanted to extract information from a software generated XML using XQuery by the according jEdit plugin. However, I could not find a real work-around for mentioned error. I believe that the cause is the name of a specific XML element of the document I want to query.
Interesting part of the XML document:

            <sessionextension name="Relational Writer" sinstancename="KDS_E_PART_PARTEI" subtype="Relational Writer" transformationtype="Target Definition" type="WRITER">
                <connectionreference cnxrefname="DB Connection" connectionname="" connectionnumber="1" connectionsubtype="" connectiontype="Relational" variable="$DBConnection_Tgt">
                <attribute name="Target load type" value="Bulk">
                <attribute name="Insert" value="YES">
                <attribute name="Update as Update" value="NO">
                <attribute name="Update as Insert" value="NO">
                <attribute name="Update else Insert" value="NO">
                <attribute name="Delete" value="NO">
                <attribute name="Truncate target table option" value="YES">
</attribute></attribute></attribute></attribute></attribute></attribute></attribute></connectionreference></sessionextension>

It is the ATTRIBUTE element. So my working query is

(: constant definition :)
   let $indent := "   "
   let $linebreak := "
"

(: main :)
   (: walk the worklets :)
   for $writer in /POWERMART/REPOSITORY/FOLDER/WORKLET/SESSION/SESSIONEXTENSION[@TYPE = "WRITER" and (starts-with(@SINSTANCENAME, "KDS_E_") or starts-with(@SINSTANCENAME, "KDS_I_") or starts-with(@SINSTANCENAME, "KDS_S_") or starts-with(@SINSTANCENAME, "KDS_T_"))]
   where ($writer/CONNECTIONREFERENCE[@VARIABLE != "$DBConnection_Staging"] and $writer/ATTRIBUTE[@NAME = "Truncate target table option" and @VALUE = "YES"])
   return
      concat($writer/../../@NAME
            ,$linebreak
            ,$indent
            ,$writer/../@NAME
            ,$linebreak
            ,$indent
            ,$indent
            ,$writer/@SINSTANCENAME
            ,$linebreak
            ,$indent
            ,$indent
            ,$indent
            ,"Connection: "
            ,$writer/CONNECTIONREFERENCE/@VARIABLE
            ,$linebreak
            ,$indent
            ,$indent
            ,$indent
            ,"Truncate target table option: YES"
      )

Initially I tried to have the analogous solution to the CONNECTIONREFERENCE solution for the ATTRIBUTE element but within the concat function it throws mentioned exception

Thoughts on DWH

• No insignificant attributes, i.e. either an attribute is
• primary key (surrogate key) uniquely marking the individual record
• unique key (business key)
• surrogate key business by which delta detection join is done (if one gets snapshot data), integrates business keys of different systems making key handling simpler
• foreign key referencing the business surrogate key
• payload being considered in comparison for the delta detection
• Only attributes used for calculations are of number type, e. g. keys, codes are not
• Flags are numeric(1) as they tend to be used to be counted over. 1 means true, -1 means false, no other value but NULL is allowed
• One process, one target table: if there are several source eventually loading a target, keep the flows separate as long as the handling of the data is not the same, to ease the debugging and unite the flows with a union operation in a process on its own such that the truncating of the target remains possible
• Write all processed data (unless directly filtered from the source) into (intermediate) target table. This makes completeness checks easier.
• The use of one UUIDs/GIDs for alle the surrogate keys makes Management between different environments easier because of fewer dependencies.
• For surrogate key values use a generator as close to the data storage as possible, e. g. database fucntions and make the filling an automatic process independent from the feeder. This helps avoid messed keys. Fiddling the key values is takes more effort but this should be the case of exception anyway.
• A process step shall be able to get restarted without producing data mess, either by discarding already processed data (truncate target table) or by taking already processed data into account
• A process step should be runnable on its own for ease of (unit) testing
• Process abortion better than problem logging as logged information usually is not being monitored and not corrected
• Raw area contains data 1 : 1 as received (no constraints at all)
• Staging area contains data having been checked (cleansed)
• unique constraints
• referential constraints
• value boundary constraints
• Temporary area contains tables with intermediary values
• those tables get truncated before an individual load, i.e. no joint use of a target table
• those tables can be used between raw and staging or staging and core
• any number of tables used get from raw to staging or from staging to core is fine
• Core area contains the fully integrated data being the only source for consumers marked by either (convention, choose one and stick to it even in hell):
• position, e.g. second attribute of the table
• its index name starts with a marker, e.g. BSI
• its attribute name
• At least in the last temporary table before core business surrogate key must be known
• The last step from to core (creation surrogate key and history) is done by generated code as the creation of history is a well known process without variation. Rules can be derived from the data dictionary of the data base (see also https://sourceforge.net/p/pg-scd/wiki/Home/).
• The data copy to the database is done by generated code as it is a mere 1:1 copy. Rules can be derived from the data dictionary of the data base. Maybe external tables can be used.
• Generated and executed code is to be logged.
• Small increments in features/fixes (e. g. Scrum)
• reduce risks
• make happy because one sees improvements fairly often
• can be handled easier
• are defied by monolitc deployments (i. e. if you can deploy a specific technology - e.g. PowerCenter - only if you deploy all objects of that technology, you usually have so many time dependencies within that technology that you cannot deploy small increments)
• Fall back systems can be used to provide almost seemless service provision only if it does not take much time to migrate data (data migration can be automated and as well as the switch to the already migrated system). Database replication might help.
• Delta deliveries, i. e. only data that has been changed or "deleted" with respective marker, is preferable because the amount is significantly less and delta detection/handling is easier with historised tables (SCD2). Missing data delivery is not more grave - leading to unchanged or not closed records - than with such of snapshot deliveries - leading to wrongly closed records instead of changed or unchanged records.
• Interfaces to other systems be it sources or consumers should sport a layer which provides development indepence as far as possible. One possibility is the use of views in database Environments, another data container of which the sole purpuse is the privision of the data from sources or to consumers such that changes within a system can be unwound exclusively within that system.
• In an environment where data needs to be anonymised, it is important that at occasions that data can be traced back to individuals, one can set up a non-disclosed table to map identifying data to a purely technical surrogate key.
• To setup naming conventions you should first decide whether the ordinary development is vertical or horizontal:
• vertical: A change is being developped from the first source to the final target in "one go" before moving to the next Change.
• horizontal: Changes are being developped layer by layer, i.e. all changes affecting one layer are being implemented before changes of the next layer are being implemented
If vertical development is preferred - I have not come accross horizontal development - make the names group by the topic (usually the final target table) go to the beginning of the name only possibly preceeded of technological information like 'df' for dataflow, 'wf' for workflow, 'm' for mapping and so on. Layer information stays at the end. E. g. m_SALES_FACT_s2t. In case of horizontal development make the names group by the layer putting that information in front of the topic.

[Citrix] Unrecognisable proxy server

Fresh install of a Linux system and trying to connect to the remote host by Citrix gives the error (in German) but the meaning is the one of the title.

Proxyserver kann nicht erkannt werden.
SendenSie folgende Informationen an den Helpdesk:
Proxyerkennung ist fehlgeschlagen: HTTP-Download von PAC-Skript ist fehlgeschlagen: Fehlende Internetbibliothek.

I suppose Schroeffu's solution is just a work around however, it works for me:
Put the following line into the section

[WFClient]

of file

~/.ICAClient/wfclient.ini

ProxyFallback=yes

I did not try out its alternative.

[Subversion] Meta data format version of the working copy

For all the versions (I think as of version 1.7) that store the meta data not any longer in files but in a SQLite database, the entries in .svn/format or .svn/entries are plainly wrong. They might be a left over of previous client versions.
You need to execute

PRAGMA user_version

against the working copy database .svn/wc.db.
You can do so with  DB Browser for SQLite or on the command line

sqlite3 .svn/wc.db "PRAGMA user_version"

I found this at https://stackoverflow.com/questions/19265363/find-out-svn-working-copy-version-1-7-or-1-8

Meta data format version	Client version
31	1.8.x
32	1.9.x
Meta data format version	Client version

[jEdit] not-empty files files without text, files do not open without error

Symptoms

All of a sudden, not knowing what went wrong, I could not open any files any longer without getting an error; two files that were open, displayed no text even there ought to have be text. jEdit was utterly unusable.

Solution

I reverted to previous setting files set out of the settings-backup directory.

[Citrix Receiver/ICAClient] Windows 10 client very laggy

Symptom

The laptop to which I connect side is on Windows 7 but my local machine is on Windows 10. I previoulsy connected from the Linux client on various distributions and the connection just was fine. The notorious mouse pointer shadow is disabled and no theme on the laptop side.

"Cause"

It seems that Windows 10 handles TCP stuff espacially its windows size.

Try

playing around with the autotuning settings. By default it is set to normal.

netsh interface tcp set global autotuninglevel=disabled

netsh interface tcp set global autotuninglevel=highlyrestricted

netsh interface tcp set global autotuninglevel=restricted

netsh interface tcp set global autotuninglevel=normal

Details at https://technet.microsoft.com/en-us/library/cc731258(WS.10).aspx
Be aware, however, it might have negative impact on other TCP using applications!
However, this did not easen my pain with Citrix.

[Citrix Receiver/ICAClient] Connection dialog frozen

Setup

• Windows 10 Home
• dual screen setup (one on HDMI set to main by Windows settings, one on VGA of the onboard graphics)
• Citrix Receiver 4.8 (4.5, 4.6 and 4.7 sport the same behavior)
• Connection to Citrix session over web link downloaded in browser

Symptom

The Citrix Receiver process freezes at connection dialog and has to be kill by process management.

Work around

• Either use VGA screen as main screen
• Or deactivate VGA screen

Also

• Linux receiver at least 13.4 and 13.5 seems to be affected as well
• see https://discussions.citrix.com/topic/387808-47-on-multi-screen-windows-10-home-buggy/

[Tumbleweed] replacements for deprecated tools

Program	Obsoleted by
arp	ip neigh
ifconfig	ip addr
ipmaddr	ip maddr
iptunnel	ip tunnel
netstat	ss ip route (netstat -r) ip -s link (netstat -i)
route	ip route
mii-tool	ethtool
nameif	ifrename

see Linux Foundation and blog

[Citrix Receiver/ICAClient] SSL error 61

Problem

Funny enough the Citrix receiver does not integrate well into several Linux distros with Firefox (probably other Mozilla browsers too) even though the package from Citrix has been taken to install ICAClient. It happens that SSL error 61 is frequent after a vanilla installation. This usually means that certificates are missing. To integrate the certificates provided by the browser you could link them to ICAClient certificate folder. Be aware that if the browser certificates change place or name this solution probably breaks. You also could copy them into the ICAClient certificate folder eating up more disk space. I will link.

Cause

The certificates provided by the ICAClient are not sufficient, i. e. not present, revoked, outdated, malformed, broken, ...

Citrix client tested

• 13.4 (seems to be broken, but this problem was not the thing for breakage)
• 13.5 (seems to be broken, but this problem was not the thing for breakage)

OpenSUSE Leap 42.2 (probably since 13.1)

Credit

sudo ln -s /usr/share/pki/trust/* /opt/Citrix/ICAClient/keystore/cacerts/

Ubuntu

Credit

sudo ln -s /usr/share/ca-certificates/mozilla/* /opt/Citrix/ICAClient/keystore/cacerts/

All

Apparently this is not necessairy: Credit

sudo c_rehash /opt/Citrix/ICAClient/keystore/cacerts/

Actually

In my case this was not sufficient. Even though Firefox provided SwissSign certificates, I had to download the PEMs again from SwissSign Root or SwissSign CA. Firefox's were "broken" (see list above 😉). I put them in /opt/certificates_downloaded as root, root writeable and world readable, linked them analogously to the Firefox's above and rehashed. Probably only SwissSign CA is needed as I came accross this phenomenon on Windows 10/Firefox too. There I had to download the Gold G2 2006 certificate in DER format and install it using the context menu in Windows explorer.

[X] Change keyboard layout/mapping on the fly on the console

I booted into a live USB Gentoo system, but even though I selected german key mapping just after the boot process started, the KDE desktop used the american layout - somewhat annoying, especially since I was not able to graphically select a german layout. The where just 8 selectable but german was not amongst, swiss would not help a lot and I was unable to install more layouts. One at irc channel #gentoo told me, I could issue the following on the command line and it works just great.

setxkbmap -verbose de

[lvm2] no devices after reboot

I was installing a Gentoo system on lvm partitions. While doing so, the system of the live USB stick froze and I had to reboot. However, no lvm devices where present in /dev even though I successfully displayed the volume group (vgdisplay) and the logical volumes (lvdisplay). The point is, that after the boot volume groups are deactivated so I had to activate them. I had this info from #gentoo IRC channel but was too dump to record it somewhere accessible because I had to shutdown my system to go home. It took me a good deal of time to find the solution again on the net but here it is:

vgchange --activate y vg_sata

GPG key management

Revoke key

https://www.hackdiary.com/2004/01/18/revoking-a-gpg-key/

Generate key

https://keyring.debian.org/creating-key.html

Convert keys

https://search.thawte.com/support/ssl-digital-certificates/index?page=content&actp=CROSSLINK&id=SO26449

[Windoof (7)] Prepend user PATH to the system PATH environment variable

This is not possible. Probably for security reasons, Windoof always appends a user variable called PATH to the system variable PATH. It looks to me as if Winzigweich does not trust in Windoofs right management. However. work around for cmd.exe usage by creating shortcuts with the shortcut command being

cmd.exe /K set PATH=%_PATH%;%PATH%

where _PATH is a user variable containing the path portion that should be prepended. In my case the system PATH variable contained the path to a broken sqlplus installation. So I wanted to overrule that.

[Java] jEdit (or other Java application) freezes goes black when dragging it from main monitor to another on multi monitor extended desktop Windows 7 environment

Funny enough, it used to work but after a distributed software update at the office, I have mentioned problem. The freeze was under Windows 7 and 32 bit Java 1.8.0_131. Under Windows 10 and 32 bit Java 1.8.0_131 and HoSpot build 25.131-b11 the java applicatioin does not freeze but on the extended screens black out but the application still works.

The problem is the usage of the Direct3D pipeline. You need to switch it off. Therefore define the environment variable

J2D_D3D

with the value

false

and your done. You just have to restart affected applications (obviously for the freeze anyway).


I found the workaround described at OTN.

[blogger.com] Using my configuration of Alex Gorbatchev's syntax highlighter in my blogs

Html

<pre class="brush:[brush alias]">your code here</pre>

Available brushes

Brush name	Brush aliases	File name
ActionScript3	as3, actionscript3	shBrushAS3.js
Bash/shell	bash, shell	shBrushBash.js
ColdFusion	cf, coldfusion	shBrushColdFusion.js
C#	c-sharp, csharp	shBrushCSharp.js
C++	cpp, c	shBrushCpp.js
CSS	css	shBrushCss.js
Delphi	delphi, pas, pascal	shBrushDelphi.js
Diff	diff, patch	shBrushDiff.js
Erlang	erl, erlang	shBrushErlang.js
Groovy	groovy	shBrushGroovy.js
JavaScript	js, jscript, javascript	shBrushJScript.js
Java	java	shBrushJava.js
JavaFX	jfx, javafx	shBrushJavaFX.js
Perl	perl, pl	shBrushPerl.js
PHP	php	shBrushPhp.js
Plain Text	plain, text	shBrushPlain.js
PowerShell	ps, powershell	shBrushPowerShell.js
Python	py, python	shBrushPython.js
Ruby	rails, ror, ruby	shBrushRuby.js
Scala	scala	shBrushScala.js
SQL	sql	shBrushSql.js
Visual Basic	vb, vbnet	shBrushVb.js
XML	xml, xhtml, xslt, html, xhtml	shBrushXml.js

For its setup see also to-integrate-alex-gorbatshevs-syntax