Date Time:23-08-16 2:49:09 PM
User Name:admin
User Group:default
User Roles:default
 
Application Variables
 
User Variables
 
Reading definition vwoidet-
Initializing Report
Preparing SQL statements
Processing Params
passignto[C]=Murali
select distinct priority from issuelog union all select 'ALL' priority from dual order by priority
Time elapsed = 6
ppriority[C]=
GetMultiSelectParamTableForDrillDownIviews
Multi Select Table Names : 
Assigning values to IView parameters
passignto(c)=Murali
passignto=Murali
ppriority(c)=
ppriority=
ppriority(c)=
Creating Columns
select  count(*) recno from (select  a.*   from ( select issuelogid, issue_no, resolved_by, issue_date, concat(b.nickname,', ',d.department_name) ifrom, issue_desc, issue_status, f.nickname responsibility, priority 
from issuelog a
join axusers b on a.usr=b.pusername 
join actionlinks c on a.issue_status=c.status
join department d ON d.departmentid = a.usrdept
join department e on e.departmentid=a.department
left outer join axusers f on e.departmentid=f.department and a.assign_tousr= f.username 
where a.issue_status<>'Closed' and a.assign_to = :passignto
and (a.priority=:ppriority or :ppriority = 'ALL')
order by issue_no
 )a) aa
passignto=Murali
ppriority=
ppriority=
Time elapsed = 62
select issuelogid, issue_no, resolved_by, issue_date, concat(b.nickname,', ',d.department_name) ifrom, issue_desc, issue_status, f.nickname responsibility, priority 
from issuelog a
join axusers b on a.usr=b.pusername 
join actionlinks c on a.issue_status=c.status
join department d ON d.departmentid = a.usrdept
join department e on e.departmentid=a.department
left outer join axusers f on e.departmentid=f.department and a.assign_tousr= f.username 
where a.issue_status<>'Closed' and a.assign_to = :passignto
and (a.priority=:ppriority or :ppriority = 'ALL')
order by issue_no

passignto=Murali
ppriority=
ppriority=
Time elapsed = 17
Time elapsed = 20
Copying result to grid
Row 1
Evaluating column values
issuelogid = 
issuelogid = 
issue_no = 
issue_no = 
issue_date = 
issue_date = 
ifrom = 
ifrom = 
issue_desc = 
issue_desc = 
priority = 
priority = 
responsibility = 
responsibility = 
issue_status = 
issue_status = 
resolved_by = 
resolved_by = 
Displaying columns
Storing subtotals
Time elapsed = 80
Total Time elapsed = 217
select Props from axuseraccess where lower(rname)='default' and lower(sname)='newis' and stype = 't'
Time elapsed = 6
\uXDS\open - syntax error at or near "WHERE"
\uXDS\open - syntax error at or near "WHERE"
 q.cds.CommandText : select  a1.FIELD_MAXNUM
 from axpdef_dc as a1
where axpdef_dcid = :dcid and :recid =0 
union all
select  FIELD_MAXNUM from coretstructhdr where coretstructhdrid = :recid 

 ParamData : !@$1412330000002!@$!@$0!@$!@$0!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
 q.cds.CommandText : select  A1.FIELD_MAXNUM
 from axpdef_dc a1
where axpdef_dcid = :dcid and :recid = 0
union
select  FIELD_MAXNUM from coretstructhdr where coretstructhdrid = :recid 

 ParamData : !@$1412330000002!@$!@$0!@$!@$0!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_detail' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'prefix' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_detail' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'prefix' is not a valid floating point value
 q.cds.CommandText : select cast(case when COALESCE(e.caption,'')='' then  e.name else e.caption end ||'-('||e.name||')' as varchar(250)) caption, e.NAME as  name,case when strpos(lower(sql),'where')>0 then left(sql,strpos(lower(sql),'where')-1) else sql end as modeofentry from vw_field_informations e
where (e.MODEOFENTRY='Select From Form' or e.MODEOFENTRY='Select From Sql')
and e.TRANSID = :stransid

 ParamData : !@$genem!@$
 q.cds.CommandText : select split_part(split_part(lower( regexp_replace( replace( :v_sql , ':','')  ,'\r\n?|\n','','g')), 'from', 1),'select',2) scolname  where :v_sql is not null
and  :v_sql <> '' 

 ParamData : !@$!@$!@$!@$!@$!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
 q.cds.CommandText : select cast(etype as varchar(50)) as etype,fieldflg  from (
select 'Before save transaction' as etype,0 as fieldflg where :control_type ='F'
union all select 'After save transaction' as etype ,0 as fieldflg where :control_type ='F'
union all select 'Before delete transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After delete transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'Before cancel transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After cancel transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After DBLoad' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On post genmap' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Row Enter' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Row Exit' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Delete row' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Form Load' as etype,0 as fieldflg  where :control_type ='T'
union all select 'On Data Load' as etype,0 as fieldflg  where :control_type ='T'
union all select 'On Frame Enter' as etype ,1 as fieldflg where :control_type ='F'
union all select 'On Field Enter' as etype ,2 as fieldflg where :control_type ='T'
union all select 'On Field Exit' as etype ,2 as fieldflg where :control_type ='T'
union all select 'On Field Change' as etype,2 as fieldflg  where :control_type ='F'
union all select 'On Click' as etype,2 as fieldflg  where :control_type ='T'
union all select 'On ClearForm' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Create' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Approve' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Every Approve' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Return' as etype,0 as fieldflg  where :control_type ='F' 
union all select 'On Reject' as etype,0 as fieldflg  where :control_type ='F' 
) a

 ParamData : !@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$
\uStructInTable\Structwise - Error
\uXDS\open - syntax error at or near "WHERE"
\uXDS\open - syntax error at or near "WHERE"
 q.cds.CommandText : select  a1.FIELD_MAXNUM
 from axpdef_dc as a1
where axpdef_dcid = :dcid and :recid =0 
union all
select  FIELD_MAXNUM from coretstructhdr where coretstructhdrid = :recid 

 ParamData : !@$1412440000002!@$!@$0!@$!@$0!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
 q.cds.CommandText : select  A1.FIELD_MAXNUM
 from axpdef_dc a1
where axpdef_dcid = :dcid and :recid = 0
union
select  FIELD_MAXNUM from coretstructhdr where coretstructhdrid = :recid 

 ParamData : !@$1412440000002!@$!@$0!@$!@$0!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_detail' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'prefix' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_detail' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'prefix' is not a valid floating point value
 q.cds.CommandText : select cast(case when COALESCE(e.caption,'')='' then  e.name else e.caption end ||'-('||e.name||')' as varchar(250)) caption, e.NAME as  name,case when strpos(lower(sql),'where')>0 then left(sql,strpos(lower(sql),'where')-1) else sql end as modeofentry from vw_field_informations e
where (e.MODEOFENTRY='Select From Form' or e.MODEOFENTRY='Select From Sql')
and e.TRANSID = :stransid

 ParamData : !@$genem!@$
 q.cds.CommandText : select split_part(split_part(lower( regexp_replace( replace( :v_sql , ':','')  ,'\r\n?|\n','','g')), 'from', 1),'select',2) scolname  where :v_sql is not null
and  :v_sql <> '' 

 ParamData : !@$!@$!@$!@$!@$!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
 q.cds.CommandText : select cast(etype as varchar(50)) as etype,fieldflg  from (
select 'Before save transaction' as etype,0 as fieldflg where :control_type ='F'
union all select 'After save transaction' as etype ,0 as fieldflg where :control_type ='F'
union all select 'Before delete transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After delete transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'Before cancel transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After cancel transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After DBLoad' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On post genmap' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Row Enter' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Row Exit' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Delete row' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Form Load' as etype,0 as fieldflg  where :control_type ='T'
union all select 'On Data Load' as etype,0 as fieldflg  where :control_type ='T'
union all select 'On Frame Enter' as etype ,1 as fieldflg where :control_type ='F'
union all select 'On Field Enter' as etype ,2 as fieldflg where :control_type ='T'
union all select 'On Field Exit' as etype ,2 as fieldflg where :control_type ='T'
union all select 'On Field Change' as etype,2 as fieldflg  where :control_type ='F'
union all select 'On Click' as etype,2 as fieldflg  where :control_type ='T'
union all select 'On ClearForm' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Create' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Approve' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Every Approve' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Return' as etype,0 as fieldflg  where :control_type ='F' 
union all select 'On Reject' as etype,0 as fieldflg  where :control_type ='F' 
) a

 ParamData : !@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$
\uStructInTable\Structwise - Error
\uXDS\open - syntax error at or near "WHERE"
\uXDS\open - syntax error at or near "WHERE"
 q.cds.CommandText : select  a1.FIELD_MAXNUM
 from axpdef_dc as a1
where axpdef_dcid = :dcid and :recid =0 
union all
select  FIELD_MAXNUM from coretstructhdr where coretstructhdrid = :recid 

 ParamData : !@$1412550000003!@$!@$0!@$!@$0!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
 q.cds.CommandText : select  A1.FIELD_MAXNUM
 from axpdef_dc a1
where axpdef_dcid = :dcid and :recid = 0
union
select  FIELD_MAXNUM from coretstructhdr where coretstructhdrid = :recid 

 ParamData : !@$1412550000003!@$!@$0!@$!@$0!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_detail' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'prefix' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_detail' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'prefix' is not a valid floating point value
 q.cds.CommandText : select cast(case when COALESCE(e.caption,'')='' then  e.name else e.caption end ||'-('||e.name||')' as varchar(250)) caption, e.NAME as  name,case when strpos(lower(sql),'where')>0 then left(sql,strpos(lower(sql),'where')-1) else sql end as modeofentry from vw_field_informations e
where (e.MODEOFENTRY='Select From Form' or e.MODEOFENTRY='Select From Sql')
and e.TRANSID = :stransid

 ParamData : !@$genem!@$
 q.cds.CommandText : select split_part(split_part(lower( regexp_replace( replace( :v_sql , ':','')  ,'\r\n?|\n','','g')), 'from', 1),'select',2) scolname  where :v_sql is not null
and  :v_sql <> '' 

 ParamData : !@$!@$!@$!@$!@$!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
 q.cds.CommandText : select cast(etype as varchar(50)) as etype,fieldflg  from (
select 'Before save transaction' as etype,0 as fieldflg where :control_type ='F'
union all select 'After save transaction' as etype ,0 as fieldflg where :control_type ='F'
union all select 'Before delete transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After delete transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'Before cancel transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After cancel transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After DBLoad' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On post genmap' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Row Enter' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Row Exit' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Delete row' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Form Load' as etype,0 as fieldflg  where :control_type ='T'
union all select 'On Data Load' as etype,0 as fieldflg  where :control_type ='T'
union all select 'On Frame Enter' as etype ,1 as fieldflg where :control_type ='F'
union all select 'On Field Enter' as etype ,2 as fieldflg where :control_type ='T'
union all select 'On Field Exit' as etype ,2 as fieldflg where :control_type ='T'
union all select 'On Field Change' as etype,2 as fieldflg  where :control_type ='F'
union all select 'On Click' as etype,2 as fieldflg  where :control_type ='T'
union all select 'On ClearForm' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Create' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Approve' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Every Approve' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Return' as etype,0 as fieldflg  where :control_type ='F' 
union all select 'On Reject' as etype,0 as fieldflg  where :control_type ='F' 
) a

 ParamData : !@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$
\uStructInTable\Structwise - Error
\uXDS\open - syntax error at or near "WHERE"
\uXDS\open - syntax error at or near "WHERE"
 q.cds.CommandText : select  a1.FIELD_MAXNUM
 from axpdef_dc as a1
where axpdef_dcid = :dcid and :recid =0 
union all
select  FIELD_MAXNUM from coretstructhdr where coretstructhdrid = :recid 

 ParamData : !@$1412660000002!@$!@$0!@$!@$0!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
 q.cds.CommandText : select  A1.FIELD_MAXNUM
 from axpdef_dc a1
where axpdef_dcid = :dcid and :recid = 0
union
select  FIELD_MAXNUM from coretstructhdr where coretstructhdrid = :recid 

 ParamData : !@$1412660000002!@$!@$0!@$!@$0!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_detail' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'prefix' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_detail' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'prefix' is not a valid floating point value
 q.cds.CommandText : select cast(case when COALESCE(e.caption,'')='' then  e.name else e.caption end ||'-('||e.name||')' as varchar(250)) caption, e.NAME as  name,case when strpos(lower(sql),'where')>0 then left(sql,strpos(lower(sql),'where')-1) else sql end as modeofentry from vw_field_informations e
where (e.MODEOFENTRY='Select From Form' or e.MODEOFENTRY='Select From Sql')
and e.TRANSID = :stransid

 ParamData : !@$genem!@$
 q.cds.CommandText : select split_part(split_part(lower( regexp_replace( replace( :v_sql , ':','')  ,'\r\n?|\n','','g')), 'from', 1),'select',2) scolname  where :v_sql is not null
and  :v_sql <> '' 

 ParamData : !@$!@$!@$!@$!@$!@$
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'listofvalues' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltext' is not a valid floating point value
\uParse\Val - 'Details:' is not a valid floating point value
\uParse\Val - 'sql_editor_sqltextform' is not a valid floating point value
 q.cds.CommandText : select cast(etype as varchar(50)) as etype,fieldflg  from (
select 'Before save transaction' as etype,0 as fieldflg where :control_type ='F'
union all select 'After save transaction' as etype ,0 as fieldflg where :control_type ='F'
union all select 'Before delete transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After delete transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'Before cancel transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After cancel transaction' as etype,0 as fieldflg  where :control_type ='F'
union all select 'After DBLoad' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On post genmap' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Row Enter' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Row Exit' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Delete row' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Form Load' as etype,0 as fieldflg  where :control_type ='T'
union all select 'On Data Load' as etype,0 as fieldflg  where :control_type ='T'
union all select 'On Frame Enter' as etype ,1 as fieldflg where :control_type ='F'
union all select 'On Field Enter' as etype ,2 as fieldflg where :control_type ='T'
union all select 'On Field Exit' as etype ,2 as fieldflg where :control_type ='T'
union all select 'On Field Change' as etype,2 as fieldflg  where :control_type ='F'
union all select 'On Click' as etype,2 as fieldflg  where :control_type ='T'
union all select 'On ClearForm' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Create' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Approve' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Every Approve' as etype,0 as fieldflg  where :control_type ='F'
union all select 'On Return' as etype,0 as fieldflg  where :control_type ='F' 
union all select 'On Reject' as etype,0 as fieldflg  where :control_type ='F' 
) a

 ParamData : !@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$!@$F!@$