Tips for efficient troubleshooting

In the case you found a bug in Lycia or need technical assistance, it would be a great help for our support team if you gather as much information as possible about the issue. This would allow for its faster reproducing and resolving.

Below, you will find the instructions on how to obtain all the mentioned information.


Lycia Version

Execute the following command in Lycia Command Line: gfgl -V


Operating System Info

Run the following commands in the command prompt:

Windows
systeminfo > sysDesc.txt

Linux
uname -a > sysDesc.txt
cat /etc/*elease >> sysDesc.txt
locale >> clientLoc.txt
sudo lshw > sysDesc2.txt


Java Version

On Windows, run the following command in the command prompt: java -version > javaVer.txt


C/C++ Runtime Version

Windows without MinGW

  1. In Microsoft Visual Studio, open the About dialog.
  2. Click Copy Info.
  3. Send the copied information to the Querix support team.

Windows, Linux with MinGW

Run the following commands in the command prompt:
gcc --version > gccDesc.txt
g++ --version > g++Desc.txt
ld --version > ldDesc.txt
ldd --version > lddDesc.txt


Configuration Files

If any of the configuration files contain sensitive information (e.g. usernames or passwords), make sure to mask it before sending the files to the Querix Service Desk

Here is the list of Lycia configuration files that might come in handy:

  • inet.env
    Windows: C:\ProgramData\Querix\Lycia\etc\
    Linux: /opt/Querix/Lycia/etc
  • environ.bat
    Windows: C:\Program Files\Querix\Lycia 3 Development Suite 7.1\Lycia\bin\
    Linux: . environ
  • env.properties
    Windows: C:\Program Files\Querix\Lycia 3 Development Suite 7.1\Lycia\etc\
    Linux: /opt/Querix/Lycia/lyciastudio/etc/
  • lycia.cfg
    Windows: C:\Program Files\Querix\Lycia 3 Development Suite 7.1\Lycia\etc\
    Linux: /opt/Querix/Lycia/etc
  • lyciastudio.ini
    Windows: C:\Program Files\Querix\Lycia 3 Development Suite 7.1\Lycia\LyciaStudio\
    Linux: /opt/Querix/Lycia/lyciastudio/

Find more information about Lycia configuration files in Lycia Online Tutorials


Log Files

If any of the log files contain sensitive information (e.g. usernames or passwords), make sure to mask it before sending the files to the Querix Service Desk

  1. Open the inet.env Lycia configuration file and set QXDEBUG to its full value to get the most detailed logs: QXDEBUG=UuBbSsEedPptLlCcmGOzAzKzQv
  2. Locate the log files and send them to the Querix support team:
    • Application logs are stored in the folder specified in listener.xml, which, by default, is
      Windows: C:\ProgramData\Querix\Lycia\logs
      Linux: /opt/Querix/Lycia/logs
    • Application server logs are stored in the Jetty configuration folder:
      Windows: C:\ProgramData\Querix\Lycia\jetty\logs
      Linux: /opt/Querix/jetty/logs
    • LyciaStudio logs are stored in your workspace .metadata which, by default, is
      Windows: C:\Users\<user>\workspace\.metadata\.log
      Linux: /home/<user>/workspace/.metadata/.log

To get Lycia Form Designer logs, add the following properties to lyciastudio.ini after -vmargs:

-Dcom.querix.fgl.forms.designer.renderer=cef
-Dcom.querix.fgl.forms.designer.render.arg.log-file=c:/temp/ceftmp.log
-Dcom.querix.fgl.forms.designer.render.arg.log-severity=verbose
-Dcom.querix.fgl.forms.designer.jslog=C:/temp/fd_scripts.js

Additional logs can be found here:

%HOMEPATH%\Lycia<num>.log
$HOME/Lycia<num>.log


Database information

Database information that may be requested by the Querix support team includes the following:

  • database driver (ODBC driver and version)
  • database driver environment
  • database locales and code pages on the server side


Database driver

To retrieve information about your database driver, follow the instructions below.

  1. Run the following commands in the command prompt:
    C:\Program Files\IBM Informix Client SDK\bin>esql.exe -version > ifxVer.txt

    dbaccess -V >> ifxVer.txt

  2. Open the ODBC Data Source Administrator, and then double-click the data source name. The About IBM Informix ODBC tab will open containing the required information.


Run the following commands in the command prompt:
/etc/odbcinst.ini

. /$INFORMIXDIR/bin/check_version csdk >> ifxVer.txt
dbaccess -V >> ifxVer.txt


Database driver environment

Use the following records in the registry to get information about your Database driver environment:
HKEY_LOCAL_MACHINE\SOFTWARE\Informix\Environment
HKEY_LOCAL_MACHINE\SOFTWARE\Informix\ONLINE\<db_driver_name>\Environment

Run the following command in the command prompt:
env >> lnxdrvenv.txt


Database locales and code pages

To retrieve the database locales and code pages on the server side:

  1. Run dbaccess
  2. Select a database
  3. Go to Database → Info → NIs