intersystems / Samples-BI

Provides sample data for use with InterSystems IRIS Business Intelligence, as well as fully developed sample BI models and dashboards.
MIT License
12 stars 20 forks source link

failure of ##class(Build.SampleBI).Build() using manual load steps #38

Open vicssun opened 9 months ago

vicssun commented 9 months ago

A customer reported the following error attempting to install this sample, which I was unable to reproduce.

Compiling routine HoleFoods.BudgetCube.Fact.1 ERROR: HoleFoods.BudgetCube.Fact.cls Input (LITERAL) encountered after end of query^ DECLARE sqlist2562159274 CURSOR FOR SELECT %ID , DateOfSale DxDateOfSale , Outlet DxOutlet , Outlet -> City DxCityViaOutlet , Outlet -> Country -> Name DxNameViaCountryViaOutlet , Outlet -> Country -> Region -> Name Dx475620761 , Outlet -> Latitude DxLatitudeViaOutlet , Outlet -> Longitude DxLongitudeViaOutlet , Outlet -> Population DxPopulationViaOutlet , Product DxProduct , Product -> Category DxCategoryViaProduct , Product -> Price DxPriceViaProduct , Product -> SKU DxSKUViaProduct , TargetAmount MxTargetAmount , Product -> Price Product_Price , CASE WHEN Actual = 0 THEN 1 ELSE 0 END '%TEST' ERROR #5123: Unable to find entry point for method '%UpdateFacts' in routine 'HoleFoods.BudgetCube.Fact.1' Compiling routine BI.Model.RelCubes.RPatients.Fact.1 Compiling routine HoleFoods.Cube.Fact.1 ERROR: HoleFoods.Cube.Fact.cls Input (LITERAL) encountered after end of query^ DECLARE sqlistHoleFoodszCubezFact CURSOR FOR SELECT %ID , AmountOfSale MxAmountOfSale , Channel DxChannel , %EXTERNAL ( Channel ) DxChannelExt , Comment MxComment , DateOfSale DxDateOfSale , Discount DxDiscountRg857767687 , Outlet DxOutlet , Outlet -> City DxCityViaOutlet , Outlet -> Country -> Name DxNameViaCountryViaOutlet , Outlet -> Country -> Region -> Name Dx475620761 , Outlet -> Latitude DxLatitudeViaOutlet , Outlet -> Longitude DxLongitudeViaOutlet , Outlet -> Population DxPopulationViaOutlet , Product DxProduct , Product -> Category DxCategoryViaProduct , Product -> Price DxPriceViaProduct , Product -> SKU DxSKUViaProduct , UnitsSold DxUnitsSold , Product -> Price Product_Price , UnitsSold , CASE WHEN Actual = 1 THEN 1 ELSE 0 END '%TEST' ERROR #5123: Unable to find entry point for method '%UpdateFacts' in routine 'HoleFoods.Cube.Fact.1' Generating file: C:\InterSystems\IRIS\CSP\samplesbi\BI_Model_PortletDemo.js Detected 6 errors during load.

asinay commented 9 months ago

Hi @vicssun, What IRIS Version was the customer using? Also, please make sure they have the correct license

vicssun commented 9 months ago

Hi @asinay, he's on 2023.1.3 and has a valid license. WRC 983629 has identified that the build fails when delimited identifier support is disabled.

isc-sfennell commented 9 months ago

The doc section "Accessing the Samples" now informs users that delimited identifier support must be enabled to build.

Should the README file for this repository also provide this disclaimer? And perhaps the README for Samples-Aviation as well?