Page 1 of 1

Problem "Choices Database File" AS400 Database

Posted: Fri Dec 26, 2014 8:01 am
by JPG
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

Re: Problem "Choices Database File" AS400 Database

Posted: Fri Dec 26, 2014 11:10 am
by Glenn
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

Re: Problem "Choices Database File" AS400 Database

Posted: Fri Dec 26, 2014 11:37 am
by Glenn
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.

Code: Select all


Library GHOPWOODX not found.  
Library list not replaced.    

Glenn

Re: Problem "Choices Database File" AS400 Database

Posted: Fri Dec 26, 2014 2:20 pm
by Scott Klement
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.

Re: Problem "Choices Database File" AS400 Database

Posted: Wed Dec 31, 2014 12:41 pm
by JPG
Thanks for your answers . I will review this.

Re: Problem "Choices Database File" AS400 Database

Posted: Fri Jan 02, 2015 6:28 am
by epinar
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]
iaspBASE.jpg
iaspBASE.jpg (66.01 KiB) Viewed 918 times
[/img]

And this is the image for a file in iasp H9O:

[img]
iaspH9O.jpg
iaspH9O.jpg (183.53 KiB) Viewed 918 times
[/img]


Thanks.

Re: Problem "Choices Database File" AS400 Database

Posted: Fri Jan 02, 2015 8:12 am
by Scott Klement
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?

Re: Problem "Choices Database File" AS400 Database

Posted: Fri Jan 02, 2015 8:37 am
by epinar
Hi Scott,

we work with last version (Version: 5.0.4).

Thanks.

Re: Problem "Choices Database File" AS400 Database

Posted: Wed Jan 14, 2015 7:16 am
by Scott Klement
I have fixed this on our development box. The fix will be included in the next release of Profound UI.