At 05:47 PM 10/13/2011, Dennis McGrath wrote:
I have a routine that creates and populates a temp table. When
I try to print a report based on the table, I am told the table
does not exist.
Change user to the owner and the report prints.
This worked fine in 7.6
Any blues clues?
Dennis,
A few questions:
01. 9.1 (32) or 9.1 (64)?
02. How did you convert the database from 7.6 to 9.1 (32/64)?
03. After migrating from 7.6 to 9.1, did you ever re-build the
entire database using the traditional UNLOAD ALL method?
Hopefully, you are not mixing and using two versions (7.6/9.1)
on the same database.
A few suggestions:
01. Make sure that you at least re-build the database once using
the UNLOAD ALL method.
02. Revisit your routine that creates/populates a temp table, and
make sure that the temporary table is actually created and you
can access/browse that table prior to printing the report based
upon this specific temporary table.
03. What happens when you include your routine as "Before Generate"
Report Action?
These are very common and straight forward options to verify any
oddity in a situation like yours.
Following the list will certainly provide you with some blue's clues!
Very Best R:egards,
Razzak.
