Choice database file

[jac53]

I have two screens with a choices database file.
Both have the same choice database file, the same choice options field, and choices selection criteria.
One of them works fine the other does not show the window with the results.
Any ideas?

[Scott Klement]

When you use the database-driven autocomplete feature on a textbox, it will build and run an SQL statement.

To see the SQL statement that it has generated:

1. Navigate to the screen where the autocomplete is failing.
2. With that screen still open, use another session to view the contents of the PUISSNVP file (this is in the library where you installed Profound UI)
3. Look for a record (it may be near the bottom) containing the SQL statement. If many people are running database-driven widgets, there may be many statements in the file, so you'll need to look for the right one.
4. Sometimes customers will copy/paste this statement into their "Run SQL Scripts" window or similar to test them out.

To see the error that's being received when Genie runs the statement:

1. Navigate to the screen where autocomplete is failing
2. Open the browser's developer tools, and switch to the network tab. Depending on your browser, you may need to tell it to begin capturing network traffic.
3. Type something that should activate the auto-complete function in your textbox
4. In the network tab, you should see a call to a URL for PUI0009102.PGM
5. View the 'response' from that program to see the error received

[jac53]

This what is in the file. See attachment.
But the field should be I_3_16 instead of I_4_16.
After an implementation it looks like the fields went with wrong sequences. I tried to fixed and enter all the info for that field the choice data base but it is pulling the next field in the screen instead as you can see in the attachment.
What would be the best way to fix this mess?

[Scott Klement]

Sorry, I don't understand what you mean by "wrong sequences".

Are you saying that it is attached to the wrong field on the screen? That's controlled by which field you click on in the Genie designer when you adjust the properties.

Are you getting an error? I explained how to view the error message, and you don't seem to have told me what the error message said.

[jac53]

No, it is attached to the right field I_3_16 but in my attachment genie issue2 you can see I_4_16.
After we applied ORACLE JD Edwards 9.4 I do not know why the properties of fields moved for example:
The field I_2_16 had a select box with values "I" for inquire "A" Add and so on. That properties moved to the field I_3_16 which is the one in question.
The properties of the field I_3_16 moved to field I_4_16. I do not why. That is what I meant as wrong sequence.
I fixed and attached the right properties to each field, but when I check the file you suggested PUISSNVP after invoking the choice data base in the field I_3_16 it is showing field I_4_16 and the SQL with a ?.
Thank you for your help and interest on this and your help will be appreciated.

[jac53]

Sorry I did the test again and now is pointing to the right field. The other suggestion honestly I do not where to go to open the browser's development tool.

File Format Mode
DATA BASE UTILITY (DBU)
File . . . : PUISSNVP Member . . : PUISSNVP Record Length . : 32166
Library . : PROFOUNDUI Format . . : PUISSNVR File Access . . : Keyed
Page# . . . : 1 of 32 Mode . . . : Display Record Number . : 3
Control . . . Text . . . :

Name genie.I_3_16

Value SELECT DISTINCT MCMCU, MCDL01 FROM F0006 WHERE UPPER
(MCMCU) LIKE ? AND ((MCSTYL = 'DC' )) ORDER BY MCMCU







More...
F1=Help F2=ON/OFF F=keys F3=Exit F4=List fields
F5=Refresh F6=Set key F10=Action F24=More keys

[Scott Klement]

which browser do you use?

[jac53]

Internet Explorer 11
I tested in Chrome and in Microsoft Edge without results.
But in the other menu option runs OK.

[jac53]

I found the following error in the I Series instance:

Message ID . . . . . . : SQ99999 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent . . . . . . : 04/24/21 Time sent . . . . . . : 07:24:36

Message . . . . : Error occurred in SQL Call Level Interface
Cause . . . . . : A procedure call encountered an error. The error code is
9. Error codes are:
3 -- Program type out of range.
4 -- SQL data type out of range.
9 -- Argument value not valid. < ----------------


Value SELECT DISTINCT MCMCU, MCDL01 FROM F0006 WHERE UPPER
(MCMCU) LIKE ? AND ((MCSTYL = 'DC' )) ORDER BY MCMCU
Looks like the error is the "?". Is that a substitution parameter?
Why is not replacing it?

[Scott Klement]

I wanted to tell you how to look at the network debugging information, and you said you didn't know how to do that. So, I asked for the web browser so that I could give you the steps for your browser. But, you listed 3 browsers. :-) I am not at a Windows computer right now, so I'll tell you how to use Chrome since I can't look into Internet Explorer (which you should consider retiring... noone uses that anymore, even Microsoft is telling everyone to stop) or Edge.

In Chrome, you have a menu in the upper-right. On Mac, it looks like 3 dots. On other computers, it may look a little different -- but its Chrome's primary menu, so I'm sure you'll find it. Open that menu, it shows all of Chrome's options, one says "More tools". Under "More tools, you'll find "Developer tools".

On that menu you'll find tabs for "Elements", "Console", "Sources", "Network" and more. "Network" is the one you need for this. I don't remember if you have to enable anything or not to start recording network events, but it should tell you on the screen. If it needs to be enabled, enable it. Then, type into the text box and it'll create a request (maybe multiple requests).

You need to find the request to PUI0009102, click on it, and you will have tabs related to that particular network request. Beneath "Headers" there's a section titled "query string parameters" that will show you what was sent to the IBM i, and a tab called "Response" that shows what is received in response.

Perhaps that will provide some clues as to what is going on.