CSPro Users Forum

Posted: **October 25th, 2023, 10:47 pm**

I dumped the entire cspro database from my online server as SQL file and imported it into my local machine (a laptop) with XAMPP. The csweb on my localhost correctly detected the number of cases.

But when I tried to download those cases into CSDB using csweb's provided PFF, I got 0 cases downloaded without any error, while in fact there are ~100000 cases on my local database.. What is wrong?

Below is my sync.log entries:

2023-10-25 12:57:30,515 INFO: Connect to server http://localhost/csweb_kw3/api/ using saved credentials
2023-10-25 12:57:30,515 INFO: Connect to server http://localhost/csweb_kw3/api/
2023-10-25 12:57:30,751 INFO: Server API version: 2
2023-10-25 12:57:30,751 INFO: Connection successful. Server id: cebe1471-3db5-4f05-9dd5-91a53b8cc30c
2023-10-25 12:57:30,751 INFO: Downloading dictionary file: SKI2023_DICT
2023-10-25 12:57:30,855 INFO: Downloading dictionary file complete
2023-10-25 12:57:31,003 INFO: Syncing data: ski2023_dict.csdb direction GET universe ""
2023-10-25 12:57:31,003 INFO: First time GET with this server
2023-10-25 12:57:31,003 INFO: Start case download with chunk size of 100
2023-10-25 12:57:31,113 INFO: Status : 200
2023-10-25 12:57:31,113 INFO: Server case count = 0/0
2023-10-25 12:57:31,222 INFO: New server revision = 2
2023-10-25 12:57:31,222 INFO: Sync GET completed.
2023-10-25 12:57:31,222 INFO: Downloaded 0 cases
2023-10-25 12:57:31,222 INFO: 0 new cases, 0 updated, 0 ignored, 0 conflicts
2023-10-25 12:57:31,222 INFO: Disconnecting from server

Why does it say

Code: Select all

Server case count = 0/0

while in fact there is over ~100000 cases ? The address is correct (i.e http://localhost/csweb_kw3/api/) and also I attached my csweb UI on localhost below:

: Cuplikan layar 2023-10-26 094259.png (46.08 KiB) Viewed 2841 times

Posted: **October 26th, 2023, 4:37 pm**

Can you send us the logs from CSWeb folder var/logs/? You can email to cspro@lists.census.gov.

Posted: **October 30th, 2023, 11:14 pm**

savy wrote: ↑October 26th, 2023, 4:37 pm Can you send us the logs from CSWeb folder var/logs/? You can email to cspro@lists.census.gov.

The "logs" folder contains one file "ui.log" and it is empty. I tried to redo all my steps above and it stays empty. And no cases are downloaded, still.

Posted: **October 31st, 2023, 6:14 am**

FIXED I forgot to also import the "cspro_sync_history" table and its records from the old server. Because I was lazy, I created a new record in that table using raw SQL command with revision value of "99999" and all of the cases were downloaded successfully without anything missing. Thank you

CSPro Users Forum

Zero cases imported since moving database location to local machine

Zero cases imported since moving database location to local machine

Re: Zero cases imported since moving database location to local machine

Re: Zero cases imported since moving database location to local machine

Re: Zero cases imported since moving database location to local machine