While running the snapshot, it crashes with the error "Error while executing procedure", please find the screen shot below.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x , x<2 | |
8.1.x, X< 1 | |
8.0.x | |
7.3.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 |
Below is the step-by-step scenario leading to the problem:
- Package and deliver the application.
- Set as current version.
- Run the Snapshot, it crashes with the error "Error while executing procedure".
The impact of the problem on the analysis or the dashboard is: The snapshot will not be finished as it crashes while computing the snapshot and we will have missing information in the dashboard.
- Check if the name of the full content module exceeds 64 characters. If the full content module exceeds 64 characters it gets truncated which leads to wrong comparison.
If this is the case apply the following Solution to solve the issue- Purge the previous failed snapshot : for this, you need to click on "Take snapshot' and the following pop-up will appear. Make sure you uncheck the checkbox to delete the failed snapshot.
- Connect to AIC Portal and change your app name to a shorter name.
- Open CAST-MS, click on "save" button, so that the new app name is saved in database.
- In Modules tab (Expert mode), delete the existing full content module
- In Cast-MS synchronize Analysis service and Dashboard service.
- Leave CAST-MS and go to your install folder.
- Open a CMD, "Cast-MS-CLI.exe PrepareSnapshot -connectionProfile <yourConnectionProfileName> -appli <TheShorterName>.
- Reopen Cast-MS, tab Modules you can see that a new full content module with the shorter name exists.
- Leave Cast-MS, go back to AIC Portal and change back the application name to the long name.
- Open CAST-MS , save , synchronize your services, you are ready to take a successful snapshot
- Purge the previous failed snapshot : for this, you need to click on "Take snapshot' and the following pop-up will appear. Make sure you uncheck the checkbox to delete the failed snapshot.
- If you have renamed your module and you are still facing this issue then check if there is a missing link between application and module in Central Database.
- Get the ID of the application using the page - SQL Queries - CAST Central Base - Queries on applications - How to get the ID of the application
Run the below query on Central Database -
Query1select count(*) from dss_links DL1 join dss_objects DOS on DL1.next_object_id = DOS.object_id and DOS.object_type_id = 20000 and DL1.previous_object_id = <Application_id>
Example
Query1 Exampleselect count(*) from dss_links DL1 join dss_objects DOS on DL1.next_object_id = DOS.object_id and DOS.object_type_id = 20000 and DL1.previous_object_id = 3 Result - 5
Run the below query on Central Database
Query2select count(*) from dss_link_info DL1 join dss_objects DOS on DL1.next_object_id = DOS.object_id and DOS.object_type_id = 20000 and DL1.previous_object_id = <Application_id> and DL1.snapshot_id = <snapshot_id>
To get the snapshot_id refer the page - SQL Queries - CAST Central Base - Queries on snapshots - How to get the ID and name of a snapshot for a given application
Example
Query2 Exampleselect count(*) from dss_links_info DL1 join dss_objects DOS on DL1.next_object_id = DOS.object_id and DOS.object_type_id = 20000 and DL1.previous_object_id = 3 and DL1.snapshot_id = 5; Result - 4
The result of Query1 should match the result of Query2.
Here, in our case it is not matching. If it does not match then it means that the there is a missing link between application and module in Central Database.
If the link is missing then use Cast AIP 8.2.2 or a higher version. This issue is fixed in 8.2.2.
- If you are using 8.2.2 or a higher version and you are still facing this issue then contact CAST Technical Support with Relevant input