Hello All
I am trying to import T24 data into InsightRisk. The import process goes to completion (137/137 tasks completed )but I get an error : Invalid object name RiskImport.dbo.20190508_Import_Exception_log.
When I get into the RiskImport database, here is the error I find
Error occurred in Other Assets configuration: Incorrect syntax near ")". INSERT INTO [Transaction] (
TransactionType
,CounterpartyID
,TransactionID
,CurrencyCode
,TradingUnitID
,ExposureTypeID
,TransactionExecutionDate
,TransactionValueDate
,CollTrn
,TrnMaturityDate
,OriginalGrossValue
,RunDateID
,TransactionKey
,ReportingUnitID
,TrnGrossValue
,TrnNotionalAmount
)
SELECT distinct Res.DataValue
,ru.ReportingUnitID
,Res.AccountNumColumn
,Res.CurrencyColumn
,ru.ReportingUnitid
,"8"
,rd.RunDate
,rd.RunDate
,0
,rd.Rundate
,sum(cast(Res.FCYAmountColumn as float))
,Rd.RundateID
,NEWID()
,ru.ReportingUnitID
,sum(cast(Res.LCYAmountColumn as float))
,sum(cast(Res.LCYAmountColumn as float))
from ()) Res
inner join [tbl dates] dat on Res.RundateID=dat.RundateID
inner join Rundate rd on rd.RundateID=dat.RundateID
inner join ReportingUnit ru on dat.ReportingUnitID=ru.ReportingUnitID
where ru.ParentReportingUnitID is null and res.DataValue in (select TransactionType from [TransactionType])
group by Res.DataValue
,ru.ReportingUnitID
,Res.AccountNumColumn
,Res.CurrencyColumn
,ru.ReportingUnitid,rd.Rundate,Rd.RundateID,ru.ReportingUnitID
Can you please help ?
Best regards
