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);'

Change History (0)

Note: See TracTickets for help on using tickets.