hi Nika in other environment when I install jasper, this is the error:
bg-ca.log
ERROR 2017-03-03 18:01:38,542 [Dispatch Post Timesheets : bg@CACLTHW02 (tenant=clarity)] xql2.xbl (clarity:admin:68138777__7C043BA6-8AC0-4E96-A05D-DA67F5A95B6C:Post Timesheets) ****POSTTIMESHEET: Couldn't post adjustmented timesheet-->adjustedTimesheetID=5040603; adjustedTimeEntryID=5189697; assignmentID=5084113
ERROR 2017-03-03 18:05:11,416 [Dispatch Load Data Warehouse : bg@CACLTHW02 (tenant=clarity)] kettle.JasperSoftDomainUpdates (clarity:admin:68138740__9F4C95BC-86D8-4E3E-9FAC-FD7B7E16F137:Load Data Warehouse)
Data warehouse is not up to date, DWH meta column sr_cost_effort_status, sr_report_status, sr_schedule_status, sr_scope_status, status_report_key is not in DWH table dwh_inv_status_report_ln hence quiting from domain updates
ERROR 2017-03-03 18:05:11,432 [Dispatch Load Data Warehouse : bg@CACLTHW02 (tenant=clarity)] kettle.JasperSoftDomainUpdates (clarity:admin:68138740__9F4C95BC-86D8-4E3E-9FAC-FD7B7E16F137:Load Data Warehouse) Error occurred while processing domain attributes. com.niku.union.persistence.PersistenceException:
SQL error code: 208
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'dwh_inv_status_report_ln'.
Executed:
select sr_cost_effort_status, sr_report_status, sr_schedule_status, sr_scope_status, status_report_key from dwh_inv_status_report_ln
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" xmlns="http://schemas.niku.com/2002/pmd">
<sql dbVendor="all">
<text>
select @select@ from @from@
</text>
<param name="select" direction="IN" dynamicReplacement="@select@" expressionListDelimiter=","/>
<param name="from" direction="IN" dynamicReplacement="@from@" expressionListDelimiter=","/>
</sql>
</statement>
Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="njs.validateDWHTableColumn_nested_0" inputSource="map" inputMapIndex="0" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" defaultSliceSize="20" ignoreIfError="false" hideResultSets="false" xmlns="http://schemas.niku.com/2002/pmd"/>
Using input:
{select=sr_cost_effort_status, sr_report_status, sr_schedule_status, sr_scope_status, status_report_key, from=dwh_inv_status_report_ln}
Using dynamic SQL:
tag: @select@ SQL:sr_cost_effort_status, sr_report_status, sr_schedule_status, sr_scope_status, status_report_key
tag: @from@ SQL:dwh_inv_status_report_ln
ERROR 2017-03-03 18:05:11,447 [Dispatch Load Data Warehouse : bg@CACLTHW02 (tenant=clarity)] niku.njs (clarity:admin:68138740__9F4C95BC-86D8-4E3E-9FAC-FD7B7E16F137:Load Data Warehouse) Error executing job: 5192103
com.niku.union.persistence.PersistenceException:
SQL error code: 208
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'dwh_inv_status_report_ln'.
Executed:
select sr_cost_effort_status, sr_report_status, sr_schedule_status, sr_scope_status, status_report_key from dwh_inv_status_report_ln
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" xmlns="http://schemas.niku.com/2002/pmd">
<sql dbVendor="all">
<text>
select @select@ from @from@
</text>
<param name="select" direction="IN" dynamicReplacement="@select@" expressionListDelimiter=","/>
<param name="from" direction="IN" dynamicReplacement="@from@" expressionListDelimiter=","/>
</sql>
</statement>
Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="njs.validateDWHTableColumn_nested_0" inputSource="map" inputMapIndex="0" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" defaultSliceSize="20" ignoreIfError="false" hideResultSets="false" xmlns="http://schemas.niku.com/2002/pmd"/>
Using input:
{select=sr_cost_effort_status, sr_report_status, sr_schedule_status, sr_scope_status, status_report_key, from=dwh_inv_status_report_ln}
Using dynamic SQL:
tag: @select@ SQL:sr_cost_effort_status, sr_report_status, sr_schedule_status, sr_scope_status, status_report_key
tag: @from@ SQL:dwh_inv_status_report_ln