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 :)
LVL 1
d0zerzAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.