Viewing CCL Print Statement Outputs in HANA Studio
CCL print statements can be added to a Streaming Project, providing output from the code to assist in debugging. The output of the statement is then sent into a trace file, which can be viewed from HANA Studio. Generally these print statements are added to the custom methods found inside the flex element.
As an example, we can add the following line to an arbitrary CCL flex method called ON EVENTS:
print (‘This is a test lalalallalalallalalalalalalalalalallalalalala’, ‘\n’);
The ‘\n’ is necessary, because the output of the print statement is written to the log file immediately when you use the ‘\n’ option. Otherwise, it is written only when the server shuts down.
Note: The example method used below is from the Freezer Monitoring streaming project, and is located inside the DASHBOARD flex element. For more information on the Freezer Monitoring project click here.
The method now looks like this:
After running the project, to view the trace file, go into the SAP HANA Administration Console perspective and double click on your project’s system. This opens up the admin console. Navigate to the “Diagnosis Files” tab, and filter by “.trc”. Under host, only select your streaming server.
Look for a .trc file with the prefix “streamingserver”, and containing your streaming project name. Open that file, and you will be able to view the output of your print statement.