Opened 4 months ago

Closed 4 months ago

#1513 closed defect (fixed)

WMS_Increase the size of rasql fragment query in varchar

Reported by: bphamhuu Owned by: bphamhuu
Priority: major Milestone: 9.4
Component: petascope Version: development
Keywords: Cc: dmisev, vmerticariu
Complexity: Medium

Description (last modified by bphamhuu)

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 text.

psql -U postgres petascopedb -c 

'ALTER TABLE wms13_style ALTER COLUMN "rasqlQueryTransformer" TYPE text;'

Change History (2)

comment:1 Changed 4 months ago by bphamhuu

  • Description modified (diff)

comment:2 Changed 4 months ago by bphamhuu

  • Description modified (diff)
  • Resolution set to fixed
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.