Solved

Failed to Open a Rowset

Posted on 2006-11-20
12
1,109 Views
Last Modified: 2012-06-21
I have report that I am running and I keep getting a few errors when I try to run it.  First error I get is

"Failed to Open a Rowset"  then I get

Query Engine Error: 'ORA-00904': "ARINVOICE"."INVOICE_DATE": Invalid Identifier then I get

Not Supported
Details: Fail to execute SQL Statement OCI Call: OCIStmtExecute

The thing that I cant figure out is I am not calling ARINVOICE.INVOICE_DATE in the report anywhere that I can find.  I think that is the problem is that the field may have been used in this report once but I changed the report.  I cna't find where I would still have it referenced.  Can anyone tell me how to fish out this field if that is the problem?
0
Comment
Question by:mfehrmann
  • 5
  • 3
  • 2
  • +1
12 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 17980235
Sounds like it is still referenced somewhere.  Look at the SQL to make sure you aren't including this in your dataset (even if it isn't being used).
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 17980411
Open the field explorer and see if it is still in the list of fields and has a check mark on it.
If it has a check mark then it is being used.

You might also try VERIFY DATABASE

To find it you may have to check all formulas and suppression formulas and the selection criteria.

mlmcc
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 17980607
Well that is the weird part is that the databse that it is looking for on this error is not even in this report anymore.  It was at one time but I removed it and never received an error that the fields were being used in the report.  I do see the database.field referenced in the SQL but no matter what I can't get rid of it.  I changed the links in the Database Links to change where it is looking for in the SQL query and it wont go away.  
0
 
LVL 42

Expert Comment

by:frodoman
ID: 17980624
Check the visual linking expert and make sure you don't still have a link to this table.

frodoman
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 17980660
That is where I was and I dont see anything to this database.  It is not even listed in the available databases.  It looks as though it is stuck in the SQL, I just can't get it to come out.  The database or field is not listed anywhere that I can find on this report.  The only place I see it is in the SQL and no matter what I do in the Visual Linking expert it doesn't come out.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 100

Expert Comment

by:mlmcc
ID: 17980716
Have you tried verifying the database under the DATABASE menu?

mlmcc
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 17980740
Yep did that too, nothing will get rid of the reference in the SQL Query
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 17980923
I figured it out, I never saw a Reset button in the Show SQL box before.  That is all I had to do what hit reset and it changed all the SQL query.  Now the button isn't there but it must just show up when database tables are removed and added in.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 17981486
I have never seen the button but then we built all our reports off database views and stored procedures.

mlmcc
0
 
LVL 5

Author Comment

by:mfehrmann
ID: 17981496
I have never seen this button either.  I am on version 9 I dont know if that makes a difference but I clicked that button once and it changed the entire SQL query and now the report works fine.  
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 18025235
PAQd, 500 points refunded.

DarthMod
CS Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now