Super Contributor.. skbd Super Contributor..
Super Contributor..
902 views

SQL Validations not populating as expected

Jump to solution

Has anyone else run into this?  The validations behind fields on my forms and CRs were populating as expected, but just recently the ones which do DB SQL lookups are now giving me a new message::

"Please make an entry above and click "Find," or show all possible values"

The 'show all' is a link which, when clicked, gives me the proper set of values the SQL should have provided right up front.

Now, my users have to click an extra time to do their work. 

Anyone have any ideas on this?Validations.JPG

0 Likes
1 Solution

Accepted Solutions
MIF Super Contributor.
Super Contributor.

Re: SQL Validations not populating as expected

Jump to solution

Hello there,

You can check if you accidentally set AUTO_COMPLETE_LONG_TYPE_CULLTEXT_REQUIRED server configuration parameter to true. 

 

--Remember to give Kudos if you like the solution.

Murat Akbar
MIF Software & Consultancy - Istanbul
http://www.mif.com.tr
8 Replies
Super Contributor.. skbd Super Contributor..
Super Contributor..

Re: SQL Validations not populating as expected

Jump to solution

I failed to mention, that I am running Version 9.32.0002

0 Likes
MIF Super Contributor.
Super Contributor.

Re: SQL Validations not populating as expected

Jump to solution

Hello,

It seems you're having problem with user input part of sql.
That part looks like  "Upper(something) LIKE Upper('?' || '%')..."
If you post sql we could help more.

--Remember to give Kudos if you like the solution.

Murat Akbar
MIF Software & Consultancy - Istanbul
http://www.mif.com.tr
0 Likes
Super Contributor.. skbd Super Contributor..
Super Contributor..

Re: SQL Validations not populating as expected

Jump to solution

That was what I thought too at first, but then none of my validations have changed during this period when I am seeing this and it is showing up on more and more of the validations as time progesses.

I did shut down the application and removed the tmp/ and work./ directories and re-ran kUpdateHTML.sh as well trying to sort out the issues, but that had no effect.

I also checked server resources but nothing seems to be lacking.

I am really confused by this new behavior.

 

0 Likes
Super Contributor.. skbd Super Contributor..
Super Contributor..

Re: SQL Validations not populating as expected

Jump to solution

Here is one of the validation SQLs that is showing the behavior - it has not been changed in over a year I am sure:

SELECT distinct(u.user_id), u.username, u.first_name, u.last_name, u.email_address
FROM KNTA_USERS u,knta_user_security us, knta_security_groups sg
WHERE  u.user_id = us.user_id
AND sg.security_group_id = us.security_group_id
and sg.security_group_name like 'ACI % Developer'
and u.username <> '[REQD.VP.UAT_TESTER]'
AND '[REQ.APPLICATION_CODE]' in (u.visible_user_data1,u.visible_user_data2,u.visible_user_data3,u.visible_user_data4,u.visible_user_data5,u.visible_user_data6,u.visible_user_data7)
AND NVL(u.start_date, CURRENT_DATE) <= CURRENT_DATE
AND NVL(u.end_date, CURRENT_DATE + 1) > CURRENT_DATE
order by 2

0 Likes
Super Contributor.. skbd Super Contributor..
Super Contributor..

Re: SQL Validations not populating as expected

Jump to solution

Today, I found that the OOTB validation for the Request field in the Search | Request screen is showing the same behavior.

0 Likes
MIF Super Contributor.
Super Contributor.

Re: SQL Validations not populating as expected

Jump to solution

Hello there,

You can check if you accidentally set AUTO_COMPLETE_LONG_TYPE_CULLTEXT_REQUIRED server configuration parameter to true. 

 

--Remember to give Kudos if you like the solution.

Murat Akbar
MIF Software & Consultancy - Istanbul
http://www.mif.com.tr
Super Contributor.. skbd Super Contributor..
Super Contributor..

Re: SQL Validations not populating as expected

Jump to solution

This seems to have worked!!

I have no idea if the setting changed or not - I certainly didn't change it.

What exactly does that particular setting do? will there be any other downstream impacts as a result of having made the change?

0 Likes
MIF Super Contributor.
Super Contributor.

Re: SQL Validations not populating as expected

Jump to solution

Hi,

Parameter is there for performance improvement as well as user experience improvement. If you have very large set of values for auto complete fields it will take some time to populate them all.

For short, if you don't have performance problems or users complaining about waiting for a list to be populated then leave the parameter as false.

--Remember to give Kudos if you like the solution.

Murat Akbar
MIF Software & Consultancy - Istanbul
http://www.mif.com.tr
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.