I found the log for the same select with returned rows and no returned rows (with the same versión of code)

Hi:

We suspect that the connection to the Database is not stable the first 3-5 times the mobile application is started from the Appeon workspace.

For example, when we select an option we checked the connection, and if it is correct, a record is retrieved. The first time the result is that it does not recover anything:

In this case, as doesn't have returned any row, we check the connection, and give us OK:

And later the same operation is OK:

How can we controle / mange this cases?

Thanks in advance, 

Oihana

Hi Zaho, Crhis and Miguel:

For example, we are sincronizing the online and offline DBs and something is going wrong, but we have no way of knowing what happened.

The issue is when we synchronize large volume of data. With 7000 records there is no problem but at which we increase the number fails. And we don't have the way to know where is the problem.

For sincronize first we do retrieve the data on the oracle online DB and then we do a rowscopy and update to a SQLite DB.

ll_rows_a_sincro = lds_datos_ori.retrieve() //online transaction. Source
IF lds_datos_ori.RowsCopy(lds_datos_ori.GetRow(), lds_datos_ori.RowCount(), Primary!, lds_datos_dest, 1, Primary!) > 0 THEN

ll_ret = lds_datos_dest.update() //offline transaction. Destiny
IF ll_ret = 1 THEN

ll_rows_sincro = lds_datos_dest.rowcount()
COMMIT USING sqlca;

ELSE

f_informa_error_bd(sqlca.SQLCode, "'(OFF) Sincronizando tabla "+ as_tabla +". Error: " + sqlca.sqlerrtext)
ROLLBACK USING sqlca;

END IF

END IF

The PowerServer log doesn't give us much information or I can't find this kind of information. I attach the Error and Server logs. I thinks that the problem is on the retrieve but I'm not sure and I don't know how to fixe it.

Note: if I execute on my PC I can sincronize 176.000 registers without problems, and it takes 29 seconds. The problem is only on the mobile.

Thanks to everybody,

Oihana 

I think Oihana is asking what to do with the dberror event's code, if this event isn't supported.

Hi Oihana,

Can you tell us how are you going to manage the transaction? Although it doesn’t support DBError, disconnect is supported. You can use transaction.SQLcode and transaction.sqlerrtext to locate the issue.

You can also use the PowerServer log and the PowerServer Error log to help locate the issue when exception or error occurs:
https://docs.appeon.com/appeon_online_help/ps2019/server_configuration_guide_for_net/Logs.html

Regards,
ZhaoKai

Hi Oihana;

   All that is managed by PowerServer. All you need to do is inform PS or a successful or unsuccessful business transaction via the standard Commit / Rollback DML commands. The SQLCA Connect is only a "logical" connection to one of PowerServer's DataSource DB Connection pools.

Regards ... Chris