XMA: XMA_MANAGER prompts to Create SQL Environment.

XMA: XMA_MANAGER prompts to Create SQL Environment.

If you have just upgraded the software:
If you have just upgraded the software, you should follow the prompts. This performs any required database upgrades and will sqlcomp any necessary object files.

If you haven't upgraded the software:
If you haven't just upgraded and the SQL environment is already configured, do a fileinfo on the XYGATEMA subvolume. If a file called NEWINST is present, rename it out of the way. The next time you start XMA_MANAGER, the Main Menu should be presented, as expected.

If this article did not provide a solution, please open a case with our support team by sending an email message to support@xypro.com.

    • Related Articles

    • XMA: xma_manager Check_SQLCompileNeeded

      Run the XMA_SQLCOMPALL macro to compile XMA object files. This problem arises when XMA object files have not been recompiled more 7 days after product installation. The solution is to recompile the SQL objects using the XMA_SQLCOMPALL macro. From the ...

    • 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> ...

    • XMA:Ways to address SQL error due to error 45 in AUDDET or AUDSESS

      Below are the Steps for ?Option 1? clean up the obsolete data records: Step: Option 1.0. Logon as an owner of XMA installation and install XMA macro at TACL Step: Option 1.1. Stop XMA Pathway by running the XMA_PWSTOP macro at TACL (or at the ...

    • XMA: SLENDER retryable transient error -4060 SQL Error : SqlCode : -4060

      To resolve the SLSENDER mover due to missing PARAMS and SYSLOGQ tables: TACL> VOLUME $<VOLUME>.<XYGATEMA Installation Subvolume> TACL> FUP COPY NEWDEFS TACL> OBEY NEWDEFS TACL> INFO DEFINE =XMA_PARAMSTBL Output should return something such as: Define ...

    • XMA: How to generate the SQL explain plan for movers.

      To produce an explain plan to show the SQL/MP cost and table usage for XMA movers. Using XMA_MANAGER stop the Mover Volume $<XUGATEMA Installation volume>.XYGATEMA RUN NEWDEFS SQLCOMP /IN <Object>/CATALOG =XMA_CAT,EXPLAIN Using XMA_MANAGER start the ...