Hello,
In the designer using for example "Combo Box" and putting library/database file in properties "Choices Database File", when I try to select "Choices value field" or "Choices option field", I get the error attached image.
Option "Library List", has the correct libraries.
Tks
Problem "Choices Database File" AS400 Database
-
- Profound User
- Posts: 54
- Joined: Fri Dec 19, 2014 12:24 pm
- First Name: Juan
- Last Name: Perez Garcia
- Company Name: NISA
- State / Province: Outside Canada/USA
- Country: Spain
- Contact:
Problem "Choices Database File" AS400 Database
- Attachments
-
- Captura.JPG (13.47 KiB) Viewed 1069 times
- Glenn
- Profound Logic Staff Member
- Posts: 124
- Joined: Mon Apr 14, 2014 4:08 pm
- First Name: Glenn
- Last Name: Hopwood
- Company Name: Profound Logic Software
- State / Province: Ohio
- Country: United States
- Contact:
Re: Problem "Choices Database File" AS400 Database
In my experience this error is caused by a typo in the list of libraries. Since you say the list is correct, it could also be an authority issue. Is the user you're signed in with authorized to all the libraries in the list?
Glenn
Glenn
- Glenn
- Profound Logic Staff Member
- Posts: 124
- Joined: Mon Apr 14, 2014 4:08 pm
- First Name: Glenn
- Last Name: Hopwood
- Company Name: Profound Logic Software
- State / Province: Ohio
- Country: United States
- Contact:
Re: Problem "Choices Database File" AS400 Database
You can also get more information on the error by finding your Designer job in the QHTTPSVR subsystem and looking at the job log. You should see a more specific error listed before the one you're seeing in the Designer.
For example, if I try to add a library that I know doesn't exist, these are the errors I see in the job log.
Glenn
For example, if I try to add a library that I know doesn't exist, these are the errors I see in the job log.
Code: Select all
Library GHOPWOODX not found.
Library list not replaced.
-
- Experienced User
- Posts: 2711
- Joined: Wed Aug 01, 2012 8:58 am
- First Name: Scott
- Last Name: Klement
- Company Name: Profound Logic
- City: Milwaukee
- State / Province: Wisconsin
Re: Problem "Choices Database File" AS400 Database
Another possible cause is putting 'PROFOUNDUI' (or whichever library you installed the product in) into your library list. Since the product will add this library automatically, it will create a conflict if you try to add it as well.
-
- Profound User
- Posts: 54
- Joined: Fri Dec 19, 2014 12:24 pm
- First Name: Juan
- Last Name: Perez Garcia
- Company Name: NISA
- State / Province: Outside Canada/USA
- Country: Spain
- Contact:
Re: Problem "Choices Database File" AS400 Database
Thanks for your answers . I will review this.
-
- New User
- Posts: 7
- Joined: Wed Jun 11, 2014 4:10 am
- First Name: Enrique
- Last Name: Pinar
- Company Name: Hospitales NISA
- Country: Spain
- Contact:
Re: Problem "Choices Database File" AS400 Database
Hi Scott,
Happy new year!
I am a colleague of JPG.
We work with IASP. I think the problem is that when we started the " Visual Designer" is not loading the IASP the connecting user.
Yes that is loaded in the options "Open" , "Convert ", "Save " and " Save As", but when you chose the DSPF, then removes the IASP and works only with the *BASE.
Would it be possible when connected to the "Visual Designer" always keep the IASP the user connecting?.
This is the Joblog for the option "Open" (H9O is the name of IASP):
ASP group H9O established.
Changed the property of PUIMBRLIST object type QTEMP
*USRSPC.
ASP Group set to *NONE.
And this is the joblog for the option "convert" (H9O is the name of IASP):
ASP group H9O established.
ASP Group set to *NONE.
This is the image for a file in *BASE:
[img] [/img]
And this is the image for a file in iasp H9O:
[img] [/img]
Thanks.
Happy new year!
I am a colleague of JPG.
We work with IASP. I think the problem is that when we started the " Visual Designer" is not loading the IASP the connecting user.
Yes that is loaded in the options "Open" , "Convert ", "Save " and " Save As", but when you chose the DSPF, then removes the IASP and works only with the *BASE.
Would it be possible when connected to the "Visual Designer" always keep the IASP the user connecting?.
This is the Joblog for the option "Open" (H9O is the name of IASP):
ASP group H9O established.
Changed the property of PUIMBRLIST object type QTEMP
*USRSPC.
ASP Group set to *NONE.
And this is the joblog for the option "convert" (H9O is the name of IASP):
ASP group H9O established.
ASP Group set to *NONE.
This is the image for a file in *BASE:
[img] [/img]
And this is the image for a file in iasp H9O:
[img] [/img]
Thanks.
-
- Experienced User
- Posts: 2711
- Joined: Wed Aug 01, 2012 8:58 am
- First Name: Scott
- Last Name: Klement
- Company Name: Profound Logic
- City: Milwaukee
- State / Province: Wisconsin
Re: Problem "Choices Database File" AS400 Database
You are correct, Enrique. It appears that the Visual Designer does not set the user's ASP group when retrieving a field listing.
I can look into fixing this... can you tell me what version of Profound UI you are running?
I can look into fixing this... can you tell me what version of Profound UI you are running?
-
- New User
- Posts: 7
- Joined: Wed Jun 11, 2014 4:10 am
- First Name: Enrique
- Last Name: Pinar
- Company Name: Hospitales NISA
- Country: Spain
- Contact:
Re: Problem "Choices Database File" AS400 Database
Hi Scott,
we work with last version (Version: 5.0.4).
Thanks.
we work with last version (Version: 5.0.4).
Thanks.
-
- Experienced User
- Posts: 2711
- Joined: Wed Aug 01, 2012 8:58 am
- First Name: Scott
- Last Name: Klement
- Company Name: Profound Logic
- City: Milwaukee
- State / Province: Wisconsin
Re: Problem "Choices Database File" AS400 Database
I have fixed this on our development box. The fix will be included in the next release of Profound UI.
Who is online
Users browsing this forum: No registered users and 0 guests