Suhas Das

Tips on SQL Join

Inner join: Returns only the rows that have matching values in both tables. SELECT * FROM tableA INNER JOIN tableB ON tableA.id = tableB.id; TableA TableB 1 A 1 2 B 3 Result of INNER JOIN on id: id nameA nameB 1 A Alpha Outer Join: Returns rows that have matches + rows without matches,…

Read More

Java ScriptEngine

The ScriptEngine in Java (from the javax.script package) doesn’t directly define a fixed list of functions itself — instead, it provides a standard interface for embedding and executing scripts in various languages (like JavaScript, Python via Jython, Groovy, etc.). So, the functions supported depend on which scripting language engine you’re using. However, here’s a breakdown…

Read More

Batch file with skip command option in case of error

Add “call” in the beginning of command robocopy, in case robocopy gives access denied error. cls@echo off set CD=%PWD% call robocopy “\server\files\GROUP\CU\DMSUploads\TrxDocs\newdocs\Nan Dur” “\lfcunas01\AccountProcess\TrxDocs\newdocs\Nan Dur” *.pdf /MOV /Eecho First robocopy completed with errorlevel %ERRORLEVEL% call robocopy “\server\files\GROUP\CU\DMSUploads\TrxDocs\newdocs\Lor Agui” “\lfcunas01\AccountProcess\TrxDocs\newdocs\Lor Agui” *.pdf /MOV /Eecho First robocopy completed with errorlevel %ERRORLEVEL% call robocopy “\server\files\GROUP\CU\DMSUploads\TrxDocs\newdocs” “\lfcunas01\AccountProcess\TrxDocs\newdocs” *.pdf /MOV…

Read More

FileSplitter Tool – Splitting data file

update the following lines: set “inputFile=C:\path\to\your\input.txt”set “outputFolder=C:\path\to\output”set “linesPerFile=1000” and here is the bat file: @echo offsetlocal :: Set variablesset “inputFile=C:\path\to\your\input.txt”set “outputFolder=C:\path\to\output”set “linesPerFile=1000” :: Create output directory if it doesn’t existif not exist “%outputFolder%” (mkdir “%outputFolder%”) :: Run PowerShell to split the filepowershell -Command ^“$inputFile = ‘%inputFile%’;” ^“$outputFolder = ‘%outputFolder%\’;” ^“$linesPerFile = %linesPerFile%;” ^“$i = 0;”…

Read More

ImageTrust: When trying to use the opener the error message The application did not pass the security self-test and will stop now stop! shows up and the application will not start.

Root Cause The Windows Authenticode Signature Verification is enabled in the system. The opener.exe cannot pass this verification because it contains the URL of the Server, and every time it is downloaded from a different URL the the .exe file is updated with the new URL. This URL is used to download and open the…

Read More

Apache Commons Text vulnerability (commons-text-1.9.jar)

Applies to • Documentum xCP 22.2 • Documentum xCP Designer 22.2 Summary Are Documentum xCP components affected by CVE-2022-42889 the commons-text library vulnerability? Resolution Documentum XCP 22.2 is the first version of the platform that is shipped with the Apache commons-text java library.   This library is focused on algorithms for working with strings that developers may want…

Read More