Report Portal
Home
Download
Customers
Customers
Testimonials
Reviews
Resources
Tutorial
Documentation
Support
Forum
FAQ
Services
Company
About us
News/Events
Contact us
Resellers
Live Demo
ReportPortal
Home
|
Profile
|
Register
|
Active Topics
|
Members
|
Search
|
FAQ
All Forums
ReportPortal General Forum
Report Portal General Issues
Error when trying to create usageReports
Note:
You must be registered in order to post a reply.
To register,
click here
. Registration is FREE!
Screensize:
640 x 480
800 x 600
1024 x 768
1280 x 1024
UserName:
Password:
Anti-Spam Code:
Message:
* HTML is ON
* Forum Code is OFF
Smilies
[quote][i]Originally posted by scaceres[/i] [br]When I try to create usage reports (settings), I get this ASP.NET error... The statement has been terminated. INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_SqlQueryFilter_Report'. The conflict occurred in database 'bireporter48', table 'Report', column 'ReportId'.; SQL: INSERT INTO QueryFilter (QueryFilterId, OrderId, QueryId, FilterType, FilterName, SqlSource, RefreshPage, DefaultValue) VALUES (1, 1, 11, 1, 'Action', 'select 0,'' None'' union SELECT ActionId, ActionName FROM UsageLogAction a', 0, '') This error was in build 44 and is in build 48. What should I do? I can touch the source code but I don't know if there's a database problem. BIServices S.A. [/quote]
Check here to include your profile signature.
Check here to subscribe to this topic.
T O P I C R E V I E W
scaceres
Posted - 06/21/2005 : 12:33:41
When I try to create usage reports (settings), I get this ASP.NET error...
The statement has been terminated. INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_SqlQueryFilter_Report'. The conflict occurred in database 'bireporter48', table 'Report', column 'ReportId'.; SQL: INSERT INTO QueryFilter (QueryFilterId, OrderId, QueryId, FilterType, FilterName, SqlSource, RefreshPage, DefaultValue) VALUES (1, 1, 11, 1, 'Action', 'select 0,'' None'' union SELECT ActionId, ActionName FROM UsageLogAction a', 0, '')
This error was in build 44 and is in build 48.
What should I do?
I can touch the source code but I don't know if there's a database problem.
BIServices S.A.
2 L A T E S T R E P L I E S (Newest First)
scaceres
Posted - 07/06/2005 : 07:57:05
Thanks!
BIServices S.A.
admin
Posted - 06/23/2005 : 23:42:34
This problem is fixed in Build 50.
ReportPortal
© 2000-2002 Snitz Communications