Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Can't Save Database Query

  1. How-to
0
Votes
Undo
  1. Daren Hunter
    Daren Hunter
  2. InfoMaker
  3. Monday, 26 February 2024 17:30 PM UTC

Hi Everyone:

 

I need to modify a PBL report in Infomaker. I am getting an error that says

ORA-00942: table or view does not exist

Do you want to correct errors?

I used to be able to click No and still be able to save the changes I made and the report would work just fine in the application. I understand Infomaker believes there to be errors with the table or view. However, I believe it is only happening because the view is referencing an Oracle temporary table. Any way to force the query to save even though Infomaker thinks there is a problem with it? 

 

 

How to retrieve a license
InfoMaker Crashing when attempting to use Design >...
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 26 February 2024 17:51 PM UTC
  2. InfoMaker
  3. # 1

Hi Daren;

  Can you tell us ...

  • Version & build of IM that you are using?
  • Version & build of Oracle that you are using?

Regards ... Ch6

Comment
There are no comments made yet.
Daren Hunter
Daren Hunter Accepted Answer Pending Moderation
  1. Monday, 26 February 2024 17:59 PM UTC
  2. InfoMaker
  3. # 2

Appeon InfoMaker Standard Edition

IDE: Version 2022 Build 1900, Built on Mar 31 2023 at 02:01:11

Runtime: Version 2022 Build 1900, Built on Mar 31 2023 at 02:01:11

19c Enterprise Edition Release 19.0.0.0.0 - Production: Patch Version 19.16.0.0.0

 

Thanks!

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 27 February 2024 21:13 PM UTC
Hi Daren;

Thank you for that information! Your error could be because ...

1) Is the IM IDE connected to the wrong DB instance. Can you see the View / Table you expect using when using IM's Database Painter?

2) It could also be because the DB User ID that you are using that logs into O19C does not have access to that View or it's related Table(s).

3) Even if the Table and/or View(s) are not present in the DB instance that you are connected to, when any such error message appears like this - you should be able to continue in "Syntax" mode (vs Graphic)?

Regards ... Chris
  1. Helpful
There are no comments made yet.
Daren Hunter
Daren Hunter Accepted Answer Pending Moderation
  1. Monday, 4 March 2024 19:36 PM UTC
  2. InfoMaker
  3. # 3

Hi Chris:

It took me a bit, but did sort out that it was a table or view permission issue. After breaking the query down, I discovered the user I was using didn't have access to sys.V$INSTANCE. Once I gave grant permissions, I was able to make the modifications needed.

 

Thanks!

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 4 March 2024 20:29 PM UTC
Hi Daren;

That's awesome news ... Super glad that you figured it out! :-)

Regards ... Chris
  1. Helpful
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Tuesday, 5 March 2024 15:22 PM UTC
You beat me to it. I was goingt to sggest it was a permissions issue.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.