Perf Missing from Season Overview

Amanda,

I was having a similar problem and this is the response I received from the help desk.  Once I did this, my performance showed up in season overview.

____

When you create a new performance, it will not be added to Season Overview until EIS_CHANGED_LOAD_NEW is run with @scope set to F (Full). If you run the procedure with @scope set to I (Interim), data is updated for any performances already in Season Overview, but no need performances are added to the performance. If @scope is set to Full, any new performances will be added to Season Overview. So the issue could be that EIS_CHANGED_LOAD_NEW hasn't been run in Full scope successfully since the performance was created.

However, sometimes organizations have trouble getting the procedure to run successfully when the season string is used rather than executing the procedure for one season at a time.

If EIS_CHANGED_LOAD_NEW has been run successfully in Full scope since the performance was created, but the performance wasn't added to Season Overview, then I suggest that you break out the job that runs EIS_CHANGED_LOAD_NEW into separate steps for each season. So when running the procedure in Full scope, your job would have the following steps:

Step 1:
EIS_CHANGED_LOAD_NEW @scope = 'F', @season = season_no

Step 2:
EIS_CHANGED_LOAD_NEW @scope = 'F', @season = season_no

Step 3:
EIS_CHANGED_LOAD_NEW @scope = 'F', @season = season_no
__________________

Thanks,

Bobby Moseley

Computer Services Manager

1921 W. Bell

Houston, TX 77019

(713) 535-3253

I've got one perf that's missing from the season overview.

I verified it is in a season set to display EIS. Other perfs from the same season are visible. I checked the season on both the perf and the prod_season, just to make sure they were not somehow out of sync with one set to a non-EIS-displaying season, but they were both the correct season. I checked the pmap associated with the pt on the perf (there's only one): the category is Ticket Price. Other performances in other seasons that happen during the same week appear, so it's not the batch period. It's not date view radio button issue. The perf was in October and isn't there Full Year or Season-to-Date.

Any other ideas why one perf wouldn't show?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Amanda,

I was having a similar problem and this is the response I received from the help desk.  Once I did this, my performance showed up in season overview.

____

When you create a new performance, it will not be added to Season Overview until EIS_CHANGED_LOAD_NEW is run with @scope set to F (Full). If you run the procedure with @scope set to I (Interim), data is updated for any performances already in Season Overview, but no need performances are added to the performance. If @scope is set to Full, any new performances will be added to Season Overview. So the issue could be that EIS_CHANGED_LOAD_NEW hasn't been run in Full scope successfully since the performance was created.

However, sometimes organizations have trouble getting the procedure to run successfully when the season string is used rather than executing the procedure for one season at a time.

If EIS_CHANGED_LOAD_NEW has been run successfully in Full scope since the performance was created, but the performance wasn't added to Season Overview, then I suggest that you break out the job that runs EIS_CHANGED_LOAD_NEW into separate steps for each season. So when running the procedure in Full scope, your job would have the following steps:

Step 1:
EIS_CHANGED_LOAD_NEW @scope = 'F', @season = season_no

Step 2:
EIS_CHANGED_LOAD_NEW @scope = 'F', @season = season_no

Step 3:
EIS_CHANGED_LOAD_NEW @scope = 'F', @season = season_no
__________________

Thanks,

Bobby Moseley

Computer Services Manager

1921 W. Bell

Houston, TX 77019

(713) 535-3253

I've got one perf that's missing from the season overview.

I verified it is in a season set to display EIS. Other perfs from the same season are visible. I checked the season on both the perf and the prod_season, just to make sure they were not somehow out of sync with one set to a non-EIS-displaying season, but they were both the correct season. I checked the pmap associated with the pt on the perf (there's only one): the category is Ticket Price. Other performances in other seasons that happen during the same week appear, so it's not the batch period. It's not date view radio button issue. The perf was in October and isn't there Full Year or Season-to-Date.

Any other ideas why one perf wouldn't show?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!