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

Valence 52+ Installation dashboard in empty

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

  • Valence 52+ Installation dashboard in empty


  • #2
    Hello Patrice,

    It appears the SQL function VVSECURE_ISAUTHORIZEDA failed to create during the installation process. Let's try to create it manually there to isolate the problem...

    Go into source member VVSQLFUNC in VALENCE52/QSQLSRC, verify each library reference is VALENCE52 (not VVLIBRARYX), then run it with this command:
    RUNSQLSTM SRCFILE(VALENCE52/QSQLSRC) SRCMBR(VVSQLFUNC) NAMING(*SQL)

    I suspect it's going to give you some sort of an error message, which will show in the spool file the process generates. Let us know what you see and then we'll decide what to do next. I believe there is an SQL bug in some versions of the OS that can cause this.

    -Rob

    Comment


    • #3
      DECMPT(*PERIOD)

      So something like French specificities ...

      Thanks for your help,
      Patrice

      Comment


      • #4
        Ahhh, thanks Patrice! That makes total sense now -- VVIN_NUM() is a recently added SQL function, and the first one we've created with a decimal return value (30,9).

        We'll be sure to add DECMPT(*PERIOD) to the install routine so this doesn't happen again on future builds.

        Have a good weekend!
        -Rob

        Comment


        • #5
          Thanks again for your help and have a nice we too !

          Comment

          Working...
          X