Solution Workbench - Migrate Kinetic BAQ Report

[Heide (Heide Warren)]

Goal: Migrate many Kinetic BAQ Reports from Pilot to Live using the Solution Workbench. In Pilot the BAQ Reports are either a Ice.UIRpt file or a Ice.UIDynRpt.

Background: In Pilot, the BAQReport exists as a classic form on one menu and as a Kinetic form on another menu. As far as I can tell, the data definition, reports, and report styles are the same for the Kinetic and Classic screen. It is the Program Type and Program name that are different. The Program name in classic is Ice.UIRpt.BAQReport.dll with the report style name below it of JobPerform_TopL. The program name in Kinetic is Ice.UIRpt.JobPerform_TopL and there is only the URL linked to it. We are also public cloud SaaS and on 2024.2.12.

I am following these posts:

Export BAQ Report

I tried to migrate a BAQ report to a different environment using solution workbench but the BAQ report can not run in the new environment. Anyone knows what elements should be included/added to the solution? Will the .rdl file automatically be installed? Thanks.

Solution Workbench - Report Styles

When building and installing solutions through Solution Workbench for Report Styles, does it also upload the .rdl file when installing the solution? Or do we also need to upload the SSRS Report after installing the solution that includes the .rdl file in the solution? I’m trying to eliminate an unnecessary step of uploading the SSRS report if the install already does this step.

I created package 1 which includes RptDataDef, Report, Report Style, and BAQ. I answered yes to the question “do you want to include the report style”. After building and installing the solution, I get the error "Error Could not find file ‘c:\windows\serviceprofiles\networkservice\appdata\local\temp\e4133792-f61d-45c5-a567-d841436f1035\database\reportstyle_jobperform_reso.xml’.

Does anyone have thoughts on how to get past my error? I am surprised that it is an xml file and the location of the file.

Here are some details from the build:

Thank you for any assistance,
Heide

[tgwinn (Tim Gwinn)]

I recall that when building a solution, the log mentions temporary files and then near the end it says it deleted the temporary files. So my assumption is that during an install, the solution CAB is being unpacked into a temporary folder and that is the folder reference you are seeing in the error. As to why it is occurring, I don’t know. It sounds like you are doing everything right.

[Hally (Simon Hall)]

I feel there’s a better solution here. Solution Management has a BAQ Report option, and that will prompt you for the report and the BAQ…

I also have to mention that there is a difference between a BAQ report and a Dynamic BAQ report. The latter you have to definitely include everything and as @hkeric.wci mentioned in the second post ensure you have your dependencies in another solution and install that one first

[Heide (Heide Warren)]

Good Morning, here is an update on my progress resolving my issue.

@cchang has been kindly helping me with my issue. Thank you.

I have tried to build and install many solutions.
Attempt 1) Built a solution using BAQ Report and Report as the elements. I answered yes to all the prompts. Installed solution. The solution installation succeed with no errors but when I went to look for the Ice.UIRpt file there was none to be found.
Attempt 2) Built a solution with BAQ Report, Report, QueryHdr, and BAQ similar to Kimberley’s suggestion. Answered yes to all prompts. Installed solution. The solution installed but again no Ice.UIRpt file to pick when building menu.
Notice: Both times that I built the above solutions, I did not build a menu element. I didn’t build the menu because I want to assign the Ice.UIRpt file to a new menu in Live and not the menu that is in Pilot. Could that be why I am failing to get the Ice.UIRpt file?
Attempt 3) I built Package 1 which included Report Data Definition, Report, Report Style, and BAQ as recommended by Haso Keric is related post . The build was successful. The install failed. The failure was:
Error Could not find file ‘c:\windows\serviceprofiles\networkservice\appdata\local\temp\e4133792-f61d-45c5-a567-d841436f1035\database\reportstyle_jobperform_topl.xml’.
[3/25/2025 7:09:21 AM] Error Import cancelled or failed for ‘JobPerform_TopL_1_JobPerform_TopL_rdl’.
CChang helped me figure out that security was blocking access to this folder. I resolved the security issue.
Attempt 4) Built the solution again, just like I built it in Attempt 3. Then I tried to install the solution. This time all I could do was pick the file I wanted to install. Everything was greyed out and I got the error
Business Layer Exception

Could not find ‘Temp\97078_Install_59f3a5fd-f916-4dcc-9c63-bf60d7d17f4f\MoveReport25_Customer Solution_4.3.200.0 (1).cab’ in UserData directory.

Error Detail

Correlation ID: c9c412f5-58c1-4e30-89c7-3cc642aa203e
Description: Could not find ‘Temp\97078_Install_59f3a5fd-f916-4dcc-9c63-bf60d7d17f4f\MoveReport25_Customer Solution_4.3.200.0 (1).cab’ in UserData directory.
Program: Ice.Services.BO.ExportPackage.dll
Method: ResolveServerPath
Table: undefined
Field: undefined

Now I am reading this article

2024.1 On-Prem Solution Workbench cannot build CAB, with "Could not find a part of the path" error

Version 2022.1 → 2024.1 on-prem Win 2019 SQL 15.0.2000.5 @daniel.eskenazi FYI Installed 2024.1 on the same DEV server as 2022.1. Built using conversion workbench on initial login. System runs and testing is 85% done and even our hugely customized UI isn’t giving much trouble. Have done a pile of issue resolution and decided to do another build. Started collecting up issue resolution items in CABs and immediately ran into a problem: [image] I initially ran into this in the Kinetic version, …

I really like your line “I feel there’s a better solution here”. I totally agree.

Thank you for the assistance. Much appreciated!

[Heide (Heide Warren)]

Based on @Hally message, building a solution with BAQ Report element and answering yes to include the report and BAQ might work. So I did that and I used a user account with no periods or dashes based on @SteveFossey.

After many more tests, I had to add the menu into the solution. Using BAQReport and Menu element, I was able to build the solution and install it. In application studio I finally see the report!!!

But when I go to use the new menu item, I have this error


The application studio layer is completely blank.

The Kinetic Application that I am trying to migrate is

I have not even tried to move an Ice.UIDynRpt yet.

I will try again using the Packages that Haso Keric has suggested.

[Heide (Heide Warren)]

I tried building a solution with Report Data Definition, Report, Report style, and BAQ. The error came back for "Error Could not find file ‘c:\windows\serviceprofiles\networkservice\appdata\local\temp\5c0c183a-a0af-4779-ae49-8b5c27435005\database\reportstyle_jobperform_topl.xml’. " and I do not have the security problem anymore.

I officially fly the white flag in surrender.

Am I doing something wrong or is there a development issue?

[Hally (Simon Hall)]

Have you tried just using the export/import for the BAQ report, you can do that with the rdl as well.

Other thing to test is just create a solution that has just the rdl and see what happens.

[Heide (Heide Warren)]

Hello Simon Hally,
Thank you for the assistance. Just like you suggested, I agreed that I had to abandon moving the BAQ Reports using the Solution Workbench. With many BAQ Reports to move to Live, I slowly moved them one by one using export/import and preview application in Kinetic. Task finally complete the old fashion way.

Here are two more notes that I noticed along the journey.
Note 1) We are unable to save layout or personalization to promote it to a customization. I tried this on many of the Kinetic BAQ Reports and they all gave me this error.

Here is the error

Note 2) For the Dynamic Report, I was able to place it on a menu as Erp.UIDynRpt.JobLabels. It works as a menu item and I can open the Kinetic screen. But I am unable to see any Dynamic Reports in the Application Studio list.

I have accomplished my task of moving the Kinetic BAQ Reports to Live. Thank you for the support. I appreciated the help.
Have a nice weekend,
Heide

[Hally (Simon Hall)]

Sorry it wasn’t a less painful process for you.

[Heide (Heide Warren)]

I appreciated all the support. It keep me going and motivated me to not give up. Thank you.

[skrahn (Steve Krahn)]

When we install a solution that contains a BAQ Report, we have to then open it once in BAQ Report Designer and select “preview application” from the three-dot menu. As soon as we have “previewed” it once we can then close BAQ Report Designer – you don’t have to save or anything, it now works for everyone. If we don’t do that, we get that same “Application … is not accessible” error. We asked EpicCare about this and were told "Re: Running Preview… That’s expected as well. The BAQ designer needs to do the Preview to build the report on the Application Server. "