Announcement
Collapse
No announcement yet.
Valence 52+ Installation dashboard in empty
Collapse
X
-
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
-
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
Comment