INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Actuate eRD Pro 11SP3 failing with potential bad characters from Sharepoint 2010

Actuate eRD Pro 11SP3 failing with potential bad characters from Sharepoint 2010

Actuate eRD Pro 11SP3 failing with potential bad characters from Sharepoint 2010

(OP)
We obtain HTML data stored within Sharepoint 2010 and use it within categorized reports. Certain category reports are failing with an Assert error (see below), which typically means no data. However, there is data, and we believe that an invalid character (or two) are being introduced via Sharepoint 2010, and when Actuate encounters the bad characters, the data gets wiped out. Prior to December, we were obtaining our source from Sharepoint 2007. Another department upgraded where the web content is being stored, and now use Sharepoint 2010, and now we have our problem. No going back. This HTML formatted data is an extended description of items that we sell. Our reports pick up the formatting and displays these descriptions in a nice, professional format, when it works (and it works form some categories).
I've written a SQL script that interogates each ASCII character within an intermediate database table that our Actuate report obtains the data directly from. That database gets it's data from Sharepoint 2010 through a separate SQL extract process. I just do not know what characters to search for that might be causing the Actuate Assert error. We are storing HTML tags within the database table. Certain category reports work and others don't, and it is probably because they do not have the bad characters. Has anyone else have this issue? Any ASCII characters that yo know will choke Actuate? According to Actuate Tech Support, all are suppose to be supported, but I am suspect. Please help.

Error (won't really help):
Generating rotp:/Content/IBO Reports/Report000266/EN_US/Report000266 Food and Beverage.roi;1 ...
Retrieving Connection Info For Environment 'DB-QXTR-DLY-PRICE-GUIDE'
Connecting...
Generating...
Fetching Rows...
Sorting...
Generating...
***
*** Error: 36 occurred, which is: Assert statement failed. at line: 1245
***
Finished Updating Control Tables
Status No: 1 :
Basic Error: 0
Module: rptQxtr%BuildReport
Line: 56

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close