Transformation Failure: Missing initJics.sql and Unable to Download Transform outputs in Blu Insights

Question

**Missing initJics.sql Output :** We are experiencing an issue with a transformation process within Blu Insights where the expected initJics.sql output file is not being generated in the transform phase. We are providing a CSD (CICS System Definition) command file as input to the transformation, based on our understanding of the process. It should result in the creation of the sql file.
 
**Download Failure:** Furthermore, we are unable to download the transformation results from Blu Insights. When attempting to download the Transform outputs results in "Download Pending: Your files are being prepared for download". Its running endlessly and not downloading anything. Other than CSD, remaining artifacts are downloading correctly.
 
Could you please provide guidance. Any assistance in resolving this issue would be greatly appreciated.

re:Post Agent · Answer

The issues you're experiencing with the Blu Insights transformation process are not uncommon and can be addressed with a few troubleshooting steps.

For the missing initJics.sql output:
1. Verify that the CSD file type is correctly set. There have been improvements to file type classifications, so you may need to launch the classification again in your code base project. This should set the CARDDEMO type to CSDCOMMAND instead of CSD.
2. After updating the file type, trigger a complete project scope transformation again.
3. Ensure that the CARDDEMO CSD file contains the expected VSAM file definitions. If the file is empty or missing necessary information, it could result in incomplete SQL file generation.
4. Double-check that you've followed all CICS configuration steps correctly as outlined in the workshop instructions.

Regarding the download failure:
1. The "Download Outputs" option may not be visible due to recent UI changes or version differences. You're using version 4.6.0, which might have a different interface compared to older versions.
2. Try clearing your browser cache and reloading the Blu Insights page.
3. Look for alternative menu options or buttons that might allow you to access or download the transformation outputs.
4. If you're using a Mac, be aware that downloading output using the menu is currently only supported for Windows and Linux. For Mac users, the system might provide an AWS CLI command to download the rendered output instead of showing a button.
5. Verify that you have the necessary permissions to download outputs within the Blu Insights platform.

If these steps don't resolve the issues, consider reaching out to AWS support or posting in the AWS re:Post community for the most up-to-date solutions, as the Blu Age workshops and tools are continuously evolving.
      
**Sources**  
[L3 Workshop. CSD does not get properly transformed. | AWS re:Post](https://repost.aws/questions/QUdSute3IVQF6JsrUCLCOHsw/l3-workshop-csd-does-not-get-properly-transformed)  
[Unable to download files from Transformation Center (Download Outputs not visible) | AWS re:Post](https://repost.aws/questions/QUkZyxO8lFTeKXNp32CXhKeA/unable-to-download-files-from-transformation-center-download-outputs-not-visible)

Transformation Failure: Missing initJics.sql and Unable to Download Transform outputs in Blu Insights

Add your answer

Relevant content