S
sauqad
Guest
"entered into the port box then my ABL code can't connect to the database and I get "ambiguous table" errors." - I have also faced this problem multiple times. Multiple reasons 1. Primary Reason : A database is not linked to PAS instance and project ( we have to link database to project as well as PAS instance ) 2. PAS instance is not up and running ( reason - OEM is not up and running ) 3. OEM is not running ( reason admin server is not running ) When all the required services are running and linked to each other, then also I have faced similar problem i.e. to fetch data from the database. In the end, I have to close all the projects, and close PDSOE. Sometime, restart of PDSOE resolved the issues. ____________________________________________________________________________________________ Where have you hosted your setup ( database + PDSOE + PAS instance ) - is it on laptop or server? If you have full control of your system ( and no other users are connected to the environment ), then you can perform below steps Close PDSOE Check if the database is still up and running Close the database server using the command: proshut Sports2000 -by Start the database server command: proserve Sports2000 -S 4256 -H localhost Open PDSOE and configure the database connection profile as mentioned in Point 2 of the previous post Link the database to project - Right Click on folder -> Properties -> ProgressOpenEdge -> Database Clean shutdown and restart of environment will fix the problem. ___________________________________________________________________________________________ Progress has suggested creating a separate PAS instance as a good practice. I have also created a separate PAS instance. This will help in implementing the PAS instance for production as There is no default PAS instance in PROD version All transports are disabled by default ( transports - REST / AIA / SOAP ) Tomcat and OE manager are not installed Authentication Gateway does not work with the development version of PAS instance Basic Command to create PAS instance: pasman create -p -P -N Eg - pasman create -p 20100 -P 20200 -N devlpas D:\devl\pas ( it will create a new PAS instance inside D:\devl\pas folder
Continue reading...
Continue reading...