Unable to Save data using Table Grid Editir
Hello,
Once I edit the table and save the information, I am unable to view the new values/rows in the table. Instead I receive the attached error message.
Is there something wrong with my table configuration?
JIRA Version: 7.3.4
Database: Postgres 9.3
Table configuration below.
Could you kindly assist with this ?
Regards,
Deepti Rao
############################################
# General grid properties section
#----------------------------------------
# gd.columns is used to define the columns which make up the grid
# gd.tablename and gd.ds are used to specify where the data of the grid should be stored
# It is possible to store the grid data in an external database
#
gd.columns=itestname,ideadline,iduration,ihypothesis,itest,imetrics,icriteria
gd.tablename=actions
gd.ds=jira
############################################
# Column section for the Test Name column
#----------------------------------------
# Various column properties are used to specify the behaviour
# of the column (such as width, type, etc.)
#
col.itestname=Test Name
col.itestname.name=itestname
col.itestname.type=string
col.itestname.required=true
col.itestname.maxLength=200
col.itestname.width=200
############################################
# Column section for the status column
#----------------------------------------
# The status column is a list column with statically
# defined values.
# Alternatively it could be a checkbox or a radio button.
#
col.ideadline=Deadline
col.ideadline.type=date
col.ideadline.defaultDate = +0d
############################################
# Column section for the duration column
#----------------------------------------
# The assignee column is a list column initialized with
# all the users listed in JIRA
# (This list could also be restricted to users who have certain role(s) # in the current project or are members of a certain group(s)
# by specifying col.iassignee.allow.groups and
# col.iassignee.allow.roles properties respectively)
#
col.iduration=Duration
col.iduration.type=integer
col.iduration.required=false
col.iduration.autocomplete=false
col.iduration.width=200
############################################
# Column section for the Test Name column
#----------------------------------------
# Various column properties are used to specify the behaviour
# of the column (such as width, type, etc.)
#
col.ihypothesis=Hypothesis (We believe that)
col.ihypothesis.name=ihypothesis
col.ihypothesis.type=string
col.ihypothesis.required=false
col.ihypothesis.maxLength=1000
col.ihypothesis.width=500
############################################
# Column section for the status column
#----------------------------------------
# The status column is a list column with statically
# defined values.
# Alternatively it could be a checkbox or a radio button.
#
col.itest=Test (To verify that, we will)
col.itest.name=itest
col.itest.type=string
col.itest.required=false
col.itest.maxLength=1000
col.itest.width=500
############################################
# Column section for the duration column
#----------------------------------------
# The assignee column is a list column initialized with
# all the users listed in JIRA
# (This list could also be restricted to users who have certain role(s) # in the current project or are members of a certain group(s)
# by specifying col.iassignee.allow.groups and
# col.iassignee.allow.roles properties respectively)
#
col.imetrics=Metric (And measure)
col.imetrics.name=imetrics
col.imetrics.type=string
col.imetrics.required=false
col.imetrics.maxLength=1000
col.imetrics.width=300
############################################
# Column section for the due date column
#----------------------------------------
# The due date column is of type 'date'
# It is automatically set to a week from now using the defaultDate property.
#
col.icriteria=Criteria (We are right if)
col.icriteria.name=icriteria
col.icriteria.type=string
col.icriteria.required=false
col.icriteria.maxLength=1000
col.icriteria.width=400