Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1019
  • Last Modified:

inconsistent error messages from the crystal server

Hi Experts:

What I'm trying to do is generate a PDF from a report...the backend is Oracle and I'm passing the crystalserver a URL that looks something like this (I broke it up for easier reading):

http://crystalserv/path/report.rpt?
cmd=EXPORT
&export_fmt=U2FPDF:0
&PROMPT0=3000002
&PROMPT1=00
&promptonrefresh=0
&user-oracleConn.dbName=user
&password-oracleConn.dbName=pass

What happens is 1 of 3 things:
1) The PDF is generated as expected (good)
2) The page returned in an HTML page requesting database logon information for the subreport  (bad)
3) An error page saying: "Data on the Page Server may have changed. In order to prevent the display of inconsistent information, the data cached in your browser will have to be refreshed." (bad)

..I've been trying to find corelations between these outcomes and how I open the page but haven't had any luck...it seems like one of the 3 is chosen at random.  If I get 2) and manually input logon info..it usually goes to 3).

I've tried passing it &user0=username&password0=password and user1=... for all subreports etc...but the same combination of things arbitrarily happen.  I've tried different prompt on refresh values, different client machines...same thing.  I've tried toggling the "save data with report" feature (I leave it off) with the same results...I've tried playing with the browser's cache settings

I'm using crystal 8.5/Oracle backend, javascript generating the URL+window.open(URL) (IE6) to open on the front.

Anyone?  I'd be eternally grateful :)
0
d0zerz
Asked:
d0zerz
  • 2
  • 2
1 Solution
 
frodomanCommented:
Have you tried setting your browser to refresh "every time"?  It sounds like you're sometimes hitting at least a partially cached copy which isn't authenticating correctly to Oracle.
0
 
EwaldLCommented:
try adding a :connect. this ensures that fresh data is retrieved from the database. so far i have only seen it used with the viewer though, so i am not sure if it can be implemented with an export, but it could be worth trying
cmd=EXPORT:connect
0
 
d0zerzAuthor Commented:
I tried refreshing the page and checking for new versions on every page visit...I don't think it's a caching issue because I get the same errors when I go on computers that haven't touched the page at all.

Sadly, cmd=EXPORT:connect didnt' work either :(

Thx for the feedback though
0
 
d0zerzAuthor Commented:
Logically that looks exactly like it, in terms of the error i'm getting and such...but it didn't do it :(

I think it's actually a licensing issue internally, more people accessing the crystal serv than we have licenses.

Thanks for the efforts though :)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now