ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Subscriptions broken after live update

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
bbloese Posted - 11/08/2018 : 22:23:25
I used live update to go from build 199 to 200. After the update when a subscription runs an error with no details is logged in the Subscriptions History tab. Nothing is logged in the windows event viewer.

https://snag.gy/BFSunf.jpg
8   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 02/13/2019 : 22:17:38
Lesane,

It’s not clear what the problem was. The patch above was created to show the error. But the customer rolled back to build 199.

There are no known issues with the Crystal Report subscriptions in the latest Build 201.
Lesane Posted - 02/13/2019 : 10:10:23
Was this issue fixed in a later update? I'm guessing the reverting was just a bandaid fix?
bbloese Posted - 11/13/2018 : 10:31:44
I can now see the errors not tied to a user.

Reverting to the Report Scheduler in build 199 has resolved the issues with crystal reports not running as scheduled.
admin Posted - 11/11/2018 : 16:38:50
Please try this fix. It will show the error for each history record even if it cannot be tied to a user.

1. Download and unzip: http://www.reportportal.com/download/rp_200_ViewHistory.zip
2. Backup old file and copy the unzipped file to: "C:\inetpub\wwwroot\ReportPortal(_200)\bin\ReportPortal.dll"
bbloese Posted - 11/09/2018 : 11:48:48
After completing the steps below I’m now able to run OLAP subscriptions that email PDFs.

1. Run UpdateDb.vbs and verified the DelivFilePatther colum is present in the Job table.

2. Updated the itextsharp.dll file in C:\inetpub\wwwroot\ReportPortal\bin\ http://reportportal.com/download/itextsharp.zip

3. Updated the RpScheduler.exe file in C:\inetpub\wwwroot\reportportal_200\bin http://www.reportportal.com/download/rp_200_RpScheduler.zip


However I’m still unable to run Cyrstal Report subscriptions. The subscriptions error out with a blank view history window. https://snag.gy/Tc1qDj.jpg
bbloese Posted - 11/08/2018 : 23:05:51
The issue seems to be isolated to subscriptions that with a content type of PDF. When running OLAP reports with a PDF content type I get the following error:

Could not load file or assembly 'itextsharp, Version=4.1.6.0, Culture=neutral, PublicKeyToken=8354ae6d2174ddca' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
bbloese Posted - 11/08/2018 : 22:50:54
I ran UpdateDb.vbs and verified that the DelivFilePattern column is present in the job table. However there is no change, subscriptions are still posting a blank error message.
admin Posted - 11/08/2018 : 22:36:30
Sounds line the database changes have not beet applied. Please run UpdateDb.vbs. You can also try to apply the database change manually:


ALTER TABLE dbo.Job ADD DelivFilePattern nvarchar(200) NULL

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page