• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

Install of version 5.2+ 20200415 errors on portal admin

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Install of version 5.2+ 20200415 errors on portal admin

    I installed Valence 5.2+ 20200415 and all went well however, when I logged in and tried portal admin, the page went into infinite loop waiting. Upon investigation network traffic showed:
    1. http://sys.smeg.com.au:7052/valence/...dm_sets&action =getSettings&page=1&start=0&limit=25&sid=JS8YETX1H 84KDQKWDYYEC7VJA19HN3DMKX81AL0KLYCMZH08Y8UW83I22W5 XJKGW&lang=en&app=95&vvKey=15872126334657045&env=1
    2. Request Method:
      GET
    3. Status Code:
      569 Session Exception
    4. Remote Address:
      10.1.1.95:7052
    5. Referrer Policy:
      no-referrer-when-downgrade
    Response:
    {"success":false,"hdr":"serverError","body":"ge ner icServerError","vvid":22,"var1":"00530051004C00200 ......

    This instance was working before this upgrade.Our other two instances for production and development testing are still working on previous version.

    Peter

  • #2
    Looks like it's logging an error of some sort. What do you see in VALENCE52/VVERRLOG? i.e.,
    Code:
    select vvstamp, char(vvmsgtxt) from valence52/vverrlog order by vvstamp desc

    Comment


    • #3
      Here is the content in errors file.

      2020-04-18-22.17.33.132000SQL statement prep failure (SQLSTT=42601) - SQL0199 - Keyword WHERE not expected. Valid tokens: FOR USE SKIP WAIT WITH FETCH LI.
      2020-04-18-22.18.49.576000SQL statement prep failure (SQLSTT=42601) - SQL0199 - Keyword WHERE not expected. Valid tokens: FOR USE SKIP WAIT WITH FETCH LI.
      2020-04-18-22.21.38.316000SQL statement prep failure (SQLSTT=42601) - SQL0199 - Keyword WHERE not expected. Valid tokens: FOR USE SKIP WAIT WITH FETCH LI.
      2020-04-18-22.23.22.518000SQL statement prep failure (SQLSTT=42601) - SQL0199 - Keyword WHERE not expected. Valid tokens: FOR USE SKIP WAIT WITH FETCH LI.
      2020-04-18-22.23.54.526000SQL statement prep failure (SQLSTT=42601) - SQL0199 - Keyword WHERE not expected. Valid tokens: FOR USE SKIP WAIT WITH FETCH LI.
      2020-04-18-22.55.04.893000Critical exception encountered in Fusion5250 daemon (VVFUSIOND)
      2020-04-18-23.51.48.468000SQL statement prep failure (SQLSTT=42601) - SQL0199 - Keyword WHERE not expected. Valid tokens: FOR USE SKIP WAIT WITH FETCH LI.

      Note also the critical Fusion5250 error which causes it not to shut down when we end the HTTP server instance. This also happens in prior 5.2+ versions.

      Peter

      Comment


      • #4
        Strange. Please pull a few more columns from the error log so we can get a bit more context of what's going on there:
        Code:
        SELECT VVSTAMP, char(VVMSGTXT), char(VVHLPTXT), VVCALSTK
        FROM vverrlog
        order by vvstamp desc

        Comment


        • #5
          OK, here is the errors file with your requested columns. It's an excel file with suffix changed from xlsx to txt because attachment doesn't allow xlsx files.
          Attached Files
          Last edited by petersioufi; 04-21-2020, 09:59 PM.

          Comment


          • #6
            Hi Peter,

            Thanks, that clarifies the issue. There's a problem in the Portal Admin backend program that only reveals itself when hidden settings are not showing. We'll get this corrected in the next build, but in the meantime you can fix it yourself there by adjusting the RPG source in VALENCE52/QRPGLESRC, member VVADM_SETS. Insert the following immediately after line 101.00:

            Code:
            whereAdded = *on;
            Thanks for bringing this to our attention.

            Comment


            • #7
              Thanks for finding the problem and formulating a solution.

              I can't apply this update because the compiler is looking for copy source that's missing.

              /copy qcpylesrc,vvkeymgrD

              There's no particular hurry to implement this version so I can wait a little for an update.

              Comment


              • #8
                Sorry about that. We just updated the last build to address this specific issue, so if you download 5.2.20200415.1 it will resolve the problem. Apologies for the inconvenience!

                Comment

                Working...
                X