1
0
-1

Hello,


We are migrating from  Uniface 967 to  Uniface 9705.

In all cron jobs we have, we are getting the following messages:


Unable to locate: UDBTXT
*** The application has tried to dynamically perform this 3GL function but could not find it.
*** Check if you have an entry for this function in the [USER_3GL] section of your assignment file.


is this something which has to be attended to or it is more of  a warning? Please let me know.


Thank you,

Venkat



    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi Venkat,

      I had the same gotfeel: your application is trying to load the TXT driver...

      Few other hints:

      1) is your .INI file correctly defining all basic paths in the paths section?
      Like in this example:

      [paths]
      helpdir=C:\Program Files (x86)\Uniface\U97\uniface\doc\help
      usysins=C:\Program Files (x86)\Uniface\U97
      usyscom=C:\Program Files (x86)\Uniface\U97\common
      usys=C:\Program Files (x86)\Uniface\U97\common\usys
      usysbin=C:\Program Files (x86)\Uniface\U97\common\bin
      usysadm=C:\Program Files (x86)\Uniface\U97\uniface\adm
      usysuniface=C:\Program Files (x86)\Uniface\U97\uniface
      javascript=C:\Program Files (x86)\Uniface\U97\uniface\webapps\uniface\dspjs

      2) is your .ASN file [USER_3GL] section including any 3gl component?

      Regards,
      Gianni

      1. Venkat NV

        Hello Gianni,


        Yes, values in usys.ini are correct:


        [paths]
        usys=/ford/thishost/u/uniface/9705/common/usys
        usysins=/ford/thishost/u/uniface/9705
        usyscom=/ford/thishost/u/uniface/9705/common
        usysuniface=/ford/thishost/u/uniface/9705/uniface
        javascript=/ford/thishost/u/uniface/9705/uniface/webapps/uniface/dspjs


        We use 3GL in urouter for security as we do not run urouter as root user and we run it as normal user.

        [USER_3GL]
        /ford/thishost/u/uniface/9705/lib/zsecdrv(usecappl)

        Other than this, we do not have any mention about 3GL any of 5 UST asn we have.

        in dbms.asn i added TXT U2.0 (as suggested in some google search pages)

        [DRIVER_SETTINGS]
        SEQ U1.0
        TXT U2.0


        in the asn responsible for job which throws these errors, i added   the same value as mentioned above.

        [DRIVER_SETTINGS]

        TXT U2.0


        Am novice in Uniface, i hope i answered it right.


        Regards,

        Venkat



      2. Gianni Sandigliano

        Hi Venkat,

        three more items to be checked:

        1) In your previous U9.6.07 installation were you already using TXT driver U2.0 or the old U1.0 driver?

        2) I do not see in your INI [paths] section reported USYSBIN and USYSADM.
        let's try to add those (eventually adapt them to your needs):
        usysbin=/ford/thishost/u/uniface/9705/common/bin
        usysadm=/ford/thishost/u/uniface/9705/uniface/adm

        3) From your answer I suppose your batches are running on a Linux/Unix machine:
        - Are you sure your batches have a shell environment properly initialized?
        - If yes, let's try to be sure to have both lowercase and UPPERCASE shell variables defined
        As an example:
        usysbin=/ford/thishost/u/uniface/9705/common/bin
        USYSBIN=/ford/thishost/u/uniface/9705/common/bin

        Regards,
        Gianni

      3. Venkat NV

        Hello Gianni,


        Please find the answers for your questions in the same order:


        1) No, there is no reference to use of TXT in any of asn from 9607 environment.

        2) As suggested, i added usysbin and usysadm to ini file and restarted urouter. Now i do not see those errors in the logs, i will monitor all batch jobs for next few days.

        3) Yes, we use Uniface only on Linux. yes shell environment is all set right.


        Regards,

        Venkat

      4. Gianni Sandigliano

        Hi Venkat,

        OK, nice to see check #2 has probably addressed your issue.

        One last consideration: if your application did NOT use TXT driver before, I suppose you've added its support into your ASN configuration because of some new functionality requiring it. Right?

        Regards,
        Gianni

      5. Venkat NV

        Hello Gianni,

        Yes that solved the original issue. (thank you for that)

        I copied over the asn files from  967 to 975 and made changes as needed.

        There is no new requirement that needed the functionality for TXT.

        I was of the assumption that something has changed in 975 which is prompting for config changes.


        Regards,

        Venkat


      CommentAdd your comment...
    2.  
      1
      0
      -1

      Hi,

      I'd say you have a line or two in your ASN file :

      $path   $TXT:........

      I presume that your application is using the text (TXT) file driver.

      The correct syntax would something like :

      TXT   U1.0

      or

      TXT U2.0

      the number at the back refers to the version of the driver....

      The file will be found in the .\common\bin folder - UTXT10.dll or UTXT20.dll

      Regards,

      Knut

      1. Venkat NV

        Hello Knut,


        Thank you for replying.

        these are the 2 lib files in the directory for TXT:

        libutxt10.so
        libutxt20.so


        In dbms.asn. these lines exists as you have mentioned.

        [DRIVER_SETTINGS]
        SEQ U1.0
        TXT U2.0


        There are no reference in the asn responsible for the batch job mentioned.


        Regards,

        Venkat

      CommentAdd your comment...