We are running Epicor 10.1.600.9 and have created an External BAQ that links to our Mattec system. We have defined an external BAQ (glhExtTest) that links into a SQL View in Mattec called vw_SIST_DashboardMachine.
When the view has the query
SELECT MachNo, CycleNo, Status, DownNo, HelpNo, HelpStart, StatTime, TimeInStat, EndOfJob, AutoSpcFlag, ManualSqcFlag, VariableSqcFlag, AttributeSqcFlag, SecondaryCommFlag, MiuCommError, MiuPartNumber, MiuPartRevision, MiuPartDate, MiuPldRevision, MiuBiosDate, StartUp, ParameterRecordingCycles, ver, ClientOnlyCurrentShiftSeq, ClientOnlyCurrentShiftName, ClientOnlyPreviousShiftSeq, ClientOnlyPreviousShiftName, ClientOnlyCurrentShiftWorking, ClientOnlyPreviousShiftWorking, SelectedDownNo FROMdbo.MachInfo
the rest URL
https://erp-app01.sistemaplastics.com/EpicorERP10/api/help/baq//glhExtTest/index#!/OData/execute
returns a result just fine. However changing the query to
SELECT TOP (100) PERCENT a.DeptNo, b.DeptName, dbo.CalculateOEEDashboard(a.ExpProdQty, a.CalProdQty, a.SumWtDownQty, a.DefectQty, a.SumDefQty, a.WtTotTime, a.WtDownTime, a.CycleEfficiencyNumerator) AS OEE CASE WHEN WtTotTime - WtDownTime > 0 THEN CycleEfficiencyNumerator / (WtTotTime - WtDownTime) ELSE 0 END AS CycleEfficiency, CASE WHEN ExpProdQty != 0 THEN 100 * (CalProdQty – DefectQty / ExpProdQty ELSE 0 END AS YieldEfficiency, CASE WHEN SumCycTm != 0 AND CycCnt != 0 THEN SumCycTm / CycCnt ELSE - 1 END AS AverageCycleTime, CASE WHEN CalProdQty != 0 THEN 100 * DefectQty / CalProdQty ELSE - 1 END AS ScrapPercent, CASE WHEN WtTotTime != 0 THEN 100 * WtDownTime / WtTotTime ELSE - 1 END AS DownPercent, CASE WHEN CalProdQty > DefectQty THEN CalProdQty - DefectQty ELSE 0 END AS GoodProduction, a.CalProdQty AS TotalProduction, CASE WHEN CalProdQty > DefectQty AND CalProdQty > 0 THEN 100 * (CalProdQty - DefectQty) / CalProdQty ELSE 0 END AS GoodPercent, CASE WHEN WtTotTime != 0 THEN 100 * (WtTotTime - WtDownTime) / WtTotTime ELSE 0 END AS RunEfficency, 0 AS Special1, 0 AS Special2, 0 AS Special3, dbo.CalculateBerry105Efficiency(a.BerryExpProdQty, a.CalProdQty, a.DefectQty, a.PakProdQty) AS Berry105Efficiency, dbo.CalculateBerryMeefEfficiency(a.WtTotTime, a.IdleWtQty, a.PmWtQty, a.WtDownTime) AS BerryMeefEfficiency FROM (SELECT b.DeptNo, SUM(b.CalProdQty) AS CalProdQty, SUM(b.DefectQty) AS DefectQty, SUM(b.PakProdQty) AS PakProdQty, SUM(b.ExpProdQty) AS ExpProdQty, SUM(b.WtTotTime) AS WtTotTime, SUM(b.WtDownTime AS WtDownTime, SUM(b.SumCycTm) AS SumCycTm, SUM(b.CycCnt) AS CycCnt, SUM(b.WtCycCnt) AS WtCycCnt, SUM(b.IdleWtQty) AS IdleWtQty, SUM(b.PmWtQty) AS PmWtQty, SUM(b.SumDownQty)AS SumDownQty, SUM(b.SumWtDownQty) AS SumWtDownQty, SUM(b.SumDefQty) AS SumDefQty, SUM(dbo.CalculateCycleEfficiencyNumerator(b.ExpCycTm, b.CycCnt, b.SumCycTm, b.WtTotTime, b.WtDownTime, b.MiuMachSpeedUnit)) AS CycleEfficiencyNumerator, SUM(CASE WHEN ExpCycTm != 0 THEN NuMCavs * (WtTotTime - WtDownTime) / (dbo.Convert_CycleTime_Rate(ExpCycTm, b.MiuMachSpeedUnit, b.TimeDivisor, b.LinearRateMultiplier) / 0.95) ELSE 0 END) AS BerryExpProdQty FROM dbo.vShiftProd AS b INNER JOIN dbo.vCurrentShiftSeq AS d ON b.MachNo = d.MachNo AND b.ShiftSeq = d.ShiftSeq WHERE (b.Active = 1)GROUP BY b.DeptNo) AS a INNER JOIN dbo.Department AS b ON a.DeptNo = b.DeptNo ORDER BY b.DeptName
Gives a result
Sorry! Something went wrong. Please contact your system administrator.
And the Curl text auto sets to accept plain text
curl -X GET --header ‘Accept: text/plain’ ‘https://erp-app01.sistemaplastics.com/EpicorERP10/api/v1/BaqSvc/glhExtTest/’
Any ideas why this would happen?
