ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Missing Column in Schedule Table
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cbergsma

Argentina
10 Posts

Posted - 05/29/2014 :  06:56:34  Show Profile  Reply with Quote
We're having a trouble with that column.
When we browse through the Admin-> Schedules menu we are getting this error message:

Invalid column name 'EndMin'.
Invalid column name 'EndHour'.; SQL: SELECT ScheduleName, IsPublic, ScheduleType, CONVERT(varchar,StartDate,101) AS StartDate, CONVERT(varchar,EndDate,101) AS EndDate, StartHour, StartMin, EndHour, EndMin, EveryHour, EveryMinute, WeekOfMonth, RepeatDays, RepeatWeeks
FROM Schedule WHERE ScheduleId = 1022

when i go check on RP database i found that the Schedule table doesn't have the EndMin column.

is there anything we can do this fix this and get our subscriptions back.

Thanks in advance.

Cristian.

admin

1637 Posts

Posted - 05/29/2014 :  08:16:03  Show Profile  Reply with Quote
Please double click this file "C:\inetpub\wwwroot\ReportPortal\UpdateDb.vbs". It will add EndMin column.
Go to Top of Page

cbergsma

Argentina
10 Posts

Posted - 05/29/2014 :  09:04:29  Show Profile  Reply with Quote
It worked perfectly, thanks a lot.

Regards,

Cristian.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page