Skip to main content

Unable to locate: UDBTXT

  • October 18, 2019
  • 8 replies
  • 1 view

Forum|alt.badge.img

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



8 replies

Knut Dybendahl
Forum|alt.badge.img
  • Participating Frequently
  • October 18, 2019

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



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


Forum|alt.badge.img
  • Author
  • Participating Frequently
  • October 18, 2019

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

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


Gianni Sandigliano
Forum|alt.badge.img

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



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


Forum|alt.badge.img
  • Author
  • Participating Frequently
  • October 21, 2019

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

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




Gianni Sandigliano
Forum|alt.badge.img

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

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


Forum|alt.badge.img
  • Author
  • Participating Frequently
  • October 21, 2019

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

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


Gianni Sandigliano
Forum|alt.badge.img

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

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


Forum|alt.badge.img
  • Author
  • Participating Frequently
  • October 23, 2019

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

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