XRM report fails with ERROR from SQL [-8025]: The SQL region was not SQL compiled.

XRM report fails with ERROR from SQL [-8025]: The SQL region was not SQL compiled.


Do a "FUP INFO XYGATR.SQLQUERY,DETAIL" to verify that SQLQUERY is a valid SQL program. Otherwise, do an "XTR_SQLCOMPALL" to solve the issue. 

$SYSTEM XYGATETR 115> fup info sqlquery,detail

$SYSTEM.XYGATETR.SQLQUERY             6 Jul 2021, 11:13
    ENSCRIBE ( VALID SQL PROGRAM )
    CATALOG $SYSTEM.XYGATETR
    PROGRAM CATALOG VERSION 1
    PROGRAM FORMAT VERSION 350
    TYPE U
    FORMAT 1
    CODE 100


If you are unable to locate the solution needed or if you need additional assistance please Click Here to open a case from our Customer Care Portal.


    • Related Articles

    • XMA: XMA_MANAGER returns ERROR from SQL [-8025]: The SQL region was not SQL compiled

      To recompile the XMA SQL objects perform the following: TACL> VOLUME $<volume>.<XYGATEMA Installation Subvolume> TACL> RUN XMA INSTALL TACL> XMA_PWSTOP (Stop XYGATEMA Mover Processes) TACL> XMA_SQLCOMPALL (SQL Compile the Mover Objects) TACL> ...

    • XRM: GUI error when attempting schedule and save a report

      Check the permissions for the folder c:\Users\<user name>\AppData\Local\XYPRO\XYGATERM and its subordinate folders by executing the following command as follows from Windows shell: (Where <user name> is the Windows user that will schedule the reports ...

    • XRM: Scheduled Reports Fails to Run

      1.Check XRM for the Task's Name, it can be found by Viewing the Task Log for the malfunctioning task and locating the 'Starting Scheduled Report' line. The task will be in the format XRM.<systemname>.<username>.<Fully.Qualified.Work.Directory> 2. ...

    • XRM: Failed Report Error, Failed - #lineins t_inv 56 ^

      This problem is caused by a blank space being in the report template file. This can be resolved in the XYGATERM GUI. The steps to do so are below. 1. Open XYGATERM GUI 2. Open the afflicted report 3. Switch to the Layout Tab 4. Under Selected Columns ...

    • XRM: Scheduled report fails with XRMMETAP being used by another process

      Schedule reports to run at least 5 minutes apart, e.g. times separated by 5 minutes between each report start to avoid the file clash. If this article did not provide a solution, please open a case with our support team by sending an email message to ...