Opened 8 years ago
Last modified 8 years ago
#1513 closed defect
WMS_Increase the size of rasql fragment query in varchar — at Initial Version
Reported by: | Bang Pham Huu | Owned by: | Bang Pham Huu |
---|---|---|---|
Priority: | major | Milestone: | 9.4 |
Component: | petascope | Version: | development |
Keywords: | Cc: | Dimitar Misev, Vlad Merticariu | |
Complexity: | Medium |
Description
current WMS 1.3 only set rasql fragment to varchar(255), it should be set larger or have error
Mar 22 12:56:34 xx server[1490]: DEBUG [12:56:34] BaseMappedStatement@41: insert data with statement 'INSERT INTO "wms13_style" ("name" ,"title" ,"styleAbstract" ,"legendURL_id" ,"rasqlQueryTransformer" ,"layer_id" ) VALUES (?,?,?,?,?,?)' and 6 args, threw exception: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255) Mar 22 12:56:34 xx server[1490]: TRACE [12:56:34] BaseMappedStatement@38: insert arguments: [ts_e15s25_r_g_b, ts_e15s25_r_g_b, color png, null, { (char)(($Iterator.0 - min($Iterator.0)) * (255 / max($Iterator.0 - min($Iterator.0)))), (char)(($Iterator.1 - min($Iterator.1)) * (255 / max($Iterator.1 - min($Iterator.1)))), (char)(($Iterator.2 - min($Iterator.2)) * (255 / max($Iterator.2 - min($Iterator.2)))) }, 3]
also, update_petascopedb.sh needs to run a psql command to update existing petascopedb.
e.g: change to 2000 characters.
psql -U postgres petascopedb -c 'ALTER TABLE wms13_style ALTER COLUMN "rasqlQueryTransformer" TYPE varchar (2000);'
Note:
See TracTickets
for help on using tickets.