Page 1 of 2
Application startup error in CSEntry 8.0 android app
Posted: February 6th, 2024, 12:04 am
by parthsaha2023
Dear Admin & team,
I am facing strange issue after upgrading to CSEntry 8.0. Now all my apps are not starting. CSEntry says "Starting <app name>" and then closes the CSEntry. No message and nothing else.
Earlier all the apps were working without any issue.
As a workaround, I updated the App to include "errmsg" to force the application show a welcome message and this helps in starting the app.
I don't know if this was due to CSEntry update or may be due to my mobile got upgraded to Android 14.
Please help to diagnose the problem, as I have many apps and many users are running the apps. It will be catastrophic to help everyone with the issue.
Thanks for any help in advance!
Parth Saha
Re: Application startup error in CSEntry 8.0 android app
Posted: February 6th, 2024, 10:36 am
by justinlakier
Hello,
Could you send us the apps so that we can test why this is happening? You can post the zipped files here, or send it to
cspro@lists.census.gov if you do not want it publicly viewable.
Thank you,
Justin
Re: Application startup error in CSEntry 8.0 android app
Posted: February 7th, 2024, 1:17 am
by parthsaha2023
Sure, I have sent the zip file through email.
Parth
Re: Application startup error in CSEntry 8.0 android app
Posted: February 7th, 2024, 4:25 pm
by justinlakier
Hello Parth,
I do not see your message at
cspro@lists.census.gov. If there was a typo in the address or other delivery issue, you can try again. You can also post your files here if unable to deliver them through email.
Thank you,
Justin
Re: Application startup error in CSEntry 8.0 android app
Posted: February 12th, 2024, 9:57 am
by Foxedu
I have the same problem, it has been updated to version 8, but the tablet with Android 11 works, and with Android 12 or 13 it does not work, close the application
Re: Application startup error in CSEntry 8.0 android app
Posted: February 15th, 2024, 7:37 am
by Xavi
I have the same problem with the applications that were running well with CSPRO 7.7.3 and getting the following warning:
warning (10102)
Could not open the data source "dict_name": table `level-1` already exists.
warning (10106)
Due to errors, the data source for "dict_name" is set to an empty data source
Re: Application startup error in CSEntry 8.0 android app
Posted: February 20th, 2024, 5:27 pm
by justinlakier
Hello,
We did not receive Parth's files at
cspro@lists.census.gov. In order to find whether these are the same error, and what is causing these errors, we need copies of your apps with test data to reproduce. Please send zipped files of your applications and all testing data files or instructions to
cspro@lists.census.gov so that we can attempt to replicate your problems and solve them in testing.
Thank you,
Justin
Re: Application startup error in CSEntry 8.0 android app
Posted: February 22nd, 2024, 9:50 am
by Foxedu
I sent you a message to the email, with files attached
Re: Application startup error in CSEntry 8.0 android app
Posted: February 22nd, 2024, 11:57 pm
by vgonzalez
I'm having the same problem with apps that were working fine with CSEntry 7.7.3 and since I don't have the auto-update option disabled, it now generates the following error messages:
System error 10106: Due to errors, the data source for %s is configured as an empty data source
System error 10102: Could not open data source %s: %s
I have tried to delete the new tables and indexes from version 8.0 first by identifying it with the following Query
Code: Select all
SELECT COUNT(*) AS CASES FROM `main`.sqlite_master WHERE type='table' AND tbl_name = 'binary-sync-history'
And then I execute the respective DROP functions if the tables and indexes exist, however, I have identified that I cannot go back to version 7.7.3 because in the CSPro meta table, the Dictionary field has the dictionary in JSON format and when I trying to update In the previous ASCII version, the SQLQUERY function generates an error, I assume it is due to the delimiter used for character strings (", ' or `).
For example:
Code: Select all
STRING strMessage4 = '"'
// Dictionary in ASCII Format available in the auxiliary control database
numCountNewTables = SQLQUERY(PATHCONCAT(Application,"..\COMUN\Censo2023.csdb"), strDataBaseDic, "SELECT dictionary FROM meta");
IF numCountNewTables > 0 THEN
strMessage5 = CONCAT("UPDATE meta SET dictionary = ", strMessage4, strDataBaseDic(1), strMessage4);
TRACE(strMessage5); //View the character string in the trace file
errmsg(strMessage5); //View the character string in a message
SQLQUERY(PATHCONCAT(Application,"..\DATA\Censo2023.csdb"), strMessage5);
ENDIF;
That code generate the following error messages: System error 8292 SqlQuery %s error: %s
And I have corroborated the generated code that it does work using another database manager such as DB Browser for sqlite and when executing the statement it does work
Does anyone know a way to pass the dictionary in ASCII format to the Dictionary field of the target table when doing the
executing an UPDATE statement with the SQLQUERY function?
Re: Application startup error in CSEntry 8.0 android app
Posted: February 26th, 2024, 9:03 am
by Gregory Martin
Single quotes must be escaped. You can use the replace function:
https://www.csprousers.org/help/CSPro/r ... ction.html
dict_text = replace(dict_text, "'", "''");
Let us know if this doesn't work.