Kbase P11854: Error 1006 running local Appserver configuration
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/06/2009 |
|
Status: Verified
SYMPTOM(s):
Error 1006 running SDO using a "local" Appserver Partition
Database <db name> not connected. (1006)
FACT(s) (Environment):
Appserver is already connected to the database
Appserver Server is running in the the same machine as the Progress Session
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
This scenario usually happens when simulating a WebClient session using a regular Progress session without connection to the database.
When using SDO's and Appserver, you need to configure the SDO instance to use a Appserver partition. The Appserver partition is configued using the Service Parameter Maintenance tool available from Pro*Tools.
When configuring the Appserver Service, if you choose the "Local" option as the method to connect, it causes the Appserver configuration to be ignored and run all procedures locally. This means that all the procedures that are configured to run on the Appserver side will no longer run in the Appserver but locally. Therefore, a connection to the database is required to be able to fetch data from the database.
As opposed to if you choose "Remote" only the Appserver is be required to be connected to the database.
FIX:
Change the configuration from "Local" to "Remote".
1) Go to Pro*tools
2) Open Service Parameter Maintenance tool
3) Click on "AppServer" tab folder
4) Select the Partition
5) Change the configuration option from "Local" to "Remote".
6) Save the configuration
7) Close Service Parameter Maintenance tool ansering "yes" to the question: "The Partition setup has been changed ......."