OK, replying to my own question. The health-ui page shows that the webserver to DB server connection works:

That brings me to the second question: transaction to cache mapping. What I didn't understand was what exactly "transaction object name" is. All examples in the help that I've seen so far use sqlca, so it seems to be a name of a variable of the transaction data type. I was trying to make the following script work:

transaction ltr_trans

ltr_trans = create transaction
if f_connect_trans_object( ltr_trans) then parent.triggerEvent( 'ue_connected')


global function boolean f_connect_trans_object (transaction atr_trans);
if f_init_trans_object( atr_trans) then
	connect using atr_trans;
	if atr_trans.sqlcode <> 0 then
		messageBox( 'Error connecting to the database', atr_trans.sqlErrtext, stopsign!)
		return false
	else
		return true
	end if
else
	messageBox( 'Error', 'Error reading DB credentials from the INI file', stopsign!)
	return false
end if

end function

Initially, I used ltr_trans but it didn't work. After I added atr_trans as well, the app successfully connected.

What I would appreciate is more detailed explanation of which transaction object variables need to be mapped to caches. I don't seem to be able to find it in PowerServer help. Thanks!

HI Konstantin ;

  The issue is most likely in the middle tier (aka PowerServer) and not your Web Server. The WS would only be used as a deployment vehicle for your PS based PB App EXE & resources. Once the PB App starts on the client machine, the PB App will use HTTP(s) to communicate directly to PS for DML processing requests. It's PS that will be performing all the DML activity with your DBMS. So in your PS project within the PB IDE where you set-up the "DB Cache" for your Transaction object is where the DB timeouts settings are defined. So I would suggest that you review those for appropriate timeout values for you Oracle environment & app processing.

  Note that in PB 2022 R3 you can now use the LongConnection setting to over-ride your DB Cache settings in PS when a PB App needs extra DBMS time.

For example ...

SQLCA.DBParm = "LongConnection=1"

HTH

regards ... Chris