How to run SmartDataObject on AppServer from a 4GL Client

Posted by sajala on 06-Aug-2014 23:11

I have search in many documents about running SDO in AppServer.

My problem is

- When I define AppServer in Server Parameter Maintanance under PRO Tools, I can select the Partition field in SDO. But when I try to run that SDO from 4GL client that does not have DB coneection, it gives error followed by information as below:

Attempt to connect a partition named AppServer (AppServer is my partition name). This partition is not currently defined in the Service Parameter Maintenance tool.

AppServer partition is running locally without the proper database connection(s).

My question is how to dump that partition? or how  can  the partition be available for the SDO from 4GL Client?

Thanks in advance.

Posted by Mike Fechner on 08-Aug-2014 00:30

There are a few articles in the knowledbase dealing with the appsrvtt.d file:

http://knowledgebase.progress.com/articles/Article/21542

http://knowledgebase.progress.com/articles/Article/000049235

http://knowledgebase.progress.com/articles/Article/000034044

The file is storing the definitions that you have obviously done in the service parameter maintenance during development and much be available at runtime.

The ADM2 documentation is AFAIK not part of the current doc sets anymore. But the archived docs here may help:

https://community.progress.com/technicalusers/w/openedgegeneral/1568.10-1b-adm-and-smartobjects-manual.aspx

https://community.progress.com/technicalusers/w/openedgegeneral/1569.10-1b-adm-reference.aspx

Look out for a chapter on “Developing Your Application’s Business Logic” and “Running SmartDataObjects in a distributed environment”

 

All Replies

Posted by Mark Davies on 07-Aug-2014 08:28

How are you running the SDO? Is it on a container or are you attempting to run it manually somehow?

Are you running standard ADM2 or Dynamics?

Posted by Mike Fechner on 07-Aug-2014 08:36

Just a rough guess. As you say you are already using the Server Parameter Maintenance and assigning a Partition, I assume that you've already made sure, that the runtime uses the appropriate appsrvtt.d file.

Please verify further - based on the error message stack trace (help button) you are executing the sdo _cl.w or .r file on the client.

You may just be missing to set the DB Required flag on a single procedure/function in the SDO source code to exclude it from the client portion.

Posted by sajala on 07-Aug-2014 23:44

Thankyou Mark for your response.

The SDO is in a Smart Window along with Smart Browser and Smart Viewer. The Smart Window is run by a simple procedure (start.p) with the statment:

run VALUE(cStartProcedure)

            no-error.

Then the start.p is run from the progress 4GL Client.

I am just creating a test program of adm2 using AppBuilder so I am unaware about the fact that it is either running in standard ADM2 or Dynamics.

Regards,

Sajala

Posted by sajala on 08-Aug-2014 00:08

Thank you Mike for your response.

I am new to adm2 so I don't exactly know how the appsrvtt.d is associated to SDO at tuntime. Can you elaborate it?

Can sdo_cl.w can be use to create smart viewer or browser? What is the difference when we use sdo.w or sdo_cl.w?

Currently my program uses sdo.r to execute.

Regards,

Sajala

Posted by Mike Fechner on 08-Aug-2014 00:30

There are a few articles in the knowledbase dealing with the appsrvtt.d file:

http://knowledgebase.progress.com/articles/Article/21542

http://knowledgebase.progress.com/articles/Article/000049235

http://knowledgebase.progress.com/articles/Article/000034044

The file is storing the definitions that you have obviously done in the service parameter maintenance during development and much be available at runtime.

The ADM2 documentation is AFAIK not part of the current doc sets anymore. But the archived docs here may help:

https://community.progress.com/technicalusers/w/openedgegeneral/1568.10-1b-adm-and-smartobjects-manual.aspx

https://community.progress.com/technicalusers/w/openedgegeneral/1569.10-1b-adm-reference.aspx

Look out for a chapter on “Developing Your Application’s Business Logic” and “Running SmartDataObjects in a distributed environment”

 

Posted by sajala on 08-Aug-2014 05:13

Hello Mike,

Does Appsrvtt.d only associate to SDO while running from AppBuilder? Because while running the smartwindow from AppBuilder, it does not gives error but when I run it from 4GL client, then ony it gives error.

Actually when I run the window from AppBuilder, it runs locally so that may be also the reason of no error.

How can I put the Appsrvtt.d file in my PROPATH if it is created runtime? or  which location should I put it in my PROPATH?

Best Regards,

Sajala

This thread is closed