Session Error Message

Das Goravani goravanis at
Mon Jan 31 18:00:26 UTC 2022

Well I figured it out partly.

I got it to work, without a SQL error message.

By switching from a REF to my session object to using the actual session object.

It seems my REF is not quite right. 

Here is my LOGON method line:

Do tSessObjPG.$logon('',iUserName,iUserPassword,'PGSESSION') Returns #F

It establishes a session named PGSESSION

Here is my method line that makes my REF to the session object:

Calculate tSessObjPGRef as $extobjects.PGSQLDAM.$objects.PGSQLSESS.$newref()

It makes a REF OK, but it’s not the one that is logged on?

How do I make a ref from the session that is logged on?

> On Jan 31, 2022, at 12:52 PM, Das Goravani <goravanis at> wrote:
> I have the following code:
> Do cvCitiesList.$definefromsqlclass($tables.tccities)
> Do cvCitiesList.$smartlist.$assign(kTrue)
> Do cvCitiesList.$sessionobject.$assign(tSessObjPGRef) Returns #F
> Prepare for import from file Delimited (commas)
> Import data cvCitiesList
> Close import file
> End import
> Do cvCitiesList.$doinserts() Returns #S1
> When I run it on the last line it goes into the SQL error method I have in the table class and the error message text is "Session not logged on" and "Session must be logged on"
> I am logged on to postgres. I have a session showing up under the SQL Browser, so I know I’m connected. I am assigning as you can see the Session Object Ref to the list.
> I don’t get where "The session is not logged on". 
> Any ideas?

More information about the omnisdev-en mailing list