Cannot upload Dictionary into CSWeb

Discussions about syncing data via Bluetooth, Dropbox, FTP, and using CSWeb
Forum rules
New release: CSPro 8.0
Post Reply
vanDjango
Posts: 3
Joined: March 21st, 2020, 1:59 pm

Cannot upload Dictionary into CSWeb

Post by vanDjango »

Hi everyone,

I hope everybody is safe during those critical days...

As the name of the topic I've tried to upload the dictionary both through the csweb app (the "Add Dictionary" button under ui/dashboard)
and through the app deployment from CSPro desktop app. I'm using CSPro 7.3 and CSWeb 7.3

In both cases I receive the following error messages

#CSWeb
"Failed to add dictionary. We are sorry, but something went terribly wrong."
Apache Logs:
"POST /api/dictionaries/ HTTP/1.1" 500 299 "-" "GuzzleHttp/6.3.3 curl/7.52.1 PHP/7.0.3
3-0+deb9u7"
"POST /ui/dashboard/dictionaries HTTP/1.1" 500 299 "http://..../ui/dashboard/"
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/.....Safari/537.36"


#CSPro Deploy Application
"Error uploading dictionary. We are sorry but something went terribly wrong..(500)"
Apache Logs:
"GET /api/server HTTP/1.1" 200 210 "-" "CSPro sync client/7.3.1"
"PUT /api/apps/PopulationRegistryEntryV2 HTTP/1.1" 200 270 "-" "CSPro sync client/7.3.1"
"POST /api/dictionaries/ HTTP/1.1" 500 324 "-" "CSPro sync client/7.3.1"


Any Idea on how can I solve this problem or debug it properly?

Thanks
vanDjango
Posts: 3
Joined: March 21st, 2020, 1:59 pm

Re: Cannot upload Dictionary into CSWeb

Post by vanDjango »

Ok,

Just to keep you posted...
I looked inside the api.log file and when I try to upload the dictionary the error I receive is the following:

CSPro API.CRITICAL: PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'dictionary_name' at row 1 (uncaught exception) at /var/www/
csweb/src/api/app/helpers.php line 137 {"exception":"[object] (PDOException(code: 22001): SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'dictionary_name' at row 1
at /var/www/csweb/src/api/app/helpers.php:137)"} []

Will start from here...
vanDjango
Posts: 3
Joined: March 21st, 2020, 1:59 pm

Re: Cannot upload Dictionary into CSWeb

Post by vanDjango »

I've sorted out.
I was using too long dictionary record names.
So now it is working.

Unfortunately, there is no information about this limitation.
Gregory Martin
Posts: 1777
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Cannot upload Dictionary into CSWeb

Post by Gregory Martin »

Sorry for the error. There was a limit on dictionary names of 32 characters. We will remove this restriction in CSPro 7.4.
Post Reply