Faq

How to check what encoding does the installed Oracle database use?

The encoding of an Oracle instance can be checked by sending the appropriate queries:

  • from the level of aSISt application
  • after login to the Oracle database

I. To check the encoding of the installed Oracle database from aSISt application level, select:

ALT + A -> aSISt information -> button: ‘SQL Console’

At the top of the displayed window:

  • enter the query:

select * from NLS_DATABASE_PARAMETERS

where parameter=’NLS_CHARACTERSET

  • select the button:

as shown in the figure below:

II. To check the encoding after login to the Oracle database:

  • add the semicolon to the query given above, so that it has the form:

select * from NLS_DATABASE_PARAMETERS

where parameter=’NLS_CHARACTERSET’;

The encoding of the ORACLE database instance, correctly supported by aSISt, is: AL32UTF8.

How to check the ORACLE database version?

To check the ORACLE database version on which the aSISt application is running, you should:

  1. Run the command line as an administrator on the database server
  2. Enter sqlplus
  3. In the place where the user should be given, enter / as sysdba
  4. Enter the command: SQL*Plus: Release database_version

As a result, you will receive information about the Oracle database version.

How to repair a damaged Derby database?

Very often problems with the Derby base arise as a result of disk damage, or lack of free space. Please check your hard disk before repairing the database.

To repair the database, please:

  1. Start the recovery.bat file (it is located in the aSISt home directory),
  2. Answer YES to the question: “Do you want to perform the derby repair process?”,
  3. Indicate the last backup (for example: asist_backup_5.11_2015-01-15_11-30-32.zip). To repair the database, use a backup that was made from the same application installation.

After completing the process of repairing the database, an information message will appear that the repair of the database has been completed.

If the damage to the database is too big, then repairing the base is not possible.

Where can I check in what taxonomy the report has been prepared if the “Report settings” function is not active?

The “Report settings” function is active only for editing reports, i.e. for those having the status of “editing raw data” or “editing in reconciliation mode”.

For non-edited reports, information on the taxonomy prepared in the report can be obtained using the function, “Report details” selected in the “List of reports” mode, after:

  • highlighted in the list of the required report
  • selecting “Report” -> “Report details”
How to remove filters applied to “List of reports”?

To quickly remove all search filters that you have set, you must:

  • activate the filter function by choosing:

“View” -> “Show filter”

  • select the ‘X‘ icon next to the period filter

After completing these steps:

  • the screen will present a list of all reports in the aSISt database
  • defined and saved filters will still be visible and possible to use under the ‘Saved filters’ button
  • defined but unsaved filters will be no longer available

To what address should I send queries in case of problems with aSISt application?

All inquiries related to the aSISt application, please send to: support@asist-xbrl.eu

It can be done:

What to do to receive emails about new versions of aSISt?

To receive emails about the new versions of aSISt, you must register on the aSISt service page.

The correct registration process requires that you complete the following steps:

1. Access the Website: https://support.asist-xbrl.eu/en/

2. Find and select the “REGISTER” function (the function is available on the black bar in the page headline menu)

3. Choose the option:

  • aSISt_ENG

4. Give:

  • name and surname
  • email address to which information from the Website will be sent
  • name of the represented bank

5. Acceptance:

  • privacy policy of GPM Systemy sp z o.o. and regulations for the provision of electronic services
  • consent to the processing of personal data for marketing purposes and for sending commercial information by electronic means by GPM Systemy sp z o.o.
  • consent to the processing of personal data for the purposes of sending the form by GMP Systemy sp.z o.o.

6. Perform a mathematical operation and provide the correct result

7. Selecting the “NEXT” button that will send the account activation message to the previously provided email address

8. Opening the message from the “aSISt Team” and clicking on the activation link confirming registration at https://support.asist-xbrl.eu/en/

How to add new users to aSISt application?

From 5.0 version, all changes related to accounts of previously created users, and adding new users take place in the “Users and role” module tab, in the side tab “User Account Management”.

To add a new user, use the function:
“User” -> + Add

The following information is required here:

  • New user names,
  • Access passwords for the added users,
  • User (role) permissions – by moving the required role to the right window panel.

It is optional to enter other data in this function.

This function is only available to users with administrator privileges.

How can you log into the newly installed aSISt application?

After starting the aSISt application, the login panel is displayed, to which you should enter:

  • Login: admin
  • Password: admin

these are the default settings with system administrator privileges.

In the next step, add accounts for all users who are going to work in aSISt, so that each user can log in to the application through their own account.

What requirements should have a computer with the aSISt application installed?

The hardware requirements for the aSISt application are specified in the document: Specification of hardware requirements for: aSISt, tranSIS systems

What should I do if my aSISt application works too slow?

If your application works to slow, please:

  • compare aSISt requirements with parameters of your computer.

Requirements for aSISt application are available at: https://support.asist-xbrl.eu/sites/default/files/documentation/aSISt_tranSIS-_system_requirements.pdf,

Go to the Settings (ALT+A -> Settings), click on tab: LOCAL, and go to the tab:

  • Memory management and add more memory moving the slider further, but it is not advised to move it to the end of the scale (The amount of available memory depends on the amount of RAM available on your computer).

Please notice that the application needs more time when report is opened for the first time with a new taxonomy.

How I can delete report?

It is not possible to delete report in the aSISt application, but it is possible to make changes in settings defined during creating a report. In this case please choose “Report” in the menu, and next click on “Settings”. You will be able to:

  • add or delete forms from the report,
  • make changes in explicit and typed dimensions.

It is impossible to change:

  • report’s type,
  • report’s period, and
  • consolidation’s type. 
How to check the version of the aSISt application?

To check the version of your aSISt application, please run function “about aSISt”, selecting:

Alt-A  -> about aSISt

The application window also presents information about database version and database type (ORACLE or DERBY).

How can I enable blanked (greyed out) cells on the report’s table in the aSISt application?

From version 5.16 of aSISt application it is possible to activate explicit dimensions from cell’s level (right mouse button – “Enable Cell”).

If function  “Enable cell” is unavailable, it means that the cell is deactivated because of taxonomy and it is impossible to activate it.

What should I do to transfer the aSISt application with Derby database to a new computer?

To transfer the aSISt application from current computer to a new workstation, please:

1. Make a backup of derby database using function “Preparing backup” (ALT+A -> “Preparing backup”),

2. Download full version of aSISt from our website (https://support.asist-xbrl.eu/en/downloads),

3. Install aSISt application on the new computer using downloaded file,

4. From the old aSISt home directory please copy to the new aSISt home directory file:

  • aSISt.license,

and catalogue:

  • preferences (If you would like to have the same user’s settings on the new workstation just like you had on the old one).

5. Update the aSISt application to the current version using:

  • local update (using file/files downloaded from our website),
  • automatic update (If you have internet connection and proper address for update config file).

6. On the new computer upload file with backup which was created from the old database.

7. Go to the Settings (ALT+A -> Settings), click on tab: LOCAL, and next go to tab:

Memory management and add more memory moving the slider further, but it is not advised to move it to the end of the scale (The amount of available memory depends on the amount of RAM available on your computer).

8. On the old computer, rename the db.properties file [for example: db_old.properties] so that, even an accidental attempt to run the application on the old computer does not interfere with the current work of aSISta.

When do I have to update Oracle database additionally? How can I update Oracle database?

In case of the aSISt application update to the full version (when second value after point changes, for example for updates to versions: 5.15, 5.16, 5.17,…) it is necessary to additionally update the Oracle database.

To update Oracle database please:

  1. run update (local or from internet),
  2. during update, click on “OK”, when there will be a question about the update method: with or without the database

Update with the database:

  • it is necessary only once on one workstation
  • can be made only when
    • aSISt is running only on this particular workstation, and additionally:
    • no other workstations are subject to updates.

When updating next workstations the update is made only to the application.

If, during the update on the first workstation, you have omitted the database update and updated only the application, the database must be updated during the next workstation update.

If, during the update on all workstations, you have omitted the database update, then please contact aSISt support team with request about script for updating Oracle database, and next:

  • In CMD run sqlplus,
  • Log in using login and password for aSISt Oracle user,
  • Run script using: @<path_for_the_script> i.e. @C:Oracleoracle.sql,
  • Save changes using command: commit.
I am not sure if I downloaded update file from the aSISt website completely. How can I check it?

Since 5.16.2 version of the aSISt application the link to the file with checksums is available in the lower part of the update package.

To be sure that downloaded file is correct, please create checksums from the file and compare with checksums which are available on our site. 

What should I do to transfer the aSISt application with Oracle database to a new computer?

To transfer the aSISt application with Oracle database it is needed to move to a new server:

  • Oracle database (It can be made using Oracle tools (it is possible to use standard import and export tools)), and:
  • aSISt application

To move the aSISt application from an old workstation to the new, please:

1. Download the full aSISt version from our website (https://support.asist-xbrl.eu/en/downloads),

2. Install the aSISt application on the new workstation using downloaded file,

3. From the old aSISt home directory please copy to the new aSISt home directory files:

  • aSISt.license,
  • db.properties,

and catalogue:

  • preferences (If you would like to have the same user’s settings on the new workstation just like you had on the old one).

In the file db.properties there are information about: URL address to the Oracle database, user name and password for aSISt user. It is possible to make changes in the file if something is incorrect.

4. Update the aSISt application to the newest version (ALT+A -> Update).

There are two ways to update the aSISt application

  • local update (using file/files downloaded from our website), or
  • automatic update (If you have internet connection and proper address for update config file).

5. Go to the Settings (ALT+A -> Settings), click on tab LOCAL, and next go to the tab:

Memory management and add more memory moving the slider further, but it is not advised to move it to the end of the scale (The amount of available memory depends on the amount of RAM memory available on your computer).

Which files should I send to the aSISt support team in case of problems with application?

In case of any problems with the aSISt application, please attach the file with logs to the email addressed to: support@asist-xbrl.eu

To generate logs, please run the “About aSISt” function (ALT+A -> About aSISt) and in the new window click the “Dump debug data” button.

The “dump.zip” file doesn’t contain report data. It includes information about the operation of the application when problem occurred.

If you still can’t find solution, go ahead to contact with us

Report issue